ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 32, fips = 27153 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1428269 | 1428269 | 2021-06-17 | Todd | Minnesota | 27153 | 2856 | 32 |
1425024 | 1425024 | 2021-06-16 | Todd | Minnesota | 27153 | 2856 | 32 |
1421776 | 1421776 | 2021-06-15 | Todd | Minnesota | 27153 | 2856 | 32 |
1418531 | 1418531 | 2021-06-14 | Todd | Minnesota | 27153 | 2856 | 32 |
1415286 | 1415286 | 2021-06-13 | Todd | Minnesota | 27153 | 2856 | 32 |
1412040 | 1412040 | 2021-06-12 | Todd | Minnesota | 27153 | 2855 | 32 |
1408795 | 1408795 | 2021-06-11 | Todd | Minnesota | 27153 | 2855 | 32 |
1405550 | 1405550 | 2021-06-10 | Todd | Minnesota | 27153 | 2854 | 32 |
1402304 | 1402304 | 2021-06-09 | Todd | Minnesota | 27153 | 2852 | 32 |
1399059 | 1399059 | 2021-06-08 | Todd | Minnesota | 27153 | 2852 | 32 |
1395813 | 1395813 | 2021-06-07 | Todd | Minnesota | 27153 | 2852 | 32 |
1392567 | 1392567 | 2021-06-06 | Todd | Minnesota | 27153 | 2851 | 32 |
1389322 | 1389322 | 2021-06-05 | Todd | Minnesota | 27153 | 2851 | 32 |
1386077 | 1386077 | 2021-06-04 | Todd | Minnesota | 27153 | 2851 | 32 |
1382832 | 1382832 | 2021-06-03 | Todd | Minnesota | 27153 | 2851 | 32 |
1379586 | 1379586 | 2021-06-02 | Todd | Minnesota | 27153 | 2849 | 32 |
1376341 | 1376341 | 2021-06-01 | Todd | Minnesota | 27153 | 2848 | 32 |
1373095 | 1373095 | 2021-05-31 | Todd | Minnesota | 27153 | 2847 | 32 |
1369850 | 1369850 | 2021-05-30 | Todd | Minnesota | 27153 | 2847 | 32 |
1366604 | 1366604 | 2021-05-29 | Todd | Minnesota | 27153 | 2847 | 32 |
1363358 | 1363358 | 2021-05-28 | Todd | Minnesota | 27153 | 2846 | 32 |
1360111 | 1360111 | 2021-05-27 | Todd | Minnesota | 27153 | 2846 | 32 |
1356865 | 1356865 | 2021-05-26 | Todd | Minnesota | 27153 | 2846 | 32 |
1353619 | 1353619 | 2021-05-25 | Todd | Minnesota | 27153 | 2844 | 32 |
1350373 | 1350373 | 2021-05-24 | Todd | Minnesota | 27153 | 2843 | 32 |
1347127 | 1347127 | 2021-05-23 | Todd | Minnesota | 27153 | 2842 | 32 |
1343879 | 1343879 | 2021-05-22 | Todd | Minnesota | 27153 | 2841 | 32 |
1340630 | 1340630 | 2021-05-21 | Todd | Minnesota | 27153 | 2840 | 32 |
1337383 | 1337383 | 2021-05-20 | Todd | Minnesota | 27153 | 2837 | 32 |
1334136 | 1334136 | 2021-05-19 | Todd | Minnesota | 27153 | 2835 | 32 |
1330889 | 1330889 | 2021-05-18 | Todd | Minnesota | 27153 | 2831 | 32 |
1327642 | 1327642 | 2021-05-17 | Todd | Minnesota | 27153 | 2829 | 32 |
1324396 | 1324396 | 2021-05-16 | Todd | Minnesota | 27153 | 2828 | 32 |
1321150 | 1321150 | 2021-05-15 | Todd | Minnesota | 27153 | 2824 | 32 |
1317904 | 1317904 | 2021-05-14 | Todd | Minnesota | 27153 | 2821 | 32 |
1314656 | 1314656 | 2021-05-13 | Todd | Minnesota | 27153 | 2816 | 32 |
1311410 | 1311410 | 2021-05-12 | Todd | Minnesota | 27153 | 2813 | 32 |
1308163 | 1308163 | 2021-05-11 | Todd | Minnesota | 27153 | 2806 | 32 |
1304917 | 1304917 | 2021-05-10 | Todd | Minnesota | 27153 | 2803 | 32 |
1301671 | 1301671 | 2021-05-09 | Todd | Minnesota | 27153 | 2804 | 32 |
1298423 | 1298423 | 2021-05-08 | Todd | Minnesota | 27153 | 2802 | 32 |
1295177 | 1295177 | 2021-05-07 | Todd | Minnesota | 27153 | 2791 | 32 |
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);