ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
812 rows where cases = 225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 69
- Georgia 50
- Texas 49
- Kansas 46
- Kentucky 42
- Virginia 39
- Missouri 30
- Nebraska 26
- Puerto Rico 25
- Indiana 22
- South Dakota 22
- Oregon 21
- Minnesota 20
- California 19
- Colorado 19
- Michigan 18
- Arkansas 17
- Illinois 17
- North Carolina 17
- Iowa 16
- New York 16
- Oklahoma 16
- Alaska 15
- Mississippi 14
- North Dakota 14
- Ohio 14
- Tennessee 14
- Louisiana 13
- Florida 12
- West Virginia 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501209 | 2501209 | 2022-05-13 | Garfield | Montana | 30033 | 225 | 3 |
2501215 | 2501215 | 2022-05-13 | Judith Basin | Montana | 30045 | 225 | 1 |
2497951 | 2497951 | 2022-05-12 | Garfield | Montana | 30033 | 225 | 3 |
2497957 | 2497957 | 2022-05-12 | Judith Basin | Montana | 30045 | 225 | 1 |
2494693 | 2494693 | 2022-05-11 | Garfield | Montana | 30033 | 225 | 3 |
2494699 | 2494699 | 2022-05-11 | Judith Basin | Montana | 30045 | 225 | 1 |
2491435 | 2491435 | 2022-05-10 | Garfield | Montana | 30033 | 225 | 3 |
2491441 | 2491441 | 2022-05-10 | Judith Basin | Montana | 30045 | 225 | 1 |
2488177 | 2488177 | 2022-05-09 | Garfield | Montana | 30033 | 225 | 3 |
2488183 | 2488183 | 2022-05-09 | Judith Basin | Montana | 30045 | 225 | 1 |
2484920 | 2484920 | 2022-05-08 | Garfield | Montana | 30033 | 225 | 3 |
2484926 | 2484926 | 2022-05-08 | Judith Basin | Montana | 30045 | 225 | 1 |
2481662 | 2481662 | 2022-05-07 | Garfield | Montana | 30033 | 225 | 3 |
2481668 | 2481668 | 2022-05-07 | Judith Basin | Montana | 30045 | 225 | 1 |
2478404 | 2478404 | 2022-05-06 | Garfield | Montana | 30033 | 225 | 3 |
2478410 | 2478410 | 2022-05-06 | Judith Basin | Montana | 30045 | 225 | 1 |
2475146 | 2475146 | 2022-05-05 | Garfield | Montana | 30033 | 225 | 3 |
2475152 | 2475152 | 2022-05-05 | Judith Basin | Montana | 30045 | 225 | 1 |
2471889 | 2471889 | 2022-05-04 | Garfield | Montana | 30033 | 225 | 3 |
2468633 | 2468633 | 2022-05-03 | Garfield | Montana | 30033 | 225 | 3 |
2465377 | 2465377 | 2022-05-02 | Garfield | Montana | 30033 | 225 | 3 |
2462122 | 2462122 | 2022-05-01 | Garfield | Montana | 30033 | 225 | 3 |
2458866 | 2458866 | 2022-04-30 | Garfield | Montana | 30033 | 225 | 3 |
2455610 | 2455610 | 2022-04-29 | Garfield | Montana | 30033 | 225 | 3 |
2452354 | 2452354 | 2022-04-28 | Garfield | Montana | 30033 | 225 | 3 |
2449098 | 2449098 | 2022-04-27 | Garfield | Montana | 30033 | 225 | 3 |
2445841 | 2445841 | 2022-04-26 | Garfield | Montana | 30033 | 225 | 3 |
2442586 | 2442586 | 2022-04-25 | Garfield | Montana | 30033 | 225 | 3 |
2439330 | 2439330 | 2022-04-24 | Garfield | Montana | 30033 | 225 | 3 |
2436074 | 2436074 | 2022-04-23 | Garfield | Montana | 30033 | 225 | 3 |
2432818 | 2432818 | 2022-04-22 | Garfield | Montana | 30033 | 225 | 3 |
2429562 | 2429562 | 2022-04-21 | Garfield | Montana | 30033 | 225 | 3 |
2426306 | 2426306 | 2022-04-20 | Garfield | Montana | 30033 | 225 | 3 |
2423050 | 2423050 | 2022-04-19 | Garfield | Montana | 30033 | 225 | 3 |
2419793 | 2419793 | 2022-04-18 | Garfield | Montana | 30033 | 225 | 3 |
2416538 | 2416538 | 2022-04-17 | Garfield | Montana | 30033 | 225 | 3 |
2413282 | 2413282 | 2022-04-16 | Garfield | Montana | 30033 | 225 | 3 |
2410026 | 2410026 | 2022-04-15 | Garfield | Montana | 30033 | 225 | 3 |
2406770 | 2406770 | 2022-04-14 | Garfield | Montana | 30033 | 225 | 3 |
2403514 | 2403514 | 2022-04-13 | Garfield | Montana | 30033 | 225 | 3 |
2400259 | 2400259 | 2022-04-12 | Garfield | Montana | 30033 | 225 | 3 |
2397004 | 2397004 | 2022-04-11 | Garfield | Montana | 30033 | 225 | 3 |
2393749 | 2393749 | 2022-04-10 | Garfield | Montana | 30033 | 225 | 3 |
2390493 | 2390493 | 2022-04-09 | Garfield | Montana | 30033 | 225 | 3 |
2387237 | 2387237 | 2022-04-08 | Garfield | Montana | 30033 | 225 | 3 |
2383982 | 2383982 | 2022-04-07 | Garfield | Montana | 30033 | 225 | 3 |
2380727 | 2380727 | 2022-04-06 | Garfield | Montana | 30033 | 225 | 3 |
2377472 | 2377472 | 2022-04-05 | Garfield | Montana | 30033 | 225 | 3 |
2374219 | 2374219 | 2022-04-04 | Garfield | Montana | 30033 | 225 | 3 |
2370967 | 2370967 | 2022-04-03 | Garfield | Montana | 30033 | 225 | 3 |
2367714 | 2367714 | 2022-04-02 | Garfield | Montana | 30033 | 225 | 3 |
2364461 | 2364461 | 2022-04-01 | Garfield | Montana | 30033 | 225 | 3 |
2361207 | 2361207 | 2022-03-31 | Garfield | Montana | 30033 | 225 | 3 |
2357953 | 2357953 | 2022-03-30 | Garfield | Montana | 30033 | 225 | 3 |
2354700 | 2354700 | 2022-03-29 | Garfield | Montana | 30033 | 225 | 3 |
2351447 | 2351447 | 2022-03-28 | Garfield | Montana | 30033 | 225 | 3 |
2348195 | 2348195 | 2022-03-27 | Garfield | Montana | 30033 | 225 | 3 |
2344942 | 2344942 | 2022-03-26 | Garfield | Montana | 30033 | 225 | 3 |
2341689 | 2341689 | 2022-03-25 | Garfield | Montana | 30033 | 225 | 3 |
2337089 | 2337089 | 2022-03-24 | Mineral | Colorado | 8079 | 225 | 1 |
2338436 | 2338436 | 2022-03-24 | Garfield | Montana | 30033 | 225 | 3 |
2333835 | 2333835 | 2022-03-23 | Mineral | Colorado | 8079 | 225 | 1 |
2335182 | 2335182 | 2022-03-23 | Garfield | Montana | 30033 | 225 | 3 |
2330581 | 2330581 | 2022-03-22 | Mineral | Colorado | 8079 | 225 | 1 |
2327329 | 2327329 | 2022-03-21 | Mineral | Colorado | 8079 | 225 | 1 |
2246940 | 2246940 | 2022-02-24 | Unknown | Maine | 225 | 0 | |
2166054 | 2166054 | 2022-01-30 | Carter | Montana | 30011 | 225 | 5 |
2162799 | 2162799 | 2022-01-29 | Carter | Montana | 30011 | 225 | 5 |
2159544 | 2159544 | 2022-01-28 | Carter | Montana | 30011 | 225 | 5 |
2156290 | 2156290 | 2022-01-27 | Carter | Montana | 30011 | 225 | 5 |
2153037 | 2153037 | 2022-01-26 | Carter | Montana | 30011 | 225 | 5 |
2149785 | 2149785 | 2022-01-25 | Carter | Montana | 30011 | 225 | 5 |
2150228 | 2150228 | 2022-01-25 | Unknown | Northern Mariana Islands | 225 | 1 | |
2143900 | 2143900 | 2022-01-23 | Gilliam | Oregon | 41021 | 225 | 4 |
2140645 | 2140645 | 2022-01-22 | Gilliam | Oregon | 41021 | 225 | 4 |
2137389 | 2137389 | 2022-01-21 | Gilliam | Oregon | 41021 | 225 | 4 |
2124986 | 2124986 | 2022-01-17 | Throckmorton | Texas | 48447 | 225 | 7 |
2054094 | 2054094 | 2021-12-27 | Sierra | California | 6091 | 225 | 0 |
2050844 | 2050844 | 2021-12-26 | Sierra | California | 6091 | 225 | 0 |
2047594 | 2047594 | 2021-12-25 | Sierra | California | 6091 | 225 | 0 |
2044344 | 2044344 | 2021-12-24 | Sierra | California | 6091 | 225 | 0 |
2041095 | 2041095 | 2021-12-23 | Sierra | California | 6091 | 225 | 0 |
2006038 | 2006038 | 2021-12-12 | Greeley | Kansas | 20071 | 225 | 3 |
2002787 | 2002787 | 2021-12-11 | Greeley | Kansas | 20071 | 225 | 3 |
1999537 | 1999537 | 2021-12-10 | Greeley | Kansas | 20071 | 225 | 3 |
1925538 | 1925538 | 2021-11-17 | Deuel | Nebraska | 31049 | 225 | 2 |
1919115 | 1919115 | 2021-11-15 | Eureka | Nevada | 32011 | 225 | 1 |
1876712 | 1876712 | 2021-11-02 | Worth | Missouri | 29227 | 225 | 2 |
1876915 | 1876915 | 2021-11-02 | Catron | New Mexico | 35003 | 225 | 7 |
1871925 | 1871925 | 2021-11-01 | Haines Borough | Alaska | 2100 | 225 | 1 |
1873463 | 1873463 | 2021-11-01 | Worth | Missouri | 29227 | 225 | 2 |
1868676 | 1868676 | 2021-10-31 | Haines Borough | Alaska | 2100 | 225 | 1 |
1865427 | 1865427 | 2021-10-30 | Haines Borough | Alaska | 2100 | 225 | 1 |
1862178 | 1862178 | 2021-10-29 | Haines Borough | Alaska | 2100 | 225 | 1 |
1859130 | 1859130 | 2021-10-28 | Kiowa | Colorado | 8061 | 225 | 4 |
1823374 | 1823374 | 2021-10-17 | Dolores | Colorado | 8033 | 225 | 2 |
1820125 | 1820125 | 2021-10-16 | Dolores | Colorado | 8033 | 225 | 2 |
1816876 | 1816876 | 2021-10-15 | Dolores | Colorado | 8033 | 225 | 2 |
1813628 | 1813628 | 2021-10-14 | Dolores | Colorado | 8033 | 225 | 2 |
1807864 | 1807864 | 2021-10-12 | Wallace | Kansas | 20199 | 225 | 4 |
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);