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 348
- Cumberland 347
- Lincoln 345
- Kennebec 343
- Oxford 343
- York 343
- Penobscot 342
- Sagadahoc 339
- Knox 337
- Waldo 336
- Franklin 334
- Somerset 331
- Hancock 328
- Aroostook 326
- Washington 326
- Piscataquis 310
- Unknown 277
state 1
- Maine · 5,655 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054692 | 1054692 | 2021-02-22 | Androscoggin | Maine | 23001 | 4707 | 54 |
1054693 | 1054693 | 2021-02-22 | Aroostook | Maine | 23003 | 1258 | 43 |
1054694 | 1054694 | 2021-02-22 | Cumberland | Maine | 23005 | 12252 | 176 |
1054695 | 1054695 | 2021-02-22 | Franklin | Maine | 23007 | 880 | 10 |
1054696 | 1054696 | 2021-02-22 | Hancock | Maine | 23009 | 879 | 31 |
1054697 | 1054697 | 2021-02-22 | Kennebec | Maine | 23011 | 3556 | 49 |
1054698 | 1054698 | 2021-02-22 | Knox | Maine | 23013 | 624 | 5 |
1054699 | 1054699 | 2021-02-22 | Lincoln | Maine | 23015 | 568 | 1 |
1054700 | 1054700 | 2021-02-22 | Oxford | Maine | 23017 | 2161 | 42 |
1054701 | 1054701 | 2021-02-22 | Penobscot | Maine | 23019 | 3794 | 76 |
1054702 | 1054702 | 2021-02-22 | Piscataquis | Maine | 23021 | 245 | 1 |
1054703 | 1054703 | 2021-02-22 | Sagadahoc | Maine | 23023 | 867 | 1 |
1054704 | 1054704 | 2021-02-22 | Somerset | Maine | 23025 | 1231 | 26 |
1054705 | 1054705 | 2021-02-22 | Unknown | Maine | 3 | 0 | |
1054706 | 1054706 | 2021-02-22 | Waldo | Maine | 23027 | 576 | 19 |
1054707 | 1054707 | 2021-02-22 | Washington | Maine | 23029 | 706 | 14 |
1054708 | 1054708 | 2021-02-22 | York | Maine | 23031 | 9287 | 110 |
1051445 | 1051445 | 2021-02-21 | Androscoggin | Maine | 23001 | 4695 | 54 |
1051446 | 1051446 | 2021-02-21 | Aroostook | Maine | 23003 | 1257 | 43 |
1051447 | 1051447 | 2021-02-21 | Cumberland | Maine | 23005 | 12228 | 176 |
1051448 | 1051448 | 2021-02-21 | Franklin | Maine | 23007 | 880 | 10 |
1051449 | 1051449 | 2021-02-21 | Hancock | Maine | 23009 | 874 | 31 |
1051450 | 1051450 | 2021-02-21 | Kennebec | Maine | 23011 | 3548 | 49 |
1051451 | 1051451 | 2021-02-21 | Knox | Maine | 23013 | 622 | 5 |
1051452 | 1051452 | 2021-02-21 | Lincoln | Maine | 23015 | 566 | 1 |
1051453 | 1051453 | 2021-02-21 | Oxford | Maine | 23017 | 2157 | 42 |
1051454 | 1051454 | 2021-02-21 | Penobscot | Maine | 23019 | 3784 | 76 |
1051455 | 1051455 | 2021-02-21 | Piscataquis | Maine | 23021 | 244 | 1 |
1051456 | 1051456 | 2021-02-21 | Sagadahoc | Maine | 23023 | 865 | 1 |
1051457 | 1051457 | 2021-02-21 | Somerset | Maine | 23025 | 1230 | 26 |
1051458 | 1051458 | 2021-02-21 | Unknown | Maine | 3 | 0 | |
1051459 | 1051459 | 2021-02-21 | Waldo | Maine | 23027 | 574 | 19 |
1051460 | 1051460 | 2021-02-21 | Washington | Maine | 23029 | 704 | 14 |
1051461 | 1051461 | 2021-02-21 | York | Maine | 23031 | 9266 | 110 |
1048198 | 1048198 | 2021-02-20 | Androscoggin | Maine | 23001 | 4684 | 54 |
1048199 | 1048199 | 2021-02-20 | Aroostook | Maine | 23003 | 1254 | 43 |
1048200 | 1048200 | 2021-02-20 | Cumberland | Maine | 23005 | 12197 | 176 |
1048201 | 1048201 | 2021-02-20 | Franklin | Maine | 23007 | 880 | 10 |
1048202 | 1048202 | 2021-02-20 | Hancock | Maine | 23009 | 871 | 31 |
1048203 | 1048203 | 2021-02-20 | Kennebec | Maine | 23011 | 3537 | 49 |
1048204 | 1048204 | 2021-02-20 | Knox | Maine | 23013 | 620 | 5 |
1048205 | 1048205 | 2021-02-20 | Lincoln | Maine | 23015 | 563 | 1 |
1048206 | 1048206 | 2021-02-20 | Oxford | Maine | 23017 | 2152 | 42 |
1048207 | 1048207 | 2021-02-20 | Penobscot | Maine | 23019 | 3759 | 76 |
1048208 | 1048208 | 2021-02-20 | Piscataquis | Maine | 23021 | 244 | 1 |
1048209 | 1048209 | 2021-02-20 | Sagadahoc | Maine | 23023 | 865 | 1 |
1048210 | 1048210 | 2021-02-20 | Somerset | Maine | 23025 | 1229 | 26 |
1048211 | 1048211 | 2021-02-20 | Unknown | Maine | 2 | 0 | |
1048212 | 1048212 | 2021-02-20 | Waldo | Maine | 23027 | 572 | 19 |
1048213 | 1048213 | 2021-02-20 | Washington | Maine | 23029 | 698 | 14 |
1048214 | 1048214 | 2021-02-20 | York | Maine | 23031 | 9240 | 110 |
1044953 | 1044953 | 2021-02-19 | Androscoggin | Maine | 23001 | 4666 | 54 |
1044954 | 1044954 | 2021-02-19 | Aroostook | Maine | 23003 | 1252 | 43 |
1044955 | 1044955 | 2021-02-19 | Cumberland | Maine | 23005 | 12160 | 176 |
1044956 | 1044956 | 2021-02-19 | Franklin | Maine | 23007 | 881 | 10 |
1044957 | 1044957 | 2021-02-19 | Hancock | Maine | 23009 | 867 | 31 |
1044958 | 1044958 | 2021-02-19 | Kennebec | Maine | 23011 | 3522 | 49 |
1044959 | 1044959 | 2021-02-19 | Knox | Maine | 23013 | 620 | 5 |
1044960 | 1044960 | 2021-02-19 | Lincoln | Maine | 23015 | 559 | 1 |
1044961 | 1044961 | 2021-02-19 | Oxford | Maine | 23017 | 2144 | 41 |
1044962 | 1044962 | 2021-02-19 | Penobscot | Maine | 23019 | 3748 | 76 |
1044963 | 1044963 | 2021-02-19 | Piscataquis | Maine | 23021 | 244 | 1 |
1044964 | 1044964 | 2021-02-19 | Sagadahoc | Maine | 23023 | 862 | 1 |
1044965 | 1044965 | 2021-02-19 | Somerset | Maine | 23025 | 1227 | 26 |
1044966 | 1044966 | 2021-02-19 | Waldo | Maine | 23027 | 570 | 18 |
1044967 | 1044967 | 2021-02-19 | Washington | Maine | 23029 | 699 | 14 |
1044968 | 1044968 | 2021-02-19 | York | Maine | 23031 | 9203 | 110 |
1041708 | 1041708 | 2021-02-18 | Androscoggin | Maine | 23001 | 4659 | 54 |
1041709 | 1041709 | 2021-02-18 | Aroostook | Maine | 23003 | 1247 | 43 |
1041710 | 1041710 | 2021-02-18 | Cumberland | Maine | 23005 | 12120 | 176 |
1041711 | 1041711 | 2021-02-18 | Franklin | Maine | 23007 | 878 | 10 |
1041712 | 1041712 | 2021-02-18 | Hancock | Maine | 23009 | 866 | 31 |
1041713 | 1041713 | 2021-02-18 | Kennebec | Maine | 23011 | 3512 | 49 |
1041714 | 1041714 | 2021-02-18 | Knox | Maine | 23013 | 618 | 5 |
1041715 | 1041715 | 2021-02-18 | Lincoln | Maine | 23015 | 554 | 1 |
1041716 | 1041716 | 2021-02-18 | Oxford | Maine | 23017 | 2136 | 41 |
1041717 | 1041717 | 2021-02-18 | Penobscot | Maine | 23019 | 3730 | 76 |
1041718 | 1041718 | 2021-02-18 | Piscataquis | Maine | 23021 | 242 | 1 |
1041719 | 1041719 | 2021-02-18 | Sagadahoc | Maine | 23023 | 857 | 1 |
1041720 | 1041720 | 2021-02-18 | Somerset | Maine | 23025 | 1225 | 26 |
1041721 | 1041721 | 2021-02-18 | Waldo | Maine | 23027 | 568 | 18 |
1041722 | 1041722 | 2021-02-18 | Washington | Maine | 23029 | 698 | 13 |
1041723 | 1041723 | 2021-02-18 | York | Maine | 23031 | 9180 | 110 |
1038463 | 1038463 | 2021-02-17 | Androscoggin | Maine | 23001 | 4643 | 54 |
1038464 | 1038464 | 2021-02-17 | Aroostook | Maine | 23003 | 1244 | 43 |
1038465 | 1038465 | 2021-02-17 | Cumberland | Maine | 23005 | 12039 | 175 |
1038466 | 1038466 | 2021-02-17 | Franklin | Maine | 23007 | 878 | 10 |
1038467 | 1038467 | 2021-02-17 | Hancock | Maine | 23009 | 861 | 31 |
1038468 | 1038468 | 2021-02-17 | Kennebec | Maine | 23011 | 3497 | 49 |
1038469 | 1038469 | 2021-02-17 | Knox | Maine | 23013 | 616 | 5 |
1038470 | 1038470 | 2021-02-17 | Lincoln | Maine | 23015 | 551 | 1 |
1038471 | 1038471 | 2021-02-17 | Oxford | Maine | 23017 | 2129 | 41 |
1038472 | 1038472 | 2021-02-17 | Penobscot | Maine | 23019 | 3704 | 76 |
1038473 | 1038473 | 2021-02-17 | Piscataquis | Maine | 23021 | 242 | 1 |
1038474 | 1038474 | 2021-02-17 | Sagadahoc | Maine | 23023 | 852 | 1 |
1038475 | 1038475 | 2021-02-17 | Somerset | Maine | 23025 | 1219 | 26 |
1038476 | 1038476 | 2021-02-17 | Waldo | Maine | 23027 | 567 | 18 |
1038477 | 1038477 | 2021-02-17 | Washington | Maine | 23029 | 696 | 13 |
1038478 | 1038478 | 2021-02-17 | York | Maine | 23031 | 9134 | 110 |
1035218 | 1035218 | 2021-02-16 | Androscoggin | Maine | 23001 | 4633 | 54 |
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);