CREATE TEMP TABLE data(
	ReportPeriod TEXT,
	Terminal TEXT,
	Arrival_Departure TEXT,
	Domestic_International TEXT,
	Passenger_Count INTEGER);
.mod csv
.separator ","
.import datafile.csv data

CREATE TABLE lax(
	id INTEGER PRIMARY KEY,
	ReportPeriod TEXT,
	Terminal TEXT,
	Arrival_Departure TEXT,
	Domestic_International TEXT,
	Passenger_Count INTEGER);

DELETE FROM data WHERE ReportPeriod LIKE 'ReportPeriod';

INSERT INTO lax SELECT null, ReportPeriod, Terminal, Arrival_Departure, Domestic_International, Passenger_Count FROM data;

DROP TABLE data;
