ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 9248 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Missouri 8
- Iowa 7
- North Carolina 5
- Indiana 4
- Louisiana 4
- Tennessee 3
- Arkansas 2
- Georgia 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- California 1
- Colorado 1
- Illinois 1
- Maine 1
- Massachusetts 1
- Minnesota 1
- New York 1
- Puerto Rico 1
- South Carolina 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492812 | 2492812 | 2022-05-10 | Manassas city | Virginia | 51683 | 9248 | 71 |
2447644 | 2447644 | 2022-04-27 | Union | Arkansas | 5139 | 9248 | 176 |
2393244 | 2393244 | 2022-04-10 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2389988 | 2389988 | 2022-04-09 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2386732 | 2386732 | 2022-04-08 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2383477 | 2383477 | 2022-04-07 | Beauregard | Louisiana | 22011 | 9248 | 142 |
2379382 | 2379382 | 2022-04-06 | Montrose | Colorado | 8085 | 9248 | 158 |
2360331 | 2360331 | 2022-03-31 | Miami | Indiana | 18103 | 9248 | 159 |
2357077 | 2357077 | 2022-03-30 | Miami | Indiana | 18103 | 9248 | 159 |
2348543 | 2348543 | 2022-03-27 | Person | North Carolina | 37145 | 9248 | 104 |
2345290 | 2345290 | 2022-03-26 | Person | North Carolina | 37145 | 9248 | 104 |
2342037 | 2342037 | 2022-03-25 | Person | North Carolina | 37145 | 9248 | 104 |
2314786 | 2314786 | 2022-03-17 | Miami | Indiana | 18103 | 9248 | 158 |
2309037 | 2309037 | 2022-03-15 | Camden | Missouri | 29029 | 9248 | 176 |
2306136 | 2306136 | 2022-03-14 | Franklin | New York | 36033 | 9248 | 44 |
2260658 | 2260658 | 2022-02-28 | Bladen | North Carolina | 37017 | 9248 | 118 |
2240098 | 2240098 | 2022-02-22 | Marshall | Iowa | 19127 | 9248 | 102 |
2236847 | 2236847 | 2022-02-21 | Marshall | Iowa | 19127 | 9248 | 102 |
2233596 | 2233596 | 2022-02-20 | Marshall | Iowa | 19127 | 9248 | 102 |
2230345 | 2230345 | 2022-02-19 | Marshall | Iowa | 19127 | 9248 | 102 |
2227094 | 2227094 | 2022-02-18 | Marshall | Iowa | 19127 | 9248 | 102 |
2223843 | 2223843 | 2022-02-17 | Marshall | Iowa | 19127 | 9248 | 102 |
2220592 | 2220592 | 2022-02-16 | Marshall | Iowa | 19127 | 9248 | 102 |
2143989 | 2143989 | 2022-01-23 | Wayne | Pennsylvania | 42127 | 9248 | 148 |
2122276 | 2122276 | 2022-01-17 | Hot Spring | Arkansas | 5059 | 9248 | 113 |
2100035 | 2100035 | 2022-01-10 | Marion | Illinois | 17121 | 9248 | 175 |
1968830 | 1968830 | 2021-11-30 | Harrison | Texas | 48203 | 9248 | 186 |
1730084 | 1730084 | 2021-09-18 | Penobscot | Maine | 23019 | 9248 | 127 |
1649792 | 1649792 | 2021-08-24 | Marion | Ohio | 39101 | 9248 | 140 |
1564452 | 1564452 | 2021-07-29 | Hampshire | Massachusetts | 25015 | 9248 | 300 |
1428384 | 1428384 | 2021-06-17 | Christian | Missouri | 29043 | 9248 | 93 |
1425139 | 1425139 | 2021-06-16 | Christian | Missouri | 29043 | 9248 | 93 |
1421891 | 1421891 | 2021-06-15 | Christian | Missouri | 29043 | 9248 | 93 |
1418646 | 1418646 | 2021-06-14 | Christian | Missouri | 29043 | 9248 | 93 |
1415401 | 1415401 | 2021-06-13 | Christian | Missouri | 29043 | 9248 | 93 |
1412155 | 1412155 | 2021-06-12 | Christian | Missouri | 29043 | 9248 | 93 |
1408910 | 1408910 | 2021-06-11 | Christian | Missouri | 29043 | 9248 | 93 |
1360622 | 1360622 | 2021-05-27 | Brunswick | North Carolina | 37019 | 9248 | 153 |
1159837 | 1159837 | 2021-03-26 | Orangeburg | South Carolina | 45075 | 9248 | 233 |
1149040 | 1149040 | 2021-03-23 | Sherburne | Minnesota | 27141 | 9248 | 77 |
1134871 | 1134871 | 2021-03-19 | Napa | California | 6055 | 9248 | 77 |
1096166 | 1096166 | 2021-03-07 | Jackson | Georgia | 13157 | 9248 | 135 |
1091874 | 1091874 | 2021-03-05 | Comal | Texas | 48091 | 9248 | 294 |
887320 | 887320 | 2021-01-01 | Maury | Tennessee | 47119 | 9248 | 104 |
884075 | 884075 | 2020-12-31 | Maury | Tennessee | 47119 | 9248 | 104 |
767269 | 767269 | 2020-11-25 | Sumner | Tennessee | 47165 | 9248 | 135 |
664814 | 664814 | 2020-10-25 | Elkhart | Indiana | 18039 | 9248 | 141 |
643771 | 643771 | 2020-10-18 | San Juan | Puerto Rico | 72127 | 9248 | |
614449 | 614449 | 2020-10-09 | Bucks | Pennsylvania | 42017 | 9248 | 621 |
602292 | 602292 | 2020-10-05 | Pierce | Washington | 53053 | 9248 | 229 |
576985 | 576985 | 2020-09-28 | Hall | Georgia | 13139 | 9248 | 152 |
400872 | 400872 | 2020-08-04 | Hamilton | Ohio | 39061 | 9248 | 248 |
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);