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 790
- Cumberland 789
- Lincoln 787
- Kennebec 785
- Oxford 785
- York 785
- Penobscot 784
- Sagadahoc 781
- Knox 779
- Waldo 778
- Franklin 776
- Somerset 773
- Hancock 770
- Aroostook 768
- Washington 768
- Piscataquis 752
- Unknown 596
state 1
- Maine · 13,046 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490990 | 2490990 | 2022-05-10 | Androscoggin | Maine | 23001 | 23123 | 285 |
2490991 | 2490991 | 2022-05-10 | Aroostook | Maine | 23003 | 14197 | 165 |
2490992 | 2490992 | 2022-05-10 | Cumberland | Maine | 23005 | 51910 | 364 |
2490993 | 2490993 | 2022-05-10 | Franklin | Maine | 23007 | 5985 | 59 |
2490994 | 2490994 | 2022-05-10 | Hancock | Maine | 23009 | 7843 | 87 |
2490995 | 2490995 | 2022-05-10 | Kennebec | Maine | 23011 | 24561 | 239 |
2490996 | 2490996 | 2022-05-10 | Knox | Maine | 23013 | 6360 | 37 |
2490997 | 2490997 | 2022-05-10 | Lincoln | Maine | 23015 | 5538 | 35 |
2490998 | 2490998 | 2022-05-10 | Oxford | Maine | 23017 | 11711 | 148 |
2490999 | 2490999 | 2022-05-10 | Penobscot | Maine | 23019 | 29383 | 331 |
2491000 | 2491000 | 2022-05-10 | Piscataquis | Maine | 23021 | 3091 | 31 |
2491001 | 2491001 | 2022-05-10 | Sagadahoc | Maine | 23023 | 5477 | 32 |
2491002 | 2491002 | 2022-05-10 | Somerset | Maine | 23025 | 10161 | 110 |
2491003 | 2491003 | 2022-05-10 | Unknown | Maine | 35 | 0 | |
2491004 | 2491004 | 2022-05-10 | Waldo | Maine | 23027 | 6399 | 57 |
2491005 | 2491005 | 2022-05-10 | Washington | Maine | 23029 | 4563 | 56 |
2491006 | 2491006 | 2022-05-10 | York | Maine | 23031 | 41568 | 291 |
2487733 | 2487733 | 2022-05-09 | Androscoggin | Maine | 23001 | 23086 | 285 |
2487734 | 2487734 | 2022-05-09 | Aroostook | Maine | 23003 | 14134 | 165 |
2487735 | 2487735 | 2022-05-09 | Cumberland | Maine | 23005 | 51689 | 364 |
2487736 | 2487736 | 2022-05-09 | Franklin | Maine | 23007 | 5978 | 59 |
2487737 | 2487737 | 2022-05-09 | Hancock | Maine | 23009 | 7812 | 87 |
2487738 | 2487738 | 2022-05-09 | Kennebec | Maine | 23011 | 24487 | 239 |
2487739 | 2487739 | 2022-05-09 | Knox | Maine | 23013 | 6340 | 37 |
2487740 | 2487740 | 2022-05-09 | Lincoln | Maine | 23015 | 5522 | 35 |
2487741 | 2487741 | 2022-05-09 | Oxford | Maine | 23017 | 11694 | 148 |
2487742 | 2487742 | 2022-05-09 | Penobscot | Maine | 23019 | 29281 | 331 |
2487743 | 2487743 | 2022-05-09 | Piscataquis | Maine | 23021 | 3083 | 31 |
2487744 | 2487744 | 2022-05-09 | Sagadahoc | Maine | 23023 | 5460 | 32 |
2487745 | 2487745 | 2022-05-09 | Somerset | Maine | 23025 | 10130 | 109 |
2487746 | 2487746 | 2022-05-09 | Unknown | Maine | 58 | 0 | |
2487747 | 2487747 | 2022-05-09 | Waldo | Maine | 23027 | 6381 | 57 |
2487748 | 2487748 | 2022-05-09 | Washington | Maine | 23029 | 4556 | 56 |
2487749 | 2487749 | 2022-05-09 | York | Maine | 23031 | 41443 | 290 |
2484475 | 2484475 | 2022-05-08 | Androscoggin | Maine | 23001 | 23061 | 285 |
2484476 | 2484476 | 2022-05-08 | Aroostook | Maine | 23003 | 14105 | 165 |
2484477 | 2484477 | 2022-05-08 | Cumberland | Maine | 23005 | 51574 | 364 |
2484478 | 2484478 | 2022-05-08 | Franklin | Maine | 23007 | 5974 | 59 |
2484479 | 2484479 | 2022-05-08 | Hancock | Maine | 23009 | 7793 | 87 |
2484480 | 2484480 | 2022-05-08 | Kennebec | Maine | 23011 | 24440 | 239 |
2484481 | 2484481 | 2022-05-08 | Knox | Maine | 23013 | 6333 | 37 |
2484482 | 2484482 | 2022-05-08 | Lincoln | Maine | 23015 | 5517 | 35 |
2484483 | 2484483 | 2022-05-08 | Oxford | Maine | 23017 | 11687 | 148 |
2484484 | 2484484 | 2022-05-08 | Penobscot | Maine | 23019 | 29230 | 331 |
2484485 | 2484485 | 2022-05-08 | Piscataquis | Maine | 23021 | 3080 | 31 |
2484486 | 2484486 | 2022-05-08 | Sagadahoc | Maine | 23023 | 5450 | 32 |
2484487 | 2484487 | 2022-05-08 | Somerset | Maine | 23025 | 10115 | 109 |
2484488 | 2484488 | 2022-05-08 | Unknown | Maine | 48 | 0 | |
2484489 | 2484489 | 2022-05-08 | Waldo | Maine | 23027 | 6368 | 57 |
2484490 | 2484490 | 2022-05-08 | Washington | Maine | 23029 | 4554 | 56 |
2484491 | 2484491 | 2022-05-08 | York | Maine | 23031 | 41360 | 290 |
2481217 | 2481217 | 2022-05-07 | Androscoggin | Maine | 23001 | 23061 | 285 |
2481218 | 2481218 | 2022-05-07 | Aroostook | Maine | 23003 | 14105 | 165 |
2481219 | 2481219 | 2022-05-07 | Cumberland | Maine | 23005 | 51574 | 364 |
2481220 | 2481220 | 2022-05-07 | Franklin | Maine | 23007 | 5974 | 59 |
2481221 | 2481221 | 2022-05-07 | Hancock | Maine | 23009 | 7793 | 87 |
2481222 | 2481222 | 2022-05-07 | Kennebec | Maine | 23011 | 24440 | 239 |
2481223 | 2481223 | 2022-05-07 | Knox | Maine | 23013 | 6333 | 37 |
2481224 | 2481224 | 2022-05-07 | Lincoln | Maine | 23015 | 5517 | 35 |
2481225 | 2481225 | 2022-05-07 | Oxford | Maine | 23017 | 11687 | 148 |
2481226 | 2481226 | 2022-05-07 | Penobscot | Maine | 23019 | 29230 | 331 |
2481227 | 2481227 | 2022-05-07 | Piscataquis | Maine | 23021 | 3080 | 31 |
2481228 | 2481228 | 2022-05-07 | Sagadahoc | Maine | 23023 | 5450 | 32 |
2481229 | 2481229 | 2022-05-07 | Somerset | Maine | 23025 | 10115 | 109 |
2481230 | 2481230 | 2022-05-07 | Unknown | Maine | 48 | 0 | |
2481231 | 2481231 | 2022-05-07 | Waldo | Maine | 23027 | 6368 | 57 |
2481232 | 2481232 | 2022-05-07 | Washington | Maine | 23029 | 4554 | 56 |
2481233 | 2481233 | 2022-05-07 | York | Maine | 23031 | 41360 | 290 |
2477959 | 2477959 | 2022-05-06 | Androscoggin | Maine | 23001 | 23004 | 285 |
2477960 | 2477960 | 2022-05-06 | Aroostook | Maine | 23003 | 14033 | 163 |
2477961 | 2477961 | 2022-05-06 | Cumberland | Maine | 23005 | 51330 | 363 |
2477962 | 2477962 | 2022-05-06 | Franklin | Maine | 23007 | 5950 | 59 |
2477963 | 2477963 | 2022-05-06 | Hancock | Maine | 23009 | 7757 | 87 |
2477964 | 2477964 | 2022-05-06 | Kennebec | Maine | 23011 | 24357 | 239 |
2477965 | 2477965 | 2022-05-06 | Knox | Maine | 23013 | 6315 | 37 |
2477966 | 2477966 | 2022-05-06 | Lincoln | Maine | 23015 | 5503 | 35 |
2477967 | 2477967 | 2022-05-06 | Oxford | Maine | 23017 | 11660 | 146 |
2477968 | 2477968 | 2022-05-06 | Penobscot | Maine | 23019 | 29104 | 329 |
2477969 | 2477969 | 2022-05-06 | Piscataquis | Maine | 23021 | 3068 | 31 |
2477970 | 2477970 | 2022-05-06 | Sagadahoc | Maine | 23023 | 5421 | 32 |
2477971 | 2477971 | 2022-05-06 | Somerset | Maine | 23025 | 10091 | 107 |
2477972 | 2477972 | 2022-05-06 | Unknown | Maine | 26 | 0 | |
2477973 | 2477973 | 2022-05-06 | Waldo | Maine | 23027 | 6353 | 57 |
2477974 | 2477974 | 2022-05-06 | Washington | Maine | 23029 | 4546 | 56 |
2477975 | 2477975 | 2022-05-06 | York | Maine | 23031 | 41210 | 290 |
2474701 | 2474701 | 2022-05-05 | Androscoggin | Maine | 23001 | 22958 | 285 |
2474702 | 2474702 | 2022-05-05 | Aroostook | Maine | 23003 | 13935 | 160 |
2474703 | 2474703 | 2022-05-05 | Cumberland | Maine | 23005 | 51124 | 362 |
2474704 | 2474704 | 2022-05-05 | Franklin | Maine | 23007 | 5940 | 59 |
2474705 | 2474705 | 2022-05-05 | Hancock | Maine | 23009 | 7723 | 87 |
2474706 | 2474706 | 2022-05-05 | Kennebec | Maine | 23011 | 24259 | 238 |
2474707 | 2474707 | 2022-05-05 | Knox | Maine | 23013 | 6291 | 36 |
2474708 | 2474708 | 2022-05-05 | Lincoln | Maine | 23015 | 5480 | 35 |
2474709 | 2474709 | 2022-05-05 | Oxford | Maine | 23017 | 11641 | 146 |
2474710 | 2474710 | 2022-05-05 | Penobscot | Maine | 23019 | 28974 | 328 |
2474711 | 2474711 | 2022-05-05 | Piscataquis | Maine | 23021 | 3059 | 31 |
2474712 | 2474712 | 2022-05-05 | Sagadahoc | Maine | 23023 | 5399 | 32 |
2474713 | 2474713 | 2022-05-05 | Somerset | Maine | 23025 | 10068 | 105 |
2474714 | 2474714 | 2022-05-05 | Unknown | Maine | 20 | 0 | |
2474715 | 2474715 | 2022-05-05 | Waldo | Maine | 23027 | 6331 | 57 |
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);