ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

13,097 rows where state = "Maine" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 17

county 17

state 1

  • Maine · 13,097 ✖
Link rowid date ▲ county state fips cases deaths
2500764 2500764 2022-05-13 Androscoggin Maine 23001 23257 285
2500765 2500765 2022-05-13 Aroostook Maine 23003 14393 166
2500766 2500766 2022-05-13 Cumberland Maine 23005 52557 366
2500767 2500767 2022-05-13 Franklin Maine 23007 6014 60
2500768 2500768 2022-05-13 Hancock Maine 23009 7983 87
2500769 2500769 2022-05-13 Kennebec Maine 23011 24799 240
2500770 2500770 2022-05-13 Knox Maine 23013 6414 38
2500771 2500771 2022-05-13 Lincoln Maine 23015 5578 35
2500772 2500772 2022-05-13 Oxford Maine 23017 11799 148
2500773 2500773 2022-05-13 Penobscot Maine 23019 29710 331
2500774 2500774 2022-05-13 Piscataquis Maine 23021 3112 31
2500775 2500775 2022-05-13 Sagadahoc Maine 23023 5531 32
2500776 2500776 2022-05-13 Somerset Maine 23025 10213 110
2500777 2500777 2022-05-13 Unknown Maine   42 0
2500778 2500778 2022-05-13 Waldo Maine 23027 6467 58
2500779 2500779 2022-05-13 Washington Maine 23029 4585 57
2500780 2500780 2022-05-13 York Maine 23031 41973 291
2497506 2497506 2022-05-12 Androscoggin Maine 23001 23208 285
2497507 2497507 2022-05-12 Aroostook Maine 23003 14325 165
2497508 2497508 2022-05-12 Cumberland Maine 23005 52361 366
2497509 2497509 2022-05-12 Franklin Maine 23007 6007 60
2497510 2497510 2022-05-12 Hancock Maine 23009 7954 87
2497511 2497511 2022-05-12 Kennebec Maine 23011 24740 239
2497512 2497512 2022-05-12 Knox Maine 23013 6391 38
2497513 2497513 2022-05-12 Lincoln Maine 23015 5566 35
2497514 2497514 2022-05-12 Oxford Maine 23017 11773 148
2497515 2497515 2022-05-12 Penobscot Maine 23019 29594 331
2497516 2497516 2022-05-12 Piscataquis Maine 23021 3105 31
2497517 2497517 2022-05-12 Sagadahoc Maine 23023 5518 32
2497518 2497518 2022-05-12 Somerset Maine 23025 10196 110
2497519 2497519 2022-05-12 Unknown Maine   52 0
2497520 2497520 2022-05-12 Waldo Maine 23027 6447 58
2497521 2497521 2022-05-12 Washington Maine 23029 4579 56
2497522 2497522 2022-05-12 York Maine 23031 41838 291
2494248 2494248 2022-05-11 Androscoggin Maine 23001 23169 285
2494249 2494249 2022-05-11 Aroostook Maine 23003 14261 165
2494250 2494250 2022-05-11 Cumberland Maine 23005 52104 365
2494251 2494251 2022-05-11 Franklin Maine 23007 5996 60
2494252 2494252 2022-05-11 Hancock Maine 23009 7895 87
2494253 2494253 2022-05-11 Kennebec Maine 23011 24652 239
2494254 2494254 2022-05-11 Knox Maine 23013 6381 37
2494255 2494255 2022-05-11 Lincoln Maine 23015 5551 35
2494256 2494256 2022-05-11 Oxford Maine 23017 11730 148
2494257 2494257 2022-05-11 Penobscot Maine 23019 29473 331
2494258 2494258 2022-05-11 Piscataquis Maine 23021 3093 31
2494259 2494259 2022-05-11 Sagadahoc Maine 23023 5494 32
2494260 2494260 2022-05-11 Somerset Maine 23025 10175 110
2494261 2494261 2022-05-11 Unknown Maine   27 0
2494262 2494262 2022-05-11 Waldo Maine 23027 6420 58
2494263 2494263 2022-05-11 Washington Maine 23029 4569 56
2494264 2494264 2022-05-11 York Maine 23031 41663 291
2490990 2490990 2022-05-10 Androscoggin Maine 23001 23123 285
2490991 2490991 2022-05-10 Aroostook Maine 23003 14197 165
2490992 2490992 2022-05-10 Cumberland Maine 23005 51910 364
2490993 2490993 2022-05-10 Franklin Maine 23007 5985 59
2490994 2490994 2022-05-10 Hancock Maine 23009 7843 87
2490995 2490995 2022-05-10 Kennebec Maine 23011 24561 239
2490996 2490996 2022-05-10 Knox Maine 23013 6360 37
2490997 2490997 2022-05-10 Lincoln Maine 23015 5538 35
2490998 2490998 2022-05-10 Oxford Maine 23017 11711 148
2490999 2490999 2022-05-10 Penobscot Maine 23019 29383 331
2491000 2491000 2022-05-10 Piscataquis Maine 23021 3091 31
2491001 2491001 2022-05-10 Sagadahoc Maine 23023 5477 32
2491002 2491002 2022-05-10 Somerset Maine 23025 10161 110
2491003 2491003 2022-05-10 Unknown Maine   35 0
2491004 2491004 2022-05-10 Waldo Maine 23027 6399 57
2491005 2491005 2022-05-10 Washington Maine 23029 4563 56
2491006 2491006 2022-05-10 York Maine 23031 41568 291
2487733 2487733 2022-05-09 Androscoggin Maine 23001 23086 285
2487734 2487734 2022-05-09 Aroostook Maine 23003 14134 165
2487735 2487735 2022-05-09 Cumberland Maine 23005 51689 364
2487736 2487736 2022-05-09 Franklin Maine 23007 5978 59
2487737 2487737 2022-05-09 Hancock Maine 23009 7812 87
2487738 2487738 2022-05-09 Kennebec Maine 23011 24487 239
2487739 2487739 2022-05-09 Knox Maine 23013 6340 37
2487740 2487740 2022-05-09 Lincoln Maine 23015 5522 35
2487741 2487741 2022-05-09 Oxford Maine 23017 11694 148
2487742 2487742 2022-05-09 Penobscot Maine 23019 29281 331
2487743 2487743 2022-05-09 Piscataquis Maine 23021 3083 31
2487744 2487744 2022-05-09 Sagadahoc Maine 23023 5460 32
2487745 2487745 2022-05-09 Somerset Maine 23025 10130 109
2487746 2487746 2022-05-09 Unknown Maine   58 0
2487747 2487747 2022-05-09 Waldo Maine 23027 6381 57
2487748 2487748 2022-05-09 Washington Maine 23029 4556 56
2487749 2487749 2022-05-09 York Maine 23031 41443 290
2484475 2484475 2022-05-08 Androscoggin Maine 23001 23061 285
2484476 2484476 2022-05-08 Aroostook Maine 23003 14105 165
2484477 2484477 2022-05-08 Cumberland Maine 23005 51574 364
2484478 2484478 2022-05-08 Franklin Maine 23007 5974 59
2484479 2484479 2022-05-08 Hancock Maine 23009 7793 87
2484480 2484480 2022-05-08 Kennebec Maine 23011 24440 239
2484481 2484481 2022-05-08 Knox Maine 23013 6333 37
2484482 2484482 2022-05-08 Lincoln Maine 23015 5517 35
2484483 2484483 2022-05-08 Oxford Maine 23017 11687 148
2484484 2484484 2022-05-08 Penobscot Maine 23019 29230 331
2484485 2484485 2022-05-08 Piscataquis Maine 23021 3080 31
2484486 2484486 2022-05-08 Sagadahoc Maine 23023 5450 32
2484487 2484487 2022-05-08 Somerset Maine 23025 10115 109
2484488 2484488 2022-05-08 Unknown Maine   48 0
2484489 2484489 2022-05-08 Waldo Maine 23027 6368 57

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);