fields = [
  'id',
  'name',
  'usa',
  'default',
  'indiana',
  'nebraska',
  'new_jersey',
  'california',
  'iowa',
  'michigan',
  'new_york',
  'pennslyvania',
  'colorado',
  'kansas',
  'illinois',
  'florida',
  'wisconsin',
  'new_mexico'
]
values = [
  [
    '-2',
    'Non Hispanic or Latino',
    0,
    '1',
    '',
    '1',
    'N',
    'N',
    '0',
    '',
    'N',
    '0N',
    '',
    'N',
    'NH',
    'N'
  ],
  ['-1', 'Hispanic or Latino', 1, '1', '', '2', 'Y', 'Y', '1', '', 'Y', '1Y', '', 'Y', 'H', 'Y'],
  [
    '1',
    'White',
    1,
    '1',
    '5',
    'WH',
    'Y',
    '700',
    '1',
    '',
    'W',
    '5',
    '1',
    '10000',
    '16',
    'Y',
    'W',
    'C'
  ],
  [
    '2',
    'Black or African American',
    1,
    '1',
    '2',
    'BL',
    'Y',
    '600',
    '1',
    '',
    'B3',
    '1',
    '00100',
    '14',
    'Y',
    'B',
    'B'
  ],
  ['3', 'Hispanic', 0, '1', '4', '', '', '', '', '', '', '4', '11', '', '', ''],
  [
    '4',
    'American Indian or Alaska Native',
    1,
    '1',
    '1',
    'AM',
    'Y',
    '100',
    '1',
    'I1',
    '1',
    '00001',
    '12',
    'Y',
    'I',
    'I'
  ],
  [
    '5',
    'Asian',
    1,
    '1',
    '3',
    'AS',
    'Y',
    '299',
    '1',
    '',
    'A',
    '9',
    '1',
    '00010',
    '13',
    'Y',
    'A',
    'A'
  ],
  [
    '6',
    'Pacific Islander',
    0,
    '1',
    '',
    '',
    'Y',
    '399',
    '1',
    '',
    'P',
    '10',
    '',
    '01000',
    '15',
    'Y',
    '',
    ''
  ],
  ['7', 'Other', 0, '1', '', '', '', '', '', '', '', '', '', ''],
  ['8', 'East Indian', 0, '', '', '', '', '', '', '', '', '', ''],
  ['9', 'Middle Eastern', 0, '1', '', '', '', '', '', '', '', '', ''],
  ['10', 'Multiracial', 1, '1', '6', '', '', '', '', '', 'M', '6', '17', '', '', ''],
  ['11', 'Unknown', 0, '', '', '', '', '', '', '', '', '', '', ''],
  ['12', 'African', 0, '1', '', '', '', '', '', '', '', '', '', ''],
  ['13', 'Filipino', 0, '1', '', '', '', '400', '', '', '', '', ''],
  ['14', 'Korean', 0, '1', '', '', '', '203', '', '', '', '', '', ''],
  ['15', 'Vietnamese', 0, '1', '', '', '', '204', '', '', '', '', ''],
  ['16', 'Native Alaskan or Pacific Island', 0, '', '', '', '', '', '', 'P'],
  [
    '17',
    'Hawaiian or Pacific Islander',
    1,
    '1',
    '7',
    'PI',
    'Y',
    '',
    '1',
    '',
    'P10',
    '1',
    '01000',
    '15',
    'Y',
    'P',
    ''
  ],
  ['18', 'Chinese', 0, '1', '', '', '', '201', '', '', '', '', '', ''],
  ['19', 'Japanese', 0, '1', '', '', '', '202', '', '', '', '', ''],
  ['20', 'Laotian', 0, '1', '', '', '', '206', '', '', '', '', '', ''],
  ['21', 'Cambodian', 0, '1', '', '', '', '207', '', '', '', '', ''],
  ['22', 'Hmong', 0, '1', '', '', '', '208', '', '', '', '', '', ''],
  ['23', 'Asian Indian', 0, '1', '', '', '', '205', '', '', '', '', ''],
  ['24', 'Guamanian', 0, '1', '', '', '', '302', '', '', '', '', ''],
  ['25', 'Samoan', 0, '1', '', '', '', '303', '', '', '', '', '', ''],
  ['26', 'Tahitian', 0, '1', '', '', '', '304', '', '', '', '', ''],
  ['27', 'Russian', 0, '1', '', '', '', '', '', '', '', '', '', ''],
  ['28', 'Hungarian', 0, '1', '', '', '', '', '', '', '', '', ''],
  ['29', 'Ukrainian', 0, '1', '', '', '', '', '', '', '', '', ''],
  ['30', 'Armenian', 0, '1', '', '', '', '', '', '', '', '', ''],
  ['31', 'Irish', 0, '1', '', '', '', '', '', '', '', '', '', ''],
  ['32', 'Cameroonian', 0, '1', '', '', '', '', '', '', '', '', ''],
  ['33', 'Hawaiian', 0, '1', '', '', '', '301', '', '', '', '', '']
]

Race.destroy_all
values.each do |v|
  r = Race.new
  fields.each_with_index do |f, index|
    r[f] = v[index]
  end
  r.save
end