ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 7459 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Ohio 10
- Florida 8
- Nevada 7
- Indiana 6
- Minnesota 4
- Texas 4
- Louisiana 3
- Mississippi 3
- Oregon 3
- New York 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Massachusetts 1
- Missouri 1
- North Carolina 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449598 | 2449598 | 2022-04-27 | Pike | Ohio | 39131 | 7459 | 121 |
2446341 | 2446341 | 2022-04-26 | Pike | Ohio | 39131 | 7459 | 121 |
2443086 | 2443086 | 2022-04-25 | Pike | Ohio | 39131 | 7459 | 121 |
2439830 | 2439830 | 2022-04-24 | Pike | Ohio | 39131 | 7459 | 121 |
2436574 | 2436574 | 2022-04-23 | Pike | Ohio | 39131 | 7459 | 121 |
2433318 | 2433318 | 2022-04-22 | Pike | Ohio | 39131 | 7459 | 121 |
2430062 | 2430062 | 2022-04-21 | Pike | Ohio | 39131 | 7459 | 121 |
2400405 | 2400405 | 2022-04-12 | Nye | Nevada | 32023 | 7459 | 239 |
2397150 | 2397150 | 2022-04-11 | Nye | Nevada | 32023 | 7459 | 239 |
2393895 | 2393895 | 2022-04-10 | Nye | Nevada | 32023 | 7459 | 239 |
2390639 | 2390639 | 2022-04-09 | Nye | Nevada | 32023 | 7459 | 239 |
2387383 | 2387383 | 2022-04-08 | Nye | Nevada | 32023 | 7459 | 239 |
2384128 | 2384128 | 2022-04-07 | Nye | Nevada | 32023 | 7459 | 239 |
2380873 | 2380873 | 2022-04-06 | Nye | Nevada | 32023 | 7459 | 239 |
2382039 | 2382039 | 2022-04-06 | Botetourt | Virginia | 51023 | 7459 | 96 |
2349870 | 2349870 | 2022-03-28 | Pike | Alabama | 1109 | 7459 | 133 |
2304991 | 2304991 | 2022-03-14 | Daviess | Indiana | 18027 | 7459 | 150 |
2303391 | 2303391 | 2022-03-13 | Humacao | Puerto Rico | 72069 | 7459 | |
2280493 | 2280493 | 2022-03-06 | Columbia | Oregon | 41009 | 7459 | 75 |
2277240 | 2277240 | 2022-03-05 | Columbia | Oregon | 41009 | 7459 | 75 |
2273987 | 2273987 | 2022-03-04 | Columbia | Oregon | 41009 | 7459 | 75 |
2215089 | 2215089 | 2022-02-14 | Delaware | New York | 36025 | 7459 | 68 |
2174970 | 2174970 | 2022-02-02 | Scott | Indiana | 18143 | 7459 | 93 |
2123512 | 2123512 | 2022-01-17 | Morrison | Minnesota | 27097 | 7459 | 92 |
2120260 | 2120260 | 2022-01-16 | Morrison | Minnesota | 27097 | 7459 | 92 |
2117008 | 2117008 | 2022-01-15 | Morrison | Minnesota | 27097 | 7459 | 92 |
2113757 | 2113757 | 2022-01-14 | Morrison | Minnesota | 27097 | 7459 | 92 |
2073544 | 2073544 | 2022-01-02 | Unknown | Arkansas | 7459 | 0 | |
2061823 | 2061823 | 2021-12-29 | Monroe | Mississippi | 28095 | 7459 | 183 |
2018839 | 2018839 | 2021-12-16 | Gibson | Indiana | 18051 | 7459 | 124 |
1980973 | 1980973 | 2021-12-04 | Livingston | New York | 36051 | 7459 | 77 |
1974739 | 1974739 | 2021-12-02 | Shelby | Ohio | 39149 | 7459 | 133 |
1942153 | 1942153 | 2021-11-22 | Williams | North Dakota | 38105 | 7459 | 54 |
1857096 | 1857096 | 2021-10-27 | Washington | Mississippi | 28151 | 7459 | 161 |
1813905 | 1813905 | 2021-10-14 | Ware | Georgia | 13299 | 7459 | 240 |
1814079 | 1814079 | 2021-10-14 | Cass | Indiana | 18017 | 7459 | 121 |
1757148 | 1757148 | 2021-09-26 | Armstrong | Pennsylvania | 42005 | 7459 | 164 |
1643314 | 1643314 | 2021-08-22 | Ross | Ohio | 39141 | 7459 | 166 |
1558269 | 1558269 | 2021-07-27 | Joplin | Missouri | 7459 | 119 | |
1493766 | 1493766 | 2021-07-07 | Rutherford | North Carolina | 37161 | 7459 | 218 |
1427206 | 1427206 | 2021-06-17 | Flagler | Florida | 12035 | 7459 | 114 |
1423961 | 1423961 | 2021-06-16 | Flagler | Florida | 12035 | 7459 | 114 |
1426492 | 1426492 | 2021-06-16 | Wise | Texas | 48497 | 7459 | 124 |
1420713 | 1420713 | 2021-06-15 | Flagler | Florida | 12035 | 7459 | 114 |
1423245 | 1423245 | 2021-06-15 | Wise | Texas | 48497 | 7459 | 124 |
1417468 | 1417468 | 2021-06-14 | Flagler | Florida | 12035 | 7459 | 114 |
1414222 | 1414222 | 2021-06-13 | Flagler | Florida | 12035 | 7459 | 114 |
1410977 | 1410977 | 2021-06-12 | Flagler | Florida | 12035 | 7459 | 114 |
1407732 | 1407732 | 2021-06-11 | Flagler | Florida | 12035 | 7459 | 114 |
1355802 | 1355802 | 2021-05-26 | Flagler | Florida | 12035 | 7459 | 112 |
1344921 | 1344921 | 2021-05-22 | Laurens | South Carolina | 45059 | 7459 | 170 |
1330279 | 1330279 | 2021-05-18 | Wayne | Indiana | 18177 | 7459 | 203 |
1274273 | 1274273 | 2021-04-30 | Wood | Wisconsin | 55141 | 7459 | 92 |
1096488 | 1096488 | 2021-03-07 | Warrick | Indiana | 18173 | 7459 | 156 |
1083951 | 1083951 | 2021-03-03 | Hampshire | Massachusetts | 25015 | 7459 | 262 |
1010922 | 1010922 | 2021-02-08 | Val Verde | Texas | 48465 | 7459 | 183 |
958247 | 958247 | 2021-01-23 | Marion | Ohio | 39101 | 7459 | 113 |
827766 | 827766 | 2020-12-14 | Jackson | Mississippi | 28059 | 7459 | 142 |
811265 | 811265 | 2020-12-09 | Tangipahoa | Louisiana | 22105 | 7459 | 147 |
806209 | 806209 | 2020-12-07 | Sullivan | Tennessee | 47163 | 7459 | 120 |
582506 | 582506 | 2020-09-29 | Jefferson | Texas | 48245 | 7459 | 133 |
250591 | 250591 | 2020-06-18 | Orleans | Louisiana | 22071 | 7459 | 523 |
247479 | 247479 | 2020-06-17 | Orleans | Louisiana | 22071 | 7459 | 523 |
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);