ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,057 rows where cases = 165 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 108
- Colorado 67
- Nevada 60
- Georgia 57
- Virginia 56
- Kentucky 38
- Indiana 35
- South Dakota 35
- Nebraska 31
- Kansas 29
- North Dakota 29
- Missouri 28
- Montana 26
- Ohio 25
- Puerto Rico 25
- Iowa 24
- Minnesota 23
- Mississippi 23
- California 21
- Illinois 21
- West Virginia 21
- Oregon 20
- Michigan 19
- North Carolina 19
- Tennessee 17
- Arkansas 15
- Oklahoma 15
- Pennsylvania 15
- Utah 15
- Alabama 14
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501349 | 2501349 | 2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 |
2498091 | 2498091 | 2022-05-12 | Eureka | Nevada | 32011 | 165 | 2 |
2493333 | 2493333 | 2022-05-11 | Jackson | Colorado | 8057 | 165 | 0 |
2494833 | 2494833 | 2022-05-11 | Eureka | Nevada | 32011 | 165 | 2 |
2490075 | 2490075 | 2022-05-10 | Jackson | Colorado | 8057 | 165 | 0 |
2491575 | 2491575 | 2022-05-10 | Eureka | Nevada | 32011 | 165 | 2 |
2486818 | 2486818 | 2022-05-09 | Jackson | Colorado | 8057 | 165 | 0 |
2488317 | 2488317 | 2022-05-09 | Eureka | Nevada | 32011 | 165 | 2 |
2483560 | 2483560 | 2022-05-08 | Jackson | Colorado | 8057 | 165 | 0 |
2485060 | 2485060 | 2022-05-08 | Eureka | Nevada | 32011 | 165 | 2 |
2480302 | 2480302 | 2022-05-07 | Jackson | Colorado | 8057 | 165 | 0 |
2481802 | 2481802 | 2022-05-07 | Eureka | Nevada | 32011 | 165 | 2 |
2477044 | 2477044 | 2022-05-06 | Jackson | Colorado | 8057 | 165 | 0 |
2478544 | 2478544 | 2022-05-06 | Eureka | Nevada | 32011 | 165 | 2 |
2473786 | 2473786 | 2022-05-05 | Jackson | Colorado | 8057 | 165 | 0 |
2475286 | 2475286 | 2022-05-05 | Eureka | Nevada | 32011 | 165 | 2 |
2470529 | 2470529 | 2022-05-04 | Jackson | Colorado | 8057 | 165 | 0 |
2472029 | 2472029 | 2022-05-04 | Eureka | Nevada | 32011 | 165 | 2 |
2467273 | 2467273 | 2022-05-03 | Jackson | Colorado | 8057 | 165 | 0 |
2468773 | 2468773 | 2022-05-03 | Eureka | Nevada | 32011 | 165 | 2 |
2464018 | 2464018 | 2022-05-02 | Jackson | Colorado | 8057 | 165 | 0 |
2465517 | 2465517 | 2022-05-02 | Eureka | Nevada | 32011 | 165 | 2 |
2460762 | 2460762 | 2022-05-01 | Jackson | Colorado | 8057 | 165 | 0 |
2462262 | 2462262 | 2022-05-01 | Eureka | Nevada | 32011 | 165 | 2 |
2457506 | 2457506 | 2022-04-30 | Jackson | Colorado | 8057 | 165 | 0 |
2459006 | 2459006 | 2022-04-30 | Eureka | Nevada | 32011 | 165 | 2 |
2454250 | 2454250 | 2022-04-29 | Jackson | Colorado | 8057 | 165 | 0 |
2455750 | 2455750 | 2022-04-29 | Eureka | Nevada | 32011 | 165 | 2 |
2450994 | 2450994 | 2022-04-28 | Jackson | Colorado | 8057 | 165 | 0 |
2452494 | 2452494 | 2022-04-28 | Eureka | Nevada | 32011 | 165 | 2 |
2447738 | 2447738 | 2022-04-27 | Jackson | Colorado | 8057 | 165 | 0 |
2449238 | 2449238 | 2022-04-27 | Eureka | Nevada | 32011 | 165 | 2 |
2444482 | 2444482 | 2022-04-26 | Jackson | Colorado | 8057 | 165 | 0 |
2445981 | 2445981 | 2022-04-26 | Eureka | Nevada | 32011 | 165 | 2 |
2441226 | 2441226 | 2022-04-25 | Jackson | Colorado | 8057 | 165 | 0 |
2442726 | 2442726 | 2022-04-25 | Eureka | Nevada | 32011 | 165 | 2 |
2437970 | 2437970 | 2022-04-24 | Jackson | Colorado | 8057 | 165 | 0 |
2439470 | 2439470 | 2022-04-24 | Eureka | Nevada | 32011 | 165 | 2 |
2434714 | 2434714 | 2022-04-23 | Jackson | Colorado | 8057 | 165 | 0 |
2436214 | 2436214 | 2022-04-23 | Eureka | Nevada | 32011 | 165 | 2 |
2431458 | 2431458 | 2022-04-22 | Jackson | Colorado | 8057 | 165 | 0 |
2432958 | 2432958 | 2022-04-22 | Eureka | Nevada | 32011 | 165 | 2 |
2428202 | 2428202 | 2022-04-21 | Jackson | Colorado | 8057 | 165 | 0 |
2429702 | 2429702 | 2022-04-21 | Eureka | Nevada | 32011 | 165 | 2 |
2424946 | 2424946 | 2022-04-20 | Jackson | Colorado | 8057 | 165 | 0 |
2426446 | 2426446 | 2022-04-20 | Eureka | Nevada | 32011 | 165 | 2 |
2421690 | 2421690 | 2022-04-19 | Jackson | Colorado | 8057 | 165 | 0 |
2423190 | 2423190 | 2022-04-19 | Eureka | Nevada | 32011 | 165 | 2 |
2418434 | 2418434 | 2022-04-18 | Jackson | Colorado | 8057 | 165 | 0 |
2419933 | 2419933 | 2022-04-18 | Eureka | Nevada | 32011 | 165 | 2 |
2416678 | 2416678 | 2022-04-17 | Eureka | Nevada | 32011 | 165 | 2 |
2413422 | 2413422 | 2022-04-16 | Eureka | Nevada | 32011 | 165 | 2 |
2410166 | 2410166 | 2022-04-15 | Eureka | Nevada | 32011 | 165 | 2 |
2406910 | 2406910 | 2022-04-14 | Eureka | Nevada | 32011 | 165 | 2 |
2403654 | 2403654 | 2022-04-13 | Eureka | Nevada | 32011 | 165 | 2 |
2400399 | 2400399 | 2022-04-12 | Eureka | Nevada | 32011 | 165 | 2 |
2397144 | 2397144 | 2022-04-11 | Eureka | Nevada | 32011 | 165 | 2 |
2393889 | 2393889 | 2022-04-10 | Eureka | Nevada | 32011 | 165 | 2 |
2390633 | 2390633 | 2022-04-09 | Eureka | Nevada | 32011 | 165 | 2 |
2387377 | 2387377 | 2022-04-08 | Eureka | Nevada | 32011 | 165 | 2 |
2384122 | 2384122 | 2022-04-07 | Eureka | Nevada | 32011 | 165 | 2 |
2380867 | 2380867 | 2022-04-06 | Eureka | Nevada | 32011 | 165 | 2 |
2377612 | 2377612 | 2022-04-05 | Eureka | Nevada | 32011 | 165 | 1 |
2374359 | 2374359 | 2022-04-04 | Eureka | Nevada | 32011 | 165 | 1 |
2371107 | 2371107 | 2022-04-03 | Eureka | Nevada | 32011 | 165 | 1 |
2367854 | 2367854 | 2022-04-02 | Eureka | Nevada | 32011 | 165 | 1 |
2364601 | 2364601 | 2022-04-01 | Eureka | Nevada | 32011 | 165 | 1 |
2361347 | 2361347 | 2022-03-31 | Eureka | Nevada | 32011 | 165 | 1 |
2358093 | 2358093 | 2022-03-30 | Eureka | Nevada | 32011 | 165 | 1 |
2354840 | 2354840 | 2022-03-29 | Eureka | Nevada | 32011 | 165 | 1 |
2351587 | 2351587 | 2022-03-28 | Eureka | Nevada | 32011 | 165 | 1 |
2348335 | 2348335 | 2022-03-27 | Eureka | Nevada | 32011 | 165 | 1 |
2345082 | 2345082 | 2022-03-26 | Eureka | Nevada | 32011 | 165 | 1 |
2341829 | 2341829 | 2022-03-25 | Eureka | Nevada | 32011 | 165 | 1 |
2338576 | 2338576 | 2022-03-24 | Eureka | Nevada | 32011 | 165 | 1 |
2335322 | 2335322 | 2022-03-23 | Eureka | Nevada | 32011 | 165 | 1 |
2332068 | 2332068 | 2022-03-22 | Eureka | Nevada | 32011 | 165 | 1 |
2327318 | 2327318 | 2022-03-21 | Jackson | Colorado | 8057 | 165 | 0 |
2328815 | 2328815 | 2022-03-21 | Eureka | Nevada | 32011 | 165 | 1 |
2324065 | 2324065 | 2022-03-20 | Jackson | Colorado | 8057 | 165 | 0 |
2325563 | 2325563 | 2022-03-20 | Eureka | Nevada | 32011 | 165 | 1 |
2320811 | 2320811 | 2022-03-19 | Jackson | Colorado | 8057 | 165 | 0 |
2322309 | 2322309 | 2022-03-19 | Eureka | Nevada | 32011 | 165 | 1 |
2317557 | 2317557 | 2022-03-18 | Jackson | Colorado | 8057 | 165 | 0 |
2319055 | 2319055 | 2022-03-18 | Eureka | Nevada | 32011 | 165 | 1 |
2314304 | 2314304 | 2022-03-17 | Jackson | Colorado | 8057 | 165 | 0 |
2315802 | 2315802 | 2022-03-17 | Eureka | Nevada | 32011 | 165 | 1 |
2311051 | 2311051 | 2022-03-16 | Jackson | Colorado | 8057 | 165 | 0 |
2312549 | 2312549 | 2022-03-16 | Eureka | Nevada | 32011 | 165 | 1 |
2287539 | 2287539 | 2022-03-08 | Loving | Texas | 48301 | 165 | 1 |
2284287 | 2284287 | 2022-03-07 | Loving | Texas | 48301 | 165 | 1 |
2281035 | 2281035 | 2022-03-06 | Loving | Texas | 48301 | 165 | 1 |
2277782 | 2277782 | 2022-03-05 | Loving | Texas | 48301 | 165 | 1 |
2274529 | 2274529 | 2022-03-04 | Loving | Texas | 48301 | 165 | 1 |
2229057 | 2229057 | 2022-02-18 | Roberts | Texas | 48393 | 165 | 1 |
2225806 | 2225806 | 2022-02-17 | Roberts | Texas | 48393 | 165 | 1 |
2166179 | 2166179 | 2022-01-30 | Rock | Nebraska | 31149 | 165 | 2 |
2162924 | 2162924 | 2022-01-29 | Rock | Nebraska | 31149 | 165 | 2 |
2159669 | 2159669 | 2022-01-28 | Rock | Nebraska | 31149 | 165 | 2 |
2156415 | 2156415 | 2022-01-27 | Rock | Nebraska | 31149 | 165 | 2 |
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);