emergency shipbuilding program
most of the ones with a 1st ship delivery date in the year 1942 were located in the state of california .
{'scope': 'subset', 'col': '2', 'most_or_all': 'most', 'criterion': 'fuzzily_match', 'value': 'california', 'subset': {'col': '3', 'criterion': 'fuzzily_match', 'value': '1942'}}
{'func': 'most_str_eq', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', '1st ship delivery date', '1942'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; 1st ship delivery date ; 1942 }', 'tointer': 'select the rows whose 1st ship delivery date record fuzzily matches to 1942 .'}, 'location ( city , state )', 'california'], 'result': True, 'ind': 1, 'tointer': 'select the rows whose 1st ship delivery date record fuzzily matches to 1942 . for the location ( city , state ) records of these rows , most of them fuzzily match to california .', 'tostr': 'most_eq { filter_eq { all_rows ; 1st ship delivery date ; 1942 } ; location ( city , state ) ; california } = true'}
most_eq { filter_eq { all_rows ; 1st ship delivery date ; 1942 } ; location ( city , state ) ; california } = true
select the rows whose 1st ship delivery date record fuzzily matches to 1942 . for the location ( city , state ) records of these rows , most of them fuzzily match to california .
{'most_str_eq_1': 'most_str_eq', 'result_2': 'true', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_3': 'all_rows', '1st ship delivery date_4': '1st ship delivery date', '1942_5': '1942', 'location (city , state)_6': 'location ( city , state )', 'california_7': 'california'}
['yard name', 'location ( city , state )', '1st ship delivery date', 'ship types delivered', 'total number of ways', 'total vessels built']
[['moore dry dock company', 'oakland , california', 'july 1940', 'c2 type , r2 type , c3 type', '4 ways', '__ ships for usmc ( remainder for usn )'], ['bethlehem steel corp', 'san francisco , california', 'february 1941', 'c1 type', 'number', '5 ships for usmc ( remainder for usn )'], ['seattle - tacoma shipbuilding', 'tacoma , washington', 'april 1941', 'c1 type , c3 type , t1 type', '8 ways', '__ ships for usmc ( remainder for usn )'], ['western pipe & steel corp', 'south san francisco , california', 'april 1941', 'c1 type , c3 type', '4 ways', '__ ships for usmc'], ['kaiser permanente ( richmond yard 1 )', 'richmond , california', 'august 1941', 'british ocean type , ec2 type , vc2 type', '7 ways', '30 ships for uk , __ ships for usmc'], ['kaiser permanente ( richmond yard 2 )', 'richmond , california', 'september 1941', 'ec2 type , vc2 type', '12 ways', '__ ships for usmc'], ['oregon shipbuilding co', 'portland , oregon', 'january 1942', 'ec2 type , vc2 type', '11 ways', '__ ships for usmc'], ['california shipbuilding corp ( calship )', 'terminal island , los angeles , california', 'february 1942', 'ec2 type , vc2 type', '14 ways', '__ ships for usmc'], ['marinship corp', 'sausalito , california', 'october 1942', 'ec2 type , t2 type', '6 ways', '__ ships for usmc'], ['pacific bridge co', 'alameda , california', 'december 1942', 'n3 type', '2 ways ( basins )', '9 ships for usmc ( remainder for usn )'], ['kaiser company , inc', 'swan island , portland , oregon', 'december 1942', 't2 type', '8 ways', '__ ships for usmc'], ['kaiser cargo ( richmond yard 4 )', 'richmond , california', 'april 1943', 's2 ( lst ) type , s2 ( frigate ) type , c1 - m type', '3 ways', '__ ships for usmc'], ['kaiser shipbuilding ( richmond yard 3 )', 'richmond , california', 'august 1943', 'c4 type', '5 ways ( basins )', '__ ships for usmc']]