ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 13584 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Kentucky 8
- Oklahoma 7
- Indiana 5
- New York 3
- Florida 2
- Georgia 2
- Michigan 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Connecticut 1
- Maine 1
- Mississippi 1
- New Mexico 1
- North Dakota 1
- Ohio 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472419 | 2472419 | 2022-05-04 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2469163 | 2469163 | 2022-05-03 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2465907 | 2465907 | 2022-05-02 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2462652 | 2462652 | 2022-05-01 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2459396 | 2459396 | 2022-04-30 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2456140 | 2456140 | 2022-04-29 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2452884 | 2452884 | 2022-04-28 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2376616 | 2376616 | 2022-04-05 | Shelby | Indiana | 18145 | 13584 | 181 |
2373364 | 2373364 | 2022-04-04 | Shelby | Indiana | 18145 | 13584 | 181 |
2370373 | 2370373 | 2022-04-03 | Franklin | Kentucky | 21073 | 13584 | 143 |
2367120 | 2367120 | 2022-04-02 | Franklin | Kentucky | 21073 | 13584 | 143 |
2363867 | 2363867 | 2022-04-01 | Franklin | Kentucky | 21073 | 13584 | 143 |
2360613 | 2360613 | 2022-03-31 | Franklin | Kentucky | 21073 | 13584 | 143 |
2357359 | 2357359 | 2022-03-30 | Franklin | Kentucky | 21073 | 13584 | 143 |
2354106 | 2354106 | 2022-03-29 | Franklin | Kentucky | 21073 | 13584 | 143 |
2350854 | 2350854 | 2022-03-28 | Franklin | Kentucky | 21073 | 13584 | 143 |
2330269 | 2330269 | 2022-03-21 | Waupaca | Wisconsin | 55135 | 13584 | 249 |
2319151 | 2319151 | 2022-03-18 | Genesee | New York | 36037 | 13584 | 184 |
2308796 | 2308796 | 2022-03-15 | Gratiot | Michigan | 26057 | 13584 | 182 |
2305545 | 2305545 | 2022-03-14 | Gratiot | Michigan | 26057 | 13584 | 182 |
2293134 | 2293134 | 2022-03-10 | Herkimer | New York | 36043 | 13584 | 189 |
2206853 | 2206853 | 2022-02-12 | Crittenden | Arkansas | 5035 | 13584 | 206 |
2178539 | 2178539 | 2022-02-03 | Nelson | Kentucky | 21179 | 13584 | 127 |
2130744 | 2130744 | 2022-01-19 | Huron | Ohio | 39077 | 13584 | 182 |
2005840 | 2005840 | 2021-12-12 | Hancock | Indiana | 18059 | 13584 | 194 |
2002589 | 2002589 | 2021-12-11 | Hancock | Indiana | 18059 | 13584 | 194 |
1999339 | 1999339 | 2021-12-10 | Hancock | Indiana | 18059 | 13584 | 194 |
1899279 | 1899279 | 2021-11-09 | Forrest | Mississippi | 28035 | 13584 | 255 |
1702826 | 1702826 | 2021-09-09 | Eau Claire | Wisconsin | 55035 | 13584 | 129 |
1515708 | 1515708 | 2021-07-14 | York | Maine | 23031 | 13584 | 134 |
1468416 | 1468416 | 2021-06-29 | Sevier | Tennessee | 47155 | 13584 | 177 |
1104028 | 1104028 | 2021-03-09 | San Juan | New Mexico | 35045 | 13584 | 450 |
1086399 | 1086399 | 2021-03-04 | Douglas | Georgia | 13097 | 13584 | 184 |
963053 | 963053 | 2021-01-25 | Columbia | Georgia | 13073 | 13584 | 135 |
913119 | 913119 | 2021-01-09 | Anderson | South Carolina | 45007 | 13584 | 301 |
877013 | 877013 | 2020-12-29 | Burleigh | North Dakota | 38015 | 13584 | 172 |
691897 | 691897 | 2020-11-02 | Erie | New York | 36029 | 13584 | 655 |
680645 | 680645 | 2020-10-30 | Escambia | Florida | 12033 | 13584 | 271 |
664201 | 664201 | 2020-10-25 | Yuma | Arizona | 4027 | 13584 | 354 |
473284 | 473284 | 2020-08-27 | New Haven | Connecticut | 9009 | 13584 | 1109 |
121629 | 121629 | 2020-05-07 | Miami-Dade | Florida | 12086 | 13584 | 454 |
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);