ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
661 rows where cases = 536 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 58
- Georgia 56
- Texas 53
- Nebraska 39
- Iowa 34
- Missouri 32
- Virginia 27
- Kansas 25
- Kentucky 24
- Alabama 21
- Minnesota 20
- Montana 20
- Puerto Rico 16
- Alaska 15
- Idaho 15
- Mississippi 15
- South Dakota 13
- Arkansas 12
- North Carolina 12
- Tennessee 11
- West Virginia 11
- Illinois 10
- Indiana 10
- Michigan 10
- Oklahoma 10
- Louisiana 9
- Oregon 9
- South Carolina 9
- Ohio 7
- New Mexico 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499969 | 2499969 | 2022-05-13 | Baker | Georgia | 13007 | 536 | 15 |
2496711 | 2496711 | 2022-05-12 | Baker | Georgia | 13007 | 536 | 15 |
2497954 | 2497954 | 2022-05-12 | Granite | Montana | 30039 | 536 | 9 |
2493453 | 2493453 | 2022-05-11 | Baker | Georgia | 13007 | 536 | 15 |
2494696 | 2494696 | 2022-05-11 | Granite | Montana | 30039 | 536 | 9 |
2490195 | 2490195 | 2022-05-10 | Baker | Georgia | 13007 | 536 | 15 |
2491438 | 2491438 | 2022-05-10 | Granite | Montana | 30039 | 536 | 9 |
2486938 | 2486938 | 2022-05-09 | Baker | Georgia | 13007 | 536 | 15 |
2488180 | 2488180 | 2022-05-09 | Granite | Montana | 30039 | 536 | 9 |
2483680 | 2483680 | 2022-05-08 | Baker | Georgia | 13007 | 536 | 15 |
2484923 | 2484923 | 2022-05-08 | Granite | Montana | 30039 | 536 | 9 |
2480422 | 2480422 | 2022-05-07 | Baker | Georgia | 13007 | 536 | 15 |
2481665 | 2481665 | 2022-05-07 | Granite | Montana | 30039 | 536 | 9 |
2477164 | 2477164 | 2022-05-06 | Baker | Georgia | 13007 | 536 | 15 |
2478407 | 2478407 | 2022-05-06 | Granite | Montana | 30039 | 536 | 9 |
2473906 | 2473906 | 2022-05-05 | Baker | Georgia | 13007 | 536 | 15 |
2475149 | 2475149 | 2022-05-05 | Granite | Montana | 30039 | 536 | 9 |
2470649 | 2470649 | 2022-05-04 | Baker | Georgia | 13007 | 536 | 15 |
2471892 | 2471892 | 2022-05-04 | Granite | Montana | 30039 | 536 | 9 |
2467393 | 2467393 | 2022-05-03 | Baker | Georgia | 13007 | 536 | 15 |
2468636 | 2468636 | 2022-05-03 | Granite | Montana | 30039 | 536 | 9 |
2464138 | 2464138 | 2022-05-02 | Baker | Georgia | 13007 | 536 | 15 |
2465380 | 2465380 | 2022-05-02 | Granite | Montana | 30039 | 536 | 9 |
2460882 | 2460882 | 2022-05-01 | Baker | Georgia | 13007 | 536 | 15 |
2457626 | 2457626 | 2022-04-30 | Baker | Georgia | 13007 | 536 | 15 |
2454370 | 2454370 | 2022-04-29 | Baker | Georgia | 13007 | 536 | 15 |
2451114 | 2451114 | 2022-04-28 | Baker | Georgia | 13007 | 536 | 15 |
2447858 | 2447858 | 2022-04-27 | Baker | Georgia | 13007 | 536 | 15 |
2444602 | 2444602 | 2022-04-26 | Baker | Georgia | 13007 | 536 | 15 |
2441346 | 2441346 | 2022-04-25 | Baker | Georgia | 13007 | 536 | 15 |
2438090 | 2438090 | 2022-04-24 | Baker | Georgia | 13007 | 536 | 15 |
2434834 | 2434834 | 2022-04-23 | Baker | Georgia | 13007 | 536 | 15 |
2431578 | 2431578 | 2022-04-22 | Baker | Georgia | 13007 | 536 | 15 |
2428322 | 2428322 | 2022-04-21 | Baker | Georgia | 13007 | 536 | 15 |
2425066 | 2425066 | 2022-04-20 | Baker | Georgia | 13007 | 536 | 15 |
2421810 | 2421810 | 2022-04-19 | Baker | Georgia | 13007 | 536 | 15 |
2418554 | 2418554 | 2022-04-18 | Baker | Georgia | 13007 | 536 | 15 |
2415298 | 2415298 | 2022-04-17 | Baker | Georgia | 13007 | 536 | 15 |
2412042 | 2412042 | 2022-04-16 | Baker | Georgia | 13007 | 536 | 15 |
2408786 | 2408786 | 2022-04-15 | Baker | Georgia | 13007 | 536 | 15 |
2318970 | 2318970 | 2022-03-18 | Cherry | Nebraska | 31031 | 536 | 8 |
2315717 | 2315717 | 2022-03-17 | Cherry | Nebraska | 31031 | 536 | 8 |
2240924 | 2240924 | 2022-02-22 | Cherry | Nebraska | 31031 | 536 | 8 |
2237673 | 2237673 | 2022-02-21 | Cherry | Nebraska | 31031 | 536 | 8 |
2234422 | 2234422 | 2022-02-20 | Cherry | Nebraska | 31031 | 536 | 8 |
2231171 | 2231171 | 2022-02-19 | Cherry | Nebraska | 31031 | 536 | 8 |
2227920 | 2227920 | 2022-02-18 | Cherry | Nebraska | 31031 | 536 | 8 |
2224669 | 2224669 | 2022-02-17 | Cherry | Nebraska | 31031 | 536 | 8 |
2221418 | 2221418 | 2022-02-16 | Cherry | Nebraska | 31031 | 536 | 8 |
2218167 | 2218167 | 2022-02-15 | Cherry | Nebraska | 31031 | 536 | 8 |
2218862 | 2218862 | 2022-02-15 | Maricao | Puerto Rico | 72093 | 536 | |
2214916 | 2214916 | 2022-02-14 | Cherry | Nebraska | 31031 | 536 | 8 |
2215611 | 2215611 | 2022-02-14 | Maricao | Puerto Rico | 72093 | 536 | |
2156676 | 2156676 | 2022-01-27 | Adams | North Dakota | 38001 | 536 | 9 |
2157395 | 2157395 | 2022-01-27 | Hardeman | Texas | 48197 | 536 | 14 |
2150685 | 2150685 | 2022-01-25 | Sanborn | South Dakota | 46111 | 536 | 5 |
2137850 | 2137850 | 2022-01-21 | Fisher | Texas | 48151 | 536 | 20 |
2085639 | 2085639 | 2022-01-05 | Stanley | South Dakota | 46117 | 536 | 3 |
2074927 | 2074927 | 2022-01-02 | Mercer | Missouri | 29129 | 536 | 10 |
2071676 | 2071676 | 2022-01-01 | Mercer | Missouri | 29129 | 536 | 10 |
2068425 | 2068425 | 2021-12-31 | Mercer | Missouri | 29129 | 536 | 10 |
2065174 | 2065174 | 2021-12-30 | Mercer | Missouri | 29129 | 536 | 10 |
2061924 | 2061924 | 2021-12-29 | Mercer | Missouri | 29129 | 536 | 10 |
2058675 | 2058675 | 2021-12-28 | Mercer | Missouri | 29129 | 536 | 10 |
2056777 | 2056777 | 2021-12-27 | Grand Isle | Vermont | 50013 | 536 | 3 |
2053128 | 2053128 | 2021-12-26 | Perkins | South Dakota | 46105 | 536 | 16 |
2049878 | 2049878 | 2021-12-25 | Perkins | South Dakota | 46105 | 536 | 16 |
2046628 | 2046628 | 2021-12-24 | Perkins | South Dakota | 46105 | 536 | 16 |
2043378 | 2043378 | 2021-12-23 | Perkins | South Dakota | 46105 | 536 | 16 |
2039644 | 2039644 | 2021-12-22 | McIntosh | North Dakota | 38051 | 536 | 9 |
2030800 | 2030800 | 2021-12-19 | Bath | Virginia | 51017 | 536 | 15 |
2027549 | 2027549 | 2021-12-18 | Bath | Virginia | 51017 | 536 | 15 |
2024298 | 2024298 | 2021-12-17 | Bath | Virginia | 51017 | 536 | 15 |
1995444 | 1995444 | 2021-12-09 | Unknown | Alaska | 536 | 1 | |
1992193 | 1992193 | 2021-12-08 | Unknown | Alaska | 536 | 1 | |
1993469 | 1993469 | 2021-12-08 | Lake of the Woods | Minnesota | 27077 | 536 | 5 |
1991687 | 1991687 | 2021-12-07 | Shackelford | Texas | 48417 | 536 | 7 |
1983979 | 1983979 | 2021-12-05 | Fallon | Montana | 30025 | 536 | 8 |
1980729 | 1980729 | 2021-12-04 | Fallon | Montana | 30025 | 536 | 8 |
1977479 | 1977479 | 2021-12-03 | Fallon | Montana | 30025 | 536 | 8 |
1974229 | 1974229 | 2021-12-02 | Fallon | Montana | 30025 | 536 | 8 |
1971115 | 1971115 | 2021-12-01 | Webster | Nebraska | 31181 | 536 | 9 |
1959690 | 1959690 | 2021-11-28 | Unknown | Alaska | 536 | 1 | |
1956439 | 1956439 | 2021-11-27 | Unknown | Alaska | 536 | 1 | |
1953188 | 1953188 | 2021-11-26 | Unknown | Alaska | 536 | 1 | |
1949937 | 1949937 | 2021-11-25 | Unknown | Alaska | 536 | 1 | |
1951507 | 1951507 | 2021-11-25 | Sheridan | Montana | 30091 | 536 | 8 |
1946686 | 1946686 | 2021-11-24 | Unknown | Alaska | 536 | 1 | |
1948256 | 1948256 | 2021-11-24 | Sheridan | Montana | 30091 | 536 | 8 |
1911403 | 1911403 | 2021-11-13 | Adams | Idaho | 16003 | 536 | 12 |
1903373 | 1903373 | 2021-11-10 | Cameron | Pennsylvania | 42023 | 536 | 11 |
1880363 | 1880363 | 2021-11-03 | Cavalier | North Dakota | 38019 | 536 | 5 |
1857624 | 1857624 | 2021-10-27 | Eddy | North Dakota | 38027 | 536 | 6 |
1834522 | 1834522 | 2021-10-20 | Sweet Grass | Montana | 30097 | 536 | 7 |
1831273 | 1831273 | 2021-10-19 | Sweet Grass | Montana | 30097 | 536 | 7 |
1828398 | 1828398 | 2021-10-18 | Nelson | North Dakota | 38063 | 536 | 16 |
1824847 | 1824847 | 2021-10-17 | Nuckolls | Nebraska | 31129 | 536 | 12 |
1825149 | 1825149 | 2021-10-17 | Nelson | North Dakota | 38063 | 536 | 16 |
1821598 | 1821598 | 2021-10-16 | Nuckolls | Nebraska | 31129 | 536 | 12 |
1821900 | 1821900 | 2021-10-16 | Nelson | North Dakota | 38063 | 536 | 16 |
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);