001-import-2023-data.sql

--
-- Insert 2023 data
--

INSERT INTO "public"."weekly_earnings" ("occupation", "slug", "parent", "total_number_workers", "median_weekly_earnings", "men_number_workers", "men_median_weekly_earnings", "women_number_workers", "women_median_weekly_earnings", "year") VALUES
('Sawing machine setters, operators, and tenders, wood', 'sawing-machine-setters-operators-and-tenders-wood', 'production-occupations', '31', '-', '30', '-', '1', '-', '2011'),
('Woodworking machine setters, operators, and tenders, except sawing', 'woodworking-machine-setters-operators-and-tenders-except-sawing', 'production-occupations', '17', '-', '15', '-', '2', '-', '2011'),
('Woodworkers, all other', 'woodworkers-all-other', 'production-occupations', '10', '-', '8', '-', '2', '-', '2011'),
('Power plant operators, distributors, and dispatchers', 'power-plant-operators-distributors-and-dispatchers', 'production-occupations', '53', '1,091', '52', '1,085', '1', '-', '2011'),
('Stationary engineers and boiler operators', 'stationary-engineers-and-boiler-operators', 'production-occupations', '93', '855', '92', '851', '1', '-', '2011'),
('Water and wastewater treatment plant and system operators', 'water-and-wastewater-treatment-plant-and-system-operators', 'production-occupations', '75', '780', '70', '788', '5', '-', '2011'),
('Miscellaneous plant and system operators', 'miscellaneous-plant-and-system-operators', 'production-occupations', '37', '-', '34', '-', '3', '-', '2011'),
('Chemical processing machine setters, operators, and tenders', 'chemical-processing-machine-setters-operators-and-tenders', 'production-occupations', '66', '853', '52', '947', '14', '-', '2011'),
('Crushing, grinding, polishing, mixing, and blending workers', 'crushing-grinding-polishing-mixing-and-blending-workers', 'production-occupations', '94', '659', '82', '702', '12', '-', '2011'),
('Cutting workers', 'cutting-workers', 'production-occupations', '69', '518', '55', '540', '13', '-', '2011'),
('Extruding, forming, pressing, and compacting machine setters, operators, and tenders', 'extruding-forming-pressing-and-compacting-machine-setters-operators-and-tenders', 'production-occupations', '31', '-', '28', '-', '3', '-', '2011'),
('Furnace, kiln, oven, drier, and kettle operators and tenders', 'furnace-kiln-oven-drier-and-kettle-operators-and-tenders', 'production-occupations', '11', '-', '11', '-', '0', '-', '2011'),
('Inspectors, testers, sorters, samplers, and weighers', 'inspectors-testers-sorters-samplers-and-weighers', 'production-occupations', '608', '675', '396', '792', '212', '541', '2011'),
('Jewelers and precious stone and metal workers', 'jewelers-and-precious-stone-and-metal-workers', 'production-occupations', '14', '-', '7', '-', '7', '-', '2011'),
('Medical, dental, and ophthalmic laboratory technicians', 'medical-dental-and-ophthalmic-laboratory-technicians', 'production-occupations', '68', '612', '34', '-', '34', '-', '2011'),
('Packaging and filling machine operators and tenders', 'packaging-and-filling-machine-operators-and-tenders', 'production-occupations', '259', '455', '120', '505', '139', '421', '2011'),
('Painting workers', 'painting-workers', 'production-occupations', '111', '602', '99', '608', '12', '-', '2011'),
('Photographic process workers and processing machine operators', 'photographic-process-workers-and-processing-machine-operators', 'production-occupations', '24', '-', '10', '-', '13', '-', '2011'),
('Semiconductor processors', 'semiconductor-processors', 'production-occupations', '4', '-', '3', '-', '1', '-', '2011'),
('Adhesive bonding machine operators and tenders', 'adhesive-bonding-machine-operators-and-tenders', 'production-occupations', '10', '-', '4', '-', '6', '-', '2011'),
('Cleaning, washing, and metal pickling equipment operators and tenders', 'cleaning-washing-and-metal-pickling-equipment-operators-and-tenders', 'production-occupations', '13', '-', '9', '-', '3', '-', '2011'),
('Cooling and freezing equipment operators and tenders', 'cooling-and-freezing-equipment-operators-and-tenders', 'production-occupations', '3', '-', '3', '-', '0', '-', '2011'),
('Etchers and engravers', 'etchers-and-engravers', 'production-occupations', '7', '-', '4', '-', '2', '-', '2011'),
('Molders, shapers, and casters, except metal and plastic', 'molders-shapers-and-casters-except-metal-and-plastic', 'production-occupations', '21', '-', '15', '-', '6', '-', '2011'),
('Paper goods machine setters, operators, and tenders', 'paper-goods-machine-setters-operators-and-tenders', 'production-occupations', '31', '-', '23', '-', '8', '-', '2011'),
('Tire builders', 'tire-builders', 'production-occupations', '17', '-', '16', '-', '1', '-', '2011'),
('Helpers--production workers', 'helpers-production-workers', 'production-occupations', '45', '-', '40', '-', '6', '-', '2011'),
('Production workers, all other', 'production-workers-all-other', 'production-occupations', '652', '579', '502', '612', '151', '483', '2011'),
('Transportation and material moving occupations', 'transportation-and-material-moving-occupations', 'production-transportation-and-material-moving-occupations', '6,275', '614', '5,489', '634', '786', '490', '2011'),
('Supervisors of transportation and material moving workers', 'supervisors-of-transportation-and-material-moving-workers', 'transportation-and-material-moving-occupations', '208', '761', '170', '773', '38', '-', '2011'),
('Aircraft pilots and flight engineers', 'aircraft-pilots-and-flight-engineers', 'transportation-and-material-moving-occupations', '93', '1,461', '89', '1,466', '4', '-', '2011'),
('Air traffic controllers and airfield operations specialists', 'air-traffic-controllers-and-airfield-operations-specialists', 'transportation-and-material-moving-occupations', '40', '-', '35', '-', '5', '-', '2011'),
('Flight attendants', 'flight-attendants', 'transportation-and-material-moving-occupations', '52', '791', '14', '-', '38', '-', '2011'),
('Ambulance drivers and attendants, except emergency medical technicians', 'ambulance-drivers-and-attendants-except-emergency-medical-technicians', 'transportation-and-material-moving-occupations', '9', '-', '9', '-', '0', '-', '2011'),
('Bus drivers', 'bus-drivers', 'transportation-and-material-moving-occupations', '310', '608', '188', '645', '122', '579', '2011'),
('Driver/sales workers and truck drivers', 'driver-sales-workers-and-truck-drivers', 'transportation-and-material-moving-occupations', '2,439', '705', '2,337', '712', '102', '511', '2011'),
('Motor vehicle operators, all other', 'motor-vehicle-operators-all-other', 'transportation-and-material-moving-occupations', '28', '-', '26', '-', '1', '-', '2011'),
('Locomotive engineers and operators', 'locomotive-engineers-and-operators', 'transportation-and-material-moving-occupations', '43', '-', '42', '-', '2', '-', '2011'),
('Railroad brake, signal, and switch operators', 'railroad-brake-signal-and-switch-operators', 'transportation-and-material-moving-occupations', '6', '-', '6', '-', '0', '-', '2011'),
('Railroad conductors and yardmasters', 'railroad-conductors-and-yardmasters', 'transportation-and-material-moving-occupations', '48', '-', '45', '-', '3', '-', '2011'),
('Subway, streetcar, and other rail transportation workers', 'subway-streetcar-and-other-rail-transportation-workers', 'transportation-and-material-moving-occupations', '14', '-', '12', '-', '2', '-', '2011'),
('Sailors and marine oilers', 'sailors-and-marine-oilers', 'transportation-and-material-moving-occupations', '23', '-', '23', '-', '0', '-', '2011'),
('Ship and boat captains and operators', 'ship-and-boat-captains-and-operators', 'transportation-and-material-moving-occupations', '35', '-', '35', '-', '0', '-', '2011'),
('Ship engineers', 'ship-engineers', 'transportation-and-material-moving-occupations', '6', '-', '6', '-', '0', '-', '2011'),
('Bridge and lock tenders', 'bridge-and-lock-tenders', 'transportation-and-material-moving-occupations', '7', '-', '7', '-', '0', '-', '2011'),
('Parking lot attendants', 'parking-lot-attendants', 'transportation-and-material-moving-occupations', '46', '-', '40', '-', '5', '-', '2011'),
('Automotive and watercraft service attendants', 'automotive-and-watercraft-service-attendants', 'transportation-and-material-moving-occupations', '42', '-', '40', '-', '2', '-', '2011'),
('Transportation inspectors', 'transportation-inspectors', 'transportation-and-material-moving-occupations', '32', '-', '28', '-', '5', '-', '2011'),
('Transportation attendants, except flight attendants', 'transportation-attendants-except-flight-attendants', 'transportation-and-material-moving-occupations', '13', '-', '5', '-', '8', '-', '2011'),
('Other transportation workers', 'other-transportation-workers', 'transportation-and-material-moving-occupations', '15', '-', '14', '-', '1', '-', '2011'),
('Conveyor operators and tenders', 'conveyor-operators-and-tenders', 'transportation-and-material-moving-occupations', '5', '-', '2', '-', '3', '-', '2011'),
('Crane and tower operators', 'crane-and-tower-operators', 'transportation-and-material-moving-occupations', '63', '739', '62', '736', '1', '-', '2011'),
('Dredge, excavating, and loading machine operators', 'dredge-excavating-and-loading-machine-operators', 'transportation-and-material-moving-occupations', '37', '-', '37', '-', '0', '-', '2011'),
('Hoist and winch operators', 'hoist-and-winch-operators', 'transportation-and-material-moving-occupations', '5', '-', '3', '-', '2', '-', '2011'),
('Industrial truck and tractor operators', 'industrial-truck-and-tractor-operators', 'transportation-and-material-moving-occupations', '491', '562', '456', '556', '35', '-', '2011'),
('Cleaners of vehicles and equipment', 'cleaners-of-vehicles-and-equipment', 'transportation-and-material-moving-occupations', '230', '465', '206', '458', '25', '-', '2011'),
('Laborers and freight, stock, and material movers, hand', 'laborers-and-freight-stock-and-material-movers-hand', 'transportation-and-material-moving-occupations', '1,260', '509', '1,085', '520', '175', '416', '2011'),
('Machine feeders and offbearers', 'machine-feeders-and-offbearers', 'transportation-and-material-moving-occupations', '32', '-', '27', '-', '5', '-', '2011'),
('Packers and packagers, hand', 'packers-and-packagers-hand', 'transportation-and-material-moving-occupations', '300', '397', '135', '396', '165', '397', '2011'),
('Pumping station operators', 'pumping-station-operators', 'transportation-and-material-moving-occupations', '26', '-', '26', '-', '0', '-', '2011'),
('Refuse and recyclable material collectors', 'refuse-and-recyclable-material-collectors', 'transportation-and-material-moving-occupations', '58', '541', '56', '580', '3', '-', '2011'),
('Mine shuttle car operators', 'mine-shuttle-car-operators', 'transportation-and-material-moving-occupations', '1', '-', '0', '-', '1', '-', '2011'),
('Tank car, truck, and ship loaders', 'tank-car-truck-and-ship-loaders', 'transportation-and-material-moving-occupations', '3', '-', '2', '-', '0', '-', '2011'),
('Material moving workers, all other', 'material-moving-workers-all-other', 'transportation-and-material-moving-occupations', '45', '-', '42', '-', '3', '-', '2011');

--
-- Cast wages to int
--

-- Set not enough data cols to 0
UPDATE weekly_earnings SET median_weekly_earnings = NULL WHERE median_weekly_earnings = '-';

-- 2024-03-09 18:40:53.2210
UPDATE weekly_earnings SET men_median_weekly_earnings = NULL WHERE men_median_weekly_earnings = '-';

-- 2024-03-09 18:40:53.2370
UPDATE weekly_earnings SET women_median_weekly_earnings = NULL WHERE women_median_weekly_earnings = '-';

-- 2024-03-09 18:40:53.2540
-- Remove commas from number strings
UPDATE weekly_earnings SET median_weekly_earnings = REPLACE(median_weekly_earnings, ',', '')::numeric;

-- 2024-03-09 18:40:53.2700
UPDATE weekly_earnings SET men_median_weekly_earnings = REPLACE(men_median_weekly_earnings, ',', '')::numeric;

-- 2024-03-09 18:40:53.2860
UPDATE weekly_earnings SET women_median_weekly_earnings = REPLACE(women_median_weekly_earnings, ',', '')::numeric;

-- 2024-03-09 18:40:53.3080
-- Cast wages to int

ALTER TABLE weekly_earnings ALTER COLUMN median_weekly_earnings TYPE int USING median_weekly_earnings::integer;

-- 2024-03-09 18:40:53.3210
ALTER TABLE weekly_earnings ALTER COLUMN men_median_weekly_earnings TYPE int USING men_median_weekly_earnings::integer;

-- 2024-03-09 18:40:53.3360
ALTER TABLE weekly_earnings ALTER COLUMN women_median_weekly_earnings TYPE int USING women_median_weekly_earnings::integer;

-- 2024-03-09 18:40:53.3670
--
-- Populate occupations table
--

INSERT INTO occupations (name, slug, parent_slug_denorm)
SELECT
	occupation,
	slug,
	parent
FROM
	weekly_earnings ON CONFLICT DO NOTHING;

-- 2024-03-09 18:40:53.3750
-- Set parent_id
UPDATE
	occupations o1
SET
	parent_id = o2.id
FROM
	occupations o2
WHERE
	o2.slug = o1.parent_slug_denorm;

-- 2024-03-09 18:40:53.3790
--
-- Populate gaps table
--
-- Move over weekly_earnings data
INSERT INTO wage_gaps (occupation_id, all_median_weekly_earnings, men_median_weekly_earnings, women_median_weekly_earnings, year)
SELECT
	occupations.id,
	median_weekly_earnings,
	men_median_weekly_earnings,
	women_median_weekly_earnings,
	year
FROM
	weekly_earnings
	INNER JOIN occupations ON weekly_earnings.slug = occupations.slug;

-- 2024-03-09 18:40:53.3930
-- Calculate cents_to_dollar
UPDATE
	wage_gaps
SET
	cents_to_dollar = ROUND((women_median_weekly_earnings::numeric * 100) / men_median_weekly_earnings::numeric)
WHERE
	men_median_weekly_earnings IS NOT NULL
	AND women_median_weekly_earnings IS NOT NULL;

-- 2024-03-09 18:41:43.8070
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'occupations'
  AND p.relkind = 'v';

-- 2024-03-09 18:41:43.8270
SELECT * FROM "public"."occupations" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 18:41:43.8270
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='occupations';

-- 2024-03-09 18:41:45.8940
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'wage_gaps'
  AND p.relkind = 'v';

-- 2024-03-09 18:41:45.9180
SELECT * FROM "public"."wage_gaps" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 18:41:45.9180
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='wage_gaps';

-- 2024-03-09 18:41:48.3010
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'weekly_earnings'
  AND p.relkind = 'v';

-- 2024-03-09 18:41:48.3220
SELECT * FROM "public"."weekly_earnings" LIMIT 300 OFFSET 0;

-- 2024-03-09 18:41:48.3230
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='weekly_earnings';

-- 2024-03-09 18:57:50.5570
DROP VIEW IF EXISTS "wage_gaps_view";

-- 2024-03-09 18:57:50.5780
DROP TABLE IF EXISTS "wage_gaps";

-- 2024-03-09 18:57:50.5960
DROP TABLE IF EXISTS "occupations";

-- 2024-03-09 18:57:50.6070
DROP TABLE IF EXISTS "weekly_earnings";

-- 2024-03-09 18:57:50.6240
CREATE TABLE "occupations" (
	"id" SERIAL PRIMARY KEY,
	"slug" varchar,
	"name" varchar,
	"parent_id" int,
	"parent_slug_denorm" varchar
);

-- 2024-03-09 18:57:50.6420
CREATE TABLE "wage_gaps" (
	"id" SERIAL PRIMARY KEY,
	"occupation_id" int,
	"year" int,
	"all_median_weekly_earnings" int,
	"men_median_weekly_earnings" int,
	"women_median_weekly_earnings" int,
	"cents_to_dollar" int
);

-- 2024-03-09 18:57:50.6510
CREATE TABLE "weekly_earnings" (
	"occupation" varchar,
	"slug" varchar,
	"parent" varchar,
	"total_number_workers" varchar,
	"median_weekly_earnings" varchar,
	"men_number_workers" varchar,
	"men_median_weekly_earnings" varchar,
	"women_number_workers" varchar,
	"women_median_weekly_earnings" varchar,
	"year" int
);

-- 2024-03-09 18:57:50.6680
ALTER TABLE "occupations"
	ADD FOREIGN KEY ("parent_id") REFERENCES "occupations" ("id");

