ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where cases = 415 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 90
- Texas 48
- Georgia 44
- Northern Mariana Islands 43
- Nebraska 40
- North Dakota 36
- Kansas 32
- Virginia 29
- Kentucky 28
- Puerto Rico 26
- Illinois 21
- Iowa 19
- Colorado 18
- Missouri 18
- Louisiana 16
- Michigan 16
- North Carolina 16
- Idaho 15
- New Mexico 14
- Alabama 13
- Arkansas 12
- California 12
- West Virginia 12
- Alaska 11
- Minnesota 11
- Ohio 11
- Tennessee 10
- Indiana 9
- New York 9
- Mississippi 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501315 | 2501315 | 2022-05-13 | Pawnee | Nebraska | 31133 | 415 | 4 |
2501640 | 2501640 | 2022-05-13 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2502080 | 2502080 | 2022-05-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2498057 | 2498057 | 2022-05-12 | Pawnee | Nebraska | 31133 | 415 | 4 |
2498382 | 2498382 | 2022-05-12 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2498822 | 2498822 | 2022-05-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2494799 | 2494799 | 2022-05-11 | Pawnee | Nebraska | 31133 | 415 | 4 |
2495124 | 2495124 | 2022-05-11 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2495564 | 2495564 | 2022-05-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2489873 | 2489873 | 2022-05-10 | Denali Borough | Alaska | 2068 | 415 | 1 |
2491866 | 2491866 | 2022-05-10 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2492306 | 2492306 | 2022-05-10 | Jerauld | South Dakota | 46073 | 415 | 20 |
2486616 | 2486616 | 2022-05-09 | Denali Borough | Alaska | 2068 | 415 | 1 |
2488608 | 2488608 | 2022-05-09 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2489048 | 2489048 | 2022-05-09 | Jerauld | South Dakota | 46073 | 415 | 20 |
2483358 | 2483358 | 2022-05-08 | Denali Borough | Alaska | 2068 | 415 | 1 |
2485351 | 2485351 | 2022-05-08 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2485791 | 2485791 | 2022-05-08 | Jerauld | South Dakota | 46073 | 415 | 20 |
2480100 | 2480100 | 2022-05-07 | Denali Borough | Alaska | 2068 | 415 | 1 |
2482093 | 2482093 | 2022-05-07 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2482533 | 2482533 | 2022-05-07 | Jerauld | South Dakota | 46073 | 415 | 20 |
2476842 | 2476842 | 2022-05-06 | Denali Borough | Alaska | 2068 | 415 | 1 |
2478835 | 2478835 | 2022-05-06 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2479275 | 2479275 | 2022-05-06 | Jerauld | South Dakota | 46073 | 415 | 20 |
2473584 | 2473584 | 2022-05-05 | Denali Borough | Alaska | 2068 | 415 | 1 |
2475577 | 2475577 | 2022-05-05 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2476017 | 2476017 | 2022-05-05 | Jerauld | South Dakota | 46073 | 415 | 20 |
2470327 | 2470327 | 2022-05-04 | Denali Borough | Alaska | 2068 | 415 | 1 |
2472320 | 2472320 | 2022-05-04 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2472760 | 2472760 | 2022-05-04 | Jerauld | South Dakota | 46073 | 415 | 20 |
2468711 | 2468711 | 2022-05-03 | Greeley | Nebraska | 31077 | 415 | 2 |
2469064 | 2469064 | 2022-05-03 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2469504 | 2469504 | 2022-05-03 | Jerauld | South Dakota | 46073 | 415 | 20 |
2465455 | 2465455 | 2022-05-02 | Greeley | Nebraska | 31077 | 415 | 2 |
2465808 | 2465808 | 2022-05-02 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2466248 | 2466248 | 2022-05-02 | Jerauld | South Dakota | 46073 | 415 | 20 |
2462200 | 2462200 | 2022-05-01 | Greeley | Nebraska | 31077 | 415 | 2 |
2462553 | 2462553 | 2022-05-01 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2462993 | 2462993 | 2022-05-01 | Jerauld | South Dakota | 46073 | 415 | 20 |
2458944 | 2458944 | 2022-04-30 | Greeley | Nebraska | 31077 | 415 | 2 |
2459297 | 2459297 | 2022-04-30 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2459737 | 2459737 | 2022-04-30 | Jerauld | South Dakota | 46073 | 415 | 20 |
2455688 | 2455688 | 2022-04-29 | Greeley | Nebraska | 31077 | 415 | 2 |
2456041 | 2456041 | 2022-04-29 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2456481 | 2456481 | 2022-04-29 | Jerauld | South Dakota | 46073 | 415 | 20 |
2452785 | 2452785 | 2022-04-28 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2453225 | 2453225 | 2022-04-28 | Jerauld | South Dakota | 46073 | 415 | 20 |
2449529 | 2449529 | 2022-04-27 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2449969 | 2449969 | 2022-04-27 | Jerauld | South Dakota | 46073 | 415 | 20 |
2446272 | 2446272 | 2022-04-26 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2446712 | 2446712 | 2022-04-26 | Jerauld | South Dakota | 46073 | 415 | 20 |
2443017 | 2443017 | 2022-04-25 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2443457 | 2443457 | 2022-04-25 | Jerauld | South Dakota | 46073 | 415 | 20 |
2439761 | 2439761 | 2022-04-24 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2440201 | 2440201 | 2022-04-24 | Jerauld | South Dakota | 46073 | 415 | 20 |
2436505 | 2436505 | 2022-04-23 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2436945 | 2436945 | 2022-04-23 | Jerauld | South Dakota | 46073 | 415 | 20 |
2433249 | 2433249 | 2022-04-22 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2433689 | 2433689 | 2022-04-22 | Jerauld | South Dakota | 46073 | 415 | 20 |
2429668 | 2429668 | 2022-04-21 | Pawnee | Nebraska | 31133 | 415 | 4 |
2429993 | 2429993 | 2022-04-21 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2430433 | 2430433 | 2022-04-21 | Jerauld | South Dakota | 46073 | 415 | 20 |
2426412 | 2426412 | 2022-04-20 | Pawnee | Nebraska | 31133 | 415 | 4 |
2426737 | 2426737 | 2022-04-20 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2427177 | 2427177 | 2022-04-20 | Jerauld | South Dakota | 46073 | 415 | 20 |
2423156 | 2423156 | 2022-04-19 | Pawnee | Nebraska | 31133 | 415 | 4 |
2423481 | 2423481 | 2022-04-19 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2423921 | 2423921 | 2022-04-19 | Jerauld | South Dakota | 46073 | 415 | 20 |
2419899 | 2419899 | 2022-04-18 | Pawnee | Nebraska | 31133 | 415 | 4 |
2420224 | 2420224 | 2022-04-18 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2420665 | 2420665 | 2022-04-18 | Jerauld | South Dakota | 46073 | 415 | 20 |
2416644 | 2416644 | 2022-04-17 | Pawnee | Nebraska | 31133 | 415 | 4 |
2416969 | 2416969 | 2022-04-17 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2417409 | 2417409 | 2022-04-17 | Jerauld | South Dakota | 46073 | 415 | 20 |
2413388 | 2413388 | 2022-04-16 | Pawnee | Nebraska | 31133 | 415 | 4 |
2413713 | 2413713 | 2022-04-16 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2414153 | 2414153 | 2022-04-16 | Jerauld | South Dakota | 46073 | 415 | 20 |
2410132 | 2410132 | 2022-04-15 | Pawnee | Nebraska | 31133 | 415 | 4 |
2410457 | 2410457 | 2022-04-15 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2410897 | 2410897 | 2022-04-15 | Jerauld | South Dakota | 46073 | 415 | 20 |
2406876 | 2406876 | 2022-04-14 | Pawnee | Nebraska | 31133 | 415 | 4 |
2407201 | 2407201 | 2022-04-14 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2407641 | 2407641 | 2022-04-14 | Jerauld | South Dakota | 46073 | 415 | 20 |
2403620 | 2403620 | 2022-04-13 | Pawnee | Nebraska | 31133 | 415 | 4 |
2403945 | 2403945 | 2022-04-13 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2404385 | 2404385 | 2022-04-13 | Jerauld | South Dakota | 46073 | 415 | 20 |
2400690 | 2400690 | 2022-04-12 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2401130 | 2401130 | 2022-04-12 | Jerauld | South Dakota | 46073 | 415 | 20 |
2397435 | 2397435 | 2022-04-11 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2397875 | 2397875 | 2022-04-11 | Jerauld | South Dakota | 46073 | 415 | 20 |
2394180 | 2394180 | 2022-04-10 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2394620 | 2394620 | 2022-04-10 | Jerauld | South Dakota | 46073 | 415 | 20 |
2390924 | 2390924 | 2022-04-09 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2391364 | 2391364 | 2022-04-09 | Jerauld | South Dakota | 46073 | 415 | 20 |
2387668 | 2387668 | 2022-04-08 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2388108 | 2388108 | 2022-04-08 | Jerauld | South Dakota | 46073 | 415 | 20 |
2384413 | 2384413 | 2022-04-07 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2384853 | 2384853 | 2022-04-07 | Jerauld | South Dakota | 46073 | 415 | 20 |
2381158 | 2381158 | 2022-04-06 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2381598 | 2381598 | 2022-04-06 | Jerauld | South Dakota | 46073 | 415 | 20 |
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);