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 787
- Cumberland 786
- Lincoln 784
- York 783
- Kennebec 782
- Oxford 782
- Penobscot 781
- Sagadahoc 778
- Knox 776
- Waldo 775
- Franklin 773
- Somerset 770
- Hancock 767
- Washington 766
- Aroostook 765
- Piscataquis 749
- Unknown 593
state 1
- Maine · 12,997 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
2474716 | 2474716 | 2022-05-05 | Washington | Maine | 23029 | 4533 | 56 |
2474717 | 2474717 | 2022-05-05 | York | Maine | 23031 | 41063 | 287 |
2471444 | 2471444 | 2022-05-04 | Androscoggin | Maine | 23001 | 22925 | 284 |
2471445 | 2471445 | 2022-05-04 | Aroostook | Maine | 23003 | 13866 | 160 |
2471446 | 2471446 | 2022-05-04 | Cumberland | Maine | 23005 | 50948 | 361 |
2471447 | 2471447 | 2022-05-04 | Franklin | Maine | 23007 | 5931 | 59 |
2471448 | 2471448 | 2022-05-04 | Hancock | Maine | 23009 | 7702 | 85 |
2471449 | 2471449 | 2022-05-04 | Kennebec | Maine | 23011 | 24189 | 236 |
2471450 | 2471450 | 2022-05-04 | Knox | Maine | 23013 | 6268 | 36 |
2471451 | 2471451 | 2022-05-04 | Lincoln | Maine | 23015 | 5464 | 35 |
2471452 | 2471452 | 2022-05-04 | Oxford | Maine | 23017 | 11611 | 146 |
2471453 | 2471453 | 2022-05-04 | Penobscot | Maine | 23019 | 28894 | 326 |
2471454 | 2471454 | 2022-05-04 | Piscataquis | Maine | 23021 | 3057 | 31 |
2471455 | 2471455 | 2022-05-04 | Sagadahoc | Maine | 23023 | 5389 | 32 |
2471456 | 2471456 | 2022-05-04 | Somerset | Maine | 23025 | 10048 | 105 |
2471457 | 2471457 | 2022-05-04 | Unknown | Maine | 18 | 0 | |
2471458 | 2471458 | 2022-05-04 | Waldo | Maine | 23027 | 6312 | 57 |
2471459 | 2471459 | 2022-05-04 | Washington | Maine | 23029 | 4522 | 56 |
2471460 | 2471460 | 2022-05-04 | York | Maine | 23031 | 40955 | 287 |
2468188 | 2468188 | 2022-05-03 | Androscoggin | Maine | 23001 | 22878 | 284 |
2468189 | 2468189 | 2022-05-03 | Aroostook | Maine | 23003 | 13761 | 158 |
2468190 | 2468190 | 2022-05-03 | Cumberland | Maine | 23005 | 50738 | 360 |
2468191 | 2468191 | 2022-05-03 | Franklin | Maine | 23007 | 5901 | 59 |
2468192 | 2468192 | 2022-05-03 | Hancock | Maine | 23009 | 7653 | 85 |
2468193 | 2468193 | 2022-05-03 | Kennebec | Maine | 23011 | 24042 | 236 |
2468194 | 2468194 | 2022-05-03 | Knox | Maine | 23013 | 6243 | 36 |
2468195 | 2468195 | 2022-05-03 | Lincoln | Maine | 23015 | 5445 | 35 |
2468196 | 2468196 | 2022-05-03 | Oxford | Maine | 23017 | 11588 | 146 |
2468197 | 2468197 | 2022-05-03 | Penobscot | Maine | 23019 | 28714 | 326 |
2468198 | 2468198 | 2022-05-03 | Piscataquis | Maine | 23021 | 3045 | 31 |
2468199 | 2468199 | 2022-05-03 | Sagadahoc | Maine | 23023 | 5367 | 32 |
2468200 | 2468200 | 2022-05-03 | Somerset | Maine | 23025 | 10020 | 104 |
2468201 | 2468201 | 2022-05-03 | Unknown | Maine | 20 | 0 | |
2468202 | 2468202 | 2022-05-03 | Waldo | Maine | 23027 | 6287 | 57 |
2468203 | 2468203 | 2022-05-03 | Washington | Maine | 23029 | 4508 | 56 |
2468204 | 2468204 | 2022-05-03 | York | Maine | 23031 | 40859 | 286 |
2464933 | 2464933 | 2022-05-02 | Androscoggin | Maine | 23001 | 22822 | 284 |
2464934 | 2464934 | 2022-05-02 | Aroostook | Maine | 23003 | 13668 | 158 |
2464935 | 2464935 | 2022-05-02 | Cumberland | Maine | 23005 | 50428 | 359 |
2464936 | 2464936 | 2022-05-02 | Franklin | Maine | 23007 | 5872 | 59 |
2464937 | 2464937 | 2022-05-02 | Hancock | Maine | 23009 | 7613 | 85 |
2464938 | 2464938 | 2022-05-02 | Kennebec | Maine | 23011 | 23907 | 236 |
2464939 | 2464939 | 2022-05-02 | Knox | Maine | 23013 | 6204 | 35 |
2464940 | 2464940 | 2022-05-02 | Lincoln | Maine | 23015 | 5411 | 35 |
2464941 | 2464941 | 2022-05-02 | Oxford | Maine | 23017 | 11558 | 146 |
2464942 | 2464942 | 2022-05-02 | Penobscot | Maine | 23019 | 28577 | 326 |
2464943 | 2464943 | 2022-05-02 | Piscataquis | Maine | 23021 | 3040 | 31 |
2464944 | 2464944 | 2022-05-02 | Sagadahoc | Maine | 23023 | 5328 | 32 |
2464945 | 2464945 | 2022-05-02 | Somerset | Maine | 23025 | 9983 | 104 |
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);