ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 21, fips = 27069 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 |
---|---|---|---|---|---|---|---|
1103553 | 1103553 | 2021-03-09 | Kittson | Minnesota | 27069 | 416 | 21 |
1100307 | 1100307 | 2021-03-08 | Kittson | Minnesota | 27069 | 411 | 21 |
1097060 | 1097060 | 2021-03-07 | Kittson | Minnesota | 27069 | 411 | 21 |
1093813 | 1093813 | 2021-03-06 | Kittson | Minnesota | 27069 | 410 | 21 |
1090567 | 1090567 | 2021-03-05 | Kittson | Minnesota | 27069 | 409 | 21 |
1087322 | 1087322 | 2021-03-04 | Kittson | Minnesota | 27069 | 409 | 21 |
1084077 | 1084077 | 2021-03-03 | Kittson | Minnesota | 27069 | 409 | 21 |
1080831 | 1080831 | 2021-03-02 | Kittson | Minnesota | 27069 | 409 | 21 |
1077585 | 1077585 | 2021-03-01 | Kittson | Minnesota | 27069 | 408 | 21 |
1074339 | 1074339 | 2021-02-28 | Kittson | Minnesota | 27069 | 408 | 21 |
1071093 | 1071093 | 2021-02-27 | Kittson | Minnesota | 27069 | 408 | 21 |
1067848 | 1067848 | 2021-02-26 | Kittson | Minnesota | 27069 | 408 | 21 |
1064603 | 1064603 | 2021-02-25 | Kittson | Minnesota | 27069 | 408 | 21 |
1061359 | 1061359 | 2021-02-24 | Kittson | Minnesota | 27069 | 407 | 21 |
1058113 | 1058113 | 2021-02-23 | Kittson | Minnesota | 27069 | 404 | 21 |
1054867 | 1054867 | 2021-02-22 | Kittson | Minnesota | 27069 | 404 | 21 |
1051620 | 1051620 | 2021-02-21 | Kittson | Minnesota | 27069 | 404 | 21 |
1048373 | 1048373 | 2021-02-20 | Kittson | Minnesota | 27069 | 403 | 21 |
1045127 | 1045127 | 2021-02-19 | Kittson | Minnesota | 27069 | 402 | 21 |
1041882 | 1041882 | 2021-02-18 | Kittson | Minnesota | 27069 | 399 | 21 |
1038637 | 1038637 | 2021-02-17 | Kittson | Minnesota | 27069 | 396 | 21 |
1035392 | 1035392 | 2021-02-16 | Kittson | Minnesota | 27069 | 395 | 21 |
1032147 | 1032147 | 2021-02-15 | Kittson | Minnesota | 27069 | 395 | 21 |
1028900 | 1028900 | 2021-02-14 | Kittson | Minnesota | 27069 | 395 | 21 |
1025654 | 1025654 | 2021-02-13 | Kittson | Minnesota | 27069 | 394 | 21 |
1022409 | 1022409 | 2021-02-12 | Kittson | Minnesota | 27069 | 393 | 21 |
1019164 | 1019164 | 2021-02-11 | Kittson | Minnesota | 27069 | 393 | 21 |
1015919 | 1015919 | 2021-02-10 | Kittson | Minnesota | 27069 | 389 | 21 |
1012674 | 1012674 | 2021-02-09 | Kittson | Minnesota | 27069 | 388 | 21 |
1009429 | 1009429 | 2021-02-08 | Kittson | Minnesota | 27069 | 388 | 21 |
1006182 | 1006182 | 2021-02-07 | Kittson | Minnesota | 27069 | 388 | 21 |
1002936 | 1002936 | 2021-02-06 | Kittson | Minnesota | 27069 | 388 | 21 |
999691 | 999691 | 2021-02-05 | Kittson | Minnesota | 27069 | 387 | 21 |
996445 | 996445 | 2021-02-04 | Kittson | Minnesota | 27069 | 387 | 21 |
993199 | 993199 | 2021-02-03 | Kittson | Minnesota | 27069 | 386 | 21 |
989953 | 989953 | 2021-02-02 | Kittson | Minnesota | 27069 | 385 | 21 |
986706 | 986706 | 2021-02-01 | Kittson | Minnesota | 27069 | 385 | 21 |
983459 | 983459 | 2021-01-31 | Kittson | Minnesota | 27069 | 385 | 21 |
980213 | 980213 | 2021-01-30 | Kittson | Minnesota | 27069 | 384 | 21 |
976967 | 976967 | 2021-01-29 | Kittson | Minnesota | 27069 | 381 | 21 |
973722 | 973722 | 2021-01-28 | Kittson | Minnesota | 27069 | 378 | 21 |
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);