ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 5717 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 |
---|---|---|---|---|---|---|---|
2501079 | 2501079 | 2022-05-13 | Audrain | Missouri | 29007 | 5717 | 110 |
2474505 | 2474505 | 2022-05-05 | Sumner | Kansas | 20191 | 5717 | 70 |
2471248 | 2471248 | 2022-05-04 | Sumner | Kansas | 20191 | 5717 | 70 |
2467992 | 2467992 | 2022-05-03 | Sumner | Kansas | 20191 | 5717 | 70 |
2464737 | 2464737 | 2022-05-02 | Sumner | Kansas | 20191 | 5717 | 70 |
2461481 | 2461481 | 2022-05-01 | Sumner | Kansas | 20191 | 5717 | 70 |
2458225 | 2458225 | 2022-04-30 | Sumner | Kansas | 20191 | 5717 | 70 |
2454969 | 2454969 | 2022-04-29 | Sumner | Kansas | 20191 | 5717 | 70 |
2420519 | 2420519 | 2022-04-18 | Cidra | Puerto Rico | 72041 | 5717 | |
2380310 | 2380310 | 2022-04-06 | Garrett | Maryland | 24023 | 5717 | 115 |
2377055 | 2377055 | 2022-04-05 | Garrett | Maryland | 24023 | 5717 | 115 |
2296890 | 2296890 | 2022-03-11 | Juana Diaz | Puerto Rico | 72075 | 5717 | |
2244093 | 2244093 | 2022-02-23 | Stone | Missouri | 29209 | 5717 | 108 |
2241130 | 2241130 | 2022-02-22 | Seneca | New York | 36099 | 5717 | 89 |
2180633 | 2180633 | 2022-02-03 | Kewaunee | Wisconsin | 55061 | 5717 | 53 |
2174638 | 2174638 | 2022-02-02 | Emanuel | Georgia | 13107 | 5717 | 146 |
2172397 | 2172397 | 2022-02-01 | Leake | Mississippi | 28079 | 5717 | 98 |
2154133 | 2154133 | 2022-01-26 | Gray | Texas | 48179 | 5717 | 107 |
2112299 | 2112299 | 2022-01-13 | Door | Wisconsin | 55029 | 5717 | 52 |
2035738 | 2035738 | 2021-12-21 | Mille Lacs | Minnesota | 27095 | 5717 | 88 |
2036338 | 2036338 | 2021-12-21 | Pasquotank | North Carolina | 37139 | 5717 | 110 |
1876516 | 1876516 | 2021-11-02 | Alcorn | Mississippi | 28003 | 5717 | 103 |
1860842 | 1860842 | 2021-10-28 | Scotland | North Carolina | 37165 | 5717 | 107 |
1856385 | 1856385 | 2021-10-27 | Steuben | Indiana | 18151 | 5717 | 79 |
1838971 | 1838971 | 2021-10-21 | Washington | Texas | 48477 | 5717 | 126 |
1792731 | 1792731 | 2021-10-07 | Madison | Ohio | 39097 | 5717 | 73 |
1773207 | 1773207 | 2021-10-01 | Defiance | Ohio | 39039 | 5717 | 101 |
1700389 | 1700389 | 2021-09-09 | Harrison | Indiana | 18061 | 5717 | 86 |
1697914 | 1697914 | 2021-09-08 | Butler | Missouri | 29023 | 5717 | 61 |
1647180 | 1647180 | 2021-08-23 | Jim Wells | Texas | 48249 | 5717 | 118 |
1642237 | 1642237 | 2021-08-22 | Hopkins | Kentucky | 21107 | 5717 | 157 |
1643931 | 1643931 | 2021-08-22 | Jim Wells | Texas | 48249 | 5717 | 118 |
1638987 | 1638987 | 2021-08-21 | Hopkins | Kentucky | 21107 | 5717 | 157 |
1635737 | 1635737 | 2021-08-20 | Hopkins | Kentucky | 21107 | 5717 | 157 |
1562372 | 1562372 | 2021-07-28 | Unknown | Puerto Rico | 5717 | 2574 | |
1559124 | 1559124 | 2021-07-27 | Unknown | Puerto Rico | 5717 | 2569 | |
1464815 | 1464815 | 2021-06-28 | Linn | Oregon | 41043 | 5717 | 81 |
1424875 | 1424875 | 2021-06-16 | Branch | Michigan | 26023 | 5717 | 120 |
1402750 | 1402750 | 2021-06-09 | Cattaraugus | New York | 36009 | 5717 | 91 |
1380833 | 1380833 | 2021-06-02 | Caldwell | Texas | 48055 | 5717 | 98 |
1349586 | 1349586 | 2021-05-24 | Coles | Illinois | 17029 | 5717 | 101 |
1329992 | 1329992 | 2021-05-18 | Polk | Georgia | 13233 | 5717 | 95 |
1301650 | 1301650 | 2021-05-09 | Otter Tail | Minnesota | 27111 | 5717 | 78 |
1266110 | 1266110 | 2021-04-28 | Lincoln | Missouri | 29113 | 5717 | 40 |
1260691 | 1260691 | 2021-04-26 | Atascosa | Texas | 48013 | 5717 | 150 |
1257444 | 1257444 | 2021-04-25 | Atascosa | Texas | 48013 | 5717 | 150 |
1254197 | 1254197 | 2021-04-24 | Atascosa | Texas | 48013 | 5717 | 150 |
1218122 | 1218122 | 2021-04-13 | Carbon | Pennsylvania | 42025 | 5717 | 159 |
1209617 | 1209617 | 2021-04-11 | Fremont | Colorado | 8043 | 5717 | 53 |
1192437 | 1192437 | 2021-04-05 | Lawrence | Tennessee | 47099 | 5717 | 86 |
1129434 | 1129434 | 2021-03-17 | Gratiot | Michigan | 26057 | 5717 | 108 |
1119724 | 1119724 | 2021-03-14 | Montcalm | Michigan | 26117 | 5717 | 96 |
1116477 | 1116477 | 2021-03-13 | Montcalm | Michigan | 26117 | 5717 | 96 |
1113231 | 1113231 | 2021-03-12 | Montcalm | Michigan | 26117 | 5717 | 96 |
1095023 | 1095023 | 2021-03-06 | Jefferson | Tennessee | 47089 | 5717 | 119 |
1043048 | 1043048 | 2021-02-18 | Bedford | Tennessee | 47003 | 5717 | 117 |
995436 | 995436 | 2021-02-04 | Jackson | Florida | 12063 | 5717 | 133 |
958418 | 958418 | 2021-01-23 | Crawford | Pennsylvania | 42039 | 5717 | 120 |
888774 | 888774 | 2021-01-02 | Wayne | Indiana | 18177 | 5717 | 148 |
858732 | 858732 | 2020-12-23 | Portage | Wisconsin | 55097 | 5717 | 48 |
811712 | 811712 | 2020-12-09 | Cascade | Montana | 30013 | 5717 | 79 |
451538 | 451538 | 2020-08-20 | St. Tammany | Louisiana | 22103 | 5717 | 221 |
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);