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 693
- Cumberland 692
- Lincoln 690
- Oxford 689
- York 689
- Kennebec 688
- Penobscot 688
- Sagadahoc 685
- Knox 682
- Waldo 682
- Franklin 679
- Somerset 677
- Hancock 673
- Washington 672
- Aroostook 671
- Piscataquis 656
- Unknown 500
state 1
- Maine · 11,406 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2178643 | 2178643 | 2022-02-03 | Oxford | Maine | 23017 | 8817 | 118 |
2178644 | 2178644 | 2022-02-03 | Penobscot | Maine | 23019 | 20090 | 261 |
2178645 | 2178645 | 2022-02-03 | Piscataquis | Maine | 23021 | 2254 | 25 |
2178646 | 2178646 | 2022-02-03 | Sagadahoc | Maine | 23023 | 3718 | 25 |
2178647 | 2178647 | 2022-02-03 | Somerset | Maine | 23025 | 7503 | 84 |
2178648 | 2178648 | 2022-02-03 | Waldo | Maine | 23027 | 4415 | 50 |
2178649 | 2178649 | 2022-02-03 | Washington | Maine | 23029 | 3139 | 45 |
2178650 | 2178650 | 2022-02-03 | York | Maine | 23031 | 30169 | 213 |
2175382 | 2175382 | 2022-02-02 | Androscoggin | Maine | 23001 | 17847 | 190 |
2175383 | 2175383 | 2022-02-02 | Aroostook | Maine | 23003 | 8475 | 114 |
2175384 | 2175384 | 2022-02-02 | Cumberland | Maine | 23005 | 36607 | 298 |
2175385 | 2175385 | 2022-02-02 | Franklin | Maine | 23007 | 4396 | 49 |
2175386 | 2175386 | 2022-02-02 | Hancock | Maine | 23009 | 5174 | 71 |
2175387 | 2175387 | 2022-02-02 | Kennebec | Maine | 23011 | 17044 | 184 |
2175388 | 2175388 | 2022-02-02 | Knox | Maine | 23013 | 4223 | 22 |
2175389 | 2175389 | 2022-02-02 | Lincoln | Maine | 23015 | 3720 | 20 |
2175390 | 2175390 | 2022-02-02 | Oxford | Maine | 23017 | 8758 | 115 |
2175391 | 2175391 | 2022-02-02 | Penobscot | Maine | 23019 | 19959 | 258 |
2175392 | 2175392 | 2022-02-02 | Piscataquis | Maine | 23021 | 2242 | 25 |
2175393 | 2175393 | 2022-02-02 | Sagadahoc | Maine | 23023 | 3700 | 25 |
2175394 | 2175394 | 2022-02-02 | Somerset | Maine | 23025 | 7472 | 84 |
2175395 | 2175395 | 2022-02-02 | Unknown | Maine | 1 | 0 | |
2175396 | 2175396 | 2022-02-02 | Waldo | Maine | 23027 | 4384 | 48 |
2175397 | 2175397 | 2022-02-02 | Washington | Maine | 23029 | 3128 | 45 |
2175398 | 2175398 | 2022-02-02 | York | Maine | 23031 | 29969 | 211 |
2172129 | 2172129 | 2022-02-01 | Androscoggin | Maine | 23001 | 17733 | 190 |
2172130 | 2172130 | 2022-02-01 | Aroostook | Maine | 23003 | 8415 | 114 |
2172131 | 2172131 | 2022-02-01 | Cumberland | Maine | 23005 | 36106 | 295 |
2172132 | 2172132 | 2022-02-01 | Franklin | Maine | 23007 | 4387 | 48 |
2172133 | 2172133 | 2022-02-01 | Hancock | Maine | 23009 | 5144 | 71 |
2172134 | 2172134 | 2022-02-01 | Kennebec | Maine | 23011 | 16962 | 184 |
2172135 | 2172135 | 2022-02-01 | Knox | Maine | 23013 | 4170 | 22 |
2172136 | 2172136 | 2022-02-01 | Lincoln | Maine | 23015 | 3704 | 20 |
2172137 | 2172137 | 2022-02-01 | Oxford | Maine | 23017 | 8738 | 115 |
2172138 | 2172138 | 2022-02-01 | Penobscot | Maine | 23019 | 19822 | 257 |
2172139 | 2172139 | 2022-02-01 | Piscataquis | Maine | 23021 | 2236 | 25 |
2172140 | 2172140 | 2022-02-01 | Sagadahoc | Maine | 23023 | 3674 | 25 |
2172141 | 2172141 | 2022-02-01 | Somerset | Maine | 23025 | 7423 | 82 |
2172142 | 2172142 | 2022-02-01 | Unknown | Maine | 2 | 0 | |
2172143 | 2172143 | 2022-02-01 | Waldo | Maine | 23027 | 4370 | 48 |
2172144 | 2172144 | 2022-02-01 | Washington | Maine | 23029 | 3125 | 45 |
2172145 | 2172145 | 2022-02-01 | York | Maine | 23031 | 29748 | 210 |
2168876 | 2168876 | 2022-01-31 | Androscoggin | Maine | 23001 | 17596 | 189 |
2168877 | 2168877 | 2022-01-31 | Aroostook | Maine | 23003 | 8364 | 112 |
2168878 | 2168878 | 2022-01-31 | Cumberland | Maine | 23005 | 35577 | 295 |
2168879 | 2168879 | 2022-01-31 | Franklin | Maine | 23007 | 4373 | 48 |
2168880 | 2168880 | 2022-01-31 | Hancock | Maine | 23009 | 5124 | 70 |
2168881 | 2168881 | 2022-01-31 | Kennebec | Maine | 23011 | 16813 | 182 |
2168882 | 2168882 | 2022-01-31 | Knox | Maine | 23013 | 4148 | 22 |
2168883 | 2168883 | 2022-01-31 | Lincoln | Maine | 23015 | 3679 | 19 |
2168884 | 2168884 | 2022-01-31 | Oxford | Maine | 23017 | 8709 | 115 |
2168885 | 2168885 | 2022-01-31 | Penobscot | Maine | 23019 | 19669 | 255 |
2168886 | 2168886 | 2022-01-31 | Piscataquis | Maine | 23021 | 2219 | 25 |
2168887 | 2168887 | 2022-01-31 | Sagadahoc | Maine | 23023 | 3650 | 24 |
2168888 | 2168888 | 2022-01-31 | Somerset | Maine | 23025 | 7367 | 80 |
2168889 | 2168889 | 2022-01-31 | Unknown | Maine | 1 | 0 | |
2168890 | 2168890 | 2022-01-31 | Waldo | Maine | 23027 | 4341 | 48 |
2168891 | 2168891 | 2022-01-31 | Washington | Maine | 23029 | 3091 | 45 |
2168892 | 2168892 | 2022-01-31 | York | Maine | 23031 | 29504 | 209 |
2165621 | 2165621 | 2022-01-30 | Androscoggin | Maine | 23001 | 17596 | 189 |
2165622 | 2165622 | 2022-01-30 | Aroostook | Maine | 23003 | 8364 | 112 |
2165623 | 2165623 | 2022-01-30 | Cumberland | Maine | 23005 | 35577 | 295 |
2165624 | 2165624 | 2022-01-30 | Franklin | Maine | 23007 | 4373 | 48 |
2165625 | 2165625 | 2022-01-30 | Hancock | Maine | 23009 | 5124 | 70 |
2165626 | 2165626 | 2022-01-30 | Kennebec | Maine | 23011 | 16813 | 182 |
2165627 | 2165627 | 2022-01-30 | Knox | Maine | 23013 | 4148 | 22 |
2165628 | 2165628 | 2022-01-30 | Lincoln | Maine | 23015 | 3679 | 19 |
2165629 | 2165629 | 2022-01-30 | Oxford | Maine | 23017 | 8709 | 115 |
2165630 | 2165630 | 2022-01-30 | Penobscot | Maine | 23019 | 19669 | 255 |
2165631 | 2165631 | 2022-01-30 | Piscataquis | Maine | 23021 | 2219 | 25 |
2165632 | 2165632 | 2022-01-30 | Sagadahoc | Maine | 23023 | 3650 | 24 |
2165633 | 2165633 | 2022-01-30 | Somerset | Maine | 23025 | 7367 | 80 |
2165634 | 2165634 | 2022-01-30 | Unknown | Maine | 1 | 0 | |
2165635 | 2165635 | 2022-01-30 | Waldo | Maine | 23027 | 4341 | 48 |
2165636 | 2165636 | 2022-01-30 | Washington | Maine | 23029 | 3091 | 45 |
2165637 | 2165637 | 2022-01-30 | York | Maine | 23031 | 29504 | 209 |
2162366 | 2162366 | 2022-01-29 | Androscoggin | Maine | 23001 | 17596 | 189 |
2162367 | 2162367 | 2022-01-29 | Aroostook | Maine | 23003 | 8364 | 112 |
2162368 | 2162368 | 2022-01-29 | Cumberland | Maine | 23005 | 35577 | 295 |
2162369 | 2162369 | 2022-01-29 | Franklin | Maine | 23007 | 4373 | 48 |
2162370 | 2162370 | 2022-01-29 | Hancock | Maine | 23009 | 5124 | 70 |
2162371 | 2162371 | 2022-01-29 | Kennebec | Maine | 23011 | 16813 | 182 |
2162372 | 2162372 | 2022-01-29 | Knox | Maine | 23013 | 4148 | 22 |
2162373 | 2162373 | 2022-01-29 | Lincoln | Maine | 23015 | 3679 | 19 |
2162374 | 2162374 | 2022-01-29 | Oxford | Maine | 23017 | 8709 | 115 |
2162375 | 2162375 | 2022-01-29 | Penobscot | Maine | 23019 | 19669 | 255 |
2162376 | 2162376 | 2022-01-29 | Piscataquis | Maine | 23021 | 2219 | 25 |
2162377 | 2162377 | 2022-01-29 | Sagadahoc | Maine | 23023 | 3650 | 24 |
2162378 | 2162378 | 2022-01-29 | Somerset | Maine | 23025 | 7367 | 80 |
2162379 | 2162379 | 2022-01-29 | Unknown | Maine | 1 | 0 | |
2162380 | 2162380 | 2022-01-29 | Waldo | Maine | 23027 | 4341 | 48 |
2162381 | 2162381 | 2022-01-29 | Washington | Maine | 23029 | 3091 | 45 |
2162382 | 2162382 | 2022-01-29 | York | Maine | 23031 | 29504 | 209 |
2159111 | 2159111 | 2022-01-28 | Androscoggin | Maine | 23001 | 17465 | 187 |
2159112 | 2159112 | 2022-01-28 | Aroostook | Maine | 23003 | 8318 | 112 |
2159113 | 2159113 | 2022-01-28 | Cumberland | Maine | 23005 | 35214 | 295 |
2159114 | 2159114 | 2022-01-28 | Franklin | Maine | 23007 | 4361 | 47 |
2159115 | 2159115 | 2022-01-28 | Hancock | Maine | 23009 | 5104 | 70 |
2159116 | 2159116 | 2022-01-28 | Kennebec | Maine | 23011 | 16675 | 181 |
2159117 | 2159117 | 2022-01-28 | Knox | Maine | 23013 | 4119 | 22 |
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);