-- 2024-03-09 18:57:50.6840
CREATE UNIQUE INDEX occupation_slugs_unique ON occupations (slug);

-- 2024-03-09 18:57:50.7020
ALTER TABLE "wage_gaps"
	ADD FOREIGN KEY ("occupation_id") REFERENCES "occupations" ("id");

-- 2024-03-09 18:57:50.7200
CREATE VIEW wage_gaps_view AS
SELECT
	o1.name,
	o1.slug,
	o2.name AS parent_name,
	wg.cents_to_dollar,
	wg.year
FROM
	occupations o1
	INNER JOIN occupations o2 ON o1.parent_id = o2.id
	INNER JOIN wage_gaps wg ON wg.occupation_id = o1.id
WHERE
	cents_to_dollar IS NOT NULL
ORDER BY
	cents_to_dollar DESC;

-- 2024-03-09 18:57:53.3490
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'occupations'
  AND p.relkind = 'v';

-- 2024-03-09 18:57:53.3590
SELECT * FROM "public"."occupations" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 18:57:53.3590
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='occupations';

-- 2024-03-09 18:57:53.3590
SELECT COUNT(*) as count FROM "public"."occupations";

-- 2024-03-09 18:57:53.9720
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'wage_gaps'
  AND p.relkind = 'v';

-- 2024-03-09 18:57:53.9880
SELECT * FROM "public"."wage_gaps" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 18:57:53.9890
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='wage_gaps';

-- 2024-03-09 18:57:53.9890
SELECT COUNT(*) as count FROM "public"."wage_gaps";

-- 2024-03-09 18:59:03.9240
INSERT INTO "public"."weekly_earnings" ("total_number_workers", "parent", "occupation", "median_weekly_earnings", "men_number_workers", "slug", "women_number_workers", "women_median_weekly_earnings", "men_median_weekly_earnings", "year") VALUES
('120,907', '', 'Total, full-time wage and salary workers', 1,117, '66,700', 'total-full-time-wage-and-salary-workers', '54,207', 1,005, 1,202, 2,023);

-- 2024-03-09 18:59:26.1200
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'weekly_earnings'
  AND p.relkind = 'v';

-- 2024-03-09 18:59:26.1370
SELECT * FROM "public"."weekly_earnings" LIMIT 300 OFFSET 0;

-- 2024-03-09 18:59:26.1380
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='weekly_earnings';

-- 2024-03-09 18:59:26.1380
SELECT COUNT(*) as count FROM "public"."weekly_earnings";

-- 2024-03-09 19:01:28.2710
DROP VIEW IF EXISTS "wage_gaps_view";

-- 2024-03-09 19:01:28.2890
DROP TABLE IF EXISTS "wage_gaps";

-- 2024-03-09 19:01:28.3050
DROP TABLE IF EXISTS "occupations";

-- 2024-03-09 19:01:28.3180
DROP TABLE IF EXISTS "weekly_earnings";

-- 2024-03-09 19:01:28.3340
CREATE TABLE "occupations" (
	"id" SERIAL PRIMARY KEY,
	"slug" varchar,
	"name" varchar,
	"parent_id" int,
	"parent_slug_denorm" varchar
);

-- 2024-03-09 19:01:28.3440
CREATE TABLE "wage_gaps" (
	"id" SERIAL PRIMARY KEY,
	"occupation_id" int,
	"year" int,
	"all_median_weekly_earnings" int,
	"men_median_weekly_earnings" int,
	"women_median_weekly_earnings" int,
	"cents_to_dollar" int
);

-- 2024-03-09 19:01:28.3570
CREATE TABLE "weekly_earnings" (
	"occupation" varchar,
	"slug" varchar,
	"parent" varchar,
	"total_number_workers" varchar,
	"median_weekly_earnings" varchar,
	"men_number_workers" varchar,
	"men_median_weekly_earnings" varchar,
	"women_number_workers" varchar,
	"women_median_weekly_earnings" varchar,
	"year" int
);

-- 2024-03-09 19:01:28.3680
ALTER TABLE "occupations"
	ADD FOREIGN KEY ("parent_id") REFERENCES "occupations" ("id");

-- 2024-03-09 19:01:28.3800
CREATE UNIQUE INDEX occupation_slugs_unique ON occupations (slug);

-- 2024-03-09 19:01:28.3970
ALTER TABLE "wage_gaps"
	ADD FOREIGN KEY ("occupation_id") REFERENCES "occupations" ("id");

-- 2024-03-09 19:01:28.4060
CREATE VIEW wage_gaps_view AS
SELECT
	o1.name,
	o1.slug,
	o2.name AS parent_name,
	wg.cents_to_dollar,
	wg.year
FROM
	occupations o1
	INNER JOIN occupations o2 ON o1.parent_id = o2.id
	INNER JOIN wage_gaps wg ON wg.occupation_id = o1.id
WHERE
	cents_to_dollar IS NOT NULL
ORDER BY
	cents_to_dollar DESC;

-- 2024-03-09 19:01:29.4190
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'weekly_earnings'
  AND p.relkind = 'v';

-- 2024-03-09 19:02:34.9030
INSERT INTO "public"."weekly_earnings" ("women_number_workers", "parent", "men_number_workers", "median_weekly_earnings", "men_median_weekly_earnings", "total_number_workers", "year", "women_median_weekly_earnings", "occupation", "slug") VALUES
('54,207', '', '66,700', '1,117', '1,202', '120,907', 2,023, '1,005', 'Total, full-time wage and salary workers', 'total-full-time-wage-and-salary-workers');

-- 2024-03-09 19:04:09.0690
INSERT INTO "public"."weekly_earnings" ("occupation", "women_number_workers", "women_median_weekly_earnings", "total_number_workers", "median_weekly_earnings", "year", "men_number_workers", "parent", "men_median_weekly_earnings", "slug") VALUES
('Total, full-time wage and salary workers', '54,207', '1,005', '120,907', '1,117', 2,023, '66,700', '', '1,202', 'total-full-time-wage-and-salary-workers');

-- 2024-03-09 19:04:54.7260
DROP VIEW IF EXISTS "wage_gaps_view";

-- 2024-03-09 19:04:54.7450
DROP TABLE IF EXISTS "wage_gaps";

-- 2024-03-09 19:04:54.7640
DROP TABLE IF EXISTS "occupations";

-- 2024-03-09 19:04:54.7780
DROP TABLE IF EXISTS "weekly_earnings";

-- 2024-03-09 19:04:54.7940
CREATE TABLE "occupations" (
	"id" SERIAL PRIMARY KEY,
	"slug" varchar,
	"name" varchar,
	"parent_id" int,
	"parent_slug_denorm" varchar
);

-- 2024-03-09 19:04:54.8060
CREATE TABLE "wage_gaps" (
	"id" SERIAL PRIMARY KEY,
	"occupation_id" int,
	"year" int,
	"all_median_weekly_earnings" int,
	"men_median_weekly_earnings" int,
	"women_median_weekly_earnings" int,
	"cents_to_dollar" int
);

-- 2024-03-09 19:04:54.8180
CREATE TABLE "weekly_earnings" (
	"occupation" varchar,
	"slug" varchar,
	"parent" varchar,
	"total_number_workers" varchar,
	"median_weekly_earnings" varchar,
	"men_number_workers" varchar,
	"men_median_weekly_earnings" varchar,
	"women_number_workers" varchar,
	"women_median_weekly_earnings" varchar,
	"year" int
);

-- 2024-03-09 19:04:54.8300
ALTER TABLE "occupations"
	ADD FOREIGN KEY ("parent_id") REFERENCES "occupations" ("id");

-- 2024-03-09 19:04:54.8440
CREATE UNIQUE INDEX occupation_slugs_unique ON occupations (slug);

-- 2024-03-09 19:04:54.8570
ALTER TABLE "wage_gaps"
	ADD FOREIGN KEY ("occupation_id") REFERENCES "occupations" ("id");

-- 2024-03-09 19:04:54.8700
CREATE VIEW wage_gaps_view AS
SELECT
	o1.name,
	o1.slug,
	o2.name AS parent_name,
	wg.cents_to_dollar,
	wg.year
FROM
	occupations o1
	INNER JOIN occupations o2 ON o1.parent_id = o2.id
	INNER JOIN wage_gaps wg ON wg.occupation_id = o1.id
WHERE
	cents_to_dollar IS NOT NULL
ORDER BY
	cents_to_dollar DESC;

-- 2024-03-09 19:05:01.3390
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'occupations'
  AND p.relkind = 'v';

-- 2024-03-09 19:05:01.3550
SELECT * FROM "public"."occupations" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:05:01.3560
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='occupations';

-- 2024-03-09 19:05:01.3560
SELECT COUNT(*) as count FROM "public"."occupations";

-- 2024-03-09 19:05:02.0020
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'wage_gaps'
  AND p.relkind = 'v';

-- 2024-03-09 19:05:02.0170
SELECT * FROM "public"."wage_gaps" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:05:02.0180
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='wage_gaps';

-- 2024-03-09 19:05:02.0180
SELECT COUNT(*) as count FROM "public"."wage_gaps";

-- 2024-03-09 19:05:04.0220
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'weekly_earnings'
  AND p.relkind = 'v';

-- 2024-03-09 19:05:04.0380
SELECT * FROM "public"."weekly_earnings" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:05:04.0390
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='weekly_earnings';

-- 2024-03-09 19:05:04.0390
SELECT COUNT(*) as count FROM "public"."weekly_earnings";

-- 2024-03-09 19:06:38.4530
select pg_get_viewdef('"public"."wage_gaps_view"'::regclass, true) as create_statement;

-- 2024-03-09 19:06:38.4630
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'wage_gaps_view'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'wage_gaps_view'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'wage_gaps_view'
  AND p.relkind = 'v';

-- 2024-03-09 19:06:38.4850
SELECT * FROM "public"."wage_gaps_view" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:06:38.4850
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='wage_gaps_view';

-- 2024-03-09 19:06:38.4850
SELECT COUNT(*) as count FROM "public"."wage_gaps_view";

-- 2024-03-09 19:06:38.9180
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'wage_gaps'
  AND p.relkind = 'v';

-- 2024-03-09 19:06:38.9330
SELECT * FROM "public"."wage_gaps" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:06:38.9330
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='wage_gaps';

-- 2024-03-09 19:06:38.9330
SELECT COUNT(*) as count FROM "public"."wage_gaps";

-- 2024-03-09 19:06:39.3610
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'wage_gaps'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'wage_gaps'
  AND p.relkind = 'v';

-- 2024-03-09 19:06:40.0810
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'occupations'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'occupations'
  AND p.relkind = 'v';

-- 2024-03-09 19:06:40.0970
SELECT * FROM "public"."occupations" ORDER BY "id" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:06:40.0980
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='occupations';

-- 2024-03-09 19:06:40.0980
SELECT COUNT(*) as count FROM "public"."occupations";

-- 2024-03-09 19:07:24.9600
SELECT
  pg_total_relation_size(relid) AS total_size,
  pg_table_size(relid) AS data_size,
  pg_indexes_size(relid) AS index_size,
  obj_description(relid, 'pg_class') AS comment
FROM
  pg_catalog.pg_statio_user_tables
WHERE
  schemaname = 'public'
  AND relname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_proc') AS comment
FROM
  pg_catalog.pg_proc p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE
  n.nspname = 'public'
 AND p.proname = 'weekly_earnings'
UNION
SELECT
  NULL AS total_size,
  NULL AS data_size,
  NULL AS index_size,
  obj_description(p.oid, 'pg_class') AS comment
FROM
  pg_catalog.pg_class p
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.relnamespace
WHERE
  n.nspname = 'public'
  AND p.relname = 'weekly_earnings'
  AND p.relkind = 'v';

-- 2024-03-09 19:07:24.9760
SELECT * FROM "public"."weekly_earnings" LIMIT 300 OFFSET 0;

-- 2024-03-09 19:07:24.9770
select reltuples::int8 as count from pg_class c JOIN pg_catalog.pg_namespace n ON n.oid=c.relnamespace where nspname='public'AND relname='weekly_earnings';

-- 2024-03-09 19:07:24.9770
SELECT COUNT(*) as count FROM "public"."weekly_earnings";

-- 2024-03-09 19:09:22.0200
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('', '120,907', 'Total, full-time wage and salary workers', '1,117', '1,005', 'total-full-time-wage-and-salary-workers', 2023, '1,202', '66,700', '54,207');

-- 2024-03-09 19:09:22.0230
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('', '56,077', 'Management, professional, and related occupations', '1,527', '1,349', 'management-professional-and-related-occupations', 2023, '1,778', '27,070', '29,007'),
('management-professional-and-related-occupations', '23,989', 'Management, business, and financial operations occupations', '1,630', '1,449', 'management-business-and-financial-operations-occupations', 2023, '1,868', '12,425', '11,564'),
('management-business-and-financial-operations-occupations', '15,762', 'Management occupations', '1,730', '1,483', 'management-occupations', 2023, '1,900', '8,731', '7,032'),
('management-occupations', '1,261', 'Chief executives', '2,901', '2,520', 'chief-executives', 2023, '2,983', '854', '407'),
('management-occupations', '1,222', 'General and operations managers', '1,544', '1,347', 'general-and-operations-managers', 2023, '1,689', '767', '456'),
('management-occupations', '6', 'Legislators', '-', '-', 'legislators', 2023, '-', '3', '3'),
('management-occupations', '47', 'Advertising and promotions managers', '-', '-', 'advertising-and-promotions-managers', 2023, '-', '29', '18'),
('management-occupations', '508', 'Marketing managers', '1,812', '1,746', 'marketing-managers', 2023, '1,911', '188', '320'),
('management-occupations', '566', 'Sales managers', '2,004', '1,688', 'sales-managers', 2023, '2,297', '390', '176'),
('management-occupations', '114', 'Public relations and fundraising managers', '1,889', '1,733', 'public-relations-and-fundraising-managers', 2023, '-', '39', '75'),
('management-occupations', '75', 'Administrative services managers', '1,405', '-', 'administrative-services-managers', 2023, '-', '25', '49'),
('management-occupations', '145', 'Facilities managers', '1,436', '-', 'facilities-managers', 2023, '1,575', '114', '32'),
('management-occupations', '781', 'Computer and information systems managers', '2,303', '2,192', 'computer-and-information-systems-managers', 2023, '2,313', '569', '212'),
('management-occupations', '1,355', 'Financial managers', '1,757', '1,497', 'financial-managers', 2023, '2,100', '607', '748'),
('management-occupations', '16', 'Compensation and benefits managers', '-', '-', 'compensation-and-benefits-managers', 2023, '-', '4', '12'),
('management-occupations', '324', 'Human resources managers', '1,756', '1,706', 'human-resources-managers', 2023, '1,891', '79', '245'),
('management-occupations', '58', 'Training and development managers', '1,976', '-', 'training-and-development-managers', 2023, '-', '27', '31'),
('management-occupations', '260', 'Industrial production managers', '1,875', '-', 'industrial-production-managers', 2023, '1,884', '212', '48'),
('management-occupations', '234', 'Purchasing managers', '1,741', '1,585', 'purchasing-managers', 2023, '1,879', '129', '105'),
('management-occupations', '360', 'Transportation, storage, and distribution managers', '1,262', '1,219', 'transportation-storage-and-distribution-managers', 2023, '1,318', '277', '83'),
('management-occupations', '116', 'Farmers, ranchers, and other agricultural managers', '1,171', '-', 'farmers-ranchers-and-other-agricultural-managers', 2023, '1,216', '86', '30'),
('management-occupations', '693', 'Construction managers', '1,680', '1,431', 'construction-managers', 2023, '1,747', '611', '82'),
('management-occupations', '941', 'Education and childcare administrators', '1,565', '1,469', 'education-and-childcare-administrators', 2023, '1,870', '294', '647'),
('management-occupations', '174', 'Architectural and engineering managers', '2,904', '-', 'architectural-and-engineering-managers', 2023, '2,887', '150', '24'),
('management-occupations', '720', 'Food service managers', '988', '924', 'food-service-managers', 2023, '1,121', '384', '336'),
('management-occupations', '5', 'Funeral home managers', '-', '-', 'funeral-home-managers', 2023, '-', '3', '2'),
('management-occupations', '53', 'Entertainment and recreation managers', '1,035', '-', 'entertainment-and-recreation-managers', 2023, '-', '32', '21'),
('management-occupations', '116', 'Lodging managers', '1,257', '1,069', 'lodging-managers', 2023, '-', '42', '74'),
('management-occupations', '767', 'Medical and health services managers', '1,634', '1,540', 'medical-and-health-services-managers', 2023, '1,914', '224', '543'),
('management-occupations', '36', 'Natural sciences managers', '-', '-', 'natural-sciences-managers', 2023, '-', '14', '22'),
('management-occupations', '16', 'Postmasters and mail superintendents', '-', '-', 'postmasters-and-mail-superintendents', 2023, '-', '4', '12'),
('management-occupations', '489', 'Property, real estate, and community association managers', '1,263', '1,143', 'property-real-estate-and-community-association-managers', 2023, '1,521', '189', '300'),
('management-occupations', '410', 'Social and community service managers', '1,382', '1,341', 'social-and-community-service-managers', 2023, '1,501', '113', '297'),
('management-occupations', '13', 'Emergency management directors', '-', '-', 'emergency-management-directors', 2023, '-', '8', '4'),
('management-occupations', '10', 'Personal service managers, all other', '-', '-', 'personal-service-managers-all-other', 2023, '-', '2', '9'),
('management-occupations', '3,872', 'Managers, all other', '1,738', '1,536', 'managers-all-other', 2023, '1,887', '2,263', '1,609'),
('management-business-and-financial-operations-occupations', '8,227', 'Business and financial operations occupations', '1,517', '1,406', 'business-and-financial-operations-occupations', 2023, '1,674', '3,694', '4,533'),
('business-and-financial-operations-occupations', '29', 'Agents and business managers of artists, performers, and athletes', '-', '-', 'agents-and-business-managers-of-artists-performers-and-athletes', 2023, '-', '15', '14'),
('business-and-financial-operations-occupations', '8', 'Buyers and purchasing agents, farm products', '-', '-', 'buyers-and-purchasing-agents-farm-products', 2023, '-', '5', '3'),
('business-and-financial-operations-occupations', '141', 'Wholesale and retail buyers, except farm products', '1,125', '1,029', 'wholesale-and-retail-buyers-except-farm-products', 2023, '1,270', '57', '84'),
('business-and-financial-operations-occupations', '287', 'Purchasing agents, except wholesale, retail, and farm products', '1,370', '1,216', 'purchasing-agents-except-wholesale-retail-and-farm-products', 2023, '1,514', '134', '153'),
('business-and-financial-operations-occupations', '367', 'Claims adjusters, appraisers, examiners, and investigators', '1,370', '1,306', 'claims-adjusters-appraisers-examiners-and-investigators', 2023, '1,468', '153', '214'),
('business-and-financial-operations-occupations', '314', 'Compliance officers', '1,458', '1,377', 'compliance-officers', 2023, '1,597', '145', '169'),
('business-and-financial-operations-occupations', '134', 'Cost estimators', '1,355', '-', 'cost-estimators', 2023, '1,401', '114', '20'),
('business-and-financial-operations-occupations', '893', 'Human resources workers', '1,273', '1,259', 'human-resources-workers', 2023, '1,367', '226', '667'),
('business-and-financial-operations-occupations', '68', 'Compensation, benefits, and job analysis specialists', '1,252', '1,266', 'compensation-benefits-and-job-analysis-specialists', 2023, '-', '16', '51');

