ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where cases = 4434 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- North Carolina 13
- Louisiana 9
- Texas 8
- Mississippi 7
- Arkansas 6
- Georgia 6
- New York 6
- Ohio 5
- Kentucky 4
- Nevada 4
- Virginia 4
- Illinois 3
- Missouri 3
- Tennessee 3
- Indiana 2
- Wisconsin 2
- Alabama 1
- California 1
- Connecticut 1
- Idaho 1
- Iowa 1
- Maine 1
- Michigan 1
- Montana 1
- Nebraska 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469946 | 2469946 | 2022-05-03 | Bristol city | Virginia | 51520 | 4434 | 80 |
2320674 | 2320674 | 2022-03-19 | Grant | Arkansas | 5053 | 4434 | 59 |
2266315 | 2266315 | 2022-03-02 | Lewis | Kentucky | 21135 | 4434 | 79 |
2258777 | 2258777 | 2022-02-28 | Henry | Alabama | 1067 | 4434 | 69 |
2256000 | 2256000 | 2022-02-27 | Putnam | Georgia | 13237 | 4434 | 100 |
2252749 | 2252749 | 2022-02-26 | Putnam | Georgia | 13237 | 4434 | 100 |
2249498 | 2249498 | 2022-02-25 | Putnam | Georgia | 13237 | 4434 | 100 |
2247375 | 2247375 | 2022-02-24 | Hill | Montana | 30041 | 4434 | 72 |
2236476 | 2236476 | 2022-02-21 | Meriwether | Georgia | 13199 | 4434 | 134 |
2219871 | 2219871 | 2022-02-16 | Hempstead | Arkansas | 5057 | 4434 | 54 |
2222092 | 2222092 | 2022-02-16 | Fajardo | Puerto Rico | 72053 | 4434 | |
2190028 | 2190028 | 2022-02-06 | Robertson | Texas | 48395 | 4434 | 71 |
2141822 | 2141822 | 2022-01-23 | Phillips | Arkansas | 5107 | 4434 | 84 |
2131823 | 2131823 | 2022-01-19 | Green Lake | Wisconsin | 55047 | 4434 | 49 |
2122256 | 2122256 | 2022-01-17 | Clark | Arkansas | 5019 | 4434 | 66 |
2124909 | 2124909 | 2022-01-17 | Limestone | Texas | 48293 | 4434 | 116 |
2112176 | 2112176 | 2022-01-13 | Staunton city | Virginia | 51790 | 4434 | 89 |
2107344 | 2107344 | 2022-01-12 | Newton | Mississippi | 28101 | 4434 | 85 |
2078069 | 2078069 | 2022-01-03 | Leake | Mississippi | 28079 | 4434 | 92 |
2019674 | 2019674 | 2021-12-16 | Miller | Missouri | 29131 | 4434 | 101 |
2016022 | 2016022 | 2021-12-15 | Richland | Louisiana | 22083 | 4434 | 80 |
1983844 | 1983844 | 2021-12-05 | Wayne | Mississippi | 28153 | 4434 | 72 |
1980594 | 1980594 | 2021-12-04 | Wayne | Mississippi | 28153 | 4434 | 72 |
1977344 | 1977344 | 2021-12-03 | Wayne | Mississippi | 28153 | 4434 | 72 |
1974094 | 1974094 | 2021-12-02 | Wayne | Mississippi | 28153 | 4434 | 72 |
1966686 | 1966686 | 2021-11-30 | Jefferson | Idaho | 16051 | 4434 | 51 |
1916183 | 1916183 | 2021-11-14 | Gallia | Ohio | 39053 | 4434 | 74 |
1899378 | 1899378 | 2021-11-09 | Dunklin | Missouri | 29069 | 4434 | 62 |
1872293 | 1872293 | 2021-11-01 | Emanuel | Georgia | 13107 | 4434 | 132 |
1858594 | 1858594 | 2021-10-27 | Isle of Wight | Virginia | 51093 | 4434 | 86 |
1854222 | 1854222 | 2021-10-26 | Greene | New York | 36039 | 4434 | 87 |
1851011 | 1851011 | 2021-10-25 | Wyoming | New York | 36121 | 4434 | 58 |
1808752 | 1808752 | 2021-10-12 | Otsego | New York | 36077 | 4434 | 52 |
1801532 | 1801532 | 2021-10-10 | Sabine | Louisiana | 22085 | 4434 | 84 |
1798283 | 1798283 | 2021-10-09 | Sabine | Louisiana | 22085 | 4434 | 84 |
1795034 | 1795034 | 2021-10-08 | Sabine | Louisiana | 22085 | 4434 | 84 |
1770445 | 1770445 | 2021-09-30 | Hickman | Tennessee | 47081 | 4434 | 68 |
1762518 | 1762518 | 2021-09-28 | East Feliciana | Louisiana | 22037 | 4434 | 140 |
1747032 | 1747032 | 2021-09-23 | Tioga | New York | 36107 | 4434 | 67 |
1669733 | 1669733 | 2021-08-30 | Henderson | Tennessee | 47077 | 4434 | 80 |
1575826 | 1575826 | 2021-08-01 | Wharton | Texas | 48481 | 4434 | 122 |
1529077 | 1529077 | 2021-07-18 | Platte | Missouri | 29165 | 4434 | 50 |
1495763 | 1495763 | 2021-07-08 | Harrison | Indiana | 18061 | 4434 | 77 |
1496891 | 1496891 | 2021-07-08 | Fulton | New York | 36035 | 4434 | 93 |
1491283 | 1491283 | 2021-07-06 | Jim Wells | Texas | 48249 | 4434 | 108 |
1428771 | 1428771 | 2021-06-17 | Alexander | North Carolina | 37003 | 4434 | 85 |
1417327 | 1417327 | 2021-06-14 | Humboldt | California | 6023 | 4434 | 46 |
1415063 | 1415063 | 2021-06-13 | Washington | Louisiana | 22117 | 4434 | 134 |
1411818 | 1411818 | 2021-06-12 | Washington | Louisiana | 22117 | 4434 | 134 |
1408573 | 1408573 | 2021-06-11 | Washington | Louisiana | 22117 | 4434 | 134 |
1405327 | 1405327 | 2021-06-10 | Washington | Louisiana | 22117 | 4434 | 134 |
1405636 | 1405636 | 2021-06-10 | Warren | Mississippi | 28149 | 4434 | 121 |
1406255 | 1406255 | 2021-06-10 | Madison | Ohio | 39097 | 4434 | 65 |
1305385 | 1305385 | 2021-05-10 | Madison | New York | 36053 | 4434 | 88 |
1281795 | 1281795 | 2021-05-03 | Barren | Kentucky | 21009 | 4434 | 91 |
1278548 | 1278548 | 2021-05-02 | Barren | Kentucky | 21009 | 4434 | 91 |
1271707 | 1271707 | 2021-04-30 | Marion | Illinois | 17121 | 4434 | 121 |
1256813 | 1256813 | 2021-04-25 | Watauga | North Carolina | 37189 | 4434 | 31 |
1253566 | 1253566 | 2021-04-24 | Watauga | North Carolina | 37189 | 4434 | 31 |
1250319 | 1250319 | 2021-04-23 | Watauga | North Carolina | 37189 | 4434 | 31 |
1210039 | 1210039 | 2021-04-11 | Stephenson | Illinois | 17177 | 4434 | 98 |
1211262 | 1211262 | 2021-04-11 | Beaufort | North Carolina | 37013 | 4434 | 90 |
1211274 | 1211274 | 2021-04-11 | Chatham | North Carolina | 37037 | 4434 | 85 |
1208013 | 1208013 | 2021-04-10 | Beaufort | North Carolina | 37013 | 4434 | 90 |
1208025 | 1208025 | 2021-04-10 | Chatham | North Carolina | 37037 | 4434 | 85 |
1204765 | 1204765 | 2021-04-09 | Beaufort | North Carolina | 37013 | 4434 | 90 |
1204777 | 1204777 | 2021-04-09 | Chatham | North Carolina | 37037 | 4434 | 85 |
1187803 | 1187803 | 2021-04-04 | Kennebec | Maine | 23011 | 4434 | 58 |
1167993 | 1167993 | 2021-03-29 | Muscatine | Iowa | 19139 | 4434 | 95 |
1110818 | 1110818 | 2021-03-11 | Shelby | Ohio | 39149 | 4434 | 80 |
1105385 | 1105385 | 2021-03-09 | Monroe | Wisconsin | 55081 | 4434 | 35 |
1081302 | 1081302 | 2021-03-02 | Otero | New Mexico | 35035 | 4434 | 58 |
1068406 | 1068406 | 2021-02-26 | Carteret | North Carolina | 37031 | 4434 | 44 |
1042269 | 1042269 | 2021-02-18 | Scotts Bluff | Nebraska | 31157 | 4434 | 92 |
1039419 | 1039419 | 2021-02-17 | Washington | Ohio | 39167 | 4434 | 86 |
1032553 | 1032553 | 2021-02-15 | Elko | Nevada | 32007 | 4434 | 49 |
1029306 | 1029306 | 2021-02-14 | Elko | Nevada | 32007 | 4434 | 49 |
1026060 | 1026060 | 2021-02-13 | Elko | Nevada | 32007 | 4434 | 49 |
1022815 | 1022815 | 2021-02-12 | Elko | Nevada | 32007 | 4434 | 49 |
1011938 | 1011938 | 2021-02-09 | Effingham | Illinois | 17049 | 4434 | 79 |
1012324 | 1012324 | 2021-02-09 | Boyd | Kentucky | 21019 | 4434 | 40 |
1000881 | 1000881 | 2021-02-05 | Franklin | Tennessee | 47051 | 4434 | 74 |
964565 | 964565 | 2021-01-25 | Franklin | North Carolina | 37069 | 4434 | 40 |
942636 | 942636 | 2021-01-18 | Henderson | Texas | 48213 | 4434 | 101 |
939391 | 939391 | 2021-01-17 | Henderson | Texas | 48213 | 4434 | 100 |
936146 | 936146 | 2021-01-16 | Henderson | Texas | 48213 | 4434 | 99 |
932901 | 932901 | 2021-01-15 | Henderson | Texas | 48213 | 4434 | 96 |
921760 | 921760 | 2021-01-12 | Van Buren | Michigan | 26159 | 4434 | 86 |
894604 | 894604 | 2021-01-04 | Crittenden | Arkansas | 5035 | 4434 | 76 |
829736 | 829736 | 2020-12-15 | Pope | Arkansas | 5115 | 4434 | 50 |
807160 | 807160 | 2020-12-08 | Middlesex | Connecticut | 9007 | 4434 | 215 |
805740 | 805740 | 2020-12-07 | Tuscarawas | Ohio | 39157 | 4434 | 87 |
779609 | 779609 | 2020-11-29 | Nash | North Carolina | 37127 | 4434 | 108 |
628820 | 628820 | 2020-10-14 | Columbia | Georgia | 13073 | 4434 | 62 |
579588 | 579588 | 2020-09-28 | Franklin | Washington | 53021 | 4434 | 67 |
547151 | 547151 | 2020-09-18 | Richmond city | Virginia | 51760 | 4434 | 55 |
501266 | 501266 | 2020-09-04 | Florence | South Carolina | 45041 | 4434 | 161 |
370578 | 370578 | 2020-07-26 | Elkhart | Indiana | 18039 | 4434 | 74 |
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);