fields = ['id', 'school_id', 'name', 'Description', 'URL', 'Code', 'Color']
values = [
  ['1', '101', 'Indiana', 'Indiana Department of Education Schools', 'www.doe.in.gov', 'IDOE', ''],
  ['2', '102', 'Nebraska', 'Nebraska Department of Education', 'www.education.ne.gov', 'NDE', ''],
  [
    '3',
    '103',
    'New Jersey',
    'New Jersey Department of Education',
    'www.state.js.us/jsded',
    'NJDOE',
    ''
  ],
  [
    '4',
    '104',
    'Pennsylvania',
    'Pennsylvania Department of Education',
    'http://www.education.state.pa.us/portal/server.pt/community/pennsylvania_department_of_education/7237',
    'PDOE',
    ''
  ],
  [
    '5',
    '105',
    'New York',
    'New York State Education Department',
    'http://www.nysed.gov/',
    'NYSED',
    ''
  ],
  [
    '6',
    '106',
    'Michigan',
    'Michigan Department of Education',
    'http://www.kansas.gov/mde',
    'KDE',
    ''
  ],
  ['7', '107', 'Iowa', 'Iowa Department of Education', 'http://www.iowa.gov/ide', 'IDE', ''],
  [
    '8',
    '108',
    'California',
    'California Department of Education',
    'http://www.california.gov/cde',
    'CDE',
    ''
  ],
  ['9', '109', 'Colorado', 'Colorado Department of Education', '', 'CDE', ''],
  ['10', '110', 'Kansas', 'Kansas Department of Education', '', 'MDE', ''],
  ['11', '111', 'Illinois', 'Illinois Department of Education', '', 'IDE', ''],
  ['12', '112', 'Florida', 'Florida Department of Education', '', 'FDE', ''],
  [
    '13',
    '113',
    'Wisconsin',
    'Wisconsin Department of Public Instruction',
    'http://dpi.wi.gov/',
    'WDPI',
    ''
  ],
  ['14', '114', 'New Hampshire', 'New Hampshire Department of Education', '', 'NHDOE', ''],
  ['15', '117', 'New Mexico', 'New Mexico Department of Education', '', 'NMDOE', '']
]

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