-- 2024-03-09 19:09:22.0260
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('business-and-financial-operations-occupations', '144', 'Training and development specialists', '1,342', '1,222', 'training-and-development-specialists', 2023, '1,648', '63', '80'),
('business-and-financial-operations-occupations', '182', 'Logisticians', '1,130', '994', 'logisticians', 2023, '1,207', '105', '78'),
('business-and-financial-operations-occupations', '886', 'Project management specialists', '1,811', '1,661', 'project-management-specialists', 2023, '1,919', '481', '405'),
('business-and-financial-operations-occupations', '714', 'Management analysts', '1,890', '1,817', 'management-analysts', 2023, '1,993', '360', '354'),
('business-and-financial-operations-occupations', '98', 'Meeting, convention, and event planners', '1,234', '1,203', 'meeting-convention-and-event-planners', 2023, '-', '25', '73'),
('business-and-financial-operations-occupations', '91', 'Fundraisers', '1,481', '1,489', 'fundraisers', 2023, '-', '22', '69'),
('business-and-financial-operations-occupations', '416', 'Market research analysts and marketing specialists', '1,590', '1,552', 'market-research-analysts-and-marketing-specialists', 2023, '1,771', '164', '252'),
('business-and-financial-operations-occupations', '474', 'Business operations specialists, all other', '1,465', '1,224', 'business-operations-specialists-all-other', 2023, '1,737', '212', '262'),
('business-and-financial-operations-occupations', '1,394', 'Accountants and auditors', '1,553', '1,504', 'accountants-and-auditors', 2023, '1,644', '587', '807'),
('business-and-financial-operations-occupations', '53', 'Property appraisers and assessors', '1,568', '-', 'property-appraisers-and-assessors', 2023, '-', '34', '19'),
('business-and-financial-operations-occupations', '37', 'Budget analysts', '-', '-', 'budget-analysts', 2023, '-', '21', '16'),
('business-and-financial-operations-occupations', '47', 'Credit analysts', '-', '-', 'credit-analysts', 2023, '-', '31', '16'),
('business-and-financial-operations-occupations', '358', 'Financial and investment analysts', '1,668', '1,643', 'financial-and-investment-analysts', 2023, '1,760', '181', '177'),
('business-and-financial-operations-occupations', '412', 'Personal financial advisors', '1,884', '1,552', 'personal-financial-advisors', 2023, '2,082', '258', '154'),
('business-and-financial-operations-occupations', '96', 'Insurance underwriters', '1,367', '1,224', 'insurance-underwriters', 2023, '-', '42', '54'),
('business-and-financial-operations-occupations', '19', 'Financial examiners', '-', '-', 'financial-examiners', 2023, '-', '9', '9'),
('business-and-financial-operations-occupations', '304', 'Credit counselors and loan officers', '1,360', '1,294', 'credit-counselors-and-loan-officers', 2023, '1,457', '139', '165'),
('business-and-financial-operations-occupations', '78', 'Tax examiners and collectors, and revenue agents', '1,396', '-', 'tax-examiners-and-collectors-and-revenue-agents', 2023, '-', '32', '46'),
('business-and-financial-operations-occupations', '63', 'Tax preparers', '1,154', '-', 'tax-preparers', 2023, '-', '14', '49'),
('business-and-financial-operations-occupations', '120', 'Other financial specialists', '1,481', '1,233', 'other-financial-specialists', 2023, '2,386', '51', '69'),
('management-professional-and-related-occupations', '32,088', 'Professional and related occupations', '1,458', '1,278', 'professional-and-related-occupations', 2023, '1,736', '14,645', '17,443'),
('professional-and-related-occupations', '6,129', 'Computer and mathematical occupations', '1,890', '1,628', 'computer-and-mathematical-occupations', 2023, '1,976', '4,522', '1,607'),
('computer-and-mathematical-occupations', '38', 'Computer and information research scientists', '-', '-', 'computer-and-information-research-scientists', 2023, '-', '26', '12'),
('computer-and-mathematical-occupations', '485', 'Computer systems analysts', '1,701', '1,487', 'computer-systems-analysts', 2023, '1,894', '291', '195'),
('computer-and-mathematical-occupations', '209', 'Information security analysts', '2,133', '-', 'information-security-analysts', 2023, '2,306', '169', '40'),
('computer-and-mathematical-occupations', '375', 'Computer programmers', '1,889', '1,760', 'computer-programmers', 2023, '1,906', '300', '75'),
('computer-and-mathematical-occupations', '2,104', 'Software developers', '2,283', '2,020', 'software-developers', 2023, '2,296', '1,682', '422'),
('computer-and-mathematical-occupations', '73', 'Software quality assurance analysts and testers', '1,751', '-', 'software-quality-assurance-analysts-and-testers', 2023, '-', '44', '29'),
('computer-and-mathematical-occupations', '57', 'Web developers', '2,197', '-', 'web-developers', 2023, '-', '49', '8'),
('computer-and-mathematical-occupations', '59', 'Web and digital interface designers', '1,423', '-', 'web-and-digital-interface-designers', 2023, '-', '30', '29'),
('computer-and-mathematical-occupations', '616', 'Computer support specialists', '1,424', '1,348', 'computer-support-specialists', 2023, '1,478', '454', '162'),
('computer-and-mathematical-occupations', '108', 'Database administrators and architects', '2,113', '-', 'database-administrators-and-architects', 2023, '2,283', '78', '30'),
('computer-and-mathematical-occupations', '200', 'Network and computer systems administrators', '1,670', '-', 'network-and-computer-systems-administrators', 2023, '1,830', '169', '30'),
('computer-and-mathematical-occupations', '97', 'Computer network architects', '1,913', '-', 'computer-network-architects', 2023, '1,967', '90', '8'),
('computer-and-mathematical-occupations', '1,104', 'Computer occupations, all other', '1,597', '1,430', 'computer-occupations-all-other', 2023, '1,631', '833', '271'),
('computer-and-mathematical-occupations', '45', 'Actuaries', '-', '-', 'actuaries', 2023, '-', '27', '18'),
('computer-and-mathematical-occupations', '4', 'Mathematicians', '-', '-', 'mathematicians', 2023, '-', '4', '0'),
('computer-and-mathematical-occupations', '142', 'Operations research analysts', '1,917', '1,665', 'operations-research-analysts', 2023, '2,208', '65', '77'),
('computer-and-mathematical-occupations', '44', 'Statisticians', '-', '-', 'statisticians', 2023, '-', '25', '18'),
('computer-and-mathematical-occupations', '369', 'Other mathematical science occupations', '1,595', '1,474', 'other-mathematical-science-occupations', 2023, '1,668', '188', '181'),
('professional-and-related-occupations', '3,374', 'Architecture and engineering occupations', '1,785', '1,635', 'architecture-and-engineering-occupations', 2023, '1,864', '2,821', '553'),
('architecture-and-engineering-occupations', '162', 'Architects, except landscape and naval', '1,831', '1,691', 'architects-except-landscape-and-naval', 2023, '1,893', '108', '55');

-- 2024-03-09 19:09:22.0280
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('architecture-and-engineering-occupations', '19', 'Landscape architects', '-', '-', 'landscape-architects', 2023, '-', '11', '9'),
('architecture-and-engineering-occupations', '37', 'Surveyors, cartographers, and photogrammetrists', '-', '-', 'surveyors-cartographers-and-photogrammetrists', 2023, '-', '31', '6'),
('architecture-and-engineering-occupations', '177', 'Aerospace engineers', '2,071', '-', 'aerospace-engineers', 2023, '2,086', '152', '25'),
('architecture-and-engineering-occupations', '4', 'Agricultural engineers', '-', '-', 'agricultural-engineers', 2023, '-', '4', '0'),
('architecture-and-engineering-occupations', '27', 'Bioengineers and biomedical engineers', '-', '-', 'bioengineers-and-biomedical-engineers', 2023, '-', '21', '6'),
('architecture-and-engineering-occupations', '86', 'Chemical engineers', '2,285', '-', 'chemical-engineers', 2023, '2,300', '67', '19'),
('architecture-and-engineering-occupations', '479', 'Civil engineers', '1,752', '1,465', 'civil-engineers', 2023, '1,839', '401', '78'),
('architecture-and-engineering-occupations', '69', 'Computer hardware engineers', '2,277', '-', 'computer-hardware-engineers', 2023, '2,252', '65', '4'),
('architecture-and-engineering-occupations', '244', 'Electrical and electronics engineers', '2,056', '-', 'electrical-and-electronics-engineers', 2023, '2,101', '216', '28'),
('architecture-and-engineering-occupations', '29', 'Environmental engineers', '-', '-', 'environmental-engineers', 2023, '-', '22', '7'),
('architecture-and-engineering-occupations', '278', 'Industrial engineers, including health and safety', '1,740', '1,682', 'industrial-engineers-including-health-and-safety', 2023, '1,766', '209', '69'),
('architecture-and-engineering-occupations', '11', 'Marine engineers and naval architects', '-', '-', 'marine-engineers-and-naval-architects', 2023, '-', '11', '0'),
('architecture-and-engineering-occupations', '52', 'Materials engineers', '2,220', '-', 'materials-engineers', 2023, '-', '46', '6'),
('architecture-and-engineering-occupations', '423', 'Mechanical engineers', '1,890', '-', 'mechanical-engineers', 2023, '1,901', '381', '43'),
('architecture-and-engineering-occupations', '9', 'Mining and geological engineers, including mining safety engineers', '-', '-', 'mining-and-geological-engineers-including-mining-safety-engineers', 2023, '-', '9', '0'),
('architecture-and-engineering-occupations', '4', 'Nuclear engineers', '-', '-', 'nuclear-engineers', 2023, '-', '4', '0'),
('architecture-and-engineering-occupations', '10', 'Petroleum engineers', '-', '-', 'petroleum-engineers', 2023, '-', '10', '0'),
('architecture-and-engineering-occupations', '620', 'Engineers, all other', '1,938', '1,904', 'engineers-all-other', 2023, '1,953', '528', '93'),
('architecture-and-engineering-occupations', '23', 'Architectural and civil drafters', '-', '-', 'architectural-and-civil-drafters', 2023, '-', '19', '4'),
('architecture-and-engineering-occupations', '73', 'Other drafters', '1,326', '-', 'other-drafters', 2023, '1,259', '58', '15'),
('architecture-and-engineering-occupations', '93', 'Electrical and electronic engineering technologists and technicians', '1,429', '-', 'electrical-and-electronic-engineering-technologists-and-technicians', 2023, '1,442', '82', '12'),
('architecture-and-engineering-occupations', '359', 'Other engineering technologists and technicians, except drafters', '1,217', '982', 'other-engineering-technologists-and-technicians-except-drafters', 2023, '1,287', '296', '63'),
('architecture-and-engineering-occupations', '83', 'Surveying and mapping technicians', '1,001', '-', 'surveying-and-mapping-technicians', 2023, '1,023', '73', '10'),
('professional-and-related-occupations', '1,583', 'Life, physical, and social science occupations', '1,541', '1,445', 'life-physical-and-social-science-occupations', 2023, '1,658', '830', '753'),
('life-physical-and-social-science-occupations', '22', 'Agricultural and food scientists', '-', '-', 'agricultural-and-food-scientists', 2023, '-', '13', '10'),
('life-physical-and-social-science-occupations', '104', 'Biological scientists', '1,404', '1,352', 'biological-scientists', 2023, '-', '47', '57'),
('life-physical-and-social-science-occupations', '29', 'Conservation scientists and foresters', '-', '-', 'conservation-scientists-and-foresters', 2023, '-', '19', '10'),
('life-physical-and-social-science-occupations', '138', 'Medical scientists', '1,826', '1,537', 'medical-scientists', 2023, '2,290', '69', '69'),
('life-physical-and-social-science-occupations', '8', 'Life scientists, all other', '-', '-', 'life-scientists-all-other', 2023, '-', '3', '5'),
('life-physical-and-social-science-occupations', '24', 'Astronomers and physicists', '-', '-', 'astronomers-and-physicists', 2023, '-', '19', '5'),
('life-physical-and-social-science-occupations', '13', 'Atmospheric and space scientists', '-', '-', 'atmospheric-and-space-scientists', 2023, '-', '9', '4'),
('life-physical-and-social-science-occupations', '96', 'Chemists and materials scientists', '1,913', '-', 'chemists-and-materials-scientists', 2023, '2,180', '63', '33'),
('life-physical-and-social-science-occupations', '49', 'Environmental scientists and specialists, including health', '-', '-', 'environmental-scientists-and-specialists-including-health', 2023, '-', '26', '23'),
('life-physical-and-social-science-occupations', '31', 'Geoscientists and hydrologists, except geographers', '-', '-', 'geoscientists-and-hydrologists-except-geographers', 2023, '-', '21', '10');

