ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
856 rows where cases = 386 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 124
- Texas 78
- Kansas 76
- Georgia 39
- Michigan 29
- Missouri 29
- South Dakota 28
- Nebraska 27
- Oklahoma 27
- Virginia 27
- Washington 24
- Kentucky 21
- Mississippi 21
- Indiana 20
- Minnesota 20
- North Dakota 20
- Idaho 19
- Illinois 19
- Puerto Rico 18
- Louisiana 15
- West Virginia 15
- Iowa 13
- Alabama 12
- Alaska 12
- New Mexico 11
- Pennsylvania 10
- Tennessee 10
- Wisconsin 9
- Wyoming 9
- Arkansas 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501202 | 2501202 | 2022-05-13 | Daniels | Montana | 30019 | 386 | 9 |
2501246 | 2501246 | 2022-05-13 | Wheatland | Montana | 30107 | 386 | 14 |
2497944 | 2497944 | 2022-05-12 | Daniels | Montana | 30019 | 386 | 9 |
2497988 | 2497988 | 2022-05-12 | Wheatland | Montana | 30107 | 386 | 14 |
2494686 | 2494686 | 2022-05-11 | Daniels | Montana | 30019 | 386 | 9 |
2494730 | 2494730 | 2022-05-11 | Wheatland | Montana | 30107 | 386 | 14 |
2491428 | 2491428 | 2022-05-10 | Daniels | Montana | 30019 | 386 | 9 |
2491472 | 2491472 | 2022-05-10 | Wheatland | Montana | 30107 | 386 | 14 |
2488170 | 2488170 | 2022-05-09 | Daniels | Montana | 30019 | 386 | 9 |
2488214 | 2488214 | 2022-05-09 | Wheatland | Montana | 30107 | 386 | 14 |
2484913 | 2484913 | 2022-05-08 | Daniels | Montana | 30019 | 386 | 9 |
2484957 | 2484957 | 2022-05-08 | Wheatland | Montana | 30107 | 386 | 14 |
2481655 | 2481655 | 2022-05-07 | Daniels | Montana | 30019 | 386 | 9 |
2481699 | 2481699 | 2022-05-07 | Wheatland | Montana | 30107 | 386 | 14 |
2478397 | 2478397 | 2022-05-06 | Daniels | Montana | 30019 | 386 | 9 |
2478441 | 2478441 | 2022-05-06 | Wheatland | Montana | 30107 | 386 | 14 |
2475139 | 2475139 | 2022-05-05 | Daniels | Montana | 30019 | 386 | 9 |
2475183 | 2475183 | 2022-05-05 | Wheatland | Montana | 30107 | 386 | 14 |
2471882 | 2471882 | 2022-05-04 | Daniels | Montana | 30019 | 386 | 9 |
2471926 | 2471926 | 2022-05-04 | Wheatland | Montana | 30107 | 386 | 14 |
2468626 | 2468626 | 2022-05-03 | Daniels | Montana | 30019 | 386 | 9 |
2468670 | 2468670 | 2022-05-03 | Wheatland | Montana | 30107 | 386 | 14 |
2465370 | 2465370 | 2022-05-02 | Daniels | Montana | 30019 | 386 | 9 |
2465414 | 2465414 | 2022-05-02 | Wheatland | Montana | 30107 | 386 | 14 |
2462115 | 2462115 | 2022-05-01 | Daniels | Montana | 30019 | 386 | 9 |
2462159 | 2462159 | 2022-05-01 | Wheatland | Montana | 30107 | 386 | 14 |
2458859 | 2458859 | 2022-04-30 | Daniels | Montana | 30019 | 386 | 9 |
2458903 | 2458903 | 2022-04-30 | Wheatland | Montana | 30107 | 386 | 14 |
2455603 | 2455603 | 2022-04-29 | Daniels | Montana | 30019 | 386 | 9 |
2455647 | 2455647 | 2022-04-29 | Wheatland | Montana | 30107 | 386 | 14 |
2452347 | 2452347 | 2022-04-28 | Daniels | Montana | 30019 | 386 | 9 |
2452391 | 2452391 | 2022-04-28 | Wheatland | Montana | 30107 | 386 | 14 |
2449091 | 2449091 | 2022-04-27 | Daniels | Montana | 30019 | 386 | 9 |
2449135 | 2449135 | 2022-04-27 | Wheatland | Montana | 30107 | 386 | 14 |
2445834 | 2445834 | 2022-04-26 | Daniels | Montana | 30019 | 386 | 9 |
2445878 | 2445878 | 2022-04-26 | Wheatland | Montana | 30107 | 386 | 14 |
2442579 | 2442579 | 2022-04-25 | Daniels | Montana | 30019 | 386 | 9 |
2442623 | 2442623 | 2022-04-25 | Wheatland | Montana | 30107 | 386 | 14 |
2439323 | 2439323 | 2022-04-24 | Daniels | Montana | 30019 | 386 | 9 |
2439367 | 2439367 | 2022-04-24 | Wheatland | Montana | 30107 | 386 | 14 |
2436067 | 2436067 | 2022-04-23 | Daniels | Montana | 30019 | 386 | 9 |
2436111 | 2436111 | 2022-04-23 | Wheatland | Montana | 30107 | 386 | 14 |
2432811 | 2432811 | 2022-04-22 | Daniels | Montana | 30019 | 386 | 9 |
2432855 | 2432855 | 2022-04-22 | Wheatland | Montana | 30107 | 386 | 14 |
2429555 | 2429555 | 2022-04-21 | Daniels | Montana | 30019 | 386 | 9 |
2429599 | 2429599 | 2022-04-21 | Wheatland | Montana | 30107 | 386 | 14 |
2426299 | 2426299 | 2022-04-20 | Daniels | Montana | 30019 | 386 | 9 |
2426343 | 2426343 | 2022-04-20 | Wheatland | Montana | 30107 | 386 | 14 |
2423043 | 2423043 | 2022-04-19 | Daniels | Montana | 30019 | 386 | 9 |
2423087 | 2423087 | 2022-04-19 | Wheatland | Montana | 30107 | 386 | 14 |
2419786 | 2419786 | 2022-04-18 | Daniels | Montana | 30019 | 386 | 9 |
2419830 | 2419830 | 2022-04-18 | Wheatland | Montana | 30107 | 386 | 14 |
2416531 | 2416531 | 2022-04-17 | Daniels | Montana | 30019 | 386 | 9 |
2416575 | 2416575 | 2022-04-17 | Wheatland | Montana | 30107 | 386 | 14 |
2413275 | 2413275 | 2022-04-16 | Daniels | Montana | 30019 | 386 | 9 |
2413319 | 2413319 | 2022-04-16 | Wheatland | Montana | 30107 | 386 | 14 |
2410019 | 2410019 | 2022-04-15 | Daniels | Montana | 30019 | 386 | 9 |
2410063 | 2410063 | 2022-04-15 | Wheatland | Montana | 30107 | 386 | 14 |
2406763 | 2406763 | 2022-04-14 | Daniels | Montana | 30019 | 386 | 9 |
2406807 | 2406807 | 2022-04-14 | Wheatland | Montana | 30107 | 386 | 14 |
2408214 | 2408214 | 2022-04-14 | Garfield | Washington | 53023 | 386 | 7 |
2403507 | 2403507 | 2022-04-13 | Daniels | Montana | 30019 | 386 | 9 |
2403551 | 2403551 | 2022-04-13 | Wheatland | Montana | 30107 | 386 | 14 |
2404958 | 2404958 | 2022-04-13 | Garfield | Washington | 53023 | 386 | 7 |
2400252 | 2400252 | 2022-04-12 | Daniels | Montana | 30019 | 386 | 9 |
2401703 | 2401703 | 2022-04-12 | Garfield | Washington | 53023 | 386 | 7 |
2396997 | 2396997 | 2022-04-11 | Daniels | Montana | 30019 | 386 | 9 |
2398448 | 2398448 | 2022-04-11 | Garfield | Washington | 53023 | 386 | 7 |
2393742 | 2393742 | 2022-04-10 | Daniels | Montana | 30019 | 386 | 9 |
2395193 | 2395193 | 2022-04-10 | Garfield | Washington | 53023 | 386 | 7 |
2390486 | 2390486 | 2022-04-09 | Daniels | Montana | 30019 | 386 | 9 |
2391937 | 2391937 | 2022-04-09 | Garfield | Washington | 53023 | 386 | 7 |
2387230 | 2387230 | 2022-04-08 | Daniels | Montana | 30019 | 386 | 9 |
2388681 | 2388681 | 2022-04-08 | Garfield | Washington | 53023 | 386 | 7 |
2383975 | 2383975 | 2022-04-07 | Daniels | Montana | 30019 | 386 | 9 |
2385426 | 2385426 | 2022-04-07 | Garfield | Washington | 53023 | 386 | 7 |
2380720 | 2380720 | 2022-04-06 | Daniels | Montana | 30019 | 386 | 9 |
2382171 | 2382171 | 2022-04-06 | Garfield | Washington | 53023 | 386 | 7 |
2377465 | 2377465 | 2022-04-05 | Daniels | Montana | 30019 | 386 | 9 |
2378916 | 2378916 | 2022-04-05 | Garfield | Washington | 53023 | 386 | 7 |
2374212 | 2374212 | 2022-04-04 | Daniels | Montana | 30019 | 386 | 9 |
2375662 | 2375662 | 2022-04-04 | Garfield | Washington | 53023 | 386 | 7 |
2370960 | 2370960 | 2022-04-03 | Daniels | Montana | 30019 | 386 | 9 |
2372410 | 2372410 | 2022-04-03 | Garfield | Washington | 53023 | 386 | 7 |
2367707 | 2367707 | 2022-04-02 | Daniels | Montana | 30019 | 386 | 9 |
2369157 | 2369157 | 2022-04-02 | Garfield | Washington | 53023 | 386 | 7 |
2364454 | 2364454 | 2022-04-01 | Daniels | Montana | 30019 | 386 | 9 |
2365904 | 2365904 | 2022-04-01 | Garfield | Washington | 53023 | 386 | 7 |
2361200 | 2361200 | 2022-03-31 | Daniels | Montana | 30019 | 386 | 9 |
2362651 | 2362651 | 2022-03-31 | Garfield | Washington | 53023 | 386 | 7 |
2357946 | 2357946 | 2022-03-30 | Daniels | Montana | 30019 | 386 | 9 |
2359397 | 2359397 | 2022-03-30 | Garfield | Washington | 53023 | 386 | 7 |
2354693 | 2354693 | 2022-03-29 | Daniels | Montana | 30019 | 386 | 9 |
2351440 | 2351440 | 2022-03-28 | Daniels | Montana | 30019 | 386 | 9 |
2348188 | 2348188 | 2022-03-27 | Daniels | Montana | 30019 | 386 | 9 |
2344935 | 2344935 | 2022-03-26 | Daniels | Montana | 30019 | 386 | 9 |
2341682 | 2341682 | 2022-03-25 | Daniels | Montana | 30019 | 386 | 9 |
2338429 | 2338429 | 2022-03-24 | Daniels | Montana | 30019 | 386 | 9 |
2335175 | 2335175 | 2022-03-23 | Daniels | Montana | 30019 | 386 | 9 |
2331921 | 2331921 | 2022-03-22 | Daniels | Montana | 30019 | 386 | 9 |
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);