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 182
- Cumberland 181
- Lincoln 179
- Kennebec 177
- Oxford 177
- York 177
- Penobscot 176
- Sagadahoc 173
- Knox 171
- Waldo 170
- Franklin 168
- Somerset 165
- Hancock 162
- Aroostook 160
- Washington 160
- Piscataquis 144
- Unknown 137
state 1
- Maine · 2,859 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
516190 | 516190 | 2020-09-09 | Androscoggin | Maine | 23001 | 627 | 10 |
516191 | 516191 | 2020-09-09 | Aroostook | Maine | 23003 | 40 | 1 |
516192 | 516192 | 2020-09-09 | Cumberland | Maine | 23005 | 2224 | 70 |
516193 | 516193 | 2020-09-09 | Franklin | Maine | 23007 | 53 | 1 |
516194 | 516194 | 2020-09-09 | Hancock | Maine | 23009 | 51 | 1 |
516195 | 516195 | 2020-09-09 | Kennebec | Maine | 23011 | 198 | 11 |
516196 | 516196 | 2020-09-09 | Knox | Maine | 23013 | 33 | 1 |
516197 | 516197 | 2020-09-09 | Lincoln | Maine | 23015 | 36 | 1 |
516198 | 516198 | 2020-09-09 | Oxford | Maine | 23017 | 75 | 0 |
516199 | 516199 | 2020-09-09 | Penobscot | Maine | 23019 | 249 | 6 |
516200 | 516200 | 2020-09-09 | Piscataquis | Maine | 23021 | 8 | 0 |
516201 | 516201 | 2020-09-09 | Sagadahoc | Maine | 23023 | 62 | 0 |
516202 | 516202 | 2020-09-09 | Somerset | Maine | 23025 | 65 | 3 |
516203 | 516203 | 2020-09-09 | Unknown | Maine | 1 | 0 | |
516204 | 516204 | 2020-09-09 | Waldo | Maine | 23027 | 72 | 14 |
516205 | 516205 | 2020-09-09 | Washington | Maine | 23029 | 15 | 0 |
516206 | 516206 | 2020-09-09 | York | Maine | 23031 | 925 | 15 |
512957 | 512957 | 2020-09-08 | Androscoggin | Maine | 23001 | 625 | 10 |
512958 | 512958 | 2020-09-08 | Aroostook | Maine | 23003 | 40 | 1 |
512959 | 512959 | 2020-09-08 | Cumberland | Maine | 23005 | 2223 | 70 |
512960 | 512960 | 2020-09-08 | Franklin | Maine | 23007 | 53 | 1 |
512961 | 512961 | 2020-09-08 | Hancock | Maine | 23009 | 51 | 1 |
512962 | 512962 | 2020-09-08 | Kennebec | Maine | 23011 | 197 | 11 |
512963 | 512963 | 2020-09-08 | Knox | Maine | 23013 | 33 | 1 |
512964 | 512964 | 2020-09-08 | Lincoln | Maine | 23015 | 36 | 1 |
512965 | 512965 | 2020-09-08 | Oxford | Maine | 23017 | 75 | 0 |
512966 | 512966 | 2020-09-08 | Penobscot | Maine | 23019 | 249 | 6 |
512967 | 512967 | 2020-09-08 | Piscataquis | Maine | 23021 | 8 | 0 |
512968 | 512968 | 2020-09-08 | Sagadahoc | Maine | 23023 | 62 | 0 |
512969 | 512969 | 2020-09-08 | Somerset | Maine | 23025 | 63 | 3 |
512970 | 512970 | 2020-09-08 | Waldo | Maine | 23027 | 72 | 14 |
512971 | 512971 | 2020-09-08 | Washington | Maine | 23029 | 15 | 0 |
512972 | 512972 | 2020-09-08 | York | Maine | 23031 | 911 | 15 |
509725 | 509725 | 2020-09-07 | Androscoggin | Maine | 23001 | 624 | 10 |
509726 | 509726 | 2020-09-07 | Aroostook | Maine | 23003 | 40 | 1 |
509727 | 509727 | 2020-09-07 | Cumberland | Maine | 23005 | 2221 | 70 |
509728 | 509728 | 2020-09-07 | Franklin | Maine | 23007 | 53 | 1 |
509729 | 509729 | 2020-09-07 | Hancock | Maine | 23009 | 50 | 1 |
509730 | 509730 | 2020-09-07 | Kennebec | Maine | 23011 | 197 | 11 |
509731 | 509731 | 2020-09-07 | Knox | Maine | 23013 | 34 | 1 |
509732 | 509732 | 2020-09-07 | Lincoln | Maine | 23015 | 36 | 1 |
509733 | 509733 | 2020-09-07 | Oxford | Maine | 23017 | 74 | 0 |
509734 | 509734 | 2020-09-07 | Penobscot | Maine | 23019 | 248 | 6 |
509735 | 509735 | 2020-09-07 | Piscataquis | Maine | 23021 | 8 | 0 |
509736 | 509736 | 2020-09-07 | Sagadahoc | Maine | 23023 | 62 | 0 |
509737 | 509737 | 2020-09-07 | Somerset | Maine | 23025 | 62 | 3 |
509738 | 509738 | 2020-09-07 | Waldo | Maine | 23027 | 72 | 14 |
509739 | 509739 | 2020-09-07 | Washington | Maine | 23029 | 15 | 0 |
509740 | 509740 | 2020-09-07 | York | Maine | 23031 | 905 | 15 |
506492 | 506492 | 2020-09-06 | Androscoggin | Maine | 23001 | 623 | 10 |
506493 | 506493 | 2020-09-06 | Aroostook | Maine | 23003 | 39 | 1 |
506494 | 506494 | 2020-09-06 | Cumberland | Maine | 23005 | 2218 | 70 |
506495 | 506495 | 2020-09-06 | Franklin | Maine | 23007 | 53 | 1 |
506496 | 506496 | 2020-09-06 | Hancock | Maine | 23009 | 50 | 1 |
506497 | 506497 | 2020-09-06 | Kennebec | Maine | 23011 | 196 | 11 |
506498 | 506498 | 2020-09-06 | Knox | Maine | 23013 | 33 | 1 |
506499 | 506499 | 2020-09-06 | Lincoln | Maine | 23015 | 36 | 1 |
506500 | 506500 | 2020-09-06 | Oxford | Maine | 23017 | 74 | 0 |
506501 | 506501 | 2020-09-06 | Penobscot | Maine | 23019 | 247 | 6 |
506502 | 506502 | 2020-09-06 | Piscataquis | Maine | 23021 | 8 | 0 |
506503 | 506503 | 2020-09-06 | Sagadahoc | Maine | 23023 | 62 | 0 |
506504 | 506504 | 2020-09-06 | Somerset | Maine | 23025 | 62 | 3 |
506505 | 506505 | 2020-09-06 | Waldo | Maine | 23027 | 71 | 14 |
506506 | 506506 | 2020-09-06 | Washington | Maine | 23029 | 15 | 0 |
506507 | 506507 | 2020-09-06 | York | Maine | 23031 | 895 | 15 |
503258 | 503258 | 2020-09-05 | Androscoggin | Maine | 23001 | 623 | 10 |
503259 | 503259 | 2020-09-05 | Aroostook | Maine | 23003 | 39 | 1 |
503260 | 503260 | 2020-09-05 | Cumberland | Maine | 23005 | 2216 | 70 |
503261 | 503261 | 2020-09-05 | Franklin | Maine | 23007 | 53 | 1 |
503262 | 503262 | 2020-09-05 | Hancock | Maine | 23009 | 50 | 1 |
503263 | 503263 | 2020-09-05 | Kennebec | Maine | 23011 | 195 | 11 |
503264 | 503264 | 2020-09-05 | Knox | Maine | 23013 | 33 | 1 |
503265 | 503265 | 2020-09-05 | Lincoln | Maine | 23015 | 36 | 1 |
503266 | 503266 | 2020-09-05 | Oxford | Maine | 23017 | 73 | 0 |
503267 | 503267 | 2020-09-05 | Penobscot | Maine | 23019 | 246 | 6 |
503268 | 503268 | 2020-09-05 | Piscataquis | Maine | 23021 | 8 | 0 |
503269 | 503269 | 2020-09-05 | Sagadahoc | Maine | 23023 | 62 | 0 |
503270 | 503270 | 2020-09-05 | Somerset | Maine | 23025 | 62 | 3 |
503271 | 503271 | 2020-09-05 | Unknown | Maine | 2 | 0 | |
503272 | 503272 | 2020-09-05 | Waldo | Maine | 23027 | 70 | 14 |
503273 | 503273 | 2020-09-05 | Washington | Maine | 23029 | 15 | 0 |
503274 | 503274 | 2020-09-05 | York | Maine | 23031 | 884 | 15 |
500025 | 500025 | 2020-09-04 | Androscoggin | Maine | 23001 | 620 | 10 |
500026 | 500026 | 2020-09-04 | Aroostook | Maine | 23003 | 38 | 1 |
500027 | 500027 | 2020-09-04 | Cumberland | Maine | 23005 | 2212 | 70 |
500028 | 500028 | 2020-09-04 | Franklin | Maine | 23007 | 53 | 1 |
500029 | 500029 | 2020-09-04 | Hancock | Maine | 23009 | 50 | 1 |
500030 | 500030 | 2020-09-04 | Kennebec | Maine | 23011 | 193 | 11 |
500031 | 500031 | 2020-09-04 | Knox | Maine | 23013 | 33 | 1 |
500032 | 500032 | 2020-09-04 | Lincoln | Maine | 23015 | 36 | 1 |
500033 | 500033 | 2020-09-04 | Oxford | Maine | 23017 | 71 | 0 |
500034 | 500034 | 2020-09-04 | Penobscot | Maine | 23019 | 240 | 6 |
500035 | 500035 | 2020-09-04 | Piscataquis | Maine | 23021 | 8 | 0 |
500036 | 500036 | 2020-09-04 | Sagadahoc | Maine | 23023 | 61 | 0 |
500037 | 500037 | 2020-09-04 | Somerset | Maine | 23025 | 61 | 3 |
500038 | 500038 | 2020-09-04 | Waldo | Maine | 23027 | 70 | 14 |
500039 | 500039 | 2020-09-04 | Washington | Maine | 23029 | 15 | 0 |
500040 | 500040 | 2020-09-04 | York | Maine | 23031 | 871 | 15 |
496791 | 496791 | 2020-09-03 | Androscoggin | Maine | 23001 | 620 | 10 |
496792 | 496792 | 2020-09-03 | Aroostook | Maine | 23003 | 38 | 1 |
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);