ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 8102 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Missouri 36
- Pennsylvania 7
- South Dakota 7
- Ohio 6
- Georgia 3
- Michigan 3
- Arkansas 2
- Indiana 2
- North Carolina 2
- Washington 2
- Alaska 1
- Arizona 1
- California 1
- Florida 1
- Illinois 1
- Maine 1
- Mississippi 1
- Oregon 1
- Utah 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475067 | 2475067 | 2022-05-05 | Laclede | Missouri | 29105 | 8102 | 176 |
2471810 | 2471810 | 2022-05-04 | Laclede | Missouri | 29105 | 8102 | 175 |
2468554 | 2468554 | 2022-05-03 | Laclede | Missouri | 29105 | 8102 | 175 |
2465298 | 2465298 | 2022-05-02 | Laclede | Missouri | 29105 | 8102 | 175 |
2462043 | 2462043 | 2022-05-01 | Laclede | Missouri | 29105 | 8102 | 175 |
2458787 | 2458787 | 2022-04-30 | Laclede | Missouri | 29105 | 8102 | 175 |
2455531 | 2455531 | 2022-04-29 | Laclede | Missouri | 29105 | 8102 | 175 |
2452275 | 2452275 | 2022-04-28 | Laclede | Missouri | 29105 | 8102 | 175 |
2449019 | 2449019 | 2022-04-27 | Laclede | Missouri | 29105 | 8102 | 175 |
2445762 | 2445762 | 2022-04-26 | Laclede | Missouri | 29105 | 8102 | 175 |
2446681 | 2446681 | 2022-04-26 | Brookings | South Dakota | 46011 | 8102 | 52 |
2442507 | 2442507 | 2022-04-25 | Laclede | Missouri | 29105 | 8102 | 175 |
2443426 | 2443426 | 2022-04-25 | Brookings | South Dakota | 46011 | 8102 | 52 |
2439251 | 2439251 | 2022-04-24 | Laclede | Missouri | 29105 | 8102 | 175 |
2440170 | 2440170 | 2022-04-24 | Brookings | South Dakota | 46011 | 8102 | 52 |
2435995 | 2435995 | 2022-04-23 | Laclede | Missouri | 29105 | 8102 | 175 |
2436914 | 2436914 | 2022-04-23 | Brookings | South Dakota | 46011 | 8102 | 52 |
2432739 | 2432739 | 2022-04-22 | Laclede | Missouri | 29105 | 8102 | 175 |
2433658 | 2433658 | 2022-04-22 | Brookings | South Dakota | 46011 | 8102 | 52 |
2429483 | 2429483 | 2022-04-21 | Laclede | Missouri | 29105 | 8102 | 175 |
2430402 | 2430402 | 2022-04-21 | Brookings | South Dakota | 46011 | 8102 | 52 |
2426227 | 2426227 | 2022-04-20 | Laclede | Missouri | 29105 | 8102 | 175 |
2427146 | 2427146 | 2022-04-20 | Brookings | South Dakota | 46011 | 8102 | 52 |
2422971 | 2422971 | 2022-04-19 | Laclede | Missouri | 29105 | 8102 | 175 |
2419714 | 2419714 | 2022-04-18 | Laclede | Missouri | 29105 | 8102 | 175 |
2416459 | 2416459 | 2022-04-17 | Laclede | Missouri | 29105 | 8102 | 175 |
2413203 | 2413203 | 2022-04-16 | Laclede | Missouri | 29105 | 8102 | 175 |
2409947 | 2409947 | 2022-04-15 | Laclede | Missouri | 29105 | 8102 | 175 |
2406691 | 2406691 | 2022-04-14 | Laclede | Missouri | 29105 | 8102 | 175 |
2403435 | 2403435 | 2022-04-13 | Laclede | Missouri | 29105 | 8102 | 175 |
2400180 | 2400180 | 2022-04-12 | Laclede | Missouri | 29105 | 8102 | 175 |
2400951 | 2400951 | 2022-04-12 | Snyder | Pennsylvania | 42109 | 8102 | 156 |
2396925 | 2396925 | 2022-04-11 | Laclede | Missouri | 29105 | 8102 | 175 |
2393670 | 2393670 | 2022-04-10 | Laclede | Missouri | 29105 | 8102 | 175 |
2390414 | 2390414 | 2022-04-09 | Laclede | Missouri | 29105 | 8102 | 175 |
2387158 | 2387158 | 2022-04-08 | Laclede | Missouri | 29105 | 8102 | 175 |
2383903 | 2383903 | 2022-04-07 | Laclede | Missouri | 29105 | 8102 | 175 |
2380648 | 2380648 | 2022-04-06 | Laclede | Missouri | 29105 | 8102 | 175 |
2377393 | 2377393 | 2022-04-05 | Laclede | Missouri | 29105 | 8102 | 175 |
2374140 | 2374140 | 2022-04-04 | Laclede | Missouri | 29105 | 8102 | 175 |
2370888 | 2370888 | 2022-04-03 | Laclede | Missouri | 29105 | 8102 | 175 |
2367635 | 2367635 | 2022-04-02 | Laclede | Missouri | 29105 | 8102 | 175 |
2364382 | 2364382 | 2022-04-01 | Laclede | Missouri | 29105 | 8102 | 175 |
2361128 | 2361128 | 2022-03-31 | Laclede | Missouri | 29105 | 8102 | 175 |
2240712 | 2240712 | 2022-02-22 | Prentiss | Mississippi | 28117 | 8102 | 99 |
2242138 | 2242138 | 2022-02-22 | Sanpete | Utah | 49039 | 8102 | 50 |
2199882 | 2199882 | 2022-02-09 | Franklin | Vermont | 50011 | 8102 | 59 |
2111206 | 2111206 | 2022-01-13 | Clinton | Ohio | 39027 | 8102 | 121 |
2091950 | 2091950 | 2022-01-07 | Wayne | Pennsylvania | 42127 | 8102 | 144 |
2012347 | 2012347 | 2021-12-14 | Huntington | Indiana | 18069 | 8102 | 121 |
1984417 | 1984417 | 2021-12-05 | Ashland | Ohio | 39005 | 8102 | 152 |
1932425 | 1932425 | 2021-11-19 | Darke | Ohio | 39037 | 8102 | 176 |
1812217 | 1812217 | 2021-10-13 | Huron | Ohio | 39077 | 8102 | 138 |
1804337 | 1804337 | 2021-10-11 | Dearborn | Indiana | 18029 | 8102 | 96 |
1790779 | 1790779 | 2021-10-07 | Mississippi | Arkansas | 5093 | 8102 | 130 |
1791901 | 1791901 | 2021-10-07 | Isabella | Michigan | 26073 | 8102 | 108 |
1788652 | 1788652 | 2021-10-06 | Isabella | Michigan | 26073 | 8102 | 108 |
1783139 | 1783139 | 2021-10-04 | Yamhill | Oregon | 41071 | 8102 | 104 |
1779922 | 1779922 | 2021-10-03 | Indiana | Pennsylvania | 42063 | 8102 | 198 |
1742413 | 1742413 | 2021-09-22 | Tift | Georgia | 13277 | 8102 | 155 |
1561957 | 1561957 | 2021-07-28 | Stanly | North Carolina | 37167 | 8102 | 138 |
1539321 | 1539321 | 2021-07-21 | Erie | Ohio | 39043 | 8102 | 166 |
1495137 | 1495137 | 2021-07-08 | Santa Cruz | Arizona | 4023 | 8102 | 181 |
1401070 | 1401070 | 2021-06-09 | Pope | Arkansas | 5115 | 8102 | 110 |
1360009 | 1360009 | 2021-05-27 | Montcalm | Michigan | 26117 | 8102 | 117 |
1337167 | 1337167 | 2021-05-20 | Androscoggin | Maine | 23001 | 8102 | 78 |
1235786 | 1235786 | 2021-04-19 | Gordon | Georgia | 13129 | 8102 | 111 |
1212443 | 1212443 | 2021-04-11 | Thurston | Washington | 53067 | 8102 | 85 |
1209194 | 1209194 | 2021-04-10 | Thurston | Washington | 53067 | 8102 | 85 |
1130273 | 1130273 | 2021-03-17 | Marion | Ohio | 39101 | 8102 | 132 |
958443 | 958443 | 2021-01-23 | Monroe | Pennsylvania | 42089 | 8102 | 237 |
914299 | 914299 | 2021-01-10 | Indian River | Florida | 12061 | 8102 | 178 |
888213 | 888213 | 2021-01-02 | Shasta | California | 6089 | 8102 | 78 |
865749 | 865749 | 2020-12-26 | Lowndes | Georgia | 13185 | 8102 | 135 |
859424 | 859424 | 2020-12-24 | Kendall | Illinois | 17093 | 8102 | 69 |
701706 | 701706 | 2020-11-05 | Gaston | North Carolina | 37071 | 8102 | 144 |
680377 | 680377 | 2020-10-30 | Anchorage | Alaska | 2020 | 8102 | 48 |
637151 | 637151 | 2020-10-16 | Berks | Pennsylvania | 42011 | 8102 | 411 |
595022 | 595022 | 2020-10-03 | Lancaster | Pennsylvania | 42071 | 8102 | 459 |
591781 | 591781 | 2020-10-02 | Lancaster | Pennsylvania | 42071 | 8102 | 459 |
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);