ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4630 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 |
---|---|---|---|---|---|---|---|
2495190 | 2495190 | 2022-05-11 | Paulding | Ohio | 39125 | 4630 | 74 |
2491932 | 2491932 | 2022-05-10 | Paulding | Ohio | 39125 | 4630 | 74 |
2488674 | 2488674 | 2022-05-09 | Paulding | Ohio | 39125 | 4630 | 74 |
2483896 | 2483896 | 2022-05-08 | Cass | Illinois | 17017 | 4630 | 44 |
2485417 | 2485417 | 2022-05-08 | Paulding | Ohio | 39125 | 4630 | 74 |
2480638 | 2480638 | 2022-05-07 | Cass | Illinois | 17017 | 4630 | 44 |
2482159 | 2482159 | 2022-05-07 | Paulding | Ohio | 39125 | 4630 | 74 |
2482854 | 2482854 | 2022-05-07 | Reeves | Texas | 48389 | 4630 | 74 |
2477380 | 2477380 | 2022-05-06 | Cass | Illinois | 17017 | 4630 | 44 |
2478901 | 2478901 | 2022-05-06 | Paulding | Ohio | 39125 | 4630 | 74 |
2474122 | 2474122 | 2022-05-05 | Cass | Illinois | 17017 | 4630 | 44 |
2475643 | 2475643 | 2022-05-05 | Paulding | Ohio | 39125 | 4630 | 74 |
2417264 | 2417264 | 2022-04-17 | Coamo | Puerto Rico | 72043 | 4630 | |
2417921 | 2417921 | 2022-04-17 | New Kent | Virginia | 51127 | 4630 | 32 |
2414665 | 2414665 | 2022-04-16 | New Kent | Virginia | 51127 | 4630 | 32 |
2411409 | 2411409 | 2022-04-15 | New Kent | Virginia | 51127 | 4630 | 32 |
2376017 | 2376017 | 2022-04-05 | Sharp | Arkansas | 5135 | 4630 | 105 |
2372765 | 2372765 | 2022-04-04 | Sharp | Arkansas | 5135 | 4630 | 105 |
2369512 | 2369512 | 2022-04-03 | Sharp | Arkansas | 5135 | 4630 | 105 |
2342406 | 2342406 | 2022-03-25 | Camuy | Puerto Rico | 72027 | 4630 | |
2307068 | 2307068 | 2022-03-14 | Montague | Texas | 48337 | 4630 | 122 |
2303817 | 2303817 | 2022-03-13 | Montague | Texas | 48337 | 4630 | 122 |
2300565 | 2300565 | 2022-03-12 | Montague | Texas | 48337 | 4630 | 122 |
2269588 | 2269588 | 2022-03-03 | Morgan | Kentucky | 21175 | 4630 | 17 |
2249123 | 2249123 | 2022-02-25 | Drew | Arkansas | 5043 | 4630 | 62 |
2243039 | 2243039 | 2022-02-23 | Worth | Georgia | 13321 | 4630 | 107 |
2213359 | 2213359 | 2022-02-14 | Cross | Arkansas | 5037 | 4630 | 75 |
2199938 | 2199938 | 2022-02-09 | Fluvanna | Virginia | 51065 | 4630 | 35 |
2180863 | 2180863 | 2022-02-04 | Phillips | Arkansas | 5107 | 4630 | 84 |
2156258 | 2156258 | 2022-01-27 | Ray | Missouri | 29177 | 4630 | 81 |
2151050 | 2151050 | 2022-01-25 | Carbon | Utah | 49007 | 4630 | 42 |
2151345 | 2151345 | 2022-01-25 | Green Lake | Wisconsin | 55047 | 4630 | 53 |
2142103 | 2142103 | 2022-01-23 | Fannin | Georgia | 13111 | 4630 | 124 |
2138848 | 2138848 | 2022-01-22 | Fannin | Georgia | 13111 | 4630 | 124 |
2135592 | 2135592 | 2022-01-21 | Fannin | Georgia | 13111 | 4630 | 124 |
2132490 | 2132490 | 2022-01-20 | Payette | Idaho | 16075 | 4630 | 75 |
2110289 | 2110289 | 2022-01-13 | Pointe Coupee | Louisiana | 22077 | 4630 | 85 |
2107038 | 2107038 | 2022-01-12 | Pointe Coupee | Louisiana | 22077 | 4630 | 85 |
2107465 | 2107465 | 2022-01-12 | Randolph | Missouri | 29175 | 4630 | 89 |
2103787 | 2103787 | 2022-01-11 | Pointe Coupee | Louisiana | 22077 | 4630 | 85 |
2105369 | 2105369 | 2022-01-11 | Hutchinson | Texas | 48233 | 4630 | 116 |
2081029 | 2081029 | 2022-01-04 | Richland | Louisiana | 22083 | 4630 | 80 |
2032487 | 2032487 | 2021-12-20 | Meeker | Minnesota | 27093 | 4630 | 65 |
2013105 | 2013105 | 2021-12-14 | Yazoo | Mississippi | 28163 | 4630 | 93 |
1972343 | 1972343 | 2021-12-01 | Isle of Wight | Virginia | 51093 | 4630 | 92 |
1925810 | 1925810 | 2021-11-17 | Montgomery | North Carolina | 37123 | 4630 | 110 |
1922561 | 1922561 | 2021-11-16 | Montgomery | North Carolina | 37123 | 4630 | 110 |
1918119 | 1918119 | 2021-11-15 | Scott | Indiana | 18143 | 4630 | 80 |
1880856 | 1880856 | 2021-11-03 | Meade | South Dakota | 46093 | 4630 | 48 |
1871996 | 1871996 | 2021-11-01 | Johnson | Arkansas | 5071 | 4630 | 57 |
1873266 | 1873266 | 2021-11-01 | Adams | Mississippi | 28001 | 4630 | 122 |
1823647 | 1823647 | 2021-10-17 | Unknown | Georgia | 4630 | 8 | |
1820398 | 1820398 | 2021-10-16 | Unknown | Georgia | 4630 | 8 | |
1817149 | 1817149 | 2021-10-15 | Unknown | Georgia | 4630 | 8 | |
1805102 | 1805102 | 2021-10-11 | Tippah | Mississippi | 28139 | 4630 | 81 |
1779005 | 1779005 | 2021-10-03 | Nobles | Minnesota | 27105 | 4630 | 51 |
1775755 | 1775755 | 2021-10-02 | Nobles | Minnesota | 27105 | 4630 | 51 |
1772505 | 1772505 | 2021-10-01 | Nobles | Minnesota | 27105 | 4630 | 51 |
1766104 | 1766104 | 2021-09-29 | Scott | Mississippi | 28123 | 4630 | 96 |
1766602 | 1766602 | 2021-09-29 | Pasquotank | North Carolina | 37139 | 4630 | 95 |
1699355 | 1699355 | 2021-09-08 | Charlottesville city | Virginia | 51540 | 4630 | 58 |
1668539 | 1668539 | 2021-08-30 | McLeod | Minnesota | 27085 | 4630 | 61 |
1643269 | 1643269 | 2021-08-22 | Fulton | Ohio | 39051 | 4630 | 78 |
1626520 | 1626520 | 2021-08-17 | Polk | Missouri | 29167 | 4630 | 48 |
1626808 | 1626808 | 2021-08-17 | Livingston | New York | 36051 | 4630 | 60 |
1609438 | 1609438 | 2021-08-12 | Huntington | Indiana | 18069 | 4630 | 84 |
1586292 | 1586292 | 2021-08-05 | DeSoto | Florida | 12027 | 4630 | 97 |
1583042 | 1583042 | 2021-08-04 | DeSoto | Florida | 12027 | 4630 | 97 |
1579792 | 1579792 | 2021-08-03 | DeSoto | Florida | 12027 | 4630 | 97 |
1576544 | 1576544 | 2021-08-02 | DeSoto | Florida | 12027 | 4630 | 97 |
1573296 | 1573296 | 2021-08-01 | DeSoto | Florida | 12027 | 4630 | 97 |
1570048 | 1570048 | 2021-07-31 | DeSoto | Florida | 12027 | 4630 | 97 |
1566800 | 1566800 | 2021-07-30 | DeSoto | Florida | 12027 | 4630 | 97 |
1546992 | 1546992 | 2021-07-24 | Chilton | Alabama | 1021 | 4630 | 117 |
1532155 | 1532155 | 2021-07-19 | Winona | Minnesota | 27169 | 4630 | 52 |
1528155 | 1528155 | 2021-07-18 | Marion | Illinois | 17121 | 4630 | 123 |
1524908 | 1524908 | 2021-07-17 | Marion | Illinois | 17121 | 4630 | 123 |
1521660 | 1521660 | 2021-07-16 | Marion | Illinois | 17121 | 4630 | 123 |
1513853 | 1513853 | 2021-07-13 | Obion | Tennessee | 47131 | 4630 | 97 |
1304818 | 1304818 | 2021-05-10 | Newaygo | Michigan | 26123 | 4630 | 60 |
1298078 | 1298078 | 2021-05-08 | Jessamine | Kentucky | 21113 | 4630 | 64 |
1298367 | 1298367 | 2021-05-08 | Douglas | Minnesota | 27041 | 4630 | 74 |
1290186 | 1290186 | 2021-05-05 | Wasatch | Utah | 49051 | 4630 | 21 |
1228757 | 1228757 | 2021-04-16 | Douglas | Wisconsin | 55031 | 4630 | 49 |
1149914 | 1149914 | 2021-03-23 | Bradford | Pennsylvania | 42015 | 4630 | 83 |
1099585 | 1099585 | 2021-03-08 | Jackson | Illinois | 17077 | 4630 | 71 |
1093872 | 1093872 | 2021-03-06 | Bolivar | Mississippi | 28011 | 4630 | 124 |
1060736 | 1060736 | 2021-02-24 | Jackson | Indiana | 18071 | 4630 | 64 |
1052809 | 1052809 | 2021-02-21 | Fayette | Tennessee | 47047 | 4630 | 71 |
1053185 | 1053185 | 2021-02-21 | Albemarle | Virginia | 51003 | 4630 | 39 |
1042621 | 1042621 | 2021-02-18 | Jefferson | Ohio | 39081 | 4630 | 105 |
1023179 | 1023179 | 2021-02-12 | Sandusky | Ohio | 39143 | 4630 | 80 |
1013522 | 1013522 | 2021-02-09 | Pontotoc | Oklahoma | 40123 | 4630 | 42 |
1010134 | 1010134 | 2021-02-08 | Belmont | Ohio | 39013 | 4630 | 51 |
987303 | 987303 | 2021-02-01 | Lenoir | North Carolina | 37107 | 4630 | 91 |
982976 | 982976 | 2021-01-31 | Sioux | Iowa | 19167 | 4630 | 62 |
984056 | 984056 | 2021-01-31 | Lenoir | North Carolina | 37107 | 4630 | 91 |
970455 | 970455 | 2021-01-27 | Chisago | Minnesota | 27025 | 4630 | 38 |
924393 | 924393 | 2021-01-13 | Cass | Indiana | 18017 | 4630 | 60 |
907585 | 907585 | 2021-01-08 | Crittenden | Arkansas | 5035 | 4630 | 77 |
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);