-- 2024-03-09 19:09:22.0300
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('life-physical-and-social-science-occupations', '399', 'Physical scientists, all other', '1,731', '1,649', 'physical-scientists-all-other', 2023, '1,742', '220', '179'),
('life-physical-and-social-science-occupations', '22', 'Economists', '-', '-', 'economists', 2023, '-', '14', '8'),
('life-physical-and-social-science-occupations', '3', 'Survey researchers', '-', '-', 'survey-researchers', 2023, '-', '2', '2'),
('life-physical-and-social-science-occupations', '5', 'Clinical and counseling psychologists', '-', '-', 'clinical-and-counseling-psychologists', 2023, '-', '2', '3'),
('life-physical-and-social-science-occupations', '46', 'School psychologists', '-', '-', 'school-psychologists', 2023, '-', '5', '41'),
('life-physical-and-social-science-occupations', '65', 'Other psychologists', '1,726', '-', 'other-psychologists', 2023, '-', '16', '49'),
('life-physical-and-social-science-occupations', '6', 'Sociologists', '-', '-', 'sociologists', 2023, '-', '1', '4'),
('life-physical-and-social-science-occupations', '34', 'Urban and regional planners', '-', '-', 'urban-and-regional-planners', 2023, '-', '23', '12'),
('life-physical-and-social-science-occupations', '42', 'Miscellaneous social scientists and related workers', '-', '-', 'miscellaneous-social-scientists-and-related-workers', 2023, '-', '20', '22'),
('life-physical-and-social-science-occupations', '34', 'Agricultural and food science technicians', '-', '-', 'agricultural-and-food-science-technicians', 2023, '-', '20', '15'),
('life-physical-and-social-science-occupations', '26', 'Biological technicians', '-', '-', 'biological-technicians', 2023, '-', '15', '11'),
('life-physical-and-social-science-occupations', '58', 'Chemical technicians', '1,377', '-', 'chemical-technicians', 2023, '-', '39', '18'),
('life-physical-and-social-science-occupations', '13', 'Environmental science and geoscience technicians', '-', '-', 'environmental-science-and-geoscience-technicians', 2023, '-', '11', '2'),
('life-physical-and-social-science-occupations', '8', 'Nuclear technicians', '-', '-', 'nuclear-technicians', 2023, '-', '3', '5'),
('life-physical-and-social-science-occupations', '4', 'Social science research assistants', '-', '-', 'social-science-research-assistants', 2023, '-', '3', '1'),
('life-physical-and-social-science-occupations', '240', 'Other life, physical, and social science technicians', '1,306', '1,275', 'other-life-physical-and-social-science-technicians', 2023, '1,430', '99', '141'),
('life-physical-and-social-science-occupations', '63', 'Occupational health and safety specialists and technicians', '1,437', '-', 'occupational-health-and-safety-specialists-and-technicians', 2023, '-', '49', '14'),
('professional-and-related-occupations', '2,334', 'Community and social service occupations', '1,147', '1,144', 'community-and-social-service-occupations', 2023, '1,157', '735', '1,599'),
('community-and-social-service-occupations', '103', 'Substance abuse and behavioral disorder counselors', '1,138', '1,130', 'substance-abuse-and-behavioral-disorder-counselors', 2023, '-', '24', '79'),
('community-and-social-service-occupations', '338', 'Educational, guidance, and career counselors and advisors', '1,167', '1,158', 'educational-guidance-and-career-counselors-and-advisors', 2023, '1,227', '73', '264'),
('community-and-social-service-occupations', '14', 'Marriage and family therapists', '-', '-', 'marriage-and-family-therapists', 2023, '-', '1', '13'),
('community-and-social-service-occupations', '123', 'Mental health counselors', '1,316', '1,372', 'mental-health-counselors', 2023, '-', '32', '91'),
('community-and-social-service-occupations', '13', 'Rehabilitation counselors', '-', '-', 'rehabilitation-counselors', 2023, '-', '5', '8'),
('community-and-social-service-occupations', '182', 'Counselors, all other', '1,070', '1,011', 'counselors-all-other', 2023, '1,248', '51', '132');

-- 2024-03-09 19:09:22.0320
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('community-and-social-service-occupations', '64', 'Child, family, and school social workers', '1,064', '1,080', 'child-family-and-school-social-workers', 2023, '-', '6', '57'),
('community-and-social-service-occupations', '68', 'Healthcare social workers', '1,028', '1,028', 'healthcare-social-workers', 2023, '-', '18', '50'),
('community-and-social-service-occupations', '11', 'Mental health and substance abuse social workers', '-', '-', 'mental-health-and-substance-abuse-social-workers', 2023, '-', '3', '8'),
('community-and-social-service-occupations', '654', 'Social workers, all other', '1,233', '1,228', 'social-workers-all-other', 2023, '1,253', '113', '541'),
('community-and-social-service-occupations', '79', 'Probation officers and correctional treatment specialists', '1,196', '-', 'probation-officers-and-correctional-treatment-specialists', 2023, '-', '33', '46'),
('community-and-social-service-occupations', '200', 'Social and human service assistants', '963', '962', 'social-and-human-service-assistants', 2023, '967', '54', '146'),
('community-and-social-service-occupations', '82', 'Other community and social service specialists', '1,045', '1,055', 'other-community-and-social-service-specialists', 2023, '-', '23', '60'),
('community-and-social-service-occupations', '308', 'Clergy', '1,084', '-', 'clergy', 2023, '1,074', '261', '47'),
('community-and-social-service-occupations', '58', 'Directors, religious activities and education', '1,244', '-', 'directors-religious-activities-and-education', 2023, '-', '21', '37'),
('community-and-social-service-occupations', '37', 'Religious workers, all other', '-', '-', 'religious-workers-all-other', 2023, '-', '17', '20'),
('professional-and-related-occupations', '1,490', 'Legal occupations', '1,880', '1,543', 'legal-occupations', 2023, '2,301', '667', '823'),
('legal-occupations', '887', 'Lawyers', '2,438', '2,330', 'lawyers', 2023, '2,505', '514', '374'),
('legal-occupations', '13', 'Judicial law clerks', '-', '-', 'judicial-law-clerks', 2023, '-', '1', '13'),
('legal-occupations', '66', 'Judges, magistrates, and other judicial workers', '2,196', '-', 'judges-magistrates-and-other-judicial-workers', 2023, '-', '32', '34'),
('legal-occupations', '371', 'Paralegals and legal assistants', '1,159', '1,125', 'paralegals-and-legal-assistants', 2023, '1,425', '68', '303'),
('legal-occupations', '83', 'Title examiners, abstractors, and searchers', '1,143', '1,030', 'title-examiners-abstractors-and-searchers', 2023, '-', '25', '58'),
('legal-occupations', '70', 'Legal support workers, all other', '1,320', '-', 'legal-support-workers-all-other', 2023, '-', '28', '42'),
('professional-and-related-occupations', '7,524', 'Education, training, and library occupations', '1,180', '1,134', 'education-training-and-library-occupations', 2023, '1,376', '2,070', '5,455'),
('education-training-and-library-occupations', '828', 'Postsecondary teachers', '1,723', '1,565', 'postsecondary-teachers', 2023, '1,852', '462', '366'),
('education-training-and-library-occupations', '523', 'Preschool and kindergarten teachers', '791', '789', 'preschool-and-kindergarten-teachers', 2023, '-', '18', '505'),
('education-training-and-library-occupations', '3,117', 'Elementary and middle school teachers', '1,243', '1,220', 'elementary-and-middle-school-teachers', 2023, '1,370', '673', '2,444'),
('education-training-and-library-occupations', '859', 'Secondary school teachers', '1,271', '1,213', 'secondary-school-teachers', 2023, '1,347', '367', '493'),
('education-training-and-library-occupations', '308', 'Special education teachers', '1,164', '1,156', 'special-education-teachers', 2023, '-', '42', '266'),
('education-training-and-library-occupations', '28', 'Tutors', '-', '-', 'tutors', 2023, '-', '8', '20'),
('education-training-and-library-occupations', '584', 'Other teachers and instructors', '1,165', '1,124', 'other-teachers-and-instructors', 2023, '1,242', '229', '355'),
('education-training-and-library-occupations', '57', 'Archivists, curators, and museum technicians', '1,289', '-', 'archivists-curators-and-museum-technicians', 2023, '-', '22', '35'),
('education-training-and-library-occupations', '117', 'Librarians and media collections specialists', '1,118', '1,174', 'librarians-and-media-collections-specialists', 2023, '-', '24', '93'),
('education-training-and-library-occupations', '15', 'Library technicians', '-', '-', 'library-technicians', 2023, '-', '5', '11'),
('education-training-and-library-occupations', '940', 'Teaching assistants', '698', '685', 'teaching-assistants', 2023, '772', '184', '757'),
('education-training-and-library-occupations', '148', 'Other educational instruction and library workers', '1,310', '1,291', 'other-educational-instruction-and-library-workers', 2023, '-', '37', '111'),
('professional-and-related-occupations', '1,858', 'Arts, design, entertainment, sports, and media occupations', '1,343', '1,271', 'arts-design-entertainment-sports-and-media-occupations', 2023, '1,381', '1,036', '822'),
('arts-design-entertainment-sports-and-media-occupations', '94', 'Artists and related workers', '1,543', '-', 'artists-and-related-workers', 2023, '1,458', '57', '37'),
('arts-design-entertainment-sports-and-media-occupations', '13', 'Commercial and industrial designers', '-', '-', 'commercial-and-industrial-designers', 2023, '-', '11', '2');

-- 2024-03-09 19:09:22.0340
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('arts-design-entertainment-sports-and-media-occupations', '25', 'Fashion designers', '-', '-', 'fashion-designers', 2023, '-', '6', '19'),
('arts-design-entertainment-sports-and-media-occupations', '25', 'Floral designers', '-', '-', 'floral-designers', 2023, '-', '6', '19'),
('arts-design-entertainment-sports-and-media-occupations', '248', 'Graphic designers', '1,253', '1,221', 'graphic-designers', 2023, '1,294', '119', '130'),
('arts-design-entertainment-sports-and-media-occupations', '50', 'Interior designers', '1,256', '-', 'interior-designers', 2023, '-', '10', '40'),
('arts-design-entertainment-sports-and-media-occupations', '18', 'Merchandise displayers and window trimmers', '-', '-', 'merchandise-displayers-and-window-trimmers', 2023, '-', '7', '11'),
('arts-design-entertainment-sports-and-media-occupations', '272', 'Other designers', '1,482', '1,408', 'other-designers', 2023, '1,495', '178', '94'),
('arts-design-entertainment-sports-and-media-occupations', '17', 'Actors', '-', '-', 'actors', 2023, '-', '7', '11'),
('arts-design-entertainment-sports-and-media-occupations', '130', 'Producers and directors', '1,467', '1,609', 'producers-and-directors', 2023, '1,312', '58', '72'),
('arts-design-entertainment-sports-and-media-occupations', '28', 'Athletes and sports competitors', '-', '-', 'athletes-and-sports-competitors', 2023, '-', '23', '5'),
('arts-design-entertainment-sports-and-media-occupations', '113', 'Coaches and scouts', '1,168', '-', 'coaches-and-scouts', 2023, '1,336', '85', '29'),
('arts-design-entertainment-sports-and-media-occupations', '2', 'Umpires, referees, and other sports officials', '-', '-', 'umpires-referees-and-other-sports-officials', 2023, '-', '2', '0'),
('arts-design-entertainment-sports-and-media-occupations', '5', 'Dancers and choreographers', '-', '-', 'dancers-and-choreographers', 2023, '-', '2', '3'),
('arts-design-entertainment-sports-and-media-occupations', '18', 'Music directors and composers', '-', '-', 'music-directors-and-composers', 2023, '-', '13', '4'),
('arts-design-entertainment-sports-and-media-occupations', '36', 'Musicians and singers', '-', '-', 'musicians-and-singers', 2023, '-', '30', '6'),
('arts-design-entertainment-sports-and-media-occupations', '12', 'Disc jockeys, except radio', '-', '-', 'disc-jockeys-except-radio', 2023, '-', '12', '0'),
('arts-design-entertainment-sports-and-media-occupations', '6', 'Entertainers and performers, sports and related workers, all other', '-', '-', 'entertainers-and-performers-sports-and-related-workers-all-other', 2023, '-', '1', '4'),
('arts-design-entertainment-sports-and-media-occupations', '20', 'Broadcast announcers and radio disc jockeys', '-', '-', 'broadcast-announcers-and-radio-disc-jockeys', 2023, '-', '12', '8'),
('arts-design-entertainment-sports-and-media-occupations', '46', 'News analysts, reporters, and journalists', '-', '-', 'news-analysts-reporters-and-journalists', 2023, '-', '25', '21'),
('arts-design-entertainment-sports-and-media-occupations', '126', 'Public relations specialists', '1,544', '1,541', 'public-relations-specialists', 2023, '-', '36', '90'),
('arts-design-entertainment-sports-and-media-occupations', '82', 'Editors', '1,440', '-', 'editors', 2023, '-', '36', '46'),
('arts-design-entertainment-sports-and-media-occupations', '46', 'Technical writers', '-', '-', 'technical-writers', 2023, '-', '17', '29'),
('arts-design-entertainment-sports-and-media-occupations', '101', 'Writers and authors', '1,322', '-', 'writers-and-authors', 2023, '1,551', '57', '44'),
('arts-design-entertainment-sports-and-media-occupations', '55', 'Interpreters and translators', '964', '-', 'interpreters-and-translators', 2023, '-', '18', '36'),
('arts-design-entertainment-sports-and-media-occupations', '12', 'Court reporters and simultaneous captioners', '-', '-', 'court-reporters-and-simultaneous-captioners', 2023, '-', '2', '10'),
('arts-design-entertainment-sports-and-media-occupations', '22', 'Media and communication workers, all other', '-', '-', 'media-and-communication-workers-all-other', 2023, '-', '18', '4'),
('arts-design-entertainment-sports-and-media-occupations', '80', 'Broadcast, sound, and lighting technicians', '1,387', '-', 'broadcast-sound-and-lighting-technicians', 2023, '1,397', '73', '6');

-- 2024-03-09 19:09:22.0350
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('arts-design-entertainment-sports-and-media-occupations', '62', 'Photographers', '1,135', '-', 'photographers', 2023, '-', '46', '16'),
('arts-design-entertainment-sports-and-media-occupations', '93', 'Television, video, and film camera operators and editors', '1,259', '-', 'television-video-and-film-camera-operators-and-editors', 2023, '1,254', '67', '26'),
('arts-design-entertainment-sports-and-media-occupations', '2', 'Media and communication equipment workers, all other', '-', '-', 'media-and-communication-equipment-workers-all-other', 2023, '-', '2', '0'),
('professional-and-related-occupations', '7,795', 'Healthcare practitioners and technical occupations', '1,404', '1,341', 'healthcare-practitioners-and-technical-occupations', 2023, '1,682', '1,963', '5,832'),
('healthcare-practitioners-and-technical-occupations', '13', 'Chiropractors', '-', '-', 'chiropractors', 2023, '-', '5', '9'),
('healthcare-practitioners-and-technical-occupations', '64', 'Dentists', '2,837', '-', 'dentists', 2023, '-', '33', '31'),
('healthcare-practitioners-and-technical-occupations', '84', 'Dietitians and nutritionists', '1,137', '1,147', 'dietitians-and-nutritionists', 2023, '-', '16', '69'),
('healthcare-practitioners-and-technical-occupations', '16', 'Optometrists', '-', '-', 'optometrists', 2023, '-', '6', '11'),
('healthcare-practitioners-and-technical-occupations', '316', 'Pharmacists', '2,208', '2,180', 'pharmacists', 2023, '2,238', '134', '182'),
('healthcare-practitioners-and-technical-occupations', '21', 'Emergency medicine physicians', '-', '-', 'emergency-medicine-physicians', 2023, '-', '9', '11'),
('healthcare-practitioners-and-technical-occupations', '18', 'Radiologists', '-', '-', 'radiologists', 2023, '-', '13', '5'),
('healthcare-practitioners-and-technical-occupations', '715', 'Other physicians', '2,914', '2,907', 'other-physicians', 2023, '2,920', '398', '317'),
('healthcare-practitioners-and-technical-occupations', '52', 'Surgeons', '3,300', '-', 'surgeons', 2023, '-', '42', '10'),
('healthcare-practitioners-and-technical-occupations', '137', 'Physician assistants', '2,006', '1,852', 'physician-assistants', 2023, '-', '45', '92'),
('healthcare-practitioners-and-technical-occupations', '3', 'Podiatrists', '-', '-', 'podiatrists', 2023, '-', '0', '3'),
('healthcare-practitioners-and-technical-occupations', '14', 'Audiologists', '-', '-', 'audiologists', 2023, '-', '1', '13'),
('healthcare-practitioners-and-technical-occupations', '116', 'Occupational therapists', '1,447', '1,431', 'occupational-therapists', 2023, '-', '14', '102'),
('healthcare-practitioners-and-technical-occupations', '234', 'Physical therapists', '1,607', '1,526', 'physical-therapists', 2023, '1,715', '89', '145'),
('healthcare-practitioners-and-technical-occupations', '15', 'Radiation therapists', '-', '-', 'radiation-therapists', 2023, '-', '2', '13');

