ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
541 rows where cases = 704 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 54
- Texas 52
- Missouri 41
- Georgia 27
- Oklahoma 27
- Kansas 25
- Nebraska 24
- Puerto Rico 23
- Kentucky 22
- Michigan 17
- Alaska 14
- Virginia 14
- Illinois 13
- Mississippi 12
- New Mexico 12
- California 11
- Ohio 11
- West Virginia 11
- Idaho 10
- Minnesota 10
- North Dakota 10
- Tennessee 10
- Indiana 9
- North Carolina 9
- Wisconsin 8
- Arkansas 7
- Colorado 7
- Washington 6
- Louisiana 5
- Iowa 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500134 | 2500134 | 2022-05-13 | Adams | Idaho | 16003 | 704 | 15 |
2501142 | 2501142 | 2022-05-13 | Mercer | Missouri | 29129 | 704 | 14 |
2497884 | 2497884 | 2022-05-12 | Mercer | Missouri | 29129 | 704 | 14 |
2498703 | 2498703 | 2022-05-12 | Maricao | Puerto Rico | 72093 | 704 | |
2494626 | 2494626 | 2022-05-11 | Mercer | Missouri | 29129 | 704 | 14 |
2491368 | 2491368 | 2022-05-10 | Mercer | Missouri | 29129 | 704 | 14 |
2492324 | 2492324 | 2022-05-10 | Potter | South Dakota | 46107 | 704 | 7 |
2488110 | 2488110 | 2022-05-09 | Mercer | Missouri | 29129 | 704 | 14 |
2489066 | 2489066 | 2022-05-09 | Potter | South Dakota | 46107 | 704 | 7 |
2484853 | 2484853 | 2022-05-08 | Mercer | Missouri | 29129 | 704 | 14 |
2485809 | 2485809 | 2022-05-08 | Potter | South Dakota | 46107 | 704 | 7 |
2481595 | 2481595 | 2022-05-07 | Mercer | Missouri | 29129 | 704 | 14 |
2482551 | 2482551 | 2022-05-07 | Potter | South Dakota | 46107 | 704 | 7 |
2478337 | 2478337 | 2022-05-06 | Mercer | Missouri | 29129 | 704 | 14 |
2479293 | 2479293 | 2022-05-06 | Potter | South Dakota | 46107 | 704 | 7 |
2475079 | 2475079 | 2022-05-05 | Mercer | Missouri | 29129 | 704 | 14 |
2476035 | 2476035 | 2022-05-05 | Potter | South Dakota | 46107 | 704 | 7 |
2472778 | 2472778 | 2022-05-04 | Potter | South Dakota | 46107 | 704 | 7 |
2423939 | 2423939 | 2022-04-19 | Potter | South Dakota | 46107 | 704 | 7 |
2420683 | 2420683 | 2022-04-18 | Potter | South Dakota | 46107 | 704 | 7 |
2417427 | 2417427 | 2022-04-17 | Potter | South Dakota | 46107 | 704 | 7 |
2414171 | 2414171 | 2022-04-16 | Potter | South Dakota | 46107 | 704 | 7 |
2410915 | 2410915 | 2022-04-15 | Potter | South Dakota | 46107 | 704 | 7 |
2407659 | 2407659 | 2022-04-14 | Potter | South Dakota | 46107 | 704 | 7 |
2404403 | 2404403 | 2022-04-13 | Potter | South Dakota | 46107 | 704 | 7 |
2401148 | 2401148 | 2022-04-12 | Potter | South Dakota | 46107 | 704 | 7 |
2397893 | 2397893 | 2022-04-11 | Potter | South Dakota | 46107 | 704 | 7 |
2394638 | 2394638 | 2022-04-10 | Potter | South Dakota | 46107 | 704 | 7 |
2391382 | 2391382 | 2022-04-09 | Potter | South Dakota | 46107 | 704 | 7 |
2388126 | 2388126 | 2022-04-08 | Potter | South Dakota | 46107 | 704 | 7 |
2384871 | 2384871 | 2022-04-07 | Potter | South Dakota | 46107 | 704 | 7 |
2381616 | 2381616 | 2022-04-06 | Potter | South Dakota | 46107 | 704 | 7 |
2378361 | 2378361 | 2022-04-05 | Potter | South Dakota | 46107 | 704 | 7 |
2375107 | 2375107 | 2022-04-04 | Potter | South Dakota | 46107 | 704 | 7 |
2371855 | 2371855 | 2022-04-03 | Potter | South Dakota | 46107 | 704 | 7 |
2368602 | 2368602 | 2022-04-02 | Potter | South Dakota | 46107 | 704 | 7 |
2365349 | 2365349 | 2022-04-01 | Potter | South Dakota | 46107 | 704 | 7 |
2362096 | 2362096 | 2022-03-31 | Potter | South Dakota | 46107 | 704 | 7 |
2358842 | 2358842 | 2022-03-30 | Potter | South Dakota | 46107 | 704 | 7 |
2355588 | 2355588 | 2022-03-29 | Potter | South Dakota | 46107 | 704 | 7 |
2352335 | 2352335 | 2022-03-28 | Potter | South Dakota | 46107 | 704 | 7 |
2349083 | 2349083 | 2022-03-27 | Potter | South Dakota | 46107 | 704 | 7 |
2345830 | 2345830 | 2022-03-26 | Potter | South Dakota | 46107 | 704 | 7 |
2342577 | 2342577 | 2022-03-25 | Potter | South Dakota | 46107 | 704 | 7 |
2339324 | 2339324 | 2022-03-24 | Potter | South Dakota | 46107 | 704 | 7 |
2336070 | 2336070 | 2022-03-23 | Potter | South Dakota | 46107 | 704 | 7 |
2332816 | 2332816 | 2022-03-22 | Potter | South Dakota | 46107 | 704 | 7 |
2329563 | 2329563 | 2022-03-21 | Potter | South Dakota | 46107 | 704 | 7 |
2326311 | 2326311 | 2022-03-20 | Potter | South Dakota | 46107 | 704 | 7 |
2323058 | 2323058 | 2022-03-19 | Potter | South Dakota | 46107 | 704 | 7 |
2319804 | 2319804 | 2022-03-18 | Potter | South Dakota | 46107 | 704 | 7 |
2316550 | 2316550 | 2022-03-17 | Potter | South Dakota | 46107 | 704 | 7 |
2313297 | 2313297 | 2022-03-16 | Potter | South Dakota | 46107 | 704 | 7 |
2310044 | 2310044 | 2022-03-15 | Potter | South Dakota | 46107 | 704 | 7 |
2244898 | 2244898 | 2022-02-23 | Vieques | Puerto Rico | 72147 | 704 | |
2241647 | 2241647 | 2022-02-22 | Vieques | Puerto Rico | 72147 | 704 | |
2238396 | 2238396 | 2022-02-21 | Vieques | Puerto Rico | 72147 | 704 | |
2235145 | 2235145 | 2022-02-20 | Vieques | Puerto Rico | 72147 | 704 | |
2201978 | 2201978 | 2022-02-10 | Valley | Nebraska | 31175 | 704 | 6 |
2189037 | 2189037 | 2022-02-06 | Mora | New Mexico | 35033 | 704 | 16 |
2185784 | 2185784 | 2022-02-05 | Mora | New Mexico | 35033 | 704 | 16 |
2182532 | 2182532 | 2022-02-04 | Mora | New Mexico | 35033 | 704 | 16 |
2173704 | 2173704 | 2022-02-01 | Kinney | Texas | 48271 | 704 | 10 |
2170452 | 2170452 | 2022-01-31 | Kinney | Texas | 48271 | 704 | 10 |
2167198 | 2167198 | 2022-01-30 | Kinney | Texas | 48271 | 704 | 10 |
2147696 | 2147696 | 2022-01-24 | Mason | Texas | 48319 | 704 | 9 |
2128026 | 2128026 | 2022-01-18 | Baylor | Texas | 48023 | 704 | 26 |
2102918 | 2102918 | 2022-01-11 | Ouray | Colorado | 8091 | 704 | 6 |
2104843 | 2104843 | 2022-01-11 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2101592 | 2101592 | 2022-01-10 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2098341 | 2098341 | 2022-01-09 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2094740 | 2094740 | 2022-01-08 | Hamilton | New York | 36041 | 704 | 4 |
2095089 | 2095089 | 2022-01-08 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2091837 | 2091837 | 2022-01-07 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2088585 | 2088585 | 2022-01-06 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2085334 | 2085334 | 2022-01-05 | Roger Mills | Oklahoma | 40129 | 704 | 13 |
2080766 | 2080766 | 2022-01-04 | Barber | Kansas | 20007 | 704 | 7 |
2077514 | 2077514 | 2022-01-03 | Barber | Kansas | 20007 | 704 | 7 |
2046482 | 2046482 | 2021-12-24 | Jayuya | Puerto Rico | 72073 | 704 | |
2043232 | 2043232 | 2021-12-23 | Jayuya | Puerto Rico | 72073 | 704 | |
2037029 | 2037029 | 2021-12-21 | Coke | Texas | 48081 | 704 | 18 |
1967644 | 1967644 | 2021-11-30 | Holt | Missouri | 29087 | 704 | 23 |
1968161 | 1968161 | 2021-11-30 | Wells | North Dakota | 38103 | 704 | 10 |
1951237 | 1951237 | 2021-11-25 | Red Lake | Minnesota | 27125 | 704 | 10 |
1947986 | 1947986 | 2021-11-24 | Red Lake | Minnesota | 27125 | 704 | 10 |
1945823 | 1945823 | 2021-11-23 | Corson | South Dakota | 46031 | 704 | 13 |
1941741 | 1941741 | 2021-11-22 | Musselshell | Montana | 30065 | 704 | 19 |
1921183 | 1921183 | 2021-11-16 | Lincoln | Idaho | 16063 | 704 | 12 |
1919826 | 1919826 | 2021-11-15 | Deuel | South Dakota | 46039 | 704 | 11 |
1881870 | 1881870 | 2021-11-04 | Huerfano | Colorado | 8055 | 704 | 19 |
1882602 | 1882602 | 2021-11-04 | Ballard | Kentucky | 21007 | 704 | 20 |
1881020 | 1881020 | 2021-11-03 | Concho | Texas | 48095 | 704 | 10 |
1877771 | 1877771 | 2021-11-02 | Concho | Texas | 48095 | 704 | 10 |
1874522 | 1874522 | 2021-11-01 | Concho | Texas | 48095 | 704 | 10 |
1870320 | 1870320 | 2021-10-31 | Johnson | Nebraska | 31097 | 704 | 10 |
1871273 | 1871273 | 2021-10-31 | Concho | Texas | 48095 | 704 | 10 |
1860554 | 1860554 | 2021-10-28 | Fillmore | Nebraska | 31059 | 704 | 13 |
1857305 | 1857305 | 2021-10-27 | Fillmore | Nebraska | 31059 | 704 | 13 |
1854073 | 1854073 | 2021-10-26 | Howard | Nebraska | 31093 | 704 | 13 |
1850824 | 1850824 | 2021-10-25 | Howard | Nebraska | 31093 | 704 | 13 |
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);