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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips 17
county 17
- Androscoggin 793
- Cumberland 792
- Lincoln 790
- Kennebec 788
- Oxford 788
- York 788
- Penobscot 787
- Sagadahoc 784
- Knox 782
- Waldo 781
- Franklin 779
- Somerset 776
- Hancock 773
- Aroostook 771
- Washington 771
- Piscataquis 755
- Unknown 599
state 1
- Maine · 13,097 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1467 | 1467 | 2020-03-12 | Androscoggin | Maine | 23001 | 1 | 0 |
1743 | 1743 | 2020-03-13 | Androscoggin | Maine | 23001 | 1 | 0 |
1744 | 1744 | 2020-03-13 | Cumberland | Maine | 23005 | 1 | 0 |
2083 | 2083 | 2020-03-14 | Androscoggin | Maine | 23001 | 1 | 0 |
2084 | 2084 | 2020-03-14 | Cumberland | Maine | 23005 | 2 | 0 |
2481 | 2481 | 2020-03-15 | Androscoggin | Maine | 23001 | 1 | 0 |
2482 | 2482 | 2020-03-15 | Cumberland | Maine | 23005 | 10 | 0 |
2483 | 2483 | 2020-03-15 | Lincoln | Maine | 23015 | 1 | 0 |
2927 | 2927 | 2020-03-16 | Androscoggin | Maine | 23001 | 1 | 0 |
2928 | 2928 | 2020-03-16 | Cumberland | Maine | 23005 | 13 | 0 |
2929 | 2929 | 2020-03-16 | Lincoln | Maine | 23015 | 2 | 0 |
2930 | 2930 | 2020-03-16 | Unknown | Maine | 1 | 0 | |
3425 | 3425 | 2020-03-17 | Androscoggin | Maine | 23001 | 3 | 0 |
3426 | 3426 | 2020-03-17 | Cumberland | Maine | 23005 | 20 | 0 |
3427 | 3427 | 2020-03-17 | Kennebec | Maine | 23011 | 1 | 0 |
3428 | 3428 | 2020-03-17 | Lincoln | Maine | 23015 | 3 | 0 |
3429 | 3429 | 2020-03-17 | Oxford | Maine | 23017 | 1 | 0 |
3430 | 3430 | 2020-03-17 | Unknown | Maine | 3 | 0 | |
3431 | 3431 | 2020-03-17 | York | Maine | 23031 | 1 | 0 |
4006 | 4006 | 2020-03-18 | Androscoggin | Maine | 23001 | 3 | 0 |
4007 | 4007 | 2020-03-18 | Cumberland | Maine | 23005 | 29 | 0 |
4008 | 4008 | 2020-03-18 | Kennebec | Maine | 23011 | 1 | 0 |
4009 | 4009 | 2020-03-18 | Lincoln | Maine | 23015 | 4 | 0 |
4010 | 4010 | 2020-03-18 | Oxford | Maine | 23017 | 1 | 0 |
4011 | 4011 | 2020-03-18 | Penobscot | Maine | 23019 | 1 | 0 |
4012 | 4012 | 2020-03-18 | Unknown | Maine | 3 | 0 | |
4013 | 4013 | 2020-03-18 | York | Maine | 23031 | 1 | 0 |
4708 | 4708 | 2020-03-19 | Androscoggin | Maine | 23001 | 3 | 0 |
4709 | 4709 | 2020-03-19 | Cumberland | Maine | 23005 | 34 | 0 |
4710 | 4710 | 2020-03-19 | Kennebec | Maine | 23011 | 3 | 0 |
4711 | 4711 | 2020-03-19 | Lincoln | Maine | 23015 | 4 | 0 |
4712 | 4712 | 2020-03-19 | Oxford | Maine | 23017 | 1 | 0 |
4713 | 4713 | 2020-03-19 | Penobscot | Maine | 23019 | 1 | 0 |
4714 | 4714 | 2020-03-19 | Unknown | Maine | 3 | 0 | |
4715 | 4715 | 2020-03-19 | York | Maine | 23031 | 3 | 0 |
5526 | 5526 | 2020-03-20 | Androscoggin | Maine | 23001 | 3 | 0 |
5527 | 5527 | 2020-03-20 | Cumberland | Maine | 23005 | 35 | 0 |
5528 | 5528 | 2020-03-20 | Kennebec | Maine | 23011 | 4 | 0 |
5529 | 5529 | 2020-03-20 | Lincoln | Maine | 23015 | 4 | 0 |
5530 | 5530 | 2020-03-20 | Oxford | Maine | 23017 | 1 | 0 |
5531 | 5531 | 2020-03-20 | Penobscot | Maine | 23019 | 2 | 0 |
5532 | 5532 | 2020-03-20 | Unknown | Maine | 3 | 0 | |
5533 | 5533 | 2020-03-20 | York | Maine | 23031 | 5 | 0 |
6481 | 6481 | 2020-03-21 | Androscoggin | Maine | 23001 | 3 | 0 |
6482 | 6482 | 2020-03-21 | Cumberland | Maine | 23005 | 41 | 0 |
6483 | 6483 | 2020-03-21 | Kennebec | Maine | 23011 | 4 | 0 |
6484 | 6484 | 2020-03-21 | Lincoln | Maine | 23015 | 4 | 0 |
6485 | 6485 | 2020-03-21 | Oxford | Maine | 23017 | 4 | 0 |
6486 | 6486 | 2020-03-21 | Penobscot | Maine | 23019 | 2 | 0 |
6487 | 6487 | 2020-03-21 | Sagadahoc | Maine | 23023 | 1 | 0 |
6488 | 6488 | 2020-03-21 | Unknown | Maine | 3 | 0 | |
6489 | 6489 | 2020-03-21 | York | Maine | 23031 | 8 | 0 |
7556 | 7556 | 2020-03-22 | Androscoggin | Maine | 23001 | 3 | 0 |
7557 | 7557 | 2020-03-22 | Cumberland | Maine | 23005 | 56 | 0 |
7558 | 7558 | 2020-03-22 | Kennebec | Maine | 23011 | 4 | 0 |
7559 | 7559 | 2020-03-22 | Lincoln | Maine | 23015 | 4 | 0 |
7560 | 7560 | 2020-03-22 | Oxford | Maine | 23017 | 4 | 0 |
7561 | 7561 | 2020-03-22 | Penobscot | Maine | 23019 | 2 | 0 |
7562 | 7562 | 2020-03-22 | Sagadahoc | Maine | 23023 | 3 | 0 |
7563 | 7563 | 2020-03-22 | Unknown | Maine | 5 | 0 | |
7564 | 7564 | 2020-03-22 | York | Maine | 23031 | 8 | 0 |
8725 | 8725 | 2020-03-23 | Androscoggin | Maine | 23001 | 3 | 0 |
8726 | 8726 | 2020-03-23 | Cumberland | Maine | 23005 | 66 | 0 |
8727 | 8727 | 2020-03-23 | Kennebec | Maine | 23011 | 4 | 0 |
8728 | 8728 | 2020-03-23 | Knox | Maine | 23013 | 1 | 0 |
8729 | 8729 | 2020-03-23 | Lincoln | Maine | 23015 | 5 | 0 |
8730 | 8730 | 2020-03-23 | Oxford | Maine | 23017 | 5 | 0 |
8731 | 8731 | 2020-03-23 | Penobscot | Maine | 23019 | 3 | 0 |
8732 | 8732 | 2020-03-23 | Sagadahoc | Maine | 23023 | 3 | 0 |
8733 | 8733 | 2020-03-23 | Unknown | Maine | 5 | 0 | |
8734 | 8734 | 2020-03-23 | York | Maine | 23031 | 12 | 0 |
10014 | 10014 | 2020-03-24 | Androscoggin | Maine | 23001 | 3 | 0 |
10015 | 10015 | 2020-03-24 | Cumberland | Maine | 23005 | 74 | 0 |
10016 | 10016 | 2020-03-24 | Kennebec | Maine | 23011 | 5 | 0 |
10017 | 10017 | 2020-03-24 | Knox | Maine | 23013 | 1 | 0 |
10018 | 10018 | 2020-03-24 | Lincoln | Maine | 23015 | 5 | 0 |
10019 | 10019 | 2020-03-24 | Oxford | Maine | 23017 | 6 | 0 |
10020 | 10020 | 2020-03-24 | Penobscot | Maine | 23019 | 4 | 0 |
10021 | 10021 | 2020-03-24 | Sagadahoc | Maine | 23023 | 3 | 0 |
10022 | 10022 | 2020-03-24 | Waldo | Maine | 23027 | 1 | 0 |
10023 | 10023 | 2020-03-24 | York | Maine | 23031 | 16 | 0 |
11423 | 11423 | 2020-03-25 | Androscoggin | Maine | 23001 | 4 | 0 |
11424 | 11424 | 2020-03-25 | Cumberland | Maine | 23005 | 87 | 0 |
11425 | 11425 | 2020-03-25 | Kennebec | Maine | 23011 | 5 | 0 |
11426 | 11426 | 2020-03-25 | Knox | Maine | 23013 | 1 | 0 |
11427 | 11427 | 2020-03-25 | Lincoln | Maine | 23015 | 5 | 0 |
11428 | 11428 | 2020-03-25 | Oxford | Maine | 23017 | 6 | 0 |
11429 | 11429 | 2020-03-25 | Penobscot | Maine | 23019 | 4 | 0 |
11430 | 11430 | 2020-03-25 | Sagadahoc | Maine | 23023 | 4 | 0 |
11431 | 11431 | 2020-03-25 | Unknown | Maine | 2 | 0 | |
11432 | 11432 | 2020-03-25 | Waldo | Maine | 23027 | 1 | 0 |
11433 | 11433 | 2020-03-25 | York | Maine | 23031 | 23 | 0 |
13003 | 13003 | 2020-03-26 | Androscoggin | Maine | 23001 | 5 | 0 |
13004 | 13004 | 2020-03-26 | Cumberland | Maine | 23005 | 90 | 0 |
13005 | 13005 | 2020-03-26 | Franklin | Maine | 23007 | 1 | 0 |
13006 | 13006 | 2020-03-26 | Kennebec | Maine | 23011 | 6 | 0 |
13007 | 13007 | 2020-03-26 | Knox | Maine | 23013 | 1 | 0 |
13008 | 13008 | 2020-03-26 | Lincoln | Maine | 23015 | 5 | 0 |
13009 | 13009 | 2020-03-26 | Oxford | Maine | 23017 | 8 | 0 |
13010 | 13010 | 2020-03-26 | Penobscot | Maine | 23019 | 5 | 0 |
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);