-- 2024-03-09 19:09:22.0360
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('healthcare-practitioners-and-technical-occupations', '7', 'Recreational therapists', '-', '-', 'recreational-therapists', 2023, '-', '1', '6'),
('healthcare-practitioners-and-technical-occupations', '78', 'Respiratory therapists', '1,371', '-', 'respiratory-therapists', 2023, '-', '36', '42'),
('healthcare-practitioners-and-technical-occupations', '140', 'Speech-language pathologists', '1,433', '1,435', 'speech-language-pathologists', 2023, '-', '11', '128'),
('healthcare-practitioners-and-technical-occupations', '6', 'Exercise physiologists', '-', '-', 'exercise-physiologists', 2023, '-', '3', '4'),
('healthcare-practitioners-and-technical-occupations', '178', 'Therapists, all other', '1,257', '1,257', 'therapists-all-other', 2023, '-', '31', '147'),
('healthcare-practitioners-and-technical-occupations', '53', 'Veterinarians', '2,020', '-', 'veterinarians', 2023, '-', '17', '36'),
('healthcare-practitioners-and-technical-occupations', '2,817', 'Registered nurses', '1,442', '1,409', 'registered-nurses', 2023, '1,657', '404', '2,413'),
('healthcare-practitioners-and-technical-occupations', '14', 'Nurse anesthetists', '-', '-', 'nurse-anesthetists', 2023, '-', '6', '8'),
('healthcare-practitioners-and-technical-occupations', '3', 'Nurse midwives', '-', '-', 'nurse-midwives', 2023, '-', '0', '3'),
('healthcare-practitioners-and-technical-occupations', '212', 'Nurse practitioners', '2,079', '2,031', 'nurse-practitioners', 2023, '-', '20', '191'),
('healthcare-practitioners-and-technical-occupations', '3', 'Acupuncturists', '-', '-', 'acupuncturists', 2023, '-', '2', '1'),
('healthcare-practitioners-and-technical-occupations', '4', 'Healthcare diagnosing or treating practitioners, all other', '-', '-', 'healthcare-diagnosing-or-treating-practitioners-all-other', 2023, '-', '2', '3'),
('healthcare-practitioners-and-technical-occupations', '251', 'Clinical laboratory technologists and technicians', '1,117', '1,089', 'clinical-laboratory-technologists-and-technicians', 2023, '1,172', '55', '197'),
('healthcare-practitioners-and-technical-occupations', '106', 'Dental hygienists', '1,326', '1,276', 'dental-hygienists', 2023, '-', '5', '100'),
('healthcare-practitioners-and-technical-occupations', '33', 'Cardiovascular technologists and technicians', '-', '-', 'cardiovascular-technologists-and-technicians', 2023, '-', '14', '18'),
('healthcare-practitioners-and-technical-occupations', '87', 'Diagnostic medical sonographers', '1,343', '1,286', 'diagnostic-medical-sonographers', 2023, '-', '29', '58'),
('healthcare-practitioners-and-technical-occupations', '204', 'Radiologic technologists and technicians', '1,412', '1,321', 'radiologic-technologists-and-technicians', 2023, '1,483', '68', '136'),
('healthcare-practitioners-and-technical-occupations', '41', 'Magnetic resonance imaging technologists', '-', '-', 'magnetic-resonance-imaging-technologists', 2023, '-', '8', '33');

-- 2024-03-09 19:09:22.0360
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('healthcare-practitioners-and-technical-occupations', '35', 'Nuclear medicine technologists and medical dosimetrists', '-', '-', 'nuclear-medicine-technologists-and-medical-dosimetrists', 2023, '-', '19', '16'),
('healthcare-practitioners-and-technical-occupations', '119', 'Emergency medical technicians', '1,101', '-', 'emergency-medical-technicians', 2023, '1,170', '78', '41'),
('healthcare-practitioners-and-technical-occupations', '102', 'Paramedics', '1,318', '-', 'paramedics', 2023, '1,349', '70', '32'),
('healthcare-practitioners-and-technical-occupations', '244', 'Pharmacy technicians', '903', '886', 'pharmacy-technicians', 2023, '992', '55', '189'),
('healthcare-practitioners-and-technical-occupations', '99', 'Psychiatric technicians', '885', '895', 'psychiatric-technicians', 2023, '-', '37', '62'),
('healthcare-practitioners-and-technical-occupations', '95', 'Surgical technologists', '1,244', '1,235', 'surgical-technologists', 2023, '-', '18', '77'),
('healthcare-practitioners-and-technical-occupations', '99', 'Veterinary technologists and technicians', '829', '817', 'veterinary-technologists-and-technicians', 2023, '-', '11', '88'),
('healthcare-practitioners-and-technical-occupations', '46', 'Dietetic technicians and ophthalmic medical technicians', '-', '-', 'dietetic-technicians-and-ophthalmic-medical-technicians', 2023, '-', '14', '32'),
('healthcare-practitioners-and-technical-occupations', '479', 'Licensed practical and licensed vocational nurses', '988', '984', 'licensed-practical-and-licensed-vocational-nurses', 2023, '1,018', '59', '420'),
('healthcare-practitioners-and-technical-occupations', '184', 'Medical records specialists', '918', '946', 'medical-records-specialists', 2023, '-', '22', '162'),
('healthcare-practitioners-and-technical-occupations', '37', 'Opticians, dispensing', '-', '-', 'opticians-dispensing', 2023, '-', '7', '30'),
('healthcare-practitioners-and-technical-occupations', '119', 'Miscellaneous health technologists and technicians', '1,035', '1,014', 'miscellaneous-health-technologists-and-technicians', 2023, '-', '25', '94');

-- 2024-03-09 19:09:22.0370
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('healthcare-practitioners-and-technical-occupations', '80', 'Other healthcare practitioners and technical occupations', '1,372', '1,203', 'other-healthcare-practitioners-and-technical-occupations', 2023, '-', '30', '51'),
('', '15,818', 'Service occupations', '721', '676', 'service-occupations', 2023, '801', '7,672', '8,146'),
('service-occupations', '3,467', 'Healthcare support occupations', '713', '704', 'healthcare-support-occupations', 2023, '794', '578', '2,890'),
('healthcare-support-occupations', '330', 'Home health aides', '644', '625', 'home-health-aides', 2023, '709', '59', '271'),
('healthcare-support-occupations', '903', 'Personal care aides', '679', '668', 'personal-care-aides', 2023, '751', '190', '713'),
('healthcare-support-occupations', '899', 'Nursing assistants', '700', '695', 'nursing-assistants', 2023, '765', '95', '804'),
('healthcare-support-occupations', '48', 'Orderlies and psychiatric aides', '-', '-', 'orderlies-and-psychiatric-aides', 2023, '-', '19', '29'),
('healthcare-support-occupations', '22', 'Occupational therapy assistants and aides', '-', '-', 'occupational-therapy-assistants-and-aides', 2023, '-', '6', '16'),
('healthcare-support-occupations', '75', 'Physical therapist assistants and aides', '909', '-', 'physical-therapist-assistants-and-aides', 2023, '-', '30', '44'),
('healthcare-support-occupations', '34', 'Massage therapists', '-', '-', 'massage-therapists', 2023, '-', '11', '23'),
('healthcare-support-occupations', '235', 'Dental assistants', '754', '758', 'dental-assistants', 2023, '-', '13', '222'),
('healthcare-support-occupations', '490', 'Medical assistants', '752', '738', 'medical-assistants', 2023, '904', '52', '438'),
('healthcare-support-occupations', '25', 'Medical transcriptionists', '-', '-', 'medical-transcriptionists', 2023, '-', '4', '20'),
('healthcare-support-occupations', '20', 'Pharmacy aides', '-', '-', 'pharmacy-aides', 2023, '-', '6', '13');

-- 2024-03-09 19:09:22.0380
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('healthcare-support-occupations', '67', 'Veterinary assistants and laboratory animal caretakers', '720', '701', 'veterinary-assistants-and-laboratory-animal-caretakers', 2023, '-', '14', '53'),
('healthcare-support-occupations', '133', 'Phlebotomists', '730', '723', 'phlebotomists', 2023, '-', '14', '119'),
('healthcare-support-occupations', '187', 'Other healthcare support workers', '833', '790', 'other-healthcare-support-workers', 2023, '919', '64', '124'),
('service-occupations', '2,706', 'Protective service occupations', '1,113', '884', 'protective-service-occupations', 2023, '1,190', '2,140', '566'),
('protective-service-occupations', '59', 'First-line supervisors of correctional officers', '1,432', '-', 'first-line-supervisors-of-correctional-officers', 2023, '-', '39', '20'),
('protective-service-occupations', '93', 'First-line supervisors of police and detectives', '1,800', '-', 'first-line-supervisors-of-police-and-detectives', 2023, '1,812', '83', '10'),
('protective-service-occupations', '47', 'First-line supervisors of firefighting and prevention workers', '-', '-', 'first-line-supervisors-of-firefighting-and-prevention-workers', 2023, '-', '45', '3'),
('protective-service-occupations', '70', 'First-line supervisors of security workers', '1,033', '-', 'first-line-supervisors-of-security-workers', 2023, '1,060', '55', '15'),
('protective-service-occupations', '3', 'First-line supervisors of protective service workers, all other', '-', '-', 'first-line-supervisors-of-protective-service-workers-all-other', 2023, '-', '2', '1'),
('protective-service-occupations', '297', 'Firefighters', '1,351', '-', 'firefighters', 2023, '1,357', '288', '9');

-- 2024-03-09 19:09:22.0380
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('protective-service-occupations', '19', 'Fire inspectors', '-', '-', 'fire-inspectors', 2023, '-', '14', '5'),
('protective-service-occupations', '12', 'Bailiffs', '-', '-', 'bailiffs', 2023, '-', '6', '6'),
('protective-service-occupations', '294', 'Correctional officers and jailers', '1,073', '914', 'correctional-officers-and-jailers', 2023, '1,133', '203', '91'),
('protective-service-occupations', '132', 'Detectives and criminal investigators', '1,732', '-', 'detectives-and-criminal-investigators', 2023, '1,833', '101', '31'),
('protective-service-occupations', '5', 'Fish and game wardens', '-', '-', 'fish-and-game-wardens', 2023, '-', '4', '1'),
('protective-service-occupations', '7', 'Parking enforcement workers', '-', '-', 'parking-enforcement-workers', 2023, '-', '3', '4'),
('protective-service-occupations', '709', 'Police officers', '1,320', '1,034', 'police-officers', 2023, '1,363', '605', '104'),
('protective-service-occupations', '12', 'Animal control workers', '-', '-', 'animal-control-workers', 2023, '-', '7', '5'),
('protective-service-occupations', '95', 'Private detectives and investigators', '1,326', '-', 'private-detectives-and-investigators', 2023, '1,481', '57', '38'),
('protective-service-occupations', '730', 'Security guards and gambling surveillance officers', '788', '717', 'security-guards-and-gambling-surveillance-officers', 2023, '811', '562', '168'),
('protective-service-occupations', '24', 'Crossing guards and flaggers', '-', '-', 'crossing-guards-and-flaggers', 2023, '-', '11', '13');

-- 2024-03-09 19:09:22.0420
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('protective-service-occupations', '45', 'Transportation security screeners', '-', '-', 'transportation-security-screeners', 2023, '-', '25', '21'),
('protective-service-occupations', '9', 'School bus monitors', '-', '-', 'school-bus-monitors', 2023, '-', '0', '9'),
('protective-service-occupations', '44', 'Other protective service workers', '-', '-', 'other-protective-service-workers', 2023, '-', '32', '11'),
('service-occupations', '4,325', 'Food preparation and serving related occupations', '660', '618', 'food-preparation-and-serving-related-occupations', 2023, '700', '2,289', '2,036'),
('food-preparation-and-serving-related-occupations', '391', 'Chefs and head cooks', '816', '690', 'chefs-and-head-cooks', 2023, '854', '304', '87'),
('food-preparation-and-serving-related-occupations', '432', 'First-line supervisors of food preparation and serving workers', '728', '677', 'first-line-supervisors-of-food-preparation-and-serving-workers', 2023, '819', '215', '217'),
('food-preparation-and-serving-related-occupations', '1,259', 'Cooks', '655', '608', 'cooks', 2023, '682', '813', '446'),
('food-preparation-and-serving-related-occupations', '484', 'Food preparation workers', '619', '600', 'food-preparation-workers', 2023, '645', '220', '264'),
('food-preparation-and-serving-related-occupations', '208', 'Bartenders', '764', '745', 'bartenders', 2023, '768', '129', '78'),
('food-preparation-and-serving-related-occupations', '288', 'Fast food and counter workers', '610', '595', 'fast-food-and-counter-workers', 2023, '639', '109', '179'),
('food-preparation-and-serving-related-occupations', '828', 'Waiters and waitresses', '642', '617', 'waiters-and-waitresses', 2023, '684', '281', '547'),
('food-preparation-and-serving-related-occupations', '91', 'Food servers, nonrestaurant', '623', '642', 'food-servers-nonrestaurant', 2023, '-', '32', '59'),
('food-preparation-and-serving-related-occupations', '132', 'Dining room and cafeteria attendants and bartender helpers', '593', '588', 'dining-room-and-cafeteria-attendants-and-bartender-helpers', 2023, '607', '62', '69'),
('food-preparation-and-serving-related-occupations', '133', 'Dishwashers', '598', '-', 'dishwashers', 2023, '601', '106', '27'),
('food-preparation-and-serving-related-occupations', '73', 'Hosts and hostesses, restaurant, lounge, and coffee shop', '594', '596', 'hosts-and-hostesses-restaurant-lounge-and-coffee-shop', 2023, '-', '11', '62'),
('food-preparation-and-serving-related-occupations', '7', 'Food preparation and serving related workers, all other', '-', '-', 'food-preparation-and-serving-related-workers-all-other', 2023, '-', '6', '1'),
('service-occupations', '3,520', 'Building and grounds cleaning and maintenance occupations', '692', '621', 'building-and-grounds-cleaning-and-maintenance-occupations', 2023, '749', '2,161', '1,359'),
('building-and-grounds-cleaning-and-maintenance-occupations', '177', 'First-line supervisors of housekeeping and janitorial workers', '896', '699', 'first-line-supervisors-of-housekeeping-and-janitorial-workers', 2023, '1,050', '100', '77'),
('building-and-grounds-cleaning-and-maintenance-occupations', '93', 'First-line supervisors of landscaping, lawn service, and groundskeeping workers', '928', '-', 'first-line-supervisors-of-landscaping-lawn-service-and-groundskeeping-workers', 2023, '938', '85', '8'),
('building-and-grounds-cleaning-and-maintenance-occupations', '1,505', 'Janitors and building cleaners', '696', '626', 'janitors-and-building-cleaners', 2023, '745', '999', '505'),
('building-and-grounds-cleaning-and-maintenance-occupations', '834', 'Maids and housekeeping cleaners', '619', '611', 'maids-and-housekeeping-cleaners', 2023, '686', '113', '721'),
('building-and-grounds-cleaning-and-maintenance-occupations', '90', 'Pest control workers', '848', '-', 'pest-control-workers', 2023, '858', '83', '7'),
('building-and-grounds-cleaning-and-maintenance-occupations', '713', 'Landscaping and groundskeeping workers', '703', '-', 'landscaping-and-groundskeeping-workers', 2023, '709', '673', '40'),
('building-and-grounds-cleaning-and-maintenance-occupations', '92', 'Tree trimmers and pruners', '775', '-', 'tree-trimmers-and-pruners', 2023, '775', '91', '1'),
('building-and-grounds-cleaning-and-maintenance-occupations', '18', 'Other grounds maintenance workers', '-', '-', 'other-grounds-maintenance-workers', 2023, '-', '18', '0'),
('service-occupations', '1,799', 'Personal care and service occupations', '725', '706', 'personal-care-and-service-occupations', 2023, '779', '505', '1,294'),
('personal-care-and-service-occupations', '97', 'Supervisors of personal care and service workers', '855', '793', 'supervisors-of-personal-care-and-service-workers', 2023, '-', '43', '54'),
('personal-care-and-service-occupations', '31', 'Animal trainers', '-', '-', 'animal-trainers', 2023, '-', '13', '18'),
('personal-care-and-service-occupations', '161', 'Animal caretakers', '704', '687', 'animal-caretakers', 2023, '-', '38', '122'),
('personal-care-and-service-occupations', '66', 'Gambling services workers', '893', '-', 'gambling-services-workers', 2023, '-', '37', '29'),
('personal-care-and-service-occupations', '7', 'Ushers, lobby attendants, and ticket takers', '-', '-', 'ushers-lobby-attendants-and-ticket-takers', 2023, '-', '3', '4'),
('personal-care-and-service-occupations', '87', 'Other entertainment attendants and related workers', '707', '-', 'other-entertainment-attendants-and-related-workers', 2023, '-', '39', '48'),
('personal-care-and-service-occupations', '13', 'Embalmers, crematory operators, and funeral attendants', '-', '-', 'embalmers-crematory-operators-and-funeral-attendants', 2023, '-', '10', '3'),
('personal-care-and-service-occupations', '28', 'Morticians, undertakers, and funeral arrangers', '-', '-', 'morticians-undertakers-and-funeral-arrangers', 2023, '-', '17', '11'),
('personal-care-and-service-occupations', '69', 'Barbers', '655', '-', 'barbers', 2023, '-', '45', '24'),
('personal-care-and-service-occupations', '239', 'Hairdressers, hairstylists, and cosmetologists', '740', '726', 'hairdressers-hairstylists-and-cosmetologists', 2023, '-', '18', '222'),
('personal-care-and-service-occupations', '197', 'Manicurists and pedicurists', '772', '748', 'manicurists-and-pedicurists', 2023, '-', '35', '162'),
('personal-care-and-service-occupations', '46', 'Skincare specialists', '-', '-', 'skincare-specialists', 2023, '-', '0', '46'),
('personal-care-and-service-occupations', '11', 'Other personal appearance workers', '-', '-', 'other-personal-appearance-workers', 2023, '-', '0', '11'),
('personal-care-and-service-occupations', '67', 'Baggage porters, bellhops, and concierges', '676', '-', 'baggage-porters-bellhops-and-concierges', 2023, '680', '51', '15'),
('personal-care-and-service-occupations', '14', 'Tour and travel guides', '-', '-', 'tour-and-travel-guides', 2023, '-', '8', '6'),
('personal-care-and-service-occupations', '379', 'Childcare workers', '635', '632', 'childcare-workers', 2023, '-', '22', '356'),
('personal-care-and-service-occupations', '71', 'Exercise trainers and group fitness instructors', '956', '-', 'exercise-trainers-and-group-fitness-instructors', 2023, '-', '40', '31'),
('personal-care-and-service-occupations', '129', 'Recreation workers', '776', '716', 'recreation-workers', 2023, '801', '56', '74'),
('personal-care-and-service-occupations', '17', 'Residential advisors', '-', '-', 'residential-advisors', 2023, '-', '5', '12'),
('personal-care-and-service-occupations', '68', 'Personal care and service workers, all other', '761', '-', 'personal-care-and-service-workers-all-other', 2023, '-', '23', '45'),
('', '21,667', 'Sales and office occupations', '923', '856', 'sales-and-office-occupations', 2023, '1,072', '8,876', '12,791'),
('sales-and-office-occupations', '9,148', 'Sales and related occupations', '1,001', '830', 'sales-and-related-occupations', 2023, '1,196', '5,099', '4,049'),
('sales-and-related-occupations', '2,234', 'First-line supervisors of retail sales workers', '995', '904', 'first-line-supervisors-of-retail-sales-workers', 2023, '1,094', '1,274', '960'),
('sales-and-related-occupations', '906', 'First-line supervisors of non-retail sales workers', '1,345', '1,151', 'first-line-supervisors-of-non-retail-sales-workers', 2023, '1,464', '538', '367'),
('sales-and-related-occupations', '1,147', 'Cashiers', '606', '602', 'cashiers', 2023, '616', '346', '801'),
('sales-and-related-occupations', '64', 'Counter and rental clerks', '801', '-', 'counter-and-rental-clerks', 2023, '-', '46', '18'),
('sales-and-related-occupations', '89', 'Parts salespersons', '769', '-', 'parts-salespersons', 2023, '796', '65', '25'),
('sales-and-related-occupations', '1,585', 'Retail salespersons', '829', '710', 'retail-salespersons', 2023, '988', '963', '622'),
('sales-and-related-occupations', '101', 'Advertising sales agents', '1,442', '1,398', 'advertising-sales-agents', 2023, '1,728', '51', '50'),
('sales-and-related-occupations', '443', 'Insurance sales agents', '1,081', '927', 'insurance-sales-agents', 2023, '1,310', '183', '260'),
('sales-and-related-occupations', '184', 'Securities, commodities, and financial services sales agents', '2,320', '1,654', 'securities-commodities-and-financial-services-sales-agents', 2023, '2,412', '129', '55'),
('sales-and-related-occupations', '48', 'Travel agents', '-', '-', 'travel-agents', 2023, '-', '8', '40'),
('sales-and-related-occupations', '577', 'Sales representatives of services, except advertising, insurance, financial services, and travel', '1,365', '1,137', 'sales-representatives-of-services-except-advertising-insurance-financial-services-and-travel', 2023, '1,451', '399', '178'),
('sales-and-related-occupations', '999', 'Sales representatives, wholesale and manufacturing', '1,427', '1,215', 'sales-representatives-wholesale-and-manufacturing', 2023, '1,535', '731', '268'),
('sales-and-related-occupations', '10', 'Models, demonstrators, and product promoters', '-', '-', 'models-demonstrators-and-product-promoters', 2023, '-', '3', '6'),
('sales-and-related-occupations', '440', 'Real estate brokers and sales agents', '1,363', '1,215', 'real-estate-brokers-and-sales-agents', 2023, '1,444', '188', '252');

