ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 5730 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kansas 16
- Missouri 10
- New York 9
- Texas 8
- North Carolina 7
- Tennessee 6
- Ohio 5
- Georgia 4
- Michigan 4
- Minnesota 4
- Nebraska 4
- Puerto Rico 4
- Utah 4
- Virginia 4
- Washington 4
- Mississippi 3
- Arkansas 2
- Indiana 2
- Colorado 1
- Illinois 1
- Maine 1
- Maryland 1
- Montana 1
- New Hampshire 1
- North Dakota 1
- Pennsylvania 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499370 | 2499370 | 2022-05-12 | Staunton city | Virginia | 51790 | 5730 | 115 |
2495451 | 2495451 | 2022-05-11 | Naranjito | Puerto Rico | 72105 | 5730 | |
2473307 | 2473307 | 2022-05-04 | Staunton city | Virginia | 51790 | 5730 | 118 |
2466795 | 2466795 | 2022-05-02 | Staunton city | Virginia | 51790 | 5730 | 118 |
2448681 | 2448681 | 2022-04-27 | Garrett | Maryland | 24023 | 5730 | 116 |
2383321 | 2383321 | 2022-04-07 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2380066 | 2380066 | 2022-04-06 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2376811 | 2376811 | 2022-04-05 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2373559 | 2373559 | 2022-04-04 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2370306 | 2370306 | 2022-04-03 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2367053 | 2367053 | 2022-04-02 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2363800 | 2363800 | 2022-04-01 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2360546 | 2360546 | 2022-03-31 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2357292 | 2357292 | 2022-03-30 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2354039 | 2354039 | 2022-03-29 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2350787 | 2350787 | 2022-03-28 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2351355 | 2351355 | 2022-03-28 | Henry | Missouri | 29083 | 5730 | 82 |
2347534 | 2347534 | 2022-03-27 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2348103 | 2348103 | 2022-03-27 | Henry | Missouri | 29083 | 5730 | 82 |
2344281 | 2344281 | 2022-03-26 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2344850 | 2344850 | 2022-03-26 | Henry | Missouri | 29083 | 5730 | 82 |
2341028 | 2341028 | 2022-03-25 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2341597 | 2341597 | 2022-03-25 | Henry | Missouri | 29083 | 5730 | 82 |
2337775 | 2337775 | 2022-03-24 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2338344 | 2338344 | 2022-03-24 | Henry | Missouri | 29083 | 5730 | 82 |
2334521 | 2334521 | 2022-03-23 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2335090 | 2335090 | 2022-03-23 | Henry | Missouri | 29083 | 5730 | 82 |
2331836 | 2331836 | 2022-03-22 | Henry | Missouri | 29083 | 5730 | 82 |
2326177 | 2326177 | 2022-03-20 | Moca | Puerto Rico | 72099 | 5730 | |
2265701 | 2265701 | 2022-03-02 | Grady | Georgia | 13131 | 5730 | 105 |
2236163 | 2236163 | 2022-02-21 | Sevier | Arkansas | 5133 | 5730 | 67 |
2221295 | 2221295 | 2022-02-16 | McDonald | Missouri | 29119 | 5730 | 64 |
2177891 | 2177891 | 2022-02-03 | Emanuel | Georgia | 13107 | 5730 | 146 |
2174339 | 2174339 | 2022-02-02 | Jackson | Arkansas | 5067 | 5730 | 49 |
2175878 | 2175878 | 2022-02-02 | Cass | Nebraska | 31025 | 5730 | 33 |
2122880 | 2122880 | 2022-01-17 | Jennings | Indiana | 18079 | 5730 | 82 |
2110564 | 2110564 | 2022-01-13 | George | Mississippi | 28039 | 5730 | 80 |
2081140 | 2081140 | 2022-01-04 | Houghton | Michigan | 26061 | 5730 | 74 |
2077888 | 2077888 | 2022-01-03 | Houghton | Michigan | 26061 | 5730 | 74 |
2055837 | 2055837 | 2021-12-27 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2052587 | 2052587 | 2021-12-26 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2053696 | 2053696 | 2021-12-26 | Okanogan | Washington | 53047 | 5730 | 104 |
2049337 | 2049337 | 2021-12-25 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2050446 | 2050446 | 2021-12-25 | Okanogan | Washington | 53047 | 5730 | 104 |
2046087 | 2046087 | 2021-12-24 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2047196 | 2047196 | 2021-12-24 | Okanogan | Washington | 53047 | 5730 | 104 |
2042837 | 2042837 | 2021-12-23 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2043946 | 2043946 | 2021-12-23 | Okanogan | Washington | 53047 | 5730 | 104 |
2039588 | 2039588 | 2021-12-22 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
1980984 | 1980984 | 2021-12-04 | Orleans | New York | 36073 | 5730 | 96 |
1962223 | 1962223 | 2021-11-28 | White | Tennessee | 47185 | 5730 | 98 |
1958972 | 1958972 | 2021-11-27 | White | Tennessee | 47185 | 5730 | 98 |
1955721 | 1955721 | 2021-11-26 | White | Tennessee | 47185 | 5730 | 98 |
1952470 | 1952470 | 2021-11-25 | White | Tennessee | 47185 | 5730 | 98 |
1949219 | 1949219 | 2021-11-24 | White | Tennessee | 47185 | 5730 | 98 |
1863646 | 1863646 | 2021-10-29 | Howell | Missouri | 29091 | 5730 | 77 |
1864003 | 1864003 | 2021-10-29 | Warren | New York | 36113 | 5730 | 86 |
1851236 | 1851236 | 2021-10-25 | Preble | Ohio | 39135 | 5730 | 125 |
1851970 | 1851970 | 2021-10-25 | Washington | Texas | 48477 | 5730 | 128 |
1847214 | 1847214 | 2021-10-24 | Isanti | Minnesota | 27059 | 5730 | 74 |
1843964 | 1843964 | 2021-10-23 | Isanti | Minnesota | 27059 | 5730 | 74 |
1840714 | 1840714 | 2021-10-22 | Isanti | Minnesota | 27059 | 5730 | 74 |
1828147 | 1828147 | 2021-10-18 | Grafton | New Hampshire | 33009 | 5730 | 30 |
1824809 | 1824809 | 2021-10-17 | Dodge | Nebraska | 31053 | 5730 | 83 |
1821560 | 1821560 | 2021-10-16 | Dodge | Nebraska | 31053 | 5730 | 83 |
1818311 | 1818311 | 2021-10-15 | Dodge | Nebraska | 31053 | 5730 | 83 |
1812971 | 1812971 | 2021-10-13 | Upshur | Texas | 48459 | 5730 | 125 |
1792718 | 1792718 | 2021-10-07 | Highland | Ohio | 39071 | 5730 | 96 |
1783686 | 1783686 | 2021-10-04 | Polk | Texas | 48373 | 5730 | 181 |
1780437 | 1780437 | 2021-10-03 | Polk | Texas | 48373 | 5730 | 181 |
1777187 | 1777187 | 2021-10-02 | Polk | Texas | 48373 | 5730 | 179 |
1773937 | 1773937 | 2021-10-01 | Polk | Texas | 48373 | 5730 | 179 |
1770687 | 1770687 | 2021-09-30 | Polk | Texas | 48373 | 5730 | 177 |
1767438 | 1767438 | 2021-09-29 | Polk | Texas | 48373 | 5730 | 176 |
1746623 | 1746623 | 2021-09-23 | Union | Mississippi | 28145 | 5730 | 86 |
1721199 | 1721199 | 2021-09-15 | Williams | North Dakota | 38105 | 5730 | 42 |
1698273 | 1698273 | 2021-09-08 | Herkimer | New York | 36043 | 5730 | 111 |
1679044 | 1679044 | 2021-09-02 | Seneca | Ohio | 39147 | 5730 | 134 |
1672815 | 1672815 | 2021-08-31 | Toa Baja | Puerto Rico | 72137 | 5730 | |
1653007 | 1653007 | 2021-08-25 | Darke | Ohio | 39037 | 5730 | 131 |
1536891 | 1536891 | 2021-07-20 | Summit | Utah | 49043 | 5730 | 15 |
1513109 | 1513109 | 2021-07-13 | Cattaraugus | New York | 36009 | 5730 | 92 |
1513196 | 1513196 | 2021-07-13 | Edgecombe | North Carolina | 37065 | 5730 | 113 |
1509863 | 1509863 | 2021-07-12 | Cattaraugus | New York | 36009 | 5730 | 92 |
1506616 | 1506616 | 2021-07-11 | Cattaraugus | New York | 36009 | 5730 | 92 |
1507646 | 1507646 | 2021-07-11 | Box Elder | Utah | 49003 | 5730 | 56 |
1503370 | 1503370 | 2021-07-10 | Cattaraugus | New York | 36009 | 5730 | 92 |
1504400 | 1504400 | 2021-07-10 | Box Elder | Utah | 49003 | 5730 | 56 |
1500124 | 1500124 | 2021-07-09 | Cattaraugus | New York | 36009 | 5730 | 92 |
1501154 | 1501154 | 2021-07-09 | Box Elder | Utah | 49003 | 5730 | 56 |
1432215 | 1432215 | 2021-06-18 | Lawrence | Ohio | 39087 | 5730 | 102 |
1352722 | 1352722 | 2021-05-25 | Polk | Georgia | 13233 | 5730 | 96 |
1349476 | 1349476 | 2021-05-24 | Polk | Georgia | 13233 | 5730 | 96 |
1322029 | 1322029 | 2021-05-15 | Columbia | Pennsylvania | 42037 | 5730 | 133 |
1304251 | 1304251 | 2021-05-10 | Henry | Indiana | 18065 | 5730 | 105 |
1286970 | 1286970 | 2021-05-04 | Augusta | Virginia | 51015 | 5730 | 70 |
1261576 | 1261576 | 2021-04-27 | Garfield | Colorado | 8045 | 5730 | 38 |
1187934 | 1187934 | 2021-04-04 | Van Buren | Michigan | 26159 | 5730 | 100 |
1184687 | 1184687 | 2021-04-03 | Van Buren | Michigan | 26159 | 5730 | 100 |
1074428 | 1074428 | 2021-02-28 | Lafayette | Mississippi | 28071 | 5730 | 113 |
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);