ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 3363 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 18
- Georgia 10
- Virginia 10
- Texas 9
- Arkansas 8
- Tennessee 8
- Iowa 7
- Florida 6
- Indiana 6
- Kentucky 6
- Mississippi 6
- Oregon 6
- Idaho 5
- South Carolina 5
- Washington 5
- Alabama 4
- Missouri 4
- New Mexico 4
- California 3
- Colorado 3
- Montana 3
- New York 3
- North Carolina 3
- Puerto Rico 3
- Illinois 2
- Maryland 2
- Minnesota 2
- Ohio 2
- Massachusetts 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490663 | 2490663 | 2022-05-10 | Mills | Iowa | 19129 | 3363 | 41 |
2487406 | 2487406 | 2022-05-09 | Mills | Iowa | 19129 | 3363 | 41 |
2489481 | 2489481 | 2022-05-09 | Alleghany | Virginia | 51005 | 3363 | 98 |
2484148 | 2484148 | 2022-05-08 | Mills | Iowa | 19129 | 3363 | 41 |
2486224 | 2486224 | 2022-05-08 | Alleghany | Virginia | 51005 | 3363 | 98 |
2480890 | 2480890 | 2022-05-07 | Mills | Iowa | 19129 | 3363 | 41 |
2482966 | 2482966 | 2022-05-07 | Alleghany | Virginia | 51005 | 3363 | 98 |
2477632 | 2477632 | 2022-05-06 | Mills | Iowa | 19129 | 3363 | 41 |
2479708 | 2479708 | 2022-05-06 | Alleghany | Virginia | 51005 | 3363 | 98 |
2474374 | 2474374 | 2022-05-05 | Mills | Iowa | 19129 | 3363 | 41 |
2471117 | 2471117 | 2022-05-04 | Mills | Iowa | 19129 | 3363 | 41 |
2452963 | 2452963 | 2022-04-28 | Curry | Oregon | 41015 | 3363 | 54 |
2426433 | 2426433 | 2022-04-20 | Unknown | Nebraska | 3363 | 459 | |
2427683 | 2427683 | 2022-04-20 | Martinsville city | Virginia | 51690 | 3363 | 119 |
2348314 | 2348314 | 2022-03-27 | Seward | Nebraska | 31159 | 3363 | 41 |
2345061 | 2345061 | 2022-03-26 | Seward | Nebraska | 31159 | 3363 | 41 |
2341808 | 2341808 | 2022-03-25 | Seward | Nebraska | 31159 | 3363 | 41 |
2335301 | 2335301 | 2022-03-23 | Seward | Nebraska | 31159 | 3363 | 41 |
2332047 | 2332047 | 2022-03-22 | Seward | Nebraska | 31159 | 3363 | 41 |
2328794 | 2328794 | 2022-03-21 | Seward | Nebraska | 31159 | 3363 | 41 |
2325542 | 2325542 | 2022-03-20 | Seward | Nebraska | 31159 | 3363 | 41 |
2322288 | 2322288 | 2022-03-19 | Seward | Nebraska | 31159 | 3363 | 41 |
2315597 | 2315597 | 2022-03-17 | Mississippi | Missouri | 29133 | 3363 | 56 |
2317118 | 2317118 | 2022-03-17 | Pacific | Washington | 53049 | 3363 | 55 |
2312344 | 2312344 | 2022-03-16 | Mississippi | Missouri | 29133 | 3363 | 56 |
2312528 | 2312528 | 2022-03-16 | Seward | Nebraska | 31159 | 3363 | 41 |
2313865 | 2313865 | 2022-03-16 | Pacific | Washington | 53049 | 3363 | 55 |
2286512 | 2286512 | 2022-03-08 | Seward | Nebraska | 31159 | 3363 | 41 |
2280007 | 2280007 | 2022-03-06 | Seward | Nebraska | 31159 | 3363 | 41 |
2276754 | 2276754 | 2022-03-05 | Seward | Nebraska | 31159 | 3363 | 41 |
2273501 | 2273501 | 2022-03-04 | Seward | Nebraska | 31159 | 3363 | 41 |
2217713 | 2217713 | 2022-02-15 | Dukes | Massachusetts | 25007 | 3363 | 0 |
2213500 | 2213500 | 2022-02-14 | Grand | Colorado | 8049 | 3363 | 23 |
2188836 | 2188836 | 2022-02-06 | Glacier | Montana | 30035 | 3363 | 65 |
2185583 | 2185583 | 2022-02-05 | Glacier | Montana | 30035 | 3363 | 65 |
2182331 | 2182331 | 2022-02-04 | Glacier | Montana | 30035 | 3363 | 65 |
2172646 | 2172646 | 2022-02-01 | Gage | Nebraska | 31067 | 3363 | 37 |
2169393 | 2169393 | 2022-01-31 | Gage | Nebraska | 31067 | 3363 | 37 |
2144034 | 2144034 | 2022-01-23 | Lares | Puerto Rico | 72081 | 3363 | |
2110194 | 2110194 | 2022-01-13 | Lawrence | Kentucky | 21127 | 3363 | 50 |
2108993 | 2108993 | 2022-01-12 | Hardy | West Virginia | 54031 | 3363 | 41 |
2099967 | 2099967 | 2022-01-10 | Minidoka | Idaho | 16067 | 3363 | 54 |
2041370 | 2041370 | 2021-12-23 | Putnam | Georgia | 13237 | 3363 | 88 |
2034391 | 2034391 | 2021-12-21 | Fayette | Alabama | 1057 | 3363 | 86 |
2031141 | 2031141 | 2021-12-20 | Fayette | Alabama | 1057 | 3363 | 86 |
2027890 | 2027890 | 2021-12-19 | Fayette | Alabama | 1057 | 3363 | 86 |
2023754 | 2023754 | 2021-12-17 | Rio Grande | Puerto Rico | 72119 | 3363 | |
2018403 | 2018403 | 2021-12-16 | Pitkin | Colorado | 8097 | 3363 | 6 |
2015633 | 2015633 | 2021-12-15 | Rush | Indiana | 18139 | 3363 | 34 |
1984924 | 1984924 | 2021-12-05 | Humphreys | Tennessee | 47085 | 3363 | 50 |
1981674 | 1981674 | 2021-12-04 | Humphreys | Tennessee | 47085 | 3363 | 50 |
1978424 | 1978424 | 2021-12-03 | Humphreys | Tennessee | 47085 | 3363 | 50 |
1975663 | 1975663 | 2021-12-02 | Adams | Washington | 53001 | 3363 | 34 |
1971589 | 1971589 | 2021-12-01 | Crook | Oregon | 41013 | 3363 | 56 |
1945605 | 1945605 | 2021-11-23 | Union | Oregon | 41061 | 3363 | 54 |
1946564 | 1946564 | 2021-11-23 | Vilas | Wisconsin | 55125 | 3363 | 60 |
1939885 | 1939885 | 2021-11-21 | Scott | Virginia | 51169 | 3363 | 83 |
1936635 | 1936635 | 2021-11-20 | Scott | Virginia | 51169 | 3363 | 83 |
1933385 | 1933385 | 2021-11-19 | Scott | Virginia | 51169 | 3363 | 83 |
1918763 | 1918763 | 2021-11-15 | Attala | Mississippi | 28007 | 3363 | 90 |
1919092 | 1919092 | 2021-11-15 | Saunders | Nebraska | 31155 | 3363 | 21 |
1885017 | 1885017 | 2021-11-05 | Randolph | Arkansas | 5121 | 3363 | 60 |
1849759 | 1849759 | 2021-10-25 | Lawrence | Illinois | 17101 | 3363 | 42 |
1819298 | 1819298 | 2021-10-15 | Deaf Smith | Texas | 48117 | 3363 | 74 |
1787847 | 1787847 | 2021-10-06 | Jones | Georgia | 13169 | 3363 | 83 |
1784286 | 1784286 | 2021-10-05 | Ouachita | Arkansas | 5103 | 3363 | 76 |
1786481 | 1786481 | 2021-10-05 | Dorado | Puerto Rico | 72051 | 3363 | |
1770450 | 1770450 | 2021-09-30 | Johnson | Tennessee | 47091 | 3363 | 45 |
1748496 | 1748496 | 2021-09-24 | Arkansas | Arkansas | 5001 | 3363 | 56 |
1696249 | 1696249 | 2021-09-07 | Stevens | Washington | 53065 | 3363 | 42 |
1690315 | 1690315 | 2021-09-06 | Burke | Georgia | 13033 | 3363 | 68 |
1687065 | 1687065 | 2021-09-05 | Burke | Georgia | 13033 | 3363 | 68 |
1683815 | 1683815 | 2021-09-04 | Burke | Georgia | 13033 | 3363 | 68 |
1680564 | 1680564 | 2021-09-03 | Burke | Georgia | 13033 | 3363 | 68 |
1677085 | 1677085 | 2021-09-02 | Sevier | Arkansas | 5133 | 3363 | 31 |
1672857 | 1672857 | 2021-08-31 | Jasper | South Carolina | 45053 | 3363 | 57 |
1654896 | 1654896 | 2021-08-26 | Decatur | Indiana | 18031 | 3363 | 98 |
1631464 | 1631464 | 2021-08-19 | Geneva | Alabama | 1061 | 3363 | 88 |
1619030 | 1619030 | 2021-08-15 | Latah | Idaho | 16057 | 3363 | 13 |
1615782 | 1615782 | 2021-08-14 | Latah | Idaho | 16057 | 3363 | 13 |
1612533 | 1612533 | 2021-08-13 | Latah | Idaho | 16057 | 3363 | 13 |
1607227 | 1607227 | 2021-08-11 | Nye | Nevada | 32023 | 3363 | 112 |
1601942 | 1601942 | 2021-08-09 | Isle of Wight | Virginia | 51093 | 3363 | 70 |
1579607 | 1579607 | 2021-08-03 | Lincoln | Arkansas | 5079 | 3363 | 49 |
1566646 | 1566646 | 2021-07-30 | Unknown | Arkansas | 3363 | 0 | |
1554889 | 1554889 | 2021-07-26 | Adams | Mississippi | 28001 | 3363 | 87 |
1543355 | 1543355 | 2021-07-22 | Willacy | Texas | 48489 | 3363 | 92 |
1494075 | 1494075 | 2021-07-07 | Greene | Pennsylvania | 42059 | 3363 | 42 |
1494859 | 1494859 | 2021-07-07 | Kittitas | Washington | 53037 | 3363 | 36 |
1415712 | 1415712 | 2021-06-13 | Luna | New Mexico | 35029 | 3363 | 92 |
1412466 | 1412466 | 2021-06-12 | Luna | New Mexico | 35029 | 3363 | 92 |
1409221 | 1409221 | 2021-06-11 | Luna | New Mexico | 35029 | 3363 | 92 |
1402372 | 1402372 | 2021-06-09 | Pike | Mississippi | 28113 | 3363 | 108 |
1402866 | 1402866 | 2021-06-09 | Montgomery | North Carolina | 37123 | 3363 | 96 |
1385736 | 1385736 | 2021-06-04 | Knox | Kentucky | 21121 | 3363 | 44 |
1302151 | 1302151 | 2021-05-09 | Otsego | New York | 36077 | 3363 | 47 |
1266458 | 1266458 | 2021-04-28 | Wyoming | New York | 36121 | 3363 | 51 |
1245601 | 1245601 | 2021-04-22 | Toombs | Georgia | 13279 | 3363 | 112 |
1242214 | 1242214 | 2021-04-21 | Wakulla | Florida | 12129 | 3363 | 54 |
1233096 | 1233096 | 2021-04-18 | Boyle | Kentucky | 21021 | 3363 | 69 |
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);