-- 2024-03-09 19:09:22.0440
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('sales-and-related-occupations', '51', 'Sales engineers', '1,918', '-', 'sales-engineers', 2023, '1,918', '51', '0'),
('sales-and-related-occupations', '28', 'Telemarketers', '-', '-', 'telemarketers', 2023, '-', '4', '24'),
('sales-and-related-occupations', '29', 'Door-to-door sales workers, news and street vendors, and related workers', '-', '-', 'door-to-door-sales-workers-news-and-street-vendors-and-related-workers', 2023, '-', '16', '14'),
('sales-and-related-occupations', '213', 'Sales and related workers, all other', '914', '807', 'sales-and-related-workers-all-other', 2023, '1,019', '105', '108'),
('sales-and-office-occupations', '12,519', 'Office and administrative support occupations', '891', '864', 'office-and-administrative-support-occupations', 2023, '983', '3,777', '8,743'),
('office-and-administrative-support-occupations', '1,038', 'First-line supervisors of office and administrative support workers', '1,114', '1,075', 'first-line-supervisors-of-office-and-administrative-support-workers', 2023, '1,209', '351', '687'),
('office-and-administrative-support-occupations', '19', 'Switchboard operators, including answering service', '-', '-', 'switchboard-operators-including-answering-service', 2023, '-', '6', '14'),
('office-and-administrative-support-occupations', '11', 'Telephone operators', '-', '-', 'telephone-operators', 2023, '-', '5', '6'),
('office-and-administrative-support-occupations', '1', 'Communications equipment operators, all other', '-', '-', 'communications-equipment-operators-all-other', 2023, '-', '1', '0'),
('office-and-administrative-support-occupations', '84', 'Bill and account collectors', '809', '778', 'bill-and-account-collectors', 2023, '-', '25', '59'),
('office-and-administrative-support-occupations', '391', 'Billing and posting clerks', '826', '819', 'billing-and-posting-clerks', 2023, '-', '31', '360'),
('office-and-administrative-support-occupations', '869', 'Bookkeeping, accounting, and auditing clerks', '943', '922', 'bookkeeping-accounting-and-auditing-clerks', 2023, '1,100', '130', '738'),
('office-and-administrative-support-occupations', '22', 'Gambling cage workers', '-', '-', 'gambling-cage-workers', 2023, '-', '11', '11'),
('office-and-administrative-support-occupations', '119', 'Payroll and timekeeping clerks', '1,040', '1,037', 'payroll-and-timekeeping-clerks', 2023, '-', '16', '103'),
('office-and-administrative-support-occupations', '41', 'Procurement clerks', '-', '-', 'procurement-clerks', 2023, '-', '25', '16'),
('office-and-administrative-support-occupations', '163', 'Tellers', '721', '711', 'tellers', 2023, '-', '44', '119'),
('office-and-administrative-support-occupations', '121', 'Financial clerks, all other', '1,078', '1,009', 'financial-clerks-all-other', 2023, '1,335', '57', '65'),
('office-and-administrative-support-occupations', '6', 'Brokerage clerks', '-', '-', 'brokerage-clerks', 2023, '-', '4', '2'),
('office-and-administrative-support-occupations', '3', 'Correspondence clerks', '-', '-', 'correspondence-clerks', 2023, '-', '0', '3'),
('office-and-administrative-support-occupations', '84', 'Court, municipal, and license clerks', '928', '821', 'court-municipal-and-license-clerks', 2023, '-', '26', '58'),
('office-and-administrative-support-occupations', '25', 'Credit authorizers, checkers, and clerks', '-', '-', 'credit-authorizers-checkers-and-clerks', 2023, '-', '8', '17'),
('office-and-administrative-support-occupations', '2,157', 'Customer service representatives', '828', '799', 'customer-service-representatives', 2023, '918', '731', '1,426'),
('office-and-administrative-support-occupations', '96', 'Eligibility interviewers, government programs', '960', '951', 'eligibility-interviewers-government-programs', 2023, '-', '15', '81'),
('office-and-administrative-support-occupations', '86', 'File Clerks', '898', '882', 'file-clerks', 2023, '-', '26', '61'),
('office-and-administrative-support-occupations', '87', 'Hotel, motel, and resort desk clerks', '741', '-', 'hotel-motel-and-resort-desk-clerks', 2023, '-', '39', '48'),
('office-and-administrative-support-occupations', '166', 'Interviewers, except eligibility and loan', '789', '797', 'interviewers-except-eligibility-and-loan', 2023, '-', '33', '133'),
('office-and-administrative-support-occupations', '33', 'Library assistants, clerical', '-', '-', 'library-assistants-clerical', 2023, '-', '5', '27'),
('office-and-administrative-support-occupations', '128', 'Loan interviewers and clerks', '931', '887', 'loan-interviewers-and-clerks', 2023, '-', '32', '96'),
('office-and-administrative-support-occupations', '17', 'New accounts clerks', '-', '-', 'new-accounts-clerks', 2023, '-', '8', '9'),
('office-and-administrative-support-occupations', '66', 'Order clerks', '734', '-', 'order-clerks', 2023, '-', '30', '36'),
('office-and-administrative-support-occupations', '71', 'Human resources assistants, except payroll and timekeeping', '988', '982', 'human-resources-assistants-except-payroll-and-timekeeping', 2023, '-', '7', '64');

-- 2024-03-09 19:09:22.0450
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('office-and-administrative-support-occupations', '827', 'Receptionists and information clerks', '752', '749', 'receptionists-and-information-clerks', 2023, '770', '112', '715'),
('office-and-administrative-support-occupations', '113', 'Reservation and transportation ticket agents and travel clerks', '900', '-', 'reservation-and-transportation-ticket-agents-and-travel-clerks', 2023, '987', '64', '49'),
('office-and-administrative-support-occupations', '71', 'Information and record clerks, all other', '858', '802', 'information-and-record-clerks-all-other', 2023, '-', '14', '57'),
('office-and-administrative-support-occupations', '25', 'Cargo and freight agents', '-', '-', 'cargo-and-freight-agents', 2023, '-', '13', '12'),
('office-and-administrative-support-occupations', '547', 'Couriers and messengers', '853', '711', 'couriers-and-messengers', 2023, '885', '435', '112'),
('office-and-administrative-support-occupations', '67', 'Public safety telecommunicators', '1,013', '964', 'public-safety-telecommunicators', 2023, '-', '11', '55'),
('office-and-administrative-support-occupations', '156', 'Dispatchers, except police, fire, and ambulance', '898', '852', 'dispatchers-except-police-fire-and-ambulance', 2023, '1,128', '65', '91'),
('office-and-administrative-support-occupations', '20', 'Meter readers, utilities', '-', '-', 'meter-readers-utilities', 2023, '-', '19', '0'),
('office-and-administrative-support-occupations', '95', 'Postal service clerks', '894', '-', 'postal-service-clerks', 2023, '-', '46', '49'),
('office-and-administrative-support-occupations', '279', 'Postal service mail carriers', '1,130', '1,015', 'postal-service-mail-carriers', 2023, '1,194', '182', '97'),
('office-and-administrative-support-occupations', '58', 'Postal service mail sorters, processors, and processing machine operators', '904', '-', 'postal-service-mail-sorters-processors-and-processing-machine-operators', 2023, '-', '26', '31'),
('office-and-administrative-support-occupations', '198', 'Production, planning, and expediting clerks', '1,334', '1,333', 'production-planning-and-expediting-clerks', 2023, '1,335', '109', '89'),
('office-and-administrative-support-occupations', '555', 'Shipping, receiving, and inventory clerks', '811', '789', 'shipping-receiving-and-inventory-clerks', 2023, '827', '356', '199'),
('office-and-administrative-support-occupations', '59', 'Weighers, measurers, checkers, and samplers, recordkeeping', '843', '-', 'weighers-measurers-checkers-and-samplers-recordkeeping', 2023, '-', '36', '23'),
('office-and-administrative-support-occupations', '179', 'Executive secretaries and executive administrative assistants', '1,272', '1,272', 'executive-secretaries-and-executive-administrative-assistants', 2023, '-', '16', '163'),
('office-and-administrative-support-occupations', '40', 'Legal secretaries and administrative assistants', '-', '-', 'legal-secretaries-and-administrative-assistants', 2023, '-', '3', '37'),
('office-and-administrative-support-occupations', '80', 'Medical secretaries and administrative assistants', '909', '914', 'medical-secretaries-and-administrative-assistants', 2023, '-', '6', '74'),
('office-and-administrative-support-occupations', '1,387', 'Secretaries and administrative assistants, except legal, medical, and executive', '894', '882', 'secretaries-and-administrative-assistants-except-legal-medical-and-executive', 2023, '1,101', '130', '1,257');

-- 2024-03-09 19:09:22.0450
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('office-and-administrative-support-occupations', '185', 'Data entry keyers', '814', '809', 'data-entry-keyers', 2023, '819', '59', '126'),
('office-and-administrative-support-occupations', '33', 'Word processors and typists', '-', '-', 'word-processors-and-typists', 2023, '-', '3', '31'),
('office-and-administrative-support-occupations', '1', 'Desktop publishers', '-', '-', 'desktop-publishers', 2023, '-', '0', '1'),
('office-and-administrative-support-occupations', '265', 'Insurance claims and policy processing clerks', '912', '896', 'insurance-claims-and-policy-processing-clerks', 2023, '1,062', '59', '206'),
('office-and-administrative-support-occupations', '37', 'Mail clerks and mail machine operators, except postal service', '-', '-', 'mail-clerks-and-mail-machine-operators-except-postal-service', 2023, '-', '20', '17'),
('office-and-administrative-support-occupations', '926', 'Office clerks, general', '828', '824', 'office-clerks-general', 2023, '867', '176', '750'),
('office-and-administrative-support-occupations', '15', 'Office machine operators, except computer', '-', '-', 'office-machine-operators-except-computer', 2023, '-', '5', '10'),
('office-and-administrative-support-occupations', '4', 'Proofreaders and copy markers', '-', '-', 'proofreaders-and-copy-markers', 2023, '-', '1', '4'),
('office-and-administrative-support-occupations', '14', 'Statistical assistants', '-', '-', 'statistical-assistants', 2023, '-', '11', '3'),
('office-and-administrative-support-occupations', '380', 'Office and administrative support workers, all other', '1,007', '988', 'office-and-administrative-support-workers-all-other', 2023, '1,038', '134', '246'),
('', '11,368', 'Natural resources, construction, and maintenance occupations', '1,001', '734', 'natural-resources-construction-and-maintenance-occupations', 2023, '1,013', '10,793', '575'),
('natural-resources-construction-and-maintenance-occupations', '731', 'Farming, fishing, and forestry occupations', '689', '614', 'farming-fishing-and-forestry-occupations', 2023, '728', '548', '183');

-- 2024-03-09 19:09:22.0460
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('farming-fishing-and-forestry-occupations', '59', 'First-line supervisors of farming, fishing, and forestry workers', '907', '-', 'first-line-supervisors-of-farming-fishing-and-forestry-workers', 2023, '-', '48', '11'),
('farming-fishing-and-forestry-occupations', '24', 'Agricultural inspectors', '-', '-', 'agricultural-inspectors', 2023, '-', '17', '7'),
('farming-fishing-and-forestry-occupations', '9', 'Animal breeders', '-', '-', 'animal-breeders', 2023, '-', '9', '0'),
('farming-fishing-and-forestry-occupations', '39', 'Graders and sorters, agricultural products', '-', '-', 'graders-and-sorters-agricultural-products', 2023, '-', '13', '26'),
('farming-fishing-and-forestry-occupations', '542', 'Miscellaneous agricultural workers', '662', '598', 'miscellaneous-agricultural-workers', 2023, '704', '412', '130'),
('farming-fishing-and-forestry-occupations', '7', 'Fishing and hunting workers', '-', '-', 'fishing-and-hunting-workers', 2023, '-', '7', '0'),
('farming-fishing-and-forestry-occupations', '18', 'Forest and conservation workers', '-', '-', 'forest-and-conservation-workers', 2023, '-', '9', '9'),
('farming-fishing-and-forestry-occupations', '33', 'Logging workers', '-', '-', 'logging-workers', 2023, '-', '33', '0'),
('natural-resources-construction-and-maintenance-occupations', '6,517', 'Construction and extraction occupations', '985', '795', 'construction-and-extraction-occupations', 2023, '991', '6,277', '240'),
('construction-and-extraction-occupations', '537', 'First-line supervisors of construction trades and extraction workers', '1,373', '-', 'first-line-supervisors-of-construction-trades-and-extraction-workers', 2023, '1,361', '525', '13');

