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 391
- Cumberland 390
- Lincoln 388
- Kennebec 386
- Oxford 386
- York 386
- Penobscot 385
- Sagadahoc 382
- Knox 380
- Waldo 379
- Franklin 377
- Somerset 374
- Hancock 371
- Aroostook 369
- Washington 369
- Piscataquis 353
- Unknown 298
state 1
- Maine · 6,364 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194295 | 1194295 | 2021-04-06 | Androscoggin | Maine | 23001 | 5593 | 59 |
1194296 | 1194296 | 2021-04-06 | Aroostook | Maine | 23003 | 1441 | 44 |
1194297 | 1194297 | 2021-04-06 | Cumberland | Maine | 23005 | 14283 | 186 |
1194298 | 1194298 | 2021-04-06 | Franklin | Maine | 23007 | 1008 | 13 |
1194299 | 1194299 | 2021-04-06 | Hancock | Maine | 23009 | 1100 | 36 |
1194300 | 1194300 | 2021-04-06 | Kennebec | Maine | 23011 | 4482 | 58 |
1194301 | 1194301 | 2021-04-06 | Knox | Maine | 23013 | 824 | 5 |
1194302 | 1194302 | 2021-04-06 | Lincoln | Maine | 23015 | 682 | 2 |
1194303 | 1194303 | 2021-04-06 | Oxford | Maine | 23017 | 2658 | 56 |
1194304 | 1194304 | 2021-04-06 | Penobscot | Maine | 23019 | 4770 | 88 |
1194305 | 1194305 | 2021-04-06 | Piscataquis | Maine | 23021 | 393 | 4 |
1194306 | 1194306 | 2021-04-06 | Sagadahoc | Maine | 23023 | 1027 | 6 |
1194307 | 1194307 | 2021-04-06 | Somerset | Maine | 23025 | 1456 | 28 |
1194308 | 1194308 | 2021-04-06 | Waldo | Maine | 23027 | 729 | 19 |
1194309 | 1194309 | 2021-04-06 | Washington | Maine | 23029 | 785 | 15 |
1194310 | 1194310 | 2021-04-06 | York | Maine | 23031 | 11045 | 127 |
1191045 | 1191045 | 2021-04-05 | Androscoggin | Maine | 23001 | 5539 | 59 |
1191046 | 1191046 | 2021-04-05 | Aroostook | Maine | 23003 | 1438 | 44 |
1191047 | 1191047 | 2021-04-05 | Cumberland | Maine | 23005 | 14239 | 186 |
1191048 | 1191048 | 2021-04-05 | Franklin | Maine | 23007 | 1007 | 13 |
1191049 | 1191049 | 2021-04-05 | Hancock | Maine | 23009 | 1089 | 36 |
1191050 | 1191050 | 2021-04-05 | Kennebec | Maine | 23011 | 4454 | 58 |
1191051 | 1191051 | 2021-04-05 | Knox | Maine | 23013 | 821 | 5 |
1191052 | 1191052 | 2021-04-05 | Lincoln | Maine | 23015 | 681 | 2 |
1191053 | 1191053 | 2021-04-05 | Oxford | Maine | 23017 | 2644 | 56 |
1191054 | 1191054 | 2021-04-05 | Penobscot | Maine | 23019 | 4733 | 88 |
1191055 | 1191055 | 2021-04-05 | Piscataquis | Maine | 23021 | 390 | 4 |
1191056 | 1191056 | 2021-04-05 | Sagadahoc | Maine | 23023 | 1020 | 6 |
1191057 | 1191057 | 2021-04-05 | Somerset | Maine | 23025 | 1443 | 28 |
1191058 | 1191058 | 2021-04-05 | Unknown | Maine | 1 | 0 | |
1191059 | 1191059 | 2021-04-05 | Waldo | Maine | 23027 | 726 | 19 |
1191060 | 1191060 | 2021-04-05 | Washington | Maine | 23029 | 783 | 15 |
1191061 | 1191061 | 2021-04-05 | York | Maine | 23031 | 10978 | 127 |
1187798 | 1187798 | 2021-04-04 | Androscoggin | Maine | 23001 | 5473 | 59 |
1187799 | 1187799 | 2021-04-04 | Aroostook | Maine | 23003 | 1437 | 44 |
1187800 | 1187800 | 2021-04-04 | Cumberland | Maine | 23005 | 14203 | 186 |
1187801 | 1187801 | 2021-04-04 | Franklin | Maine | 23007 | 1002 | 13 |
1187802 | 1187802 | 2021-04-04 | Hancock | Maine | 23009 | 1087 | 35 |
1187803 | 1187803 | 2021-04-04 | Kennebec | Maine | 23011 | 4434 | 58 |
1187804 | 1187804 | 2021-04-04 | Knox | Maine | 23013 | 819 | 5 |
1187805 | 1187805 | 2021-04-04 | Lincoln | Maine | 23015 | 680 | 2 |
1187806 | 1187806 | 2021-04-04 | Oxford | Maine | 23017 | 2628 | 56 |
1187807 | 1187807 | 2021-04-04 | Penobscot | Maine | 23019 | 4727 | 88 |
1187808 | 1187808 | 2021-04-04 | Piscataquis | Maine | 23021 | 389 | 4 |
1187809 | 1187809 | 2021-04-04 | Sagadahoc | Maine | 23023 | 1009 | 6 |
1187810 | 1187810 | 2021-04-04 | Somerset | Maine | 23025 | 1434 | 28 |
1187811 | 1187811 | 2021-04-04 | Waldo | Maine | 23027 | 722 | 19 |
1187812 | 1187812 | 2021-04-04 | Washington | Maine | 23029 | 782 | 15 |
1187813 | 1187813 | 2021-04-04 | York | Maine | 23031 | 10937 | 127 |
1184551 | 1184551 | 2021-04-03 | Androscoggin | Maine | 23001 | 5417 | 59 |
1184552 | 1184552 | 2021-04-03 | Aroostook | Maine | 23003 | 1427 | 44 |
1184553 | 1184553 | 2021-04-03 | Cumberland | Maine | 23005 | 14147 | 186 |
1184554 | 1184554 | 2021-04-03 | Franklin | Maine | 23007 | 1000 | 13 |
1184555 | 1184555 | 2021-04-03 | Hancock | Maine | 23009 | 1078 | 35 |
1184556 | 1184556 | 2021-04-03 | Kennebec | Maine | 23011 | 4397 | 58 |
1184557 | 1184557 | 2021-04-03 | Knox | Maine | 23013 | 819 | 5 |
1184558 | 1184558 | 2021-04-03 | Lincoln | Maine | 23015 | 675 | 2 |
1184559 | 1184559 | 2021-04-03 | Oxford | Maine | 23017 | 2602 | 56 |
1184560 | 1184560 | 2021-04-03 | Penobscot | Maine | 23019 | 4707 | 88 |
1184561 | 1184561 | 2021-04-03 | Piscataquis | Maine | 23021 | 388 | 4 |
1184562 | 1184562 | 2021-04-03 | Sagadahoc | Maine | 23023 | 998 | 6 |
1184563 | 1184563 | 2021-04-03 | Somerset | Maine | 23025 | 1426 | 28 |
1184564 | 1184564 | 2021-04-03 | Waldo | Maine | 23027 | 721 | 19 |
1184565 | 1184565 | 2021-04-03 | Washington | Maine | 23029 | 777 | 15 |
1184566 | 1184566 | 2021-04-03 | York | Maine | 23031 | 10889 | 127 |
1181304 | 1181304 | 2021-04-02 | Androscoggin | Maine | 23001 | 5389 | 59 |
1181305 | 1181305 | 2021-04-02 | Aroostook | Maine | 23003 | 1422 | 44 |
1181306 | 1181306 | 2021-04-02 | Cumberland | Maine | 23005 | 14094 | 186 |
1181307 | 1181307 | 2021-04-02 | Franklin | Maine | 23007 | 997 | 13 |
1181308 | 1181308 | 2021-04-02 | Hancock | Maine | 23009 | 1074 | 35 |
1181309 | 1181309 | 2021-04-02 | Kennebec | Maine | 23011 | 4370 | 58 |
1181310 | 1181310 | 2021-04-02 | Knox | Maine | 23013 | 816 | 5 |
1181311 | 1181311 | 2021-04-02 | Lincoln | Maine | 23015 | 668 | 2 |
1181312 | 1181312 | 2021-04-02 | Oxford | Maine | 23017 | 2592 | 56 |
1181313 | 1181313 | 2021-04-02 | Penobscot | Maine | 23019 | 4677 | 88 |
1181314 | 1181314 | 2021-04-02 | Piscataquis | Maine | 23021 | 388 | 4 |
1181315 | 1181315 | 2021-04-02 | Sagadahoc | Maine | 23023 | 993 | 6 |
1181316 | 1181316 | 2021-04-02 | Somerset | Maine | 23025 | 1414 | 27 |
1181317 | 1181317 | 2021-04-02 | Unknown | Maine | 2 | 0 | |
1181318 | 1181318 | 2021-04-02 | Waldo | Maine | 23027 | 720 | 19 |
1181319 | 1181319 | 2021-04-02 | Washington | Maine | 23029 | 770 | 15 |
1181320 | 1181320 | 2021-04-02 | York | Maine | 23031 | 10803 | 127 |
1178057 | 1178057 | 2021-04-01 | Androscoggin | Maine | 23001 | 5312 | 59 |
1178058 | 1178058 | 2021-04-01 | Aroostook | Maine | 23003 | 1409 | 44 |
1178059 | 1178059 | 2021-04-01 | Cumberland | Maine | 23005 | 14035 | 186 |
1178060 | 1178060 | 2021-04-01 | Franklin | Maine | 23007 | 991 | 13 |
1178061 | 1178061 | 2021-04-01 | Hancock | Maine | 23009 | 1062 | 35 |
1178062 | 1178062 | 2021-04-01 | Kennebec | Maine | 23011 | 4323 | 58 |
1178063 | 1178063 | 2021-04-01 | Knox | Maine | 23013 | 809 | 5 |
1178064 | 1178064 | 2021-04-01 | Lincoln | Maine | 23015 | 661 | 2 |
1178065 | 1178065 | 2021-04-01 | Oxford | Maine | 23017 | 2551 | 56 |
1178066 | 1178066 | 2021-04-01 | Penobscot | Maine | 23019 | 4650 | 88 |
1178067 | 1178067 | 2021-04-01 | Piscataquis | Maine | 23021 | 388 | 4 |
1178068 | 1178068 | 2021-04-01 | Sagadahoc | Maine | 23023 | 985 | 6 |
1178069 | 1178069 | 2021-04-01 | Somerset | Maine | 23025 | 1399 | 27 |
1178070 | 1178070 | 2021-04-01 | Unknown | Maine | 1 | 0 | |
1178071 | 1178071 | 2021-04-01 | Waldo | Maine | 23027 | 710 | 19 |
1178072 | 1178072 | 2021-04-01 | Washington | Maine | 23029 | 768 | 15 |
1178073 | 1178073 | 2021-04-01 | York | Maine | 23031 | 10734 | 127 |
1174810 | 1174810 | 2021-03-31 | Androscoggin | Maine | 23001 | 5286 | 59 |
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);