ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,474 rows where cases = 121 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 175
- Montana 105
- Georgia 92
- Virginia 72
- Kentucky 70
- Colorado 49
- Puerto Rico 48
- Iowa 46
- North Dakota 44
- Michigan 38
- Missouri 37
- Illinois 36
- Indiana 36
- North Carolina 36
- Ohio 36
- Washington 36
- Nevada 35
- Oklahoma 33
- Minnesota 31
- Nebraska 31
- Kansas 30
- New York 27
- Arkansas 26
- Idaho 26
- Mississippi 24
- Louisiana 23
- Wisconsin 23
- Oregon 21
- South Dakota 21
- West Virginia 21
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502429 | 2502429 | 2022-05-13 | Terrell | Texas | 48443 | 121 | 3 |
2499171 | 2499171 | 2022-05-12 | Terrell | Texas | 48443 | 121 | 3 |
2495913 | 2495913 | 2022-05-11 | Terrell | Texas | 48443 | 121 | 3 |
2492655 | 2492655 | 2022-05-10 | Terrell | Texas | 48443 | 121 | 3 |
2489397 | 2489397 | 2022-05-09 | Terrell | Texas | 48443 | 121 | 3 |
2486139 | 2486139 | 2022-05-08 | Terrell | Texas | 48443 | 121 | 3 |
2482881 | 2482881 | 2022-05-07 | Terrell | Texas | 48443 | 121 | 3 |
2479623 | 2479623 | 2022-05-06 | Terrell | Texas | 48443 | 121 | 3 |
2476365 | 2476365 | 2022-05-05 | Terrell | Texas | 48443 | 121 | 3 |
2473108 | 2473108 | 2022-05-04 | Terrell | Texas | 48443 | 121 | 3 |
2469852 | 2469852 | 2022-05-03 | Terrell | Texas | 48443 | 121 | 3 |
2466596 | 2466596 | 2022-05-02 | Terrell | Texas | 48443 | 121 | 3 |
2463341 | 2463341 | 2022-05-01 | Terrell | Texas | 48443 | 121 | 3 |
2460085 | 2460085 | 2022-04-30 | Terrell | Texas | 48443 | 121 | 3 |
2456829 | 2456829 | 2022-04-29 | Terrell | Texas | 48443 | 121 | 3 |
2453573 | 2453573 | 2022-04-28 | Terrell | Texas | 48443 | 121 | 3 |
2450317 | 2450317 | 2022-04-27 | Terrell | Texas | 48443 | 121 | 3 |
2447060 | 2447060 | 2022-04-26 | Terrell | Texas | 48443 | 121 | 3 |
2443805 | 2443805 | 2022-04-25 | Terrell | Texas | 48443 | 121 | 3 |
2440549 | 2440549 | 2022-04-24 | Terrell | Texas | 48443 | 121 | 3 |
2437293 | 2437293 | 2022-04-23 | Terrell | Texas | 48443 | 121 | 3 |
2434037 | 2434037 | 2022-04-22 | Terrell | Texas | 48443 | 121 | 3 |
2430781 | 2430781 | 2022-04-21 | Terrell | Texas | 48443 | 121 | 3 |
2427525 | 2427525 | 2022-04-20 | Terrell | Texas | 48443 | 121 | 3 |
2424269 | 2424269 | 2022-04-19 | Terrell | Texas | 48443 | 121 | 3 |
2421013 | 2421013 | 2022-04-18 | Terrell | Texas | 48443 | 121 | 3 |
2417757 | 2417757 | 2022-04-17 | Terrell | Texas | 48443 | 121 | 3 |
2414501 | 2414501 | 2022-04-16 | Terrell | Texas | 48443 | 121 | 3 |
2411245 | 2411245 | 2022-04-15 | Terrell | Texas | 48443 | 121 | 3 |
2407989 | 2407989 | 2022-04-14 | Terrell | Texas | 48443 | 121 | 3 |
2404733 | 2404733 | 2022-04-13 | Terrell | Texas | 48443 | 121 | 3 |
2401478 | 2401478 | 2022-04-12 | Terrell | Texas | 48443 | 121 | 3 |
2398223 | 2398223 | 2022-04-11 | Terrell | Texas | 48443 | 121 | 3 |
2394968 | 2394968 | 2022-04-10 | Terrell | Texas | 48443 | 121 | 3 |
2391712 | 2391712 | 2022-04-09 | Terrell | Texas | 48443 | 121 | 3 |
2388456 | 2388456 | 2022-04-08 | Terrell | Texas | 48443 | 121 | 3 |
2385201 | 2385201 | 2022-04-07 | Terrell | Texas | 48443 | 121 | 3 |
2381946 | 2381946 | 2022-04-06 | Terrell | Texas | 48443 | 121 | 3 |
2378691 | 2378691 | 2022-04-05 | Terrell | Texas | 48443 | 121 | 3 |
2375437 | 2375437 | 2022-04-04 | Terrell | Texas | 48443 | 121 | 3 |
2372185 | 2372185 | 2022-04-03 | Terrell | Texas | 48443 | 121 | 3 |
2368932 | 2368932 | 2022-04-02 | Terrell | Texas | 48443 | 121 | 3 |
2365679 | 2365679 | 2022-04-01 | Terrell | Texas | 48443 | 121 | 3 |
2362426 | 2362426 | 2022-03-31 | Terrell | Texas | 48443 | 121 | 3 |
2359172 | 2359172 | 2022-03-30 | Terrell | Texas | 48443 | 121 | 3 |
2355918 | 2355918 | 2022-03-29 | Terrell | Texas | 48443 | 121 | 3 |
2352665 | 2352665 | 2022-03-28 | Terrell | Texas | 48443 | 121 | 3 |
2349413 | 2349413 | 2022-03-27 | Terrell | Texas | 48443 | 121 | 3 |
2346160 | 2346160 | 2022-03-26 | Terrell | Texas | 48443 | 121 | 3 |
2342907 | 2342907 | 2022-03-25 | Terrell | Texas | 48443 | 121 | 3 |
2339654 | 2339654 | 2022-03-24 | Terrell | Texas | 48443 | 121 | 3 |
2336400 | 2336400 | 2022-03-23 | Terrell | Texas | 48443 | 121 | 3 |
2332076 | 2332076 | 2022-03-22 | Storey | Nevada | 32029 | 121 | 11 |
2333146 | 2333146 | 2022-03-22 | Terrell | Texas | 48443 | 121 | 3 |
2328823 | 2328823 | 2022-03-21 | Storey | Nevada | 32029 | 121 | 11 |
2329893 | 2329893 | 2022-03-21 | Terrell | Texas | 48443 | 121 | 3 |
2325571 | 2325571 | 2022-03-20 | Storey | Nevada | 32029 | 121 | 11 |
2326641 | 2326641 | 2022-03-20 | Terrell | Texas | 48443 | 121 | 3 |
2322317 | 2322317 | 2022-03-19 | Storey | Nevada | 32029 | 121 | 11 |
2323388 | 2323388 | 2022-03-19 | Terrell | Texas | 48443 | 121 | 3 |
2319063 | 2319063 | 2022-03-18 | Storey | Nevada | 32029 | 121 | 11 |
2320134 | 2320134 | 2022-03-18 | Terrell | Texas | 48443 | 121 | 3 |
2315810 | 2315810 | 2022-03-17 | Storey | Nevada | 32029 | 121 | 11 |
2316880 | 2316880 | 2022-03-17 | Terrell | Texas | 48443 | 121 | 3 |
2312557 | 2312557 | 2022-03-16 | Storey | Nevada | 32029 | 121 | 11 |
2291537 | 2291537 | 2022-03-10 | Hinsdale | Colorado | 8053 | 121 | 0 |
2288285 | 2288285 | 2022-03-09 | Hinsdale | Colorado | 8053 | 121 | 0 |
2285034 | 2285034 | 2022-03-08 | Hinsdale | Colorado | 8053 | 121 | 0 |
2281782 | 2281782 | 2022-03-07 | Hinsdale | Colorado | 8053 | 121 | 0 |
2278529 | 2278529 | 2022-03-06 | Hinsdale | Colorado | 8053 | 121 | 0 |
2275276 | 2275276 | 2022-03-05 | Hinsdale | Colorado | 8053 | 121 | 0 |
2272023 | 2272023 | 2022-03-04 | Hinsdale | Colorado | 8053 | 121 | 0 |
2268771 | 2268771 | 2022-03-03 | Hinsdale | Colorado | 8053 | 121 | 0 |
2265518 | 2265518 | 2022-03-02 | Hinsdale | Colorado | 8053 | 121 | 0 |
2223071 | 2223071 | 2022-02-17 | Skagway Municipality | Alaska | 2230 | 121 | 0 |
2219820 | 2219820 | 2022-02-16 | Skagway Municipality | Alaska | 2230 | 121 | 0 |
2216570 | 2216570 | 2022-02-15 | Skagway Municipality | Alaska | 2230 | 121 | 0 |
2213319 | 2213319 | 2022-02-14 | Skagway Municipality | Alaska | 2230 | 121 | 0 |
2195474 | 2195474 | 2022-02-08 | Wheeler | Nebraska | 31183 | 121 | 1 |
2192220 | 2192220 | 2022-02-07 | Wheeler | Nebraska | 31183 | 121 | 1 |
2158493 | 2158493 | 2022-01-28 | Camas | Idaho | 16025 | 121 | 1 |
2155240 | 2155240 | 2022-01-27 | Camas | Idaho | 16025 | 121 | 1 |
2151987 | 2151987 | 2022-01-26 | Camas | Idaho | 16025 | 121 | 1 |
2148735 | 2148735 | 2022-01-25 | Camas | Idaho | 16025 | 121 | 1 |
2107605 | 2107605 | 2022-01-12 | Logan | Nebraska | 31113 | 121 | 0 |
2101385 | 2101385 | 2022-01-10 | Billings | North Dakota | 38007 | 121 | 1 |
2098134 | 2098134 | 2022-01-09 | Billings | North Dakota | 38007 | 121 | 1 |
2094882 | 2094882 | 2022-01-08 | Billings | North Dakota | 38007 | 121 | 1 |
2091630 | 2091630 | 2022-01-07 | Billings | North Dakota | 38007 | 121 | 1 |
2088379 | 2088379 | 2022-01-06 | Billings | North Dakota | 38007 | 121 | 1 |
2085127 | 2085127 | 2022-01-05 | Billings | North Dakota | 38007 | 121 | 1 |
2081875 | 2081875 | 2022-01-04 | Billings | North Dakota | 38007 | 121 | 1 |
2078623 | 2078623 | 2022-01-03 | Billings | North Dakota | 38007 | 121 | 1 |
2073664 | 2073664 | 2022-01-02 | San Juan | Colorado | 8111 | 121 | 0 |
2075372 | 2075372 | 2022-01-02 | Billings | North Dakota | 38007 | 121 | 1 |
2070413 | 2070413 | 2022-01-01 | San Juan | Colorado | 8111 | 121 | 0 |
2072121 | 2072121 | 2022-01-01 | Billings | North Dakota | 38007 | 121 | 1 |
2072469 | 2072469 | 2022-01-01 | Culebra | Puerto Rico | 72049 | 121 | |
2067162 | 2067162 | 2021-12-31 | San Juan | Colorado | 8111 | 121 | 0 |
2069218 | 2069218 | 2021-12-31 | Culebra | Puerto Rico | 72049 | 121 |
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);