ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
179 rows where cases = 3812 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496000 | 2496000 | 2022-05-11 | Appomattox | Virginia | 51011 | 3812 | 53 |
2491550 | 2491550 | 2022-05-10 | Saline | Nebraska | 31151 | 3812 | 12 |
2492742 | 2492742 | 2022-05-10 | Appomattox | Virginia | 51011 | 3812 | 53 |
2488292 | 2488292 | 2022-05-09 | Saline | Nebraska | 31151 | 3812 | 12 |
2485035 | 2485035 | 2022-05-08 | Saline | Nebraska | 31151 | 3812 | 12 |
2481777 | 2481777 | 2022-05-07 | Saline | Nebraska | 31151 | 3812 | 12 |
2478519 | 2478519 | 2022-05-06 | Saline | Nebraska | 31151 | 3812 | 12 |
2475261 | 2475261 | 2022-05-05 | Saline | Nebraska | 31151 | 3812 | 12 |
2475859 | 2475859 | 2022-05-05 | Barceloneta | Puerto Rico | 72017 | 3812 | |
2471785 | 2471785 | 2022-05-04 | Dallas | Missouri | 29059 | 3812 | 71 |
2472004 | 2472004 | 2022-05-04 | Saline | Nebraska | 31151 | 3812 | 12 |
2472102 | 2472102 | 2022-05-04 | Socorro | New Mexico | 35053 | 3812 | 87 |
2468529 | 2468529 | 2022-05-03 | Dallas | Missouri | 29059 | 3812 | 71 |
2468748 | 2468748 | 2022-05-03 | Saline | Nebraska | 31151 | 3812 | 12 |
2465273 | 2465273 | 2022-05-02 | Dallas | Missouri | 29059 | 3812 | 71 |
2462018 | 2462018 | 2022-05-01 | Dallas | Missouri | 29059 | 3812 | 71 |
2458762 | 2458762 | 2022-04-30 | Dallas | Missouri | 29059 | 3812 | 71 |
2455506 | 2455506 | 2022-04-29 | Dallas | Missouri | 29059 | 3812 | 71 |
2452250 | 2452250 | 2022-04-28 | Dallas | Missouri | 29059 | 3812 | 71 |
2448994 | 2448994 | 2022-04-27 | Dallas | Missouri | 29059 | 3812 | 71 |
2445737 | 2445737 | 2022-04-26 | Dallas | Missouri | 29059 | 3812 | 71 |
2441086 | 2441086 | 2022-04-25 | Franklin | Arkansas | 5047 | 3812 | 73 |
2442482 | 2442482 | 2022-04-25 | Dallas | Missouri | 29059 | 3812 | 71 |
2437830 | 2437830 | 2022-04-24 | Franklin | Arkansas | 5047 | 3812 | 73 |
2439226 | 2439226 | 2022-04-24 | Dallas | Missouri | 29059 | 3812 | 71 |
2434574 | 2434574 | 2022-04-23 | Franklin | Arkansas | 5047 | 3812 | 73 |
2435970 | 2435970 | 2022-04-23 | Dallas | Missouri | 29059 | 3812 | 71 |
2431318 | 2431318 | 2022-04-22 | Franklin | Arkansas | 5047 | 3812 | 73 |
2432714 | 2432714 | 2022-04-22 | Dallas | Missouri | 29059 | 3812 | 71 |
2428062 | 2428062 | 2022-04-21 | Franklin | Arkansas | 5047 | 3812 | 73 |
2429458 | 2429458 | 2022-04-21 | Dallas | Missouri | 29059 | 3812 | 71 |
2424806 | 2424806 | 2022-04-20 | Franklin | Arkansas | 5047 | 3812 | 73 |
2426202 | 2426202 | 2022-04-20 | Dallas | Missouri | 29059 | 3812 | 71 |
2422946 | 2422946 | 2022-04-19 | Dallas | Missouri | 29059 | 3812 | 71 |
2419689 | 2419689 | 2022-04-18 | Dallas | Missouri | 29059 | 3812 | 71 |
2416434 | 2416434 | 2022-04-17 | Dallas | Missouri | 29059 | 3812 | 71 |
2413178 | 2413178 | 2022-04-16 | Dallas | Missouri | 29059 | 3812 | 71 |
2409922 | 2409922 | 2022-04-15 | Dallas | Missouri | 29059 | 3812 | 71 |
2406666 | 2406666 | 2022-04-14 | Dallas | Missouri | 29059 | 3812 | 71 |
2403410 | 2403410 | 2022-04-13 | Dallas | Missouri | 29059 | 3812 | 71 |
2400155 | 2400155 | 2022-04-12 | Dallas | Missouri | 29059 | 3812 | 71 |
2396900 | 2396900 | 2022-04-11 | Dallas | Missouri | 29059 | 3812 | 71 |
2393645 | 2393645 | 2022-04-10 | Dallas | Missouri | 29059 | 3812 | 71 |
2390389 | 2390389 | 2022-04-09 | Dallas | Missouri | 29059 | 3812 | 71 |
2387133 | 2387133 | 2022-04-08 | Dallas | Missouri | 29059 | 3812 | 71 |
2383878 | 2383878 | 2022-04-07 | Dallas | Missouri | 29059 | 3812 | 71 |
2380623 | 2380623 | 2022-04-06 | Dallas | Missouri | 29059 | 3812 | 71 |
2377368 | 2377368 | 2022-04-05 | Dallas | Missouri | 29059 | 3812 | 71 |
2374115 | 2374115 | 2022-04-04 | Dallas | Missouri | 29059 | 3812 | 71 |
2370863 | 2370863 | 2022-04-03 | Dallas | Missouri | 29059 | 3812 | 71 |
2367610 | 2367610 | 2022-04-02 | Dallas | Missouri | 29059 | 3812 | 71 |
2364357 | 2364357 | 2022-04-01 | Dallas | Missouri | 29059 | 3812 | 71 |
2361103 | 2361103 | 2022-03-31 | Dallas | Missouri | 29059 | 3812 | 71 |
2348131 | 2348131 | 2022-03-27 | Moniteau | Missouri | 29135 | 3812 | 55 |
2344878 | 2344878 | 2022-03-26 | Moniteau | Missouri | 29135 | 3812 | 55 |
2341625 | 2341625 | 2022-03-25 | Moniteau | Missouri | 29135 | 3812 | 55 |
2338372 | 2338372 | 2022-03-24 | Moniteau | Missouri | 29135 | 3812 | 55 |
2280238 | 2280238 | 2022-03-06 | Polk | North Carolina | 37149 | 3812 | 52 |
2281362 | 2281362 | 2022-03-06 | Braxton | West Virginia | 54007 | 3812 | 42 |
2276985 | 2276985 | 2022-03-05 | Polk | North Carolina | 37149 | 3812 | 52 |
2278109 | 2278109 | 2022-03-05 | Braxton | West Virginia | 54007 | 3812 | 42 |
2273732 | 2273732 | 2022-03-04 | Polk | North Carolina | 37149 | 3812 | 52 |
2274856 | 2274856 | 2022-03-04 | Braxton | West Virginia | 54007 | 3812 | 42 |
2225690 | 2225690 | 2022-02-17 | Freestone | Texas | 48161 | 3812 | 81 |
2210121 | 2210121 | 2022-02-13 | Izard | Arkansas | 5065 | 3812 | 63 |
2210917 | 2210917 | 2022-02-13 | Jackson | Kansas | 20085 | 3812 | 27 |
2207664 | 2207664 | 2022-02-12 | Jackson | Kansas | 20085 | 3812 | 27 |
2204411 | 2204411 | 2022-02-11 | Jackson | Kansas | 20085 | 3812 | 27 |
2201158 | 2201158 | 2022-02-10 | Jackson | Kansas | 20085 | 3812 | 27 |
2197626 | 2197626 | 2022-02-09 | Mason | Illinois | 17125 | 3812 | 60 |
2197904 | 2197904 | 2022-02-09 | Jackson | Kansas | 20085 | 3812 | 27 |
2199705 | 2199705 | 2022-02-09 | Houston | Texas | 48225 | 3812 | 98 |
2171609 | 2171609 | 2022-02-01 | Mercer | Illinois | 17131 | 3812 | 40 |
2125929 | 2125929 | 2022-01-18 | Washington | Georgia | 13303 | 3812 | 127 |
2106987 | 2106987 | 2022-01-12 | Spencer | Kentucky | 21215 | 3812 | 44 |
2098015 | 2098015 | 2022-01-09 | Schoharie | New York | 36095 | 3812 | 30 |
2079410 | 2079410 | 2022-01-03 | Moore | Texas | 48341 | 3812 | 93 |
2066825 | 2066825 | 2021-12-30 | Taylor | Wisconsin | 55119 | 3812 | 61 |
2056780 | 2056780 | 2021-12-27 | Orleans | Vermont | 50019 | 3812 | 28 |
2057049 | 2057049 | 2021-12-27 | Langlade | Wisconsin | 55067 | 3812 | 66 |
2052504 | 2052504 | 2021-12-26 | Seneca | New York | 36099 | 3812 | 77 |
2041015 | 2041015 | 2021-12-23 | Logan | Arkansas | 5083 | 3812 | 53 |
2029172 | 2029172 | 2021-12-19 | Osceola | Michigan | 26133 | 3812 | 55 |
2025921 | 2025921 | 2021-12-18 | Osceola | Michigan | 26133 | 3812 | 55 |
2022670 | 2022670 | 2021-12-17 | Osceola | Michigan | 26133 | 3812 | 55 |
2015266 | 2015266 | 2021-12-15 | Burke | Georgia | 13033 | 3812 | 86 |
1981893 | 1981893 | 2021-12-04 | Milam | Texas | 48331 | 3812 | 90 |
1956648 | 1956648 | 2021-11-27 | Routt | Colorado | 8107 | 3812 | 23 |
1953397 | 1953397 | 2021-11-26 | Routt | Colorado | 8107 | 3812 | 23 |
1950146 | 1950146 | 2021-11-25 | Routt | Colorado | 8107 | 3812 | 23 |
1916194 | 1916194 | 2021-11-14 | Holmes | Ohio | 39075 | 3812 | 132 |
1904791 | 1904791 | 2021-11-11 | Fannin | Georgia | 13111 | 3812 | 108 |
1901541 | 1901541 | 2021-11-10 | Fannin | Georgia | 13111 | 3812 | 108 |
1903996 | 1903996 | 2021-11-10 | Sevier | Utah | 49041 | 3812 | 18 |
1898291 | 1898291 | 2021-11-09 | Fannin | Georgia | 13111 | 3812 | 108 |
1900326 | 1900326 | 2021-11-09 | Davison | South Dakota | 46035 | 3812 | 71 |
1900746 | 1900746 | 2021-11-09 | Sevier | Utah | 49041 | 3812 | 18 |
1884729 | 1884729 | 2021-11-04 | Nicholas | West Virginia | 54067 | 3812 | 50 |
1878136 | 1878136 | 2021-11-02 | Russell | Virginia | 51167 | 3812 | 65 |
1859376 | 1859376 | 2021-10-28 | Tattnall | Georgia | 13267 | 3812 | 106 |
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);