ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,097 rows where state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Androscoggin 460
- Cumberland 459
- Lincoln 457
- Kennebec 455
- Oxford 455
- York 455
- Penobscot 454
- Sagadahoc 451
- Knox 449
- Waldo 448
- Franklin 446
- Somerset 443
- Hancock 440
- Aroostook 438
- Washington 438
- Piscataquis 422
- Unknown 334
state 1
- Maine · 7,504 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418315 | 1418315 | 2021-06-14 | Androscoggin | Maine | 23001 | 8360 | 85 |
1418316 | 1418316 | 2021-06-14 | Aroostook | Maine | 23003 | 1885 | 46 |
1418317 | 1418317 | 2021-06-14 | Cumberland | Maine | 23005 | 17195 | 197 |
1418318 | 1418318 | 2021-06-14 | Franklin | Maine | 23007 | 1368 | 15 |
1418319 | 1418319 | 2021-06-14 | Hancock | Maine | 23009 | 1370 | 38 |
1418320 | 1418320 | 2021-06-14 | Kennebec | Maine | 23011 | 6566 | 74 |
1418321 | 1418321 | 2021-06-14 | Knox | Maine | 23013 | 1144 | 6 |
1418322 | 1418322 | 2021-06-14 | Lincoln | Maine | 23015 | 1076 | 3 |
1418323 | 1418323 | 2021-06-14 | Oxford | Maine | 23017 | 3623 | 66 |
1418324 | 1418324 | 2021-06-14 | Penobscot | Maine | 23019 | 6290 | 94 |
1418325 | 1418325 | 2021-06-14 | Piscataquis | Maine | 23021 | 575 | 6 |
1418326 | 1418326 | 2021-06-14 | Sagadahoc | Maine | 23023 | 1472 | 11 |
1418327 | 1418327 | 2021-06-14 | Somerset | Maine | 23025 | 2264 | 33 |
1418328 | 1418328 | 2021-06-14 | Waldo | Maine | 23027 | 1047 | 21 |
1418329 | 1418329 | 2021-06-14 | Washington | Maine | 23029 | 930 | 17 |
1418330 | 1418330 | 2021-06-14 | York | Maine | 23031 | 13438 | 133 |
1415069 | 1415069 | 2021-06-13 | Androscoggin | Maine | 23001 | 8360 | 85 |
1415070 | 1415070 | 2021-06-13 | Aroostook | Maine | 23003 | 1885 | 46 |
1415071 | 1415071 | 2021-06-13 | Cumberland | Maine | 23005 | 17198 | 197 |
1415072 | 1415072 | 2021-06-13 | Franklin | Maine | 23007 | 1367 | 15 |
1415073 | 1415073 | 2021-06-13 | Hancock | Maine | 23009 | 1370 | 38 |
1415074 | 1415074 | 2021-06-13 | Kennebec | Maine | 23011 | 6562 | 74 |
1415075 | 1415075 | 2021-06-13 | Knox | Maine | 23013 | 1143 | 6 |
1415076 | 1415076 | 2021-06-13 | Lincoln | Maine | 23015 | 1076 | 3 |
1415077 | 1415077 | 2021-06-13 | Oxford | Maine | 23017 | 3624 | 66 |
1415078 | 1415078 | 2021-06-13 | Penobscot | Maine | 23019 | 6285 | 94 |
1415079 | 1415079 | 2021-06-13 | Piscataquis | Maine | 23021 | 574 | 6 |
1415080 | 1415080 | 2021-06-13 | Sagadahoc | Maine | 23023 | 1472 | 11 |
1415081 | 1415081 | 2021-06-13 | Somerset | Maine | 23025 | 2260 | 33 |
1415082 | 1415082 | 2021-06-13 | Unknown | Maine | 3 | 0 | |
1415083 | 1415083 | 2021-06-13 | Waldo | Maine | 23027 | 1046 | 21 |
1415084 | 1415084 | 2021-06-13 | Washington | Maine | 23029 | 930 | 17 |
1415085 | 1415085 | 2021-06-13 | York | Maine | 23031 | 13435 | 133 |
1411824 | 1411824 | 2021-06-12 | Androscoggin | Maine | 23001 | 8355 | 85 |
1411825 | 1411825 | 2021-06-12 | Aroostook | Maine | 23003 | 1884 | 46 |
1411826 | 1411826 | 2021-06-12 | Cumberland | Maine | 23005 | 17196 | 197 |
1411827 | 1411827 | 2021-06-12 | Franklin | Maine | 23007 | 1362 | 15 |
1411828 | 1411828 | 2021-06-12 | Hancock | Maine | 23009 | 1370 | 38 |
1411829 | 1411829 | 2021-06-12 | Kennebec | Maine | 23011 | 6555 | 74 |
1411830 | 1411830 | 2021-06-12 | Knox | Maine | 23013 | 1142 | 6 |
1411831 | 1411831 | 2021-06-12 | Lincoln | Maine | 23015 | 1075 | 3 |
1411832 | 1411832 | 2021-06-12 | Oxford | Maine | 23017 | 3620 | 66 |
1411833 | 1411833 | 2021-06-12 | Penobscot | Maine | 23019 | 6279 | 94 |
1411834 | 1411834 | 2021-06-12 | Piscataquis | Maine | 23021 | 573 | 6 |
1411835 | 1411835 | 2021-06-12 | Sagadahoc | Maine | 23023 | 1471 | 11 |
1411836 | 1411836 | 2021-06-12 | Somerset | Maine | 23025 | 2257 | 33 |
1411837 | 1411837 | 2021-06-12 | Waldo | Maine | 23027 | 1043 | 21 |
1411838 | 1411838 | 2021-06-12 | Washington | Maine | 23029 | 927 | 17 |
1411839 | 1411839 | 2021-06-12 | York | Maine | 23031 | 13431 | 133 |
1408579 | 1408579 | 2021-06-11 | Androscoggin | Maine | 23001 | 8346 | 85 |
1408580 | 1408580 | 2021-06-11 | Aroostook | Maine | 23003 | 1882 | 46 |
1408581 | 1408581 | 2021-06-11 | Cumberland | Maine | 23005 | 17185 | 197 |
1408582 | 1408582 | 2021-06-11 | Franklin | Maine | 23007 | 1361 | 15 |
1408583 | 1408583 | 2021-06-11 | Hancock | Maine | 23009 | 1368 | 38 |
1408584 | 1408584 | 2021-06-11 | Kennebec | Maine | 23011 | 6550 | 74 |
1408585 | 1408585 | 2021-06-11 | Knox | Maine | 23013 | 1142 | 6 |
1408586 | 1408586 | 2021-06-11 | Lincoln | Maine | 23015 | 1074 | 3 |
1408587 | 1408587 | 2021-06-11 | Oxford | Maine | 23017 | 3616 | 66 |
1408588 | 1408588 | 2021-06-11 | Penobscot | Maine | 23019 | 6271 | 94 |
1408589 | 1408589 | 2021-06-11 | Piscataquis | Maine | 23021 | 572 | 6 |
1408590 | 1408590 | 2021-06-11 | Sagadahoc | Maine | 23023 | 1471 | 11 |
1408591 | 1408591 | 2021-06-11 | Somerset | Maine | 23025 | 2253 | 33 |
1408592 | 1408592 | 2021-06-11 | Waldo | Maine | 23027 | 1043 | 21 |
1408593 | 1408593 | 2021-06-11 | Washington | Maine | 23029 | 926 | 16 |
1408594 | 1408594 | 2021-06-11 | York | Maine | 23031 | 13427 | 133 |
1405333 | 1405333 | 2021-06-10 | Androscoggin | Maine | 23001 | 8339 | 85 |
1405334 | 1405334 | 2021-06-10 | Aroostook | Maine | 23003 | 1882 | 46 |
1405335 | 1405335 | 2021-06-10 | Cumberland | Maine | 23005 | 17180 | 197 |
1405336 | 1405336 | 2021-06-10 | Franklin | Maine | 23007 | 1358 | 15 |
1405337 | 1405337 | 2021-06-10 | Hancock | Maine | 23009 | 1367 | 38 |
1405338 | 1405338 | 2021-06-10 | Kennebec | Maine | 23011 | 6546 | 74 |
1405339 | 1405339 | 2021-06-10 | Knox | Maine | 23013 | 1142 | 6 |
1405340 | 1405340 | 2021-06-10 | Lincoln | Maine | 23015 | 1072 | 3 |
1405341 | 1405341 | 2021-06-10 | Oxford | Maine | 23017 | 3616 | 66 |
1405342 | 1405342 | 2021-06-10 | Penobscot | Maine | 23019 | 6267 | 94 |
1405343 | 1405343 | 2021-06-10 | Piscataquis | Maine | 23021 | 572 | 6 |
1405344 | 1405344 | 2021-06-10 | Sagadahoc | Maine | 23023 | 1471 | 11 |
1405345 | 1405345 | 2021-06-10 | Somerset | Maine | 23025 | 2252 | 33 |
1405346 | 1405346 | 2021-06-10 | Unknown | Maine | 1 | 0 | |
1405347 | 1405347 | 2021-06-10 | Waldo | Maine | 23027 | 1042 | 21 |
1405348 | 1405348 | 2021-06-10 | Washington | Maine | 23029 | 925 | 16 |
1405349 | 1405349 | 2021-06-10 | York | Maine | 23031 | 13417 | 132 |
1402088 | 1402088 | 2021-06-09 | Androscoggin | Maine | 23001 | 8328 | 85 |
1402089 | 1402089 | 2021-06-09 | Aroostook | Maine | 23003 | 1881 | 46 |
1402090 | 1402090 | 2021-06-09 | Cumberland | Maine | 23005 | 17175 | 197 |
1402091 | 1402091 | 2021-06-09 | Franklin | Maine | 23007 | 1355 | 15 |
1402092 | 1402092 | 2021-06-09 | Hancock | Maine | 23009 | 1363 | 38 |
1402093 | 1402093 | 2021-06-09 | Kennebec | Maine | 23011 | 6539 | 74 |
1402094 | 1402094 | 2021-06-09 | Knox | Maine | 23013 | 1141 | 6 |
1402095 | 1402095 | 2021-06-09 | Lincoln | Maine | 23015 | 1070 | 3 |
1402096 | 1402096 | 2021-06-09 | Oxford | Maine | 23017 | 3615 | 66 |
1402097 | 1402097 | 2021-06-09 | Penobscot | Maine | 23019 | 6259 | 94 |
1402098 | 1402098 | 2021-06-09 | Piscataquis | Maine | 23021 | 572 | 6 |
1402099 | 1402099 | 2021-06-09 | Sagadahoc | Maine | 23023 | 1470 | 11 |
1402100 | 1402100 | 2021-06-09 | Somerset | Maine | 23025 | 2249 | 33 |
1402101 | 1402101 | 2021-06-09 | Waldo | Maine | 23027 | 1038 | 21 |
1402102 | 1402102 | 2021-06-09 | Washington | Maine | 23029 | 922 | 16 |
1402103 | 1402103 | 2021-06-09 | York | Maine | 23031 | 13407 | 132 |
1398843 | 1398843 | 2021-06-08 | Androscoggin | Maine | 23001 | 8325 | 85 |
1398844 | 1398844 | 2021-06-08 | Aroostook | Maine | 23003 | 1877 | 46 |
Advanced export
JSON shape: default, array, newline-delimited
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);