ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 9999 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423409 | 2423409 | 2022-04-19 | Scotland | North Carolina | 37165 | 9999 | 126 |
2420152 | 2420152 | 2022-04-18 | Scotland | North Carolina | 37165 | 9999 | 126 |
2416897 | 2416897 | 2022-04-17 | Scotland | North Carolina | 37165 | 9999 | 126 |
2413641 | 2413641 | 2022-04-16 | Scotland | North Carolina | 37165 | 9999 | 126 |
2410385 | 2410385 | 2022-04-15 | Scotland | North Carolina | 37165 | 9999 | 126 |
2407129 | 2407129 | 2022-04-14 | Scotland | North Carolina | 37165 | 9999 | 126 |
2403873 | 2403873 | 2022-04-13 | Scotland | North Carolina | 37165 | 9999 | 126 |
2398696 | 2398696 | 2022-04-12 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2395441 | 2395441 | 2022-04-11 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2392185 | 2392185 | 2022-04-10 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2388929 | 2388929 | 2022-04-09 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2385674 | 2385674 | 2022-04-08 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2382419 | 2382419 | 2022-04-07 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2379164 | 2379164 | 2022-04-06 | Bethel Census Area | Alaska | 2050 | 9999 | 41 |
2308154 | 2308154 | 2022-03-15 | Fulton | Illinois | 17057 | 9999 | 135 |
2265301 | 2265301 | 2022-03-02 | Russell | Alabama | 1113 | 9999 | 79 |
2240328 | 2240328 | 2022-02-22 | Muhlenberg | Kentucky | 21177 | 9999 | 114 |
2127068 | 2127068 | 2022-01-18 | Buffalo | Nebraska | 31019 | 9999 | 89 |
2074344 | 2074344 | 2022-01-02 | Saline | Kansas | 20169 | 9999 | 204 |
2071093 | 2071093 | 2022-01-01 | Saline | Kansas | 20169 | 9999 | 204 |
2067842 | 2067842 | 2021-12-31 | Saline | Kansas | 20169 | 9999 | 204 |
2064591 | 2064591 | 2021-12-30 | Saline | Kansas | 20169 | 9999 | 204 |
2061341 | 2061341 | 2021-12-29 | Saline | Kansas | 20169 | 9999 | 204 |
1988492 | 1988492 | 2021-12-06 | Iron | Utah | 49021 | 9999 | 66 |
1985242 | 1985242 | 2021-12-05 | Iron | Utah | 49021 | 9999 | 66 |
1981992 | 1981992 | 2021-12-04 | Iron | Utah | 49021 | 9999 | 66 |
1978742 | 1978742 | 2021-12-03 | Iron | Utah | 49021 | 9999 | 66 |
1785303 | 1785303 | 2021-10-05 | Vermilion | Louisiana | 22113 | 9999 | 180 |
1615221 | 1615221 | 2021-08-14 | DeKalb | Alabama | 1049 | 9999 | 197 |
1611972 | 1611972 | 2021-08-13 | DeKalb | Alabama | 1049 | 9999 | 197 |
1577282 | 1577282 | 2021-08-02 | Madison | Kentucky | 21151 | 9999 | 113 |
1503576 | 1503576 | 2021-07-10 | Ward | North Dakota | 38101 | 9999 | 200 |
1310404 | 1310404 | 2021-05-12 | Barrow | Georgia | 13013 | 9999 | 139 |
1159406 | 1159406 | 2021-03-26 | Grand Forks | North Dakota | 38035 | 9999 | 76 |
1122543 | 1122543 | 2021-03-15 | Pottawattamie | Iowa | 19155 | 9999 | 149 |
1115507 | 1115507 | 2021-03-13 | Citrus | Florida | 12017 | 9999 | 415 |
1109181 | 1109181 | 2021-03-11 | Newton | Georgia | 13217 | 9999 | 210 |
1071847 | 1071847 | 2021-02-27 | Miami | Ohio | 39109 | 9999 | 189 |
1039405 | 1039405 | 2021-02-17 | Richland | Ohio | 39139 | 9999 | 180 |
907241 | 907241 | 2021-01-07 | Richmond city | Virginia | 51760 | 9999 | 101 |
790582 | 790582 | 2020-12-02 | Rock | Wisconsin | 55105 | 9999 | 93 |
688329 | 688329 | 2020-11-01 | Greene | Missouri | 29077 | 9999 | 154 |
685085 | 685085 | 2020-10-31 | Greene | Missouri | 29077 | 9999 | 154 |
681842 | 681842 | 2020-10-30 | Greene | Missouri | 29077 | 9999 | 154 |
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);