ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,056 rows where cases = 204 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 146
- Texas 94
- Puerto Rico 69
- Virginia 60
- Georgia 53
- Colorado 38
- Kansas 36
- Minnesota 30
- Missouri 28
- Illinois 27
- Kentucky 27
- Mississippi 27
- Nebraska 26
- Ohio 23
- Indiana 21
- North Dakota 20
- West Virginia 20
- Alaska 19
- Michigan 19
- Washington 17
- Iowa 16
- Louisiana 16
- Wisconsin 16
- South Dakota 15
- Nevada 14
- North Carolina 14
- Pennsylvania 14
- Tennessee 14
- Alabama 13
- Arkansas 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501247 | 2501247 | 2022-05-13 | Wibaux | Montana | 30109 | 204 | 8 |
2497989 | 2497989 | 2022-05-12 | Wibaux | Montana | 30109 | 204 | 8 |
2494731 | 2494731 | 2022-05-11 | Wibaux | Montana | 30109 | 204 | 8 |
2491473 | 2491473 | 2022-05-10 | Wibaux | Montana | 30109 | 204 | 8 |
2488215 | 2488215 | 2022-05-09 | Wibaux | Montana | 30109 | 204 | 8 |
2484958 | 2484958 | 2022-05-08 | Wibaux | Montana | 30109 | 204 | 8 |
2481700 | 2481700 | 2022-05-07 | Wibaux | Montana | 30109 | 204 | 8 |
2478442 | 2478442 | 2022-05-06 | Wibaux | Montana | 30109 | 204 | 8 |
2475184 | 2475184 | 2022-05-05 | Wibaux | Montana | 30109 | 204 | 8 |
2471927 | 2471927 | 2022-05-04 | Wibaux | Montana | 30109 | 204 | 8 |
2468671 | 2468671 | 2022-05-03 | Wibaux | Montana | 30109 | 204 | 8 |
2465415 | 2465415 | 2022-05-02 | Wibaux | Montana | 30109 | 204 | 8 |
2462160 | 2462160 | 2022-05-01 | Wibaux | Montana | 30109 | 204 | 8 |
2458904 | 2458904 | 2022-04-30 | Wibaux | Montana | 30109 | 204 | 8 |
2455648 | 2455648 | 2022-04-29 | Wibaux | Montana | 30109 | 204 | 8 |
2452392 | 2452392 | 2022-04-28 | Wibaux | Montana | 30109 | 204 | 8 |
2449136 | 2449136 | 2022-04-27 | Wibaux | Montana | 30109 | 204 | 8 |
2445879 | 2445879 | 2022-04-26 | Wibaux | Montana | 30109 | 204 | 8 |
2442624 | 2442624 | 2022-04-25 | Wibaux | Montana | 30109 | 204 | 8 |
2443661 | 2443661 | 2022-04-25 | Foard | Texas | 48155 | 204 | 11 |
2439368 | 2439368 | 2022-04-24 | Wibaux | Montana | 30109 | 204 | 8 |
2440405 | 2440405 | 2022-04-24 | Foard | Texas | 48155 | 204 | 11 |
2436112 | 2436112 | 2022-04-23 | Wibaux | Montana | 30109 | 204 | 8 |
2437149 | 2437149 | 2022-04-23 | Foard | Texas | 48155 | 204 | 11 |
2432856 | 2432856 | 2022-04-22 | Wibaux | Montana | 30109 | 204 | 8 |
2433893 | 2433893 | 2022-04-22 | Foard | Texas | 48155 | 204 | 11 |
2429600 | 2429600 | 2022-04-21 | Wibaux | Montana | 30109 | 204 | 8 |
2430637 | 2430637 | 2022-04-21 | Foard | Texas | 48155 | 204 | 11 |
2426344 | 2426344 | 2022-04-20 | Wibaux | Montana | 30109 | 204 | 8 |
2427381 | 2427381 | 2022-04-20 | Foard | Texas | 48155 | 204 | 11 |
2423088 | 2423088 | 2022-04-19 | Wibaux | Montana | 30109 | 204 | 8 |
2419831 | 2419831 | 2022-04-18 | Wibaux | Montana | 30109 | 204 | 8 |
2416576 | 2416576 | 2022-04-17 | Wibaux | Montana | 30109 | 204 | 8 |
2413320 | 2413320 | 2022-04-16 | Wibaux | Montana | 30109 | 204 | 8 |
2410064 | 2410064 | 2022-04-15 | Wibaux | Montana | 30109 | 204 | 8 |
2406808 | 2406808 | 2022-04-14 | Wibaux | Montana | 30109 | 204 | 8 |
2403552 | 2403552 | 2022-04-13 | Wibaux | Montana | 30109 | 204 | 8 |
2400297 | 2400297 | 2022-04-12 | Wibaux | Montana | 30109 | 204 | 8 |
2397042 | 2397042 | 2022-04-11 | Wibaux | Montana | 30109 | 204 | 8 |
2393787 | 2393787 | 2022-04-10 | Wibaux | Montana | 30109 | 204 | 8 |
2390531 | 2390531 | 2022-04-09 | Wibaux | Montana | 30109 | 204 | 8 |
2387275 | 2387275 | 2022-04-08 | Wibaux | Montana | 30109 | 204 | 8 |
2384020 | 2384020 | 2022-04-07 | Wibaux | Montana | 30109 | 204 | 8 |
2380765 | 2380765 | 2022-04-06 | Wibaux | Montana | 30109 | 204 | 8 |
2377510 | 2377510 | 2022-04-05 | Wibaux | Montana | 30109 | 204 | 8 |
2374257 | 2374257 | 2022-04-04 | Wibaux | Montana | 30109 | 204 | 8 |
2371005 | 2371005 | 2022-04-03 | Wibaux | Montana | 30109 | 204 | 8 |
2367752 | 2367752 | 2022-04-02 | Wibaux | Montana | 30109 | 204 | 8 |
2364499 | 2364499 | 2022-04-01 | Wibaux | Montana | 30109 | 204 | 8 |
2361245 | 2361245 | 2022-03-31 | Wibaux | Montana | 30109 | 204 | 8 |
2357991 | 2357991 | 2022-03-30 | Wibaux | Montana | 30109 | 204 | 8 |
2354738 | 2354738 | 2022-03-29 | Wibaux | Montana | 30109 | 204 | 8 |
2351485 | 2351485 | 2022-03-28 | Wibaux | Montana | 30109 | 204 | 8 |
2348233 | 2348233 | 2022-03-27 | Wibaux | Montana | 30109 | 204 | 8 |
2344980 | 2344980 | 2022-03-26 | Wibaux | Montana | 30109 | 204 | 8 |
2341727 | 2341727 | 2022-03-25 | Wibaux | Montana | 30109 | 204 | 8 |
2338474 | 2338474 | 2022-03-24 | Wibaux | Montana | 30109 | 204 | 8 |
2335220 | 2335220 | 2022-03-23 | Wibaux | Montana | 30109 | 204 | 8 |
2331966 | 2331966 | 2022-03-22 | Wibaux | Montana | 30109 | 204 | 8 |
2328713 | 2328713 | 2022-03-21 | Wibaux | Montana | 30109 | 204 | 8 |
2325461 | 2325461 | 2022-03-20 | Wibaux | Montana | 30109 | 204 | 8 |
2322207 | 2322207 | 2022-03-19 | Wibaux | Montana | 30109 | 204 | 8 |
2318953 | 2318953 | 2022-03-18 | Wibaux | Montana | 30109 | 204 | 8 |
2315700 | 2315700 | 2022-03-17 | Wibaux | Montana | 30109 | 204 | 8 |
2312447 | 2312447 | 2022-03-16 | Wibaux | Montana | 30109 | 204 | 8 |
2309194 | 2309194 | 2022-03-15 | Wibaux | Montana | 30109 | 204 | 8 |
2305942 | 2305942 | 2022-03-14 | Wibaux | Montana | 30109 | 204 | 8 |
2302691 | 2302691 | 2022-03-13 | Wibaux | Montana | 30109 | 204 | 8 |
2299439 | 2299439 | 2022-03-12 | Wibaux | Montana | 30109 | 204 | 8 |
2296187 | 2296187 | 2022-03-11 | Wibaux | Montana | 30109 | 204 | 8 |
2292935 | 2292935 | 2022-03-10 | Wibaux | Montana | 30109 | 204 | 8 |
2289683 | 2289683 | 2022-03-09 | Wibaux | Montana | 30109 | 204 | 8 |
2286431 | 2286431 | 2022-03-08 | Wibaux | Montana | 30109 | 204 | 8 |
2283179 | 2283179 | 2022-03-07 | Wibaux | Montana | 30109 | 204 | 8 |
2279926 | 2279926 | 2022-03-06 | Wibaux | Montana | 30109 | 204 | 8 |
2276673 | 2276673 | 2022-03-05 | Wibaux | Montana | 30109 | 204 | 8 |
2273420 | 2273420 | 2022-03-04 | Wibaux | Montana | 30109 | 204 | 8 |
2270168 | 2270168 | 2022-03-03 | Wibaux | Montana | 30109 | 204 | 8 |
2266915 | 2266915 | 2022-03-02 | Wibaux | Montana | 30109 | 204 | 8 |
2263664 | 2263664 | 2022-03-01 | Wibaux | Montana | 30109 | 204 | 8 |
2260413 | 2260413 | 2022-02-28 | Wibaux | Montana | 30109 | 204 | 8 |
2257162 | 2257162 | 2022-02-27 | Wibaux | Montana | 30109 | 204 | 8 |
2253911 | 2253911 | 2022-02-26 | Wibaux | Montana | 30109 | 204 | 8 |
2250660 | 2250660 | 2022-02-25 | Wibaux | Montana | 30109 | 204 | 8 |
2247409 | 2247409 | 2022-02-24 | Wibaux | Montana | 30109 | 204 | 8 |
2166071 | 2166071 | 2022-01-30 | Judith Basin | Montana | 30045 | 204 | 1 |
2162816 | 2162816 | 2022-01-29 | Judith Basin | Montana | 30045 | 204 | 1 |
2159561 | 2159561 | 2022-01-28 | Judith Basin | Montana | 30045 | 204 | 1 |
2056604 | 2056604 | 2021-12-27 | Irion | Texas | 48235 | 204 | 2 |
2007580 | 2007580 | 2021-12-12 | Campbell | South Dakota | 46021 | 204 | 5 |
2008095 | 2008095 | 2021-12-12 | Highland | Virginia | 51091 | 204 | 4 |
2004329 | 2004329 | 2021-12-11 | Campbell | South Dakota | 46021 | 204 | 5 |
2004844 | 2004844 | 2021-12-11 | Highland | Virginia | 51091 | 204 | 4 |
2001078 | 2001078 | 2021-12-10 | Campbell | South Dakota | 46021 | 204 | 5 |
2001593 | 2001593 | 2021-12-10 | Highland | Virginia | 51091 | 204 | 4 |
1997828 | 1997828 | 2021-12-09 | Campbell | South Dakota | 46021 | 204 | 5 |
1925890 | 1925890 | 2021-11-17 | Sheridan | North Dakota | 38083 | 204 | 4 |
1922641 | 1922641 | 2021-11-16 | Sheridan | North Dakota | 38083 | 204 | 4 |
1850886 | 1850886 | 2021-10-25 | Storey | Nevada | 32029 | 204 | 4 |
1847636 | 1847636 | 2021-10-24 | Storey | Nevada | 32029 | 204 | 4 |
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);