ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 6046 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- North Carolina 8
- Florida 3
- Guam 3
- New Hampshire 3
- Ohio 3
- California 2
- Georgia 2
- Indiana 2
- Missouri 2
- New York 2
- Oregon 2
- Pennsylvania 2
- Texas 2
- Virginia 2
- Alabama 1
- Colorado 1
- Illinois 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Michigan 1
- Minnesota 1
- New Jersey 1
- New Mexico 1
- North Dakota 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2407378 | 2407378 | 2022-04-14 | Crook | Oregon | 41013 | 6046 | 79 |
2404122 | 2404122 | 2022-04-13 | Crook | Oregon | 41013 | 6046 | 79 |
2358681 | 2358681 | 2022-03-30 | Corozal | Puerto Rico | 72047 | 6046 | |
2355033 | 2355033 | 2022-03-29 | Martin | North Carolina | 37117 | 6046 | 89 |
2351780 | 2351780 | 2022-03-28 | Martin | North Carolina | 37117 | 6046 | 89 |
2338769 | 2338769 | 2022-03-24 | Martin | North Carolina | 37117 | 6046 | 89 |
2329008 | 2329008 | 2022-03-21 | Martin | North Carolina | 37117 | 6046 | 89 |
2244092 | 2244092 | 2022-02-23 | Stoddard | Missouri | 29207 | 6046 | 116 |
2224853 | 2224853 | 2022-02-17 | Lewis | New York | 36049 | 6046 | 46 |
2174001 | 2174001 | 2022-02-01 | Winchester city | Virginia | 51840 | 6046 | 61 |
2166219 | 2166219 | 2022-01-30 | Coos | New Hampshire | 33007 | 6046 | 93 |
2162964 | 2162964 | 2022-01-29 | Coos | New Hampshire | 33007 | 6046 | 93 |
2159709 | 2159709 | 2022-01-28 | Coos | New Hampshire | 33007 | 6046 | 93 |
2132558 | 2132558 | 2022-01-20 | McDonough | Illinois | 17109 | 6046 | 88 |
2041361 | 2041361 | 2021-12-23 | Oconee | Georgia | 13219 | 6046 | 82 |
2033237 | 2033237 | 2021-12-20 | Ottawa | Ohio | 39123 | 6046 | 106 |
1980714 | 1980714 | 2021-12-04 | Webster | Missouri | 29225 | 6046 | 116 |
1968420 | 1968420 | 2021-11-30 | Pike | Pennsylvania | 42103 | 6046 | 70 |
1857696 | 1857696 | 2021-10-27 | Guernsey | Ohio | 39059 | 6046 | 72 |
1845389 | 1845389 | 2021-10-23 | Matagorda | Texas | 48321 | 6046 | 156 |
1782810 | 1782810 | 2021-10-04 | Davie | North Carolina | 37059 | 6046 | 65 |
1763437 | 1763437 | 2021-09-28 | Williams | North Dakota | 38105 | 6046 | 43 |
1757176 | 1757176 | 2021-09-26 | Huntingdon | Pennsylvania | 42061 | 6046 | 144 |
1742138 | 1742138 | 2021-09-22 | Broomfield | Colorado | 8014 | 6046 | 78 |
1706163 | 1706163 | 2021-09-11 | Chilton | Alabama | 1021 | 6046 | 127 |
1678028 | 1678028 | 2021-09-02 | Whitley | Kentucky | 21235 | 6046 | 65 |
1651354 | 1651354 | 2021-08-25 | Colquitt | Georgia | 13071 | 6046 | 135 |
1455554 | 1455554 | 2021-06-25 | Hardin | Texas | 48199 | 6046 | 114 |
1347681 | 1347681 | 2021-05-23 | Lee | North Carolina | 37105 | 6046 | 79 |
1344433 | 1344433 | 2021-05-22 | Lee | North Carolina | 37105 | 6046 | 79 |
1341185 | 1341185 | 2021-05-21 | Lee | North Carolina | 37105 | 6046 | 79 |
1331294 | 1331294 | 2021-05-18 | Salem | New Jersey | 34033 | 6046 | 185 |
1290750 | 1290750 | 2021-05-06 | San Benito | California | 6069 | 6046 | 63 |
1197078 | 1197078 | 2021-04-07 | Dubois | Indiana | 18037 | 6046 | 117 |
1193352 | 1193352 | 2021-04-06 | Yuba | California | 6115 | 6046 | 43 |
1171678 | 1171678 | 2021-03-30 | Montcalm | Michigan | 26117 | 6046 | 96 |
1157737 | 1157737 | 2021-03-26 | Jackson | Florida | 12063 | 6046 | 154 |
1154490 | 1154490 | 2021-03-25 | Jackson | Florida | 12063 | 6046 | 154 |
1110816 | 1110816 | 2021-03-11 | Scioto | Ohio | 39145 | 6046 | 90 |
1076012 | 1076012 | 2021-02-28 | Rockingham | Virginia | 51165 | 6046 | 92 |
1054263 | 1054263 | 2021-02-22 | Morgan | Indiana | 18109 | 6046 | 129 |
749845 | 749845 | 2020-11-20 | Wright | Minnesota | 27171 | 6046 | 34 |
710049 | 710049 | 2020-11-08 | Unknown | Guam | 6046 | 89 | |
706805 | 706805 | 2020-11-07 | Unknown | Guam | 6046 | 89 | |
703562 | 703562 | 2020-11-06 | Unknown | Guam | 6046 | 89 | |
672397 | 672397 | 2020-10-27 | Doña Ana | New Mexico | 35013 | 6046 | 70 |
578394 | 578394 | 2020-09-28 | Monroe | New York | 36055 | 6046 | 260 |
460408 | 460408 | 2020-08-23 | Lake | Florida | 12069 | 6046 | 93 |
287937 | 287937 | 2020-06-30 | Polk | Iowa | 19153 | 6046 | 177 |
210323 | 210323 | 2020-06-05 | Baltimore city | Maryland | 24510 | 6046 | 272 |
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);