-- 2024-03-09 19:09:22.0460
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('construction-and-extraction-occupations', '14', 'Boilermakers', '-', '-', 'boilermakers', 2023, '-', '12', '3'),
('construction-and-extraction-occupations', '76', 'Brickmasons, blockmasons, and stonemasons', '850', '-', 'brickmasons-blockmasons-and-stonemasons', 2023, '856', '75', '1'),
('construction-and-extraction-occupations', '942', 'Carpenters', '928', '-', 'carpenters', 2023, '927', '915', '27'),
('construction-and-extraction-occupations', '67', 'Carpet, floor, and tile installers and finishers', '924', '-', 'carpet-floor-and-tile-installers-and-finishers', 2023, '931', '61', '6'),
('construction-and-extraction-occupations', '48', 'Cement masons, concrete finishers, and terrazzo workers', '-', '-', 'cement-masons-concrete-finishers-and-terrazzo-workers', 2023, '-', '48', '0'),
('construction-and-extraction-occupations', '1,572', 'Construction laborers', '858', '711', 'construction-laborers', 2023, '870', '1,498', '74'),
('construction-and-extraction-occupations', '353', 'Construction equipment operators', '1,113', '-', 'construction-equipment-operators', 2023, '1,115', '351', '2'),
('construction-and-extraction-occupations', '90', 'Drywall installers, ceiling tile installers, and tapers', '812', '-', 'drywall-installers-ceiling-tile-installers-and-tapers', 2023, '815', '88', '2'),
('construction-and-extraction-occupations', '813', 'Electricians', '1,195', '-', 'electricians', 2023, '1,199', '793', '19'),
('construction-and-extraction-occupations', '28', 'Glaziers', '-', '-', 'glaziers', 2023, '-', '25', '3');

-- 2024-03-09 19:09:22.0470
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('construction-and-extraction-occupations', '61', 'Insulation workers', '1,079', '-', 'insulation-workers', 2023, '973', '57', '4'),
('construction-and-extraction-occupations', '389', 'Painters and paperhangers', '810', '-', 'painters-and-paperhangers', 2023, '821', '348', '41'),
('construction-and-extraction-occupations', '46', 'Pipelayers', '-', '-', 'pipelayers', 2023, '-', '46', '0'),
('construction-and-extraction-occupations', '546', 'Plumbers, pipefitters, and steamfitters', '1,063', '-', 'plumbers-pipefitters-and-steamfitters', 2023, '1,070', '538', '8'),
('construction-and-extraction-occupations', '22', 'Plasterers and stucco masons', '-', '-', 'plasterers-and-stucco-masons', 2023, '-', '22', '0'),
('construction-and-extraction-occupations', '10', 'Reinforcing iron and rebar workers', '-', '-', 'reinforcing-iron-and-rebar-workers', 2023, '-', '10', '0'),
('construction-and-extraction-occupations', '187', 'Roofers', '804', '-', 'roofers', 2023, '808', '179', '8'),
('construction-and-extraction-occupations', '112', 'Sheet metal workers', '1,096', '-', 'sheet-metal-workers', 2023, '1,095', '108', '4'),
('construction-and-extraction-occupations', '37', 'Structural iron and steel workers', '-', '-', 'structural-iron-and-steel-workers', 2023, '-', '35', '2'),
('construction-and-extraction-occupations', '14', 'Solar photovoltaic installers', '-', '-', 'solar-photovoltaic-installers', 2023, '-', '14', '0'),
('construction-and-extraction-occupations', '49', 'Helpers, construction trades', '-', '-', 'helpers-construction-trades', 2023, '-', '45', '4'),
('construction-and-extraction-occupations', '85', 'Construction and building inspectors', '1,193', '-', 'construction-and-building-inspectors', 2023, '1,197', '78', '7');

-- 2024-03-09 19:09:22.0480
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('construction-and-extraction-occupations', '39', 'Elevator and escalator installers and repairers', '-', '-', 'elevator-and-escalator-installers-and-repairers', 2023, '-', '39', '0'),
('construction-and-extraction-occupations', '26', 'Fence erectors', '-', '-', 'fence-erectors', 2023, '-', '26', '0'),
('construction-and-extraction-occupations', '21', 'Hazardous materials removal workers', '-', '-', 'hazardous-materials-removal-workers', 2023, '-', '21', '0'),
('construction-and-extraction-occupations', '98', 'Highway maintenance workers', '941', '-', 'highway-maintenance-workers', 2023, '941', '98', '0'),
('construction-and-extraction-occupations', '22', 'Rail-track laying and maintenance equipment operators', '-', '-', 'rail-track-laying-and-maintenance-equipment-operators', 2023, '-', '22', '0'),
('construction-and-extraction-occupations', '7', 'Septic tank servicers and sewer pipe cleaners', '-', '-', 'septic-tank-servicers-and-sewer-pipe-cleaners', 2023, '-', '5', '1'),
('construction-and-extraction-occupations', '48', 'Miscellaneous construction and related workers', '-', '-', 'miscellaneous-construction-and-related-workers', 2023, '-', '44', '4'),
('construction-and-extraction-occupations', '21', 'Derrick, rotary drill, and service unit operators, oil and gas', '-', '-', 'derrick-rotary-drill-and-service-unit-operators-oil-and-gas', 2023, '-', '21', '0'),
('construction-and-extraction-occupations', '9', 'Excavating and loading machine and dragline operators, surface mining', '-', '-', 'excavating-and-loading-machine-and-dragline-operators-surface-mining', 2023, '-', '6', '3'),
('construction-and-extraction-occupations', '22', 'Earth drillers, except oil and gas', '-', '-', 'earth-drillers-except-oil-and-gas', 2023, '-', '22', '0'),
('construction-and-extraction-occupations', '7', 'Explosives workers, ordnance handling experts, and blasters', '-', '-', 'explosives-workers-ordnance-handling-experts-and-blasters', 2023, '-', '7', '0'),
('construction-and-extraction-occupations', '43', 'Underground mining machine operators', '-', '-', 'underground-mining-machine-operators', 2023, '-', '42', '1');

-- 2024-03-09 19:09:22.0480
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('construction-and-extraction-occupations', '8', 'Roustabouts, oil and gas', '-', '-', 'roustabouts-oil-and-gas', 2023, '-', '8', '0'),
('construction-and-extraction-occupations', '47', 'Other extraction workers', '-', '-', 'other-extraction-workers', 2023, '-', '46', '1'),
('natural-resources-construction-and-maintenance-occupations', '4,120', 'Installation, maintenance, and repair occupations', '1,092', '875', 'installation-maintenance-and-repair-occupations', 2023, '1,104', '3,968', '152'),
('installation-maintenance-and-repair-occupations', '227', 'First-line supervisors of mechanics, installers, and repairers', '1,246', '-', 'first-line-supervisors-of-mechanics-installers-and-repairers', 2023, '1,246', '210', '17'),
('installation-maintenance-and-repair-occupations', '109', 'Computer, automated teller, and office machine repairers', '1,042', '-', 'computer-automated-teller-and-office-machine-repairers', 2023, '1,072', '92', '17'),
('installation-maintenance-and-repair-occupations', '92', 'Radio and telecommunications equipment installers and repairers', '1,042', '-', 'radio-and-telecommunications-equipment-installers-and-repairers', 2023, '1,052', '85', '7'),
('installation-maintenance-and-repair-occupations', '10', 'Avionics technicians', '-', '-', 'avionics-technicians', 2023, '-', '9', '1'),
('installation-maintenance-and-repair-occupations', '18', 'Electric motor, power tool, and related repairers', '-', '-', 'electric-motor-power-tool-and-related-repairers', 2023, '-', '18', '0'),
('installation-maintenance-and-repair-occupations', '0', 'Electrical and electronics installers and repairers, transportation equipment', '-', '-', 'electrical-and-electronics-installers-and-repairers-transportation-equipment', 2023, '-', '0', '0'),
('installation-maintenance-and-repair-occupations', '8', 'Electrical and electronics repairers, industrial and utility', '-', '-', 'electrical-and-electronics-repairers-industrial-and-utility', 2023, '-', '7', '0'),
('installation-maintenance-and-repair-occupations', '3', 'Electronic equipment installers and repairers, motor vehicles', '-', '-', 'electronic-equipment-installers-and-repairers-motor-vehicles', 2023, '-', '3', '0'),
('installation-maintenance-and-repair-occupations', '19', 'Audiovisual equipment installers and repairers', '-', '-', 'audiovisual-equipment-installers-and-repairers', 2023, '-', '17', '2'),
('installation-maintenance-and-repair-occupations', '37', 'Security and fire alarm systems installers', '-', '-', 'security-and-fire-alarm-systems-installers', 2023, '-', '36', '1'),
('installation-maintenance-and-repair-occupations', '115', 'Aircraft mechanics and service technicians', '1,355', '-', 'aircraft-mechanics-and-service-technicians', 2023, '1,370', '112', '3');

-- 2024-03-09 19:09:22.0490
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('installation-maintenance-and-repair-occupations', '105', 'Automotive body and related repairers', '1,025', '-', 'automotive-body-and-related-repairers', 2023, '1,049', '97', '8'),
('installation-maintenance-and-repair-occupations', '18', 'Automotive glass installers and repairers', '-', '-', 'automotive-glass-installers-and-repairers', 2023, '-', '17', '1'),
('installation-maintenance-and-repair-occupations', '741', 'Automotive service technicians and mechanics', '994', '-', 'automotive-service-technicians-and-mechanics', 2023, '1,001', '727', '15'),
('installation-maintenance-and-repair-occupations', '281', 'Bus and truck mechanics and diesel engine specialists', '1,093', '-', 'bus-and-truck-mechanics-and-diesel-engine-specialists', 2023, '1,095', '277', '5'),
('installation-maintenance-and-repair-occupations', '194', 'Heavy vehicle and mobile equipment service technicians and mechanics', '1,206', '-', 'heavy-vehicle-and-mobile-equipment-service-technicians-and-mechanics', 2023, '1,210', '191', '3'),
('installation-maintenance-and-repair-occupations', '28', 'Small engine mechanics', '-', '-', 'small-engine-mechanics', 2023, '-', '27', '1'),
('installation-maintenance-and-repair-occupations', '56', 'Miscellaneous vehicle and mobile equipment mechanics, installers, and repairers', '804', '-', 'miscellaneous-vehicle-and-mobile-equipment-mechanics-installers-and-repairers', 2023, '810', '55', '1'),
('installation-maintenance-and-repair-occupations', '19', 'Control and valve installers and repairers', '-', '-', 'control-and-valve-installers-and-repairers', 2023, '-', '18', '2'),
('installation-maintenance-and-repair-occupations', '464', 'Heating, air conditioning, and refrigeration mechanics and installers', '1,126', '-', 'heating-air-conditioning-and-refrigeration-mechanics-and-installers', 2023, '1,129', '458', '5'),
('installation-maintenance-and-repair-occupations', '28', 'Home appliance repairers', '-', '-', 'home-appliance-repairers', 2023, '-', '27', '1'),
('installation-maintenance-and-repair-occupations', '397', 'Industrial and refractory machinery mechanics', '1,172', '-', 'industrial-and-refractory-machinery-mechanics', 2023, '1,183', '383', '14'),
('installation-maintenance-and-repair-occupations', '586', 'Maintenance and repair workers, general', '1,007', '-', 'maintenance-and-repair-workers-general', 2023, '1,017', '559', '27'),
('installation-maintenance-and-repair-occupations', '20', 'Maintenance workers, machinery', '-', '-', 'maintenance-workers-machinery', 2023, '-', '19', '2'),
('installation-maintenance-and-repair-occupations', '33', 'Millwrights', '-', '-', 'millwrights', 2023, '-', '32', '1'),
('installation-maintenance-and-repair-occupations', '122', 'Electrical power-line installers and repairers', '1,373', '-', 'electrical-power-line-installers-and-repairers', 2023, '1,374', '120', '2'),
('installation-maintenance-and-repair-occupations', '141', 'Telecommunications line installers and repairers', '1,135', '-', 'telecommunications-line-installers-and-repairers', 2023, '1,141', '134', '8'),
('installation-maintenance-and-repair-occupations', '35', 'Precision instrument and equipment repairers', '-', '-', 'precision-instrument-and-equipment-repairers', 2023, '-', '32', '4'),
('installation-maintenance-and-repair-occupations', '9', 'Wind turbine service technicians', '-', '-', 'wind-turbine-service-technicians', 2023, '-', '9', '0');

-- 2024-03-09 19:09:22.0500
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('installation-maintenance-and-repair-occupations', '26', 'Coin, vending, and amusement machine servicers and repairers', '-', '-', 'coin-vending-and-amusement-machine-servicers-and-repairers', 2023, '-', '21', '5'),
('installation-maintenance-and-repair-occupations', '1', 'Commercial divers', '-', '-', 'commercial-divers', 2023, '-', '1', '0'),
('installation-maintenance-and-repair-occupations', '23', 'Locksmiths and safe repairers', '-', '-', 'locksmiths-and-safe-repairers', 2023, '-', '23', '0'),
('installation-maintenance-and-repair-occupations', '3', 'Manufactured building and mobile home installers', '-', '-', 'manufactured-building-and-mobile-home-installers', 2023, '-', '3', '0'),
('installation-maintenance-and-repair-occupations', '15', 'Riggers', '-', '-', 'riggers', 2023, '-', '15', '0'),
('installation-maintenance-and-repair-occupations', '12', 'Helpers--installation, maintenance, and repair workers', '-', '-', 'helpers-installation-maintenance-and-repair-workers', 2023, '-', '12', '0'),
('installation-maintenance-and-repair-occupations', '124', 'Other installation, maintenance, and repair workers', '1,014', '-', 'other-installation-maintenance-and-repair-workers', 2023, '1,018', '123', '2'),
('', '15,977', 'Production, transportation, and material moving occupations', '869', '716', 'production-transportation-and-material-moving-occupations', 2023, '923', '12,290', '3,688'),
('production-transportation-and-material-moving-occupations', '7,313', 'Production occupations', '895', '742', 'production-occupations', 2023, '966', '5,277', '2,036'),
('production-occupations', '714', 'First-line supervisors of production and operating workers', '1,175', '914', 'first-line-supervisors-of-production-and-operating-workers', 2023, '1,263', '560', '154'),
('production-occupations', '14', 'Aircraft structure, surfaces, rigging, and systems assemblers', '-', '-', 'aircraft-structure-surfaces-rigging-and-systems-assemblers', 2023, '-', '8', '6'),
('production-occupations', '115', 'Electrical, electronics, and electromechanical assemblers', '824', '782', 'electrical-electronics-and-electromechanical-assemblers', 2023, '887', '61', '54');

-- 2024-03-09 19:09:22.0510
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('production-occupations', '12', 'Engine and other machine assemblers', '-', '-', 'engine-and-other-machine-assemblers', 2023, '-', '11', '2'),
('production-occupations', '18', 'Structural metal fabricators and fitters', '-', '-', 'structural-metal-fabricators-and-fitters', 2023, '-', '18', '0'),
('production-occupations', '961', 'Other assemblers and fabricators', '812', '758', 'other-assemblers-and-fabricators', 2023, '852', '607', '355'),
('production-occupations', '139', 'Bakers', '670', '656', 'bakers', 2023, '726', '58', '81'),
('production-occupations', '231', 'Butchers and other meat, poultry, and fish processing workers', '767', '696', 'butchers-and-other-meat-poultry-and-fish-processing-workers', 2023, '818', '161', '69'),
('production-occupations', '2', 'Food and tobacco roasting, baking, and drying machine operators and tenders', '-', '-', 'food-and-tobacco-roasting-baking-and-drying-machine-operators-and-tenders', 2023, '-', '1', '1'),
('production-occupations', '57', 'Food batchmakers', '810', '-', 'food-batchmakers', 2023, '-', '27', '30'),
('production-occupations', '8', 'Food cooking machine operators and tenders', '-', '-', 'food-cooking-machine-operators-and-tenders', 2023, '-', '6', '3'),
('production-occupations', '137', 'Food processing workers, all other', '927', '-', 'food-processing-workers-all-other', 2023, '970', '102', '35'),
('production-occupations', '107', 'Computer numerically controlled tool operators and programmers', '1,055', '-', 'computer-numerically-controlled-tool-operators-and-programmers', 2023, '1,087', '96', '11'),
('production-occupations', '28', 'Forming machine setters, operators, and tenders, metal and plastic', '-', '-', 'forming-machine-setters-operators-and-tenders-metal-and-plastic', 2023, '-', '20', '8'),
('production-occupations', '68', 'Cutting, punching, and press machine setters, operators, and tenders, metal and plastic', '780', '-', 'cutting-punching-and-press-machine-setters-operators-and-tenders-metal-and-plastic', 2023, '788', '66', '2'),
('production-occupations', '35', 'Grinding, lapping, polishing, and buffing machine tool setters, operators, and tenders, metal and plastic', '-', '-', 'grinding-lapping-polishing-and-buffing-machine-tool-setters-operators-and-tenders-metal-and-plastic', 2023, '-', '30', '5');

-- 2024-03-09 19:09:22.0510
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('production-occupations', '8', 'Other machine tool setters, operators, and tenders, metal and plastic', '-', '-', 'other-machine-tool-setters-operators-and-tenders-metal-and-plastic', 2023, '-', '6', '2'),
('production-occupations', '284', 'Machinists', '1,023', '-', 'machinists', 2023, '1,049', '263', '21'),
('production-occupations', '15', 'Metal furnace operators, tenders, pourers, and casters', '-', '-', 'metal-furnace-operators-tenders-pourers-and-casters', 2023, '-', '13', '2'),
('production-occupations', '5', 'Model makers and patternmakers, metal and plastic', '-', '-', 'model-makers-and-patternmakers-metal-and-plastic', 2023, '-', '5', '0'),
('production-occupations', '29', 'Molders and molding machine setters, operators, and tenders, metal and plastic', '-', '-', 'molders-and-molding-machine-setters-operators-and-tenders-metal-and-plastic', 2023, '-', '27', '2'),
('production-occupations', '31', 'Tool and die makers', '-', '-', 'tool-and-die-makers', 2023, '-', '31', '0'),
('production-occupations', '498', 'Welding, soldering, and brazing workers', '1,012', '-', 'welding-soldering-and-brazing-workers', 2023, '1,019', '465', '33'),
('production-occupations', '347', 'Other metal workers and plastic workers', '855', '684', 'other-metal-workers-and-plastic-workers', 2023, '906', '278', '69'),
('production-occupations', '9', 'Prepress technicians and workers', '-', '-', 'prepress-technicians-and-workers', 2023, '-', '9', '0'),
('production-occupations', '117', 'Printing press operators', '869', '-', 'printing-press-operators', 2023, '914', '94', '24'),
('production-occupations', '11', 'Print binding and finishing workers', '-', '-', 'print-binding-and-finishing-workers', 2023, '-', '11', '0'),
('production-occupations', '92', 'Laundry and dry-cleaning workers', '665', '636', 'laundry-and-dry-cleaning-workers', 2023, '-', '24', '69');

-- 2024-03-09 19:09:22.0520
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('production-occupations', '16', 'Pressers, textile, garment, and related materials', '-', '-', 'pressers-textile-garment-and-related-materials', 2023, '-', '10', '6'),
('production-occupations', '103', 'Sewing machine operators', '673', '655', 'sewing-machine-operators', 2023, '-', '31', '71'),
('production-occupations', '6', 'Shoe and leather workers', '-', '-', 'shoe-and-leather-workers', 2023, '-', '3', '3'),
('production-occupations', '32', 'Tailors, dressmakers, and sewers', '-', '-', 'tailors-dressmakers-and-sewers', 2023, '-', '5', '27'),
('production-occupations', '17', 'Textile machine setters, operators, and tenders', '-', '-', 'textile-machine-setters-operators-and-tenders', 2023, '-', '7', '10'),
('production-occupations', '15', 'Upholsterers', '-', '-', 'upholsterers', 2023, '-', '10', '5'),
('production-occupations', '9', 'Other textile, apparel, and furnishings workers', '-', '-', 'other-textile-apparel-and-furnishings-workers', 2023, '-', '4', '6'),
('production-occupations', '33', 'Cabinetmakers and bench carpenters', '-', '-', 'cabinetmakers-and-bench-carpenters', 2023, '-', '32', '2'),
('production-occupations', '7', 'Furniture finishers', '-', '-', 'furniture-finishers', 2023, '-', '4', '2'),
('production-occupations', '16', 'Sawing machine setters, operators, and tenders, wood', '-', '-', 'sawing-machine-setters-operators-and-tenders-wood', 2023, '-', '14', '2'),
('production-occupations', '28', 'Woodworking machine setters, operators, and tenders, except sawing', '-', '-', 'woodworking-machine-setters-operators-and-tenders-except-sawing', 2023, '-', '25', '4');

-- 2024-03-09 19:09:22.0520
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('production-occupations', '15', 'Other woodworkers', '-', '-', 'other-woodworkers', 2023, '-', '12', '3'),
('production-occupations', '41', 'Power plant operators, distributors, and dispatchers', '-', '-', 'power-plant-operators-distributors-and-dispatchers', 2023, '-', '40', '1'),
('production-occupations', '72', 'Stationary engineers and boiler operators', '1,328', '-', 'stationary-engineers-and-boiler-operators', 2023, '1,337', '70', '2'),
('production-occupations', '89', 'Water and wastewater treatment plant and system operators', '961', '-', 'water-and-wastewater-treatment-plant-and-system-operators', 2023, '965', '81', '7'),
('production-occupations', '34', 'Miscellaneous plant and system operators', '-', '-', 'miscellaneous-plant-and-system-operators', 2023, '-', '33', '1'),
('production-occupations', '41', 'Chemical processing machine setters, operators, and tenders', '-', '-', 'chemical-processing-machine-setters-operators-and-tenders', 2023, '-', '37', '4'),
('production-occupations', '94', 'Crushing, grinding, polishing, mixing, and blending workers', '994', '-', 'crushing-grinding-polishing-mixing-and-blending-workers', 2023, '1,020', '77', '17'),
('production-occupations', '50', 'Cutting workers', '826', '-', 'cutting-workers', 2023, '-', '35', '15'),
('production-occupations', '14', 'Extruding, forming, pressing, and compacting machine setters, operators, and tenders', '-', '-', 'extruding-forming-pressing-and-compacting-machine-setters-operators-and-tenders', 2023, '-', '12', '1');

-- 2024-03-09 19:09:22.0530
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('production-occupations', '8', 'Furnace, kiln, oven, drier, and kettle operators and tenders', '-', '-', 'furnace-kiln-oven-drier-and-kettle-operators-and-tenders', 2023, '-', '8', '0'),
('production-occupations', '718', 'Inspectors, testers, sorters, samplers, and weighers', '921', '809', 'inspectors-testers-sorters-samplers-and-weighers', 2023, '1,010', '436', '282'),
('production-occupations', '33', 'Jewelers and precious stone and metal workers', '-', '-', 'jewelers-and-precious-stone-and-metal-workers', 2023, '-', '25', '8'),
('production-occupations', '56', 'Dental and ophthalmic laboratory technicians and medical appliance technicians', '722', '-', 'dental-and-ophthalmic-laboratory-technicians-and-medical-appliance-technicians', 2023, '-', '30', '26'),
('production-occupations', '264', 'Packaging and filling machine operators and tenders', '716', '698', 'packaging-and-filling-machine-operators-and-tenders', 2023, '752', '117', '147'),
('production-occupations', '126', 'Painting workers', '816', '-', 'painting-workers', 2023, '824', '114', '12'),
('production-occupations', '18', 'Photographic process workers and processing machine operators', '-', '-', 'photographic-process-workers-and-processing-machine-operators', 2023, '-', '9', '9'),
('production-occupations', '10', 'Adhesive bonding machine operators and tenders', '-', '-', 'adhesive-bonding-machine-operators-and-tenders', 2023, '-', '7', '3'),
('production-occupations', '5', 'Etchers and engravers', '-', '-', 'etchers-and-engravers', 2023, '-', '3', '2'),
('production-occupations', '17', 'Molders, shapers, and casters, except metal and plastic', '-', '-', 'molders-shapers-and-casters-except-metal-and-plastic', 2023, '-', '16', '1'),
('production-occupations', '15', 'Paper goods machine setters, operators, and tenders', '-', '-', 'paper-goods-machine-setters-operators-and-tenders', 2023, '-', '8', '6'),
('production-occupations', '10', 'Tire builders', '-', '-', 'tire-builders', 2023, '-', '9', '1'),
('production-occupations', '39', 'Helpers--production workers', '-', '-', 'helpers-production-workers', 2023, '-', '29', '10'),
('production-occupations', '7', 'Other production equipment operators and tenders', '-', '-', 'other-production-equipment-operators-and-tenders', 2023, '-', '3', '4'),
('production-occupations', '1,162', 'Other production workers', '856', '771', 'other-production-workers', 2023, '893', '862', '301');

-- 2024-03-09 19:09:22.0540
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('production-transportation-and-material-moving-occupations', '8,664', 'Transportation and material moving occupations', '841', '694', 'transportation-and-material-moving-occupations', 2023, '897', '7,013', '1,651'),
('transportation-and-material-moving-occupations', '313', 'Supervisors of transportation and material moving workers', '1,016', '791', 'supervisors-of-transportation-and-material-moving-workers', 2023, '1,127', '235', '78'),
('transportation-and-material-moving-occupations', '173', 'Aircraft pilots and flight engineers', '2,015', '-', 'aircraft-pilots-and-flight-engineers', 2023, '2,005', '158', '15'),
('transportation-and-material-moving-occupations', '38', 'Air traffic controllers and airfield operations specialists', '-', '-', 'air-traffic-controllers-and-airfield-operations-specialists', 2023, '-', '34', '3'),
('transportation-and-material-moving-occupations', '74', 'Flight attendants', '961', '815', 'flight-attendants', 2023, '-', '19', '55'),
('transportation-and-material-moving-occupations', '13', 'Ambulance drivers and attendants, except emergency medical technicians', '-', '-', 'ambulance-drivers-and-attendants-except-emergency-medical-technicians', 2023, '-', '9', '4'),
('transportation-and-material-moving-occupations', '115', 'Bus drivers, school', '660', '650', 'bus-drivers-school', 2023, '-', '46', '69'),
('transportation-and-material-moving-occupations', '224', 'Bus drivers, transit and intercity', '911', '811', 'bus-drivers-transit-and-intercity', 2023, '979', '150', '74'),
('transportation-and-material-moving-occupations', '2,709', 'Driver/sales workers and truck drivers', '1,005', '734', 'driver-sales-workers-and-truck-drivers', 2023, '1,016', '2,560', '149');

-- 2024-03-09 19:09:22.0540
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('transportation-and-material-moving-occupations', '47', 'Shuttle drivers and chauffeurs', '-', '-', 'shuttle-drivers-and-chauffeurs', 2023, '-', '44', '3'),
('transportation-and-material-moving-occupations', '218', 'Taxi drivers', '865', '-', 'taxi-drivers', 2023, '925', '190', '29'),
('transportation-and-material-moving-occupations', '114', 'Motor vehicle operators, all other', '813', '-', 'motor-vehicle-operators-all-other', 2023, '865', '95', '19'),
('transportation-and-material-moving-occupations', '45', 'Locomotive engineers and operators', '-', '-', 'locomotive-engineers-and-operators', 2023, '-', '43', '1'),
('transportation-and-material-moving-occupations', '53', 'Railroad conductors and yardmasters', '1,642', '-', 'railroad-conductors-and-yardmasters', 2023, '1,656', '50', '3'),
('transportation-and-material-moving-occupations', '27', 'Other rail transportation workers', '-', '-', 'other-rail-transportation-workers', 2023, '-', '24', '2'),
('transportation-and-material-moving-occupations', '16', 'Sailors and marine oilers', '-', '-', 'sailors-and-marine-oilers', 2023, '-', '12', '3'),
('transportation-and-material-moving-occupations', '27', 'Ship and boat captains and operators', '-', '-', 'ship-and-boat-captains-and-operators', 2023, '-', '27', '0'),
('transportation-and-material-moving-occupations', '3', 'Ship engineers', '-', '-', 'ship-engineers', 2023, '-', '3', '0'),
('transportation-and-material-moving-occupations', '41', 'Parking attendants', '-', '-', 'parking-attendants', 2023, '-', '37', '4');

-- 2024-03-09 19:09:22.0550
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('transportation-and-material-moving-occupations', '44', 'Transportation service attendants', '-', '-', 'transportation-service-attendants', 2023, '-', '38', '7'),
('transportation-and-material-moving-occupations', '35', 'Transportation inspectors', '-', '-', 'transportation-inspectors', 2023, '-', '32', '4'),
('transportation-and-material-moving-occupations', '25', 'Passenger attendants', '-', '-', 'passenger-attendants', 2023, '-', '9', '16'),
('transportation-and-material-moving-occupations', '29', 'Other transportation workers', '-', '-', 'other-transportation-workers', 2023, '-', '24', '5'),
('transportation-and-material-moving-occupations', '55', 'Crane and tower operators', '1,316', '-', 'crane-and-tower-operators', 2023, '1,326', '54', '1'),
('transportation-and-material-moving-occupations', '21', 'Conveyor, dredge, and hoist and winch operators', '-', '-', 'conveyor-dredge-and-hoist-and-winch-operators', 2023, '-', '19', '2'),
('transportation-and-material-moving-occupations', '583', 'Industrial truck and tractor operators', '809', '786', 'industrial-truck-and-tractor-operators', 2023, '812', '526', '57'),
('transportation-and-material-moving-occupations', '299', 'Cleaners of vehicles and equipment', '694', '605', 'cleaners-of-vehicles-and-equipment', 2023, '704', '242', '57'),
('transportation-and-material-moving-occupations', '1,584', 'Laborers and freight, stock, and material movers, hand', '765', '685', 'laborers-and-freight-stock-and-material-movers-hand', 2023, '801', '1,235', '349'),
('transportation-and-material-moving-occupations', '29', 'Machine feeders and offbearers', '-', '-', 'machine-feeders-and-offbearers', 2023, '-', '13', '16');

-- 2024-03-09 19:09:22.0550
INSERT INTO "public"."weekly_earnings" ("parent", "total_number_workers", "occupation", "median_weekly_earnings", "women_median_weekly_earnings", "slug", "year", "men_median_weekly_earnings", "men_number_workers", "women_number_workers") VALUES
('transportation-and-material-moving-occupations', '484', 'Packers and packagers, hand', '698', '667', 'packers-and-packagers-hand', 2023, '732', '229', '255'),
('transportation-and-material-moving-occupations', '1,084', 'Stockers and order fillers', '706', '667', 'stockers-and-order-fillers', 2023, '730', '729', '355'),
('transportation-and-material-moving-occupations', '18', 'Pumping station operators', '-', '-', 'pumping-station-operators', 2023, '-', '17', '1'),
('transportation-and-material-moving-occupations', '74', 'Refuse and recyclable material collectors', '762', '-', 'refuse-and-recyclable-material-collectors', 2023, '789', '69', '5'),
('transportation-and-material-moving-occupations', '50', 'Other material moving workers', '889', '-', 'other-material-moving-workers', 2023, '-', '38', '11');


--
-- Cast wages to int
--

-- Set not enough data cols to 0
UPDATE weekly_earnings SET median_weekly_earnings = NULL WHERE median_weekly_earnings = '-';

UPDATE weekly_earnings SET men_median_weekly_earnings = NULL WHERE men_median_weekly_earnings = '-';

UPDATE weekly_earnings SET women_median_weekly_earnings = NULL WHERE women_median_weekly_earnings = '-';

-- Remove commas from number strings
UPDATE weekly_earnings SET median_weekly_earnings = REPLACE(median_weekly_earnings, ',', '')::numeric;

UPDATE weekly_earnings SET men_median_weekly_earnings = REPLACE(men_median_weekly_earnings, ',', '')::numeric;

UPDATE weekly_earnings SET women_median_weekly_earnings = REPLACE(women_median_weekly_earnings, ',', '')::numeric;

-- Cast wages to int
ALTER TABLE weekly_earnings ALTER COLUMN median_weekly_earnings TYPE int USING median_weekly_earnings::integer;

ALTER TABLE weekly_earnings ALTER COLUMN men_median_weekly_earnings TYPE int USING men_median_weekly_earnings::integer;

ALTER TABLE weekly_earnings ALTER COLUMN women_median_weekly_earnings TYPE int USING women_median_weekly_earnings::integer;


--
-- Populate occupations table
--

INSERT INTO occupations (name, slug, parent_slug_denorm)
SELECT
	occupation,
	slug,
	parent
FROM
	weekly_earnings ON CONFLICT DO NOTHING;

-- Set parent_id
UPDATE
	occupations o1
SET
	parent_id = o2.id
FROM
	occupations o2
WHERE
	o2.slug = o1.parent_slug_denorm;

--
-- Populate gaps table
--
-- Move over weekly_earnings data
INSERT INTO wage_gaps (occupation_id, all_median_weekly_earnings, men_median_weekly_earnings, women_median_weekly_earnings, year)
SELECT
	occupations.id,
	median_weekly_earnings,
	men_median_weekly_earnings,
	women_median_weekly_earnings,
	year
FROM
	weekly_earnings
	INNER JOIN occupations ON weekly_earnings.slug = occupations.slug;

-- Calculate cents_to_dollar
UPDATE
	wage_gaps
SET
	cents_to_dollar = ROUND((women_median_weekly_earnings::numeric * 100) / men_median_weekly_earnings::numeric)
WHERE
	men_median_weekly_earnings IS NOT NULL
	AND women_median_weekly_earnings IS NOT NULL;