ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,406 rows where cases = 109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 111
- Virginia 103
- Idaho 76
- Georgia 64
- South Dakota 58
- Nevada 54
- Indiana 51
- Iowa 50
- Nebraska 50
- Kentucky 49
- Missouri 46
- Mississippi 38
- Oklahoma 38
- Montana 35
- Colorado 33
- Illinois 31
- New York 31
- Puerto Rico 31
- Minnesota 30
- Ohio 29
- Pennsylvania 28
- Utah 28
- Kansas 26
- Tennessee 26
- Arkansas 23
- West Virginia 23
- Florida 21
- Michigan 20
- New Mexico 19
- North Carolina 19
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500149 | 2500149 | 2022-05-13 | Clark | Idaho | 16033 | 109 | 1 |
2501348 | 2501348 | 2022-05-13 | Esmeralda | Nevada | 32009 | 109 | 3 |
2496891 | 2496891 | 2022-05-12 | Clark | Idaho | 16033 | 109 | 1 |
2498090 | 2498090 | 2022-05-12 | Esmeralda | Nevada | 32009 | 109 | 3 |
2493633 | 2493633 | 2022-05-11 | Clark | Idaho | 16033 | 109 | 1 |
2494832 | 2494832 | 2022-05-11 | Esmeralda | Nevada | 32009 | 109 | 3 |
2490375 | 2490375 | 2022-05-10 | Clark | Idaho | 16033 | 109 | 1 |
2487118 | 2487118 | 2022-05-09 | Clark | Idaho | 16033 | 109 | 1 |
2483860 | 2483860 | 2022-05-08 | Clark | Idaho | 16033 | 109 | 1 |
2480602 | 2480602 | 2022-05-07 | Clark | Idaho | 16033 | 109 | 1 |
2477344 | 2477344 | 2022-05-06 | Clark | Idaho | 16033 | 109 | 1 |
2474086 | 2474086 | 2022-05-05 | Clark | Idaho | 16033 | 109 | 1 |
2470829 | 2470829 | 2022-05-04 | Clark | Idaho | 16033 | 109 | 1 |
2467573 | 2467573 | 2022-05-03 | Clark | Idaho | 16033 | 109 | 1 |
2464318 | 2464318 | 2022-05-02 | Clark | Idaho | 16033 | 109 | 1 |
2461062 | 2461062 | 2022-05-01 | Clark | Idaho | 16033 | 109 | 1 |
2457806 | 2457806 | 2022-04-30 | Clark | Idaho | 16033 | 109 | 1 |
2454550 | 2454550 | 2022-04-29 | Clark | Idaho | 16033 | 109 | 1 |
2451294 | 2451294 | 2022-04-28 | Clark | Idaho | 16033 | 109 | 1 |
2448038 | 2448038 | 2022-04-27 | Clark | Idaho | 16033 | 109 | 1 |
2444782 | 2444782 | 2022-04-26 | Clark | Idaho | 16033 | 109 | 1 |
2445980 | 2445980 | 2022-04-26 | Esmeralda | Nevada | 32009 | 109 | 3 |
2441526 | 2441526 | 2022-04-25 | Clark | Idaho | 16033 | 109 | 1 |
2442725 | 2442725 | 2022-04-25 | Esmeralda | Nevada | 32009 | 109 | 3 |
2438270 | 2438270 | 2022-04-24 | Clark | Idaho | 16033 | 109 | 1 |
2439469 | 2439469 | 2022-04-24 | Esmeralda | Nevada | 32009 | 109 | 3 |
2435014 | 2435014 | 2022-04-23 | Clark | Idaho | 16033 | 109 | 1 |
2436213 | 2436213 | 2022-04-23 | Esmeralda | Nevada | 32009 | 109 | 3 |
2431758 | 2431758 | 2022-04-22 | Clark | Idaho | 16033 | 109 | 1 |
2432957 | 2432957 | 2022-04-22 | Esmeralda | Nevada | 32009 | 109 | 3 |
2428502 | 2428502 | 2022-04-21 | Clark | Idaho | 16033 | 109 | 1 |
2429701 | 2429701 | 2022-04-21 | Esmeralda | Nevada | 32009 | 109 | 3 |
2425246 | 2425246 | 2022-04-20 | Clark | Idaho | 16033 | 109 | 1 |
2426445 | 2426445 | 2022-04-20 | Esmeralda | Nevada | 32009 | 109 | 3 |
2421990 | 2421990 | 2022-04-19 | Clark | Idaho | 16033 | 109 | 1 |
2423189 | 2423189 | 2022-04-19 | Esmeralda | Nevada | 32009 | 109 | 3 |
2418734 | 2418734 | 2022-04-18 | Clark | Idaho | 16033 | 109 | 1 |
2419932 | 2419932 | 2022-04-18 | Esmeralda | Nevada | 32009 | 109 | 3 |
2415478 | 2415478 | 2022-04-17 | Clark | Idaho | 16033 | 109 | 1 |
2416677 | 2416677 | 2022-04-17 | Esmeralda | Nevada | 32009 | 109 | 3 |
2412222 | 2412222 | 2022-04-16 | Clark | Idaho | 16033 | 109 | 1 |
2413421 | 2413421 | 2022-04-16 | Esmeralda | Nevada | 32009 | 109 | 3 |
2408966 | 2408966 | 2022-04-15 | Clark | Idaho | 16033 | 109 | 1 |
2410165 | 2410165 | 2022-04-15 | Esmeralda | Nevada | 32009 | 109 | 3 |
2405710 | 2405710 | 2022-04-14 | Clark | Idaho | 16033 | 109 | 1 |
2406909 | 2406909 | 2022-04-14 | Esmeralda | Nevada | 32009 | 109 | 3 |
2402455 | 2402455 | 2022-04-13 | Clark | Idaho | 16033 | 109 | 1 |
2403653 | 2403653 | 2022-04-13 | Esmeralda | Nevada | 32009 | 109 | 3 |
2399200 | 2399200 | 2022-04-12 | Clark | Idaho | 16033 | 109 | 1 |
2400398 | 2400398 | 2022-04-12 | Esmeralda | Nevada | 32009 | 109 | 3 |
2395945 | 2395945 | 2022-04-11 | Clark | Idaho | 16033 | 109 | 1 |
2397143 | 2397143 | 2022-04-11 | Esmeralda | Nevada | 32009 | 109 | 3 |
2392689 | 2392689 | 2022-04-10 | Clark | Idaho | 16033 | 109 | 1 |
2393888 | 2393888 | 2022-04-10 | Esmeralda | Nevada | 32009 | 109 | 3 |
2389433 | 2389433 | 2022-04-09 | Clark | Idaho | 16033 | 109 | 1 |
2390632 | 2390632 | 2022-04-09 | Esmeralda | Nevada | 32009 | 109 | 3 |
2386178 | 2386178 | 2022-04-08 | Clark | Idaho | 16033 | 109 | 1 |
2387376 | 2387376 | 2022-04-08 | Esmeralda | Nevada | 32009 | 109 | 3 |
2382923 | 2382923 | 2022-04-07 | Clark | Idaho | 16033 | 109 | 1 |
2384121 | 2384121 | 2022-04-07 | Esmeralda | Nevada | 32009 | 109 | 3 |
2379668 | 2379668 | 2022-04-06 | Clark | Idaho | 16033 | 109 | 1 |
2380866 | 2380866 | 2022-04-06 | Esmeralda | Nevada | 32009 | 109 | 3 |
2376414 | 2376414 | 2022-04-05 | Clark | Idaho | 16033 | 109 | 1 |
2377611 | 2377611 | 2022-04-05 | Esmeralda | Nevada | 32009 | 109 | 3 |
2373162 | 2373162 | 2022-04-04 | Clark | Idaho | 16033 | 109 | 1 |
2374358 | 2374358 | 2022-04-04 | Esmeralda | Nevada | 32009 | 109 | 3 |
2369909 | 2369909 | 2022-04-03 | Clark | Idaho | 16033 | 109 | 1 |
2371106 | 2371106 | 2022-04-03 | Esmeralda | Nevada | 32009 | 109 | 3 |
2366656 | 2366656 | 2022-04-02 | Clark | Idaho | 16033 | 109 | 1 |
2367853 | 2367853 | 2022-04-02 | Esmeralda | Nevada | 32009 | 109 | 3 |
2363403 | 2363403 | 2022-04-01 | Clark | Idaho | 16033 | 109 | 1 |
2364600 | 2364600 | 2022-04-01 | Esmeralda | Nevada | 32009 | 109 | 3 |
2360149 | 2360149 | 2022-03-31 | Clark | Idaho | 16033 | 109 | 1 |
2361346 | 2361346 | 2022-03-31 | Esmeralda | Nevada | 32009 | 109 | 3 |
2356895 | 2356895 | 2022-03-30 | Clark | Idaho | 16033 | 109 | 1 |
2358092 | 2358092 | 2022-03-30 | Esmeralda | Nevada | 32009 | 109 | 3 |
2353642 | 2353642 | 2022-03-29 | Clark | Idaho | 16033 | 109 | 1 |
2354839 | 2354839 | 2022-03-29 | Esmeralda | Nevada | 32009 | 109 | 3 |
2350390 | 2350390 | 2022-03-28 | Clark | Idaho | 16033 | 109 | 1 |
2351586 | 2351586 | 2022-03-28 | Esmeralda | Nevada | 32009 | 109 | 3 |
2347137 | 2347137 | 2022-03-27 | Clark | Idaho | 16033 | 109 | 1 |
2348334 | 2348334 | 2022-03-27 | Esmeralda | Nevada | 32009 | 109 | 3 |
2343884 | 2343884 | 2022-03-26 | Clark | Idaho | 16033 | 109 | 1 |
2345081 | 2345081 | 2022-03-26 | Esmeralda | Nevada | 32009 | 109 | 3 |
2340631 | 2340631 | 2022-03-25 | Clark | Idaho | 16033 | 109 | 1 |
2341828 | 2341828 | 2022-03-25 | Esmeralda | Nevada | 32009 | 109 | 3 |
2337378 | 2337378 | 2022-03-24 | Clark | Idaho | 16033 | 109 | 1 |
2338575 | 2338575 | 2022-03-24 | Esmeralda | Nevada | 32009 | 109 | 3 |
2334124 | 2334124 | 2022-03-23 | Clark | Idaho | 16033 | 109 | 1 |
2335321 | 2335321 | 2022-03-23 | Esmeralda | Nevada | 32009 | 109 | 3 |
2330870 | 2330870 | 2022-03-22 | Clark | Idaho | 16033 | 109 | 1 |
2332067 | 2332067 | 2022-03-22 | Esmeralda | Nevada | 32009 | 109 | 3 |
2328814 | 2328814 | 2022-03-21 | Esmeralda | Nevada | 32009 | 109 | 3 |
2325562 | 2325562 | 2022-03-20 | Esmeralda | Nevada | 32009 | 109 | 3 |
2322308 | 2322308 | 2022-03-19 | Esmeralda | Nevada | 32009 | 109 | 3 |
2319054 | 2319054 | 2022-03-18 | Esmeralda | Nevada | 32009 | 109 | 3 |
2315801 | 2315801 | 2022-03-17 | Esmeralda | Nevada | 32009 | 109 | 3 |
2312548 | 2312548 | 2022-03-16 | Esmeralda | Nevada | 32009 | 109 | 3 |
2237703 | 2237703 | 2022-02-21 | Hooker | Nebraska | 31091 | 109 | 5 |
2234452 | 2234452 | 2022-02-20 | Hooker | Nebraska | 31091 | 109 | 5 |
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);