ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,495 rows where cases = 106 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 243
- Nebraska 109
- Virginia 70
- Colorado 59
- Missouri 57
- Kentucky 52
- Georgia 49
- Mississippi 42
- Ohio 41
- Illinois 39
- Iowa 38
- North Carolina 38
- Indiana 37
- West Virginia 36
- New York 35
- Michigan 33
- Idaho 31
- Kansas 31
- Puerto Rico 31
- Tennessee 29
- Montana 27
- Louisiana 26
- Oklahoma 26
- California 25
- Arkansas 22
- North Dakota 22
- Pennsylvania 21
- Wisconsin 21
- South Dakota 19
- Alaska 18
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468710 | 2468710 | 2022-05-03 | Grant | Nebraska | 31075 | 106 | 5 |
2465454 | 2465454 | 2022-05-02 | Grant | Nebraska | 31075 | 106 | 5 |
2462199 | 2462199 | 2022-05-01 | Grant | Nebraska | 31075 | 106 | 5 |
2458943 | 2458943 | 2022-04-30 | Grant | Nebraska | 31075 | 106 | 5 |
2455687 | 2455687 | 2022-04-29 | Grant | Nebraska | 31075 | 106 | 5 |
2452431 | 2452431 | 2022-04-28 | Grant | Nebraska | 31075 | 106 | 5 |
2449175 | 2449175 | 2022-04-27 | Grant | Nebraska | 31075 | 106 | 5 |
2445918 | 2445918 | 2022-04-26 | Grant | Nebraska | 31075 | 106 | 5 |
2442663 | 2442663 | 2022-04-25 | Grant | Nebraska | 31075 | 106 | 5 |
2439407 | 2439407 | 2022-04-24 | Grant | Nebraska | 31075 | 106 | 5 |
2436151 | 2436151 | 2022-04-23 | Grant | Nebraska | 31075 | 106 | 5 |
2432895 | 2432895 | 2022-04-22 | Grant | Nebraska | 31075 | 106 | 5 |
2429639 | 2429639 | 2022-04-21 | Grant | Nebraska | 31075 | 106 | 5 |
2429644 | 2429644 | 2022-04-21 | Hayes | Nebraska | 31085 | 106 | 0 |
2426383 | 2426383 | 2022-04-20 | Grant | Nebraska | 31075 | 106 | 5 |
2426388 | 2426388 | 2022-04-20 | Hayes | Nebraska | 31085 | 106 | 0 |
2423127 | 2423127 | 2022-04-19 | Grant | Nebraska | 31075 | 106 | 5 |
2423132 | 2423132 | 2022-04-19 | Hayes | Nebraska | 31085 | 106 | 0 |
2419870 | 2419870 | 2022-04-18 | Grant | Nebraska | 31075 | 106 | 5 |
2419875 | 2419875 | 2022-04-18 | Hayes | Nebraska | 31085 | 106 | 0 |
2416615 | 2416615 | 2022-04-17 | Grant | Nebraska | 31075 | 106 | 5 |
2416620 | 2416620 | 2022-04-17 | Hayes | Nebraska | 31085 | 106 | 0 |
2413359 | 2413359 | 2022-04-16 | Grant | Nebraska | 31075 | 106 | 5 |
2413364 | 2413364 | 2022-04-16 | Hayes | Nebraska | 31085 | 106 | 0 |
2410103 | 2410103 | 2022-04-15 | Grant | Nebraska | 31075 | 106 | 5 |
2410108 | 2410108 | 2022-04-15 | Hayes | Nebraska | 31085 | 106 | 0 |
2406847 | 2406847 | 2022-04-14 | Grant | Nebraska | 31075 | 106 | 5 |
2406852 | 2406852 | 2022-04-14 | Hayes | Nebraska | 31085 | 106 | 0 |
2403591 | 2403591 | 2022-04-13 | Grant | Nebraska | 31075 | 106 | 5 |
2403596 | 2403596 | 2022-04-13 | Hayes | Nebraska | 31085 | 106 | 0 |
2400336 | 2400336 | 2022-04-12 | Grant | Nebraska | 31075 | 106 | 5 |
2397081 | 2397081 | 2022-04-11 | Grant | Nebraska | 31075 | 106 | 5 |
2393826 | 2393826 | 2022-04-10 | Grant | Nebraska | 31075 | 106 | 5 |
2390570 | 2390570 | 2022-04-09 | Grant | Nebraska | 31075 | 106 | 5 |
2387314 | 2387314 | 2022-04-08 | Grant | Nebraska | 31075 | 106 | 5 |
2384059 | 2384059 | 2022-04-07 | Grant | Nebraska | 31075 | 106 | 5 |
2380804 | 2380804 | 2022-04-06 | Grant | Nebraska | 31075 | 106 | 5 |
2377549 | 2377549 | 2022-04-05 | Grant | Nebraska | 31075 | 106 | 5 |
2374296 | 2374296 | 2022-04-04 | Grant | Nebraska | 31075 | 106 | 5 |
2371044 | 2371044 | 2022-04-03 | Grant | Nebraska | 31075 | 106 | 5 |
2367791 | 2367791 | 2022-04-02 | Grant | Nebraska | 31075 | 106 | 5 |
2364538 | 2364538 | 2022-04-01 | Grant | Nebraska | 31075 | 106 | 5 |
2361284 | 2361284 | 2022-03-31 | Grant | Nebraska | 31075 | 106 | 5 |
2358030 | 2358030 | 2022-03-30 | Grant | Nebraska | 31075 | 106 | 5 |
2358035 | 2358035 | 2022-03-30 | Hayes | Nebraska | 31085 | 106 | 0 |
2354777 | 2354777 | 2022-03-29 | Grant | Nebraska | 31075 | 106 | 5 |
2354782 | 2354782 | 2022-03-29 | Hayes | Nebraska | 31085 | 106 | 0 |
2351524 | 2351524 | 2022-03-28 | Grant | Nebraska | 31075 | 106 | 5 |
2351529 | 2351529 | 2022-03-28 | Hayes | Nebraska | 31085 | 106 | 0 |
2348272 | 2348272 | 2022-03-27 | Grant | Nebraska | 31075 | 106 | 5 |
2345019 | 2345019 | 2022-03-26 | Grant | Nebraska | 31075 | 106 | 5 |
2341766 | 2341766 | 2022-03-25 | Grant | Nebraska | 31075 | 106 | 5 |
2338513 | 2338513 | 2022-03-24 | Grant | Nebraska | 31075 | 106 | 5 |
2338518 | 2338518 | 2022-03-24 | Hayes | Nebraska | 31085 | 106 | 0 |
2335259 | 2335259 | 2022-03-23 | Grant | Nebraska | 31075 | 106 | 5 |
2335264 | 2335264 | 2022-03-23 | Hayes | Nebraska | 31085 | 106 | 0 |
2331785 | 2331785 | 2022-03-22 | Unknown | Mississippi | 106 | 32 | |
2332005 | 2332005 | 2022-03-22 | Grant | Nebraska | 31075 | 106 | 5 |
2332010 | 2332010 | 2022-03-22 | Hayes | Nebraska | 31085 | 106 | 0 |
2328752 | 2328752 | 2022-03-21 | Grant | Nebraska | 31075 | 106 | 5 |
2328757 | 2328757 | 2022-03-21 | Hayes | Nebraska | 31085 | 106 | 0 |
2325500 | 2325500 | 2022-03-20 | Grant | Nebraska | 31075 | 106 | 5 |
2322246 | 2322246 | 2022-03-19 | Grant | Nebraska | 31075 | 106 | 5 |
2312491 | 2312491 | 2022-03-16 | Hayes | Nebraska | 31085 | 106 | 0 |
2309238 | 2309238 | 2022-03-15 | Hayes | Nebraska | 31085 | 106 | 0 |
2302735 | 2302735 | 2022-03-13 | Hayes | Nebraska | 31085 | 106 | 0 |
2299483 | 2299483 | 2022-03-12 | Hayes | Nebraska | 31085 | 106 | 0 |
2296231 | 2296231 | 2022-03-11 | Hayes | Nebraska | 31085 | 106 | 0 |
2191031 | 2191031 | 2022-02-07 | Clark | Idaho | 16033 | 106 | 0 |
2156386 | 2156386 | 2022-01-27 | Hooker | Nebraska | 31091 | 106 | 3 |
2156392 | 2156392 | 2022-01-27 | Keya Paha | Nebraska | 31103 | 106 | 0 |
2153133 | 2153133 | 2022-01-26 | Hooker | Nebraska | 31091 | 106 | 3 |
2153139 | 2153139 | 2022-01-26 | Keya Paha | Nebraska | 31103 | 106 | 0 |
2149881 | 2149881 | 2022-01-25 | Hooker | Nebraska | 31091 | 106 | 3 |
2146629 | 2146629 | 2022-01-24 | Hooker | Nebraska | 31091 | 106 | 3 |
2141930 | 2141930 | 2022-01-23 | Hinsdale | Colorado | 8053 | 106 | 0 |
2138675 | 2138675 | 2022-01-22 | Hinsdale | Colorado | 8053 | 106 | 0 |
2135419 | 2135419 | 2022-01-21 | Hinsdale | Colorado | 8053 | 106 | 0 |
2132167 | 2132167 | 2022-01-20 | Hinsdale | Colorado | 8053 | 106 | 0 |
2128914 | 2128914 | 2022-01-19 | Hinsdale | Colorado | 8053 | 106 | 0 |
2127151 | 2127151 | 2022-01-18 | Wheeler | Nebraska | 31183 | 106 | 0 |
2123899 | 2123899 | 2022-01-17 | Wheeler | Nebraska | 31183 | 106 | 0 |
2028163 | 2028163 | 2021-12-19 | San Juan | Colorado | 8111 | 106 | 0 |
2024912 | 2024912 | 2021-12-18 | San Juan | Colorado | 8111 | 106 | 0 |
2021661 | 2021661 | 2021-12-17 | San Juan | Colorado | 8111 | 106 | 0 |
2018410 | 2018410 | 2021-12-16 | San Juan | Colorado | 8111 | 106 | 0 |
1992404 | 1992404 | 2021-12-08 | San Juan | Colorado | 8111 | 106 | 0 |
1989153 | 1989153 | 2021-12-07 | San Juan | Colorado | 8111 | 106 | 0 |
1975424 | 1975424 | 2021-12-02 | Roberts | Texas | 48393 | 106 | 1 |
1972175 | 1972175 | 2021-12-01 | Roberts | Texas | 48393 | 106 | 1 |
1966404 | 1966404 | 2021-11-30 | San Juan | Colorado | 8111 | 106 | 0 |
1968925 | 1968925 | 2021-11-30 | Roberts | Texas | 48393 | 106 | 1 |
1963152 | 1963152 | 2021-11-29 | San Juan | Colorado | 8111 | 106 | 0 |
1964861 | 1964861 | 2021-11-29 | Billings | North Dakota | 38007 | 106 | 1 |
1965674 | 1965674 | 2021-11-29 | Roberts | Texas | 48393 | 106 | 1 |
1959788 | 1959788 | 2021-11-28 | Alpine | California | 6003 | 106 | 0 |
1959901 | 1959901 | 2021-11-28 | San Juan | Colorado | 8111 | 106 | 0 |
1961609 | 1961609 | 2021-11-28 | Billings | North Dakota | 38007 | 106 | 1 |
1956537 | 1956537 | 2021-11-27 | Alpine | California | 6003 | 106 | 0 |
1956650 | 1956650 | 2021-11-27 | San Juan | Colorado | 8111 | 106 | 0 |
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);