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 673
- Cumberland 672
- Lincoln 670
- Kennebec 668
- Oxford 668
- York 668
- Penobscot 667
- Sagadahoc 664
- Knox 662
- Waldo 661
- Franklin 659
- Somerset 656
- Hancock 653
- Aroostook 651
- Washington 651
- Piscataquis 635
- Unknown 480
state 1
- Maine · 11,058 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110316 | 2110316 | 2022-01-13 | Androscoggin | Maine | 23001 | 16325 | 173 |
2110317 | 2110317 | 2022-01-13 | Aroostook | Maine | 23003 | 7779 | 110 |
2110318 | 2110318 | 2022-01-13 | Cumberland | Maine | 23005 | 31064 | 278 |
2110319 | 2110319 | 2022-01-13 | Franklin | Maine | 23007 | 4023 | 45 |
2110320 | 2110320 | 2022-01-13 | Hancock | Maine | 23009 | 4768 | 67 |
2110321 | 2110321 | 2022-01-13 | Kennebec | Maine | 23011 | 15455 | 165 |
2110322 | 2110322 | 2022-01-13 | Knox | Maine | 23013 | 3604 | 20 |
2110323 | 2110323 | 2022-01-13 | Lincoln | Maine | 23015 | 3262 | 16 |
2110324 | 2110324 | 2022-01-13 | Oxford | Maine | 23017 | 8060 | 112 |
2110325 | 2110325 | 2022-01-13 | Penobscot | Maine | 23019 | 18635 | 237 |
2110326 | 2110326 | 2022-01-13 | Piscataquis | Maine | 23021 | 2086 | 23 |
2110327 | 2110327 | 2022-01-13 | Sagadahoc | Maine | 23023 | 3206 | 23 |
2110328 | 2110328 | 2022-01-13 | Somerset | Maine | 23025 | 6877 | 77 |
2110329 | 2110329 | 2022-01-13 | Unknown | Maine | 7 | 0 | |
2110330 | 2110330 | 2022-01-13 | Waldo | Maine | 23027 | 3987 | 44 |
2110331 | 2110331 | 2022-01-13 | Washington | Maine | 23029 | 2886 | 41 |
2110332 | 2110332 | 2022-01-13 | York | Maine | 23031 | 26063 | 195 |
2107065 | 2107065 | 2022-01-12 | Androscoggin | Maine | 23001 | 16173 | 173 |
2107066 | 2107066 | 2022-01-12 | Aroostook | Maine | 23003 | 7685 | 110 |
2107067 | 2107067 | 2022-01-12 | Cumberland | Maine | 23005 | 30688 | 277 |
2107068 | 2107068 | 2022-01-12 | Franklin | Maine | 23007 | 3963 | 45 |
2107069 | 2107069 | 2022-01-12 | Hancock | Maine | 23009 | 4717 | 67 |
2107070 | 2107070 | 2022-01-12 | Kennebec | Maine | 23011 | 15357 | 163 |
2107071 | 2107071 | 2022-01-12 | Knox | Maine | 23013 | 3552 | 20 |
2107072 | 2107072 | 2022-01-12 | Lincoln | Maine | 23015 | 3214 | 16 |
2107073 | 2107073 | 2022-01-12 | Oxford | Maine | 23017 | 7981 | 112 |
2107074 | 2107074 | 2022-01-12 | Penobscot | Maine | 23019 | 18534 | 237 |
2107075 | 2107075 | 2022-01-12 | Piscataquis | Maine | 23021 | 2083 | 23 |
2107076 | 2107076 | 2022-01-12 | Sagadahoc | Maine | 23023 | 3179 | 23 |
2107077 | 2107077 | 2022-01-12 | Somerset | Maine | 23025 | 6823 | 77 |
2107078 | 2107078 | 2022-01-12 | Unknown | Maine | 18 | 0 | |
2107079 | 2107079 | 2022-01-12 | Waldo | Maine | 23027 | 3954 | 44 |
2107080 | 2107080 | 2022-01-12 | Washington | Maine | 23029 | 2874 | 41 |
2107081 | 2107081 | 2022-01-12 | York | Maine | 23031 | 25737 | 195 |
2103814 | 2103814 | 2022-01-11 | Androscoggin | Maine | 23001 | 16099 | 173 |
2103815 | 2103815 | 2022-01-11 | Aroostook | Maine | 23003 | 7632 | 110 |
2103816 | 2103816 | 2022-01-11 | Cumberland | Maine | 23005 | 30249 | 277 |
2103817 | 2103817 | 2022-01-11 | Franklin | Maine | 23007 | 3905 | 45 |
2103818 | 2103818 | 2022-01-11 | Hancock | Maine | 23009 | 4681 | 67 |
2103819 | 2103819 | 2022-01-11 | Kennebec | Maine | 23011 | 15280 | 163 |
2103820 | 2103820 | 2022-01-11 | Knox | Maine | 23013 | 3474 | 20 |
2103821 | 2103821 | 2022-01-11 | Lincoln | Maine | 23015 | 3201 | 16 |
2103822 | 2103822 | 2022-01-11 | Oxford | Maine | 23017 | 7920 | 112 |
2103823 | 2103823 | 2022-01-11 | Penobscot | Maine | 23019 | 18371 | 237 |
2103824 | 2103824 | 2022-01-11 | Piscataquis | Maine | 23021 | 2081 | 23 |
2103825 | 2103825 | 2022-01-11 | Sagadahoc | Maine | 23023 | 3156 | 23 |
2103826 | 2103826 | 2022-01-11 | Somerset | Maine | 23025 | 6773 | 77 |
2103827 | 2103827 | 2022-01-11 | Unknown | Maine | 19 | 0 | |
2103828 | 2103828 | 2022-01-11 | Waldo | Maine | 23027 | 3940 | 44 |
2103829 | 2103829 | 2022-01-11 | Washington | Maine | 23029 | 2868 | 41 |
2103830 | 2103830 | 2022-01-11 | York | Maine | 23031 | 25506 | 195 |
2100563 | 2100563 | 2022-01-10 | Androscoggin | Maine | 23001 | 15980 | 170 |
2100564 | 2100564 | 2022-01-10 | Aroostook | Maine | 23003 | 7541 | 110 |
2100565 | 2100565 | 2022-01-10 | Cumberland | Maine | 23005 | 29844 | 274 |
2100566 | 2100566 | 2022-01-10 | Franklin | Maine | 23007 | 3833 | 45 |
2100567 | 2100567 | 2022-01-10 | Hancock | Maine | 23009 | 4606 | 66 |
2100568 | 2100568 | 2022-01-10 | Kennebec | Maine | 23011 | 15169 | 156 |
2100569 | 2100569 | 2022-01-10 | Knox | Maine | 23013 | 3381 | 20 |
2100570 | 2100570 | 2022-01-10 | Lincoln | Maine | 23015 | 3113 | 15 |
2100571 | 2100571 | 2022-01-10 | Oxford | Maine | 23017 | 7847 | 111 |
2100572 | 2100572 | 2022-01-10 | Penobscot | Maine | 23019 | 18165 | 236 |
2100573 | 2100573 | 2022-01-10 | Piscataquis | Maine | 23021 | 2080 | 23 |
2100574 | 2100574 | 2022-01-10 | Sagadahoc | Maine | 23023 | 3113 | 23 |
2100575 | 2100575 | 2022-01-10 | Somerset | Maine | 23025 | 6739 | 74 |
2100576 | 2100576 | 2022-01-10 | Unknown | Maine | 6 | 0 | |
2100577 | 2100577 | 2022-01-10 | Waldo | Maine | 23027 | 3871 | 44 |
2100578 | 2100578 | 2022-01-10 | Washington | Maine | 23029 | 2861 | 41 |
2100579 | 2100579 | 2022-01-10 | York | Maine | 23031 | 25227 | 195 |
2097312 | 2097312 | 2022-01-09 | Androscoggin | Maine | 23001 | 15980 | 170 |
2097313 | 2097313 | 2022-01-09 | Aroostook | Maine | 23003 | 7541 | 110 |
2097314 | 2097314 | 2022-01-09 | Cumberland | Maine | 23005 | 29844 | 274 |
2097315 | 2097315 | 2022-01-09 | Franklin | Maine | 23007 | 3833 | 45 |
2097316 | 2097316 | 2022-01-09 | Hancock | Maine | 23009 | 4606 | 66 |
2097317 | 2097317 | 2022-01-09 | Kennebec | Maine | 23011 | 15169 | 156 |
2097318 | 2097318 | 2022-01-09 | Knox | Maine | 23013 | 3381 | 20 |
2097319 | 2097319 | 2022-01-09 | Lincoln | Maine | 23015 | 3113 | 15 |
2097320 | 2097320 | 2022-01-09 | Oxford | Maine | 23017 | 7847 | 111 |
2097321 | 2097321 | 2022-01-09 | Penobscot | Maine | 23019 | 18165 | 236 |
2097322 | 2097322 | 2022-01-09 | Piscataquis | Maine | 23021 | 2080 | 23 |
2097323 | 2097323 | 2022-01-09 | Sagadahoc | Maine | 23023 | 3113 | 23 |
2097324 | 2097324 | 2022-01-09 | Somerset | Maine | 23025 | 6739 | 74 |
2097325 | 2097325 | 2022-01-09 | Unknown | Maine | 6 | 0 | |
2097326 | 2097326 | 2022-01-09 | Waldo | Maine | 23027 | 3871 | 44 |
2097327 | 2097327 | 2022-01-09 | Washington | Maine | 23029 | 2861 | 41 |
2097328 | 2097328 | 2022-01-09 | York | Maine | 23031 | 25227 | 195 |
2094060 | 2094060 | 2022-01-08 | Androscoggin | Maine | 23001 | 15980 | 170 |
2094061 | 2094061 | 2022-01-08 | Aroostook | Maine | 23003 | 7541 | 110 |
2094062 | 2094062 | 2022-01-08 | Cumberland | Maine | 23005 | 29844 | 274 |
2094063 | 2094063 | 2022-01-08 | Franklin | Maine | 23007 | 3833 | 45 |
2094064 | 2094064 | 2022-01-08 | Hancock | Maine | 23009 | 4606 | 66 |
2094065 | 2094065 | 2022-01-08 | Kennebec | Maine | 23011 | 15169 | 156 |
2094066 | 2094066 | 2022-01-08 | Knox | Maine | 23013 | 3381 | 20 |
2094067 | 2094067 | 2022-01-08 | Lincoln | Maine | 23015 | 3113 | 15 |
2094068 | 2094068 | 2022-01-08 | Oxford | Maine | 23017 | 7847 | 111 |
2094069 | 2094069 | 2022-01-08 | Penobscot | Maine | 23019 | 18165 | 236 |
2094070 | 2094070 | 2022-01-08 | Piscataquis | Maine | 23021 | 2080 | 23 |
2094071 | 2094071 | 2022-01-08 | Sagadahoc | Maine | 23023 | 3113 | 23 |
2094072 | 2094072 | 2022-01-08 | Somerset | Maine | 23025 | 6739 | 74 |
2094073 | 2094073 | 2022-01-08 | Unknown | Maine | 6 | 0 | |
2094074 | 2094074 | 2022-01-08 | Waldo | Maine | 23027 | 3871 | 44 |
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);