ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 27129 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054897 | 1054897 | 2021-02-22 | Renville | Minnesota | 27129 | 1467 | 40 |
1051650 | 1051650 | 2021-02-21 | Renville | Minnesota | 27129 | 1467 | 40 |
1048403 | 1048403 | 2021-02-20 | Renville | Minnesota | 27129 | 1467 | 40 |
1045157 | 1045157 | 2021-02-19 | Renville | Minnesota | 27129 | 1459 | 40 |
1041912 | 1041912 | 2021-02-18 | Renville | Minnesota | 27129 | 1456 | 40 |
1038667 | 1038667 | 2021-02-17 | Renville | Minnesota | 27129 | 1452 | 40 |
1035422 | 1035422 | 2021-02-16 | Renville | Minnesota | 27129 | 1452 | 40 |
1032177 | 1032177 | 2021-02-15 | Renville | Minnesota | 27129 | 1452 | 40 |
1028930 | 1028930 | 2021-02-14 | Renville | Minnesota | 27129 | 1448 | 40 |
1025684 | 1025684 | 2021-02-13 | Renville | Minnesota | 27129 | 1445 | 40 |
1022439 | 1022439 | 2021-02-12 | Renville | Minnesota | 27129 | 1444 | 40 |
1019194 | 1019194 | 2021-02-11 | Renville | Minnesota | 27129 | 1430 | 40 |
1015949 | 1015949 | 2021-02-10 | Renville | Minnesota | 27129 | 1428 | 40 |
1012704 | 1012704 | 2021-02-09 | Renville | Minnesota | 27129 | 1426 | 40 |
1009459 | 1009459 | 2021-02-08 | Renville | Minnesota | 27129 | 1424 | 40 |
1006212 | 1006212 | 2021-02-07 | Renville | Minnesota | 27129 | 1420 | 40 |
1002966 | 1002966 | 2021-02-06 | Renville | Minnesota | 27129 | 1419 | 40 |
999721 | 999721 | 2021-02-05 | Renville | Minnesota | 27129 | 1414 | 40 |
996475 | 996475 | 2021-02-04 | Renville | Minnesota | 27129 | 1411 | 40 |
993229 | 993229 | 2021-02-03 | Renville | Minnesota | 27129 | 1409 | 40 |
989983 | 989983 | 2021-02-02 | Renville | Minnesota | 27129 | 1405 | 40 |
986736 | 986736 | 2021-02-01 | Renville | Minnesota | 27129 | 1403 | 40 |
983489 | 983489 | 2021-01-31 | Renville | Minnesota | 27129 | 1403 | 40 |
980243 | 980243 | 2021-01-30 | Renville | Minnesota | 27129 | 1400 | 40 |
976997 | 976997 | 2021-01-29 | Renville | Minnesota | 27129 | 1399 | 40 |
973752 | 973752 | 2021-01-28 | Renville | Minnesota | 27129 | 1394 | 40 |
970507 | 970507 | 2021-01-27 | Renville | Minnesota | 27129 | 1392 | 40 |
967262 | 967262 | 2021-01-26 | Renville | Minnesota | 27129 | 1387 | 40 |
964018 | 964018 | 2021-01-25 | Renville | Minnesota | 27129 | 1385 | 40 |
960773 | 960773 | 2021-01-24 | Renville | Minnesota | 27129 | 1384 | 40 |
957527 | 957527 | 2021-01-23 | Renville | Minnesota | 27129 | 1380 | 40 |
954282 | 954282 | 2021-01-22 | Renville | Minnesota | 27129 | 1379 | 40 |
951037 | 951037 | 2021-01-21 | Renville | Minnesota | 27129 | 1378 | 40 |
947791 | 947791 | 2021-01-20 | Renville | Minnesota | 27129 | 1375 | 40 |
944544 | 944544 | 2021-01-19 | Renville | Minnesota | 27129 | 1375 | 39 |
941299 | 941299 | 2021-01-18 | Renville | Minnesota | 27129 | 1372 | 39 |
938054 | 938054 | 2021-01-17 | Renville | Minnesota | 27129 | 1371 | 39 |
934809 | 934809 | 2021-01-16 | Renville | Minnesota | 27129 | 1365 | 39 |
931564 | 931564 | 2021-01-15 | Renville | Minnesota | 27129 | 1363 | 39 |
928319 | 928319 | 2021-01-14 | Renville | Minnesota | 27129 | 1361 | 39 |
925073 | 925073 | 2021-01-13 | Renville | Minnesota | 27129 | 1356 | 39 |
921828 | 921828 | 2021-01-12 | Renville | Minnesota | 27129 | 1354 | 39 |
918583 | 918583 | 2021-01-11 | Renville | Minnesota | 27129 | 1351 | 39 |
915338 | 915338 | 2021-01-10 | Renville | Minnesota | 27129 | 1350 | 39 |
912093 | 912093 | 2021-01-09 | Renville | Minnesota | 27129 | 1347 | 39 |
908848 | 908848 | 2021-01-08 | Renville | Minnesota | 27129 | 1345 | 39 |
905602 | 905602 | 2021-01-07 | Renville | Minnesota | 27129 | 1340 | 39 |
902357 | 902357 | 2021-01-06 | Renville | Minnesota | 27129 | 1328 | 39 |
899112 | 899112 | 2021-01-05 | Renville | Minnesota | 27129 | 1324 | 39 |
895867 | 895867 | 2021-01-04 | Renville | Minnesota | 27129 | 1315 | 39 |
892620 | 892620 | 2021-01-03 | Renville | Minnesota | 27129 | 1308 | 39 |
889374 | 889374 | 2021-01-02 | Renville | Minnesota | 27129 | 1301 | 39 |
886128 | 886128 | 2021-01-01 | Renville | Minnesota | 27129 | 1291 | 39 |
882883 | 882883 | 2020-12-31 | Renville | Minnesota | 27129 | 1291 | 39 |
879638 | 879638 | 2020-12-30 | Renville | Minnesota | 27129 | 1291 | 38 |
876393 | 876393 | 2020-12-29 | Renville | Minnesota | 27129 | 1286 | 38 |
873148 | 873148 | 2020-12-28 | Renville | Minnesota | 27129 | 1283 | 38 |
869903 | 869903 | 2020-12-27 | Renville | Minnesota | 27129 | 1281 | 38 |
866658 | 866658 | 2020-12-26 | Renville | Minnesota | 27129 | 1273 | 38 |
863413 | 863413 | 2020-12-25 | Renville | Minnesota | 27129 | 1265 | 38 |
860168 | 860168 | 2020-12-24 | Renville | Minnesota | 27129 | 1265 | 38 |
856923 | 856923 | 2020-12-23 | Renville | Minnesota | 27129 | 1256 | 37 |
853678 | 853678 | 2020-12-22 | Renville | Minnesota | 27129 | 1245 | 37 |
850433 | 850433 | 2020-12-21 | Renville | Minnesota | 27129 | 1242 | 37 |
847188 | 847188 | 2020-12-20 | Renville | Minnesota | 27129 | 1234 | 37 |
843942 | 843942 | 2020-12-19 | Renville | Minnesota | 27129 | 1225 | 35 |
840697 | 840697 | 2020-12-18 | Renville | Minnesota | 27129 | 1215 | 35 |
837452 | 837452 | 2020-12-17 | Renville | Minnesota | 27129 | 1210 | 35 |
834206 | 834206 | 2020-12-16 | Renville | Minnesota | 27129 | 1199 | 34 |
830959 | 830959 | 2020-12-15 | Renville | Minnesota | 27129 | 1191 | 34 |
827713 | 827713 | 2020-12-14 | Renville | Minnesota | 27129 | 1184 | 34 |
824466 | 824466 | 2020-12-13 | Renville | Minnesota | 27129 | 1180 | 34 |
821220 | 821220 | 2020-12-12 | Renville | Minnesota | 27129 | 1169 | 33 |
817974 | 817974 | 2020-12-11 | Renville | Minnesota | 27129 | 1148 | 32 |
814728 | 814728 | 2020-12-10 | Renville | Minnesota | 27129 | 1137 | 32 |
811483 | 811483 | 2020-12-09 | Renville | Minnesota | 27129 | 1120 | 32 |
808238 | 808238 | 2020-12-08 | Renville | Minnesota | 27129 | 1106 | 32 |
804993 | 804993 | 2020-12-07 | Renville | Minnesota | 27129 | 1092 | 32 |
801748 | 801748 | 2020-12-06 | Renville | Minnesota | 27129 | 1071 | 32 |
798503 | 798503 | 2020-12-05 | Renville | Minnesota | 27129 | 1033 | 31 |
795258 | 795258 | 2020-12-04 | Renville | Minnesota | 27129 | 986 | 30 |
792013 | 792013 | 2020-12-03 | Renville | Minnesota | 27129 | 955 | 30 |
788768 | 788768 | 2020-12-02 | Renville | Minnesota | 27129 | 927 | 29 |
785523 | 785523 | 2020-12-01 | Renville | Minnesota | 27129 | 913 | 29 |
782279 | 782279 | 2020-11-30 | Renville | Minnesota | 27129 | 895 | 29 |
779033 | 779033 | 2020-11-29 | Renville | Minnesota | 27129 | 865 | 27 |
775788 | 775788 | 2020-11-28 | Renville | Minnesota | 27129 | 831 | 24 |
772543 | 772543 | 2020-11-27 | Renville | Minnesota | 27129 | 773 | 22 |
769298 | 769298 | 2020-11-26 | Renville | Minnesota | 27129 | 751 | 19 |
766052 | 766052 | 2020-11-25 | Renville | Minnesota | 27129 | 751 | 19 |
762807 | 762807 | 2020-11-24 | Renville | Minnesota | 27129 | 731 | 18 |
759562 | 759562 | 2020-11-23 | Renville | Minnesota | 27129 | 708 | 18 |
756315 | 756315 | 2020-11-22 | Renville | Minnesota | 27129 | 688 | 18 |
753069 | 753069 | 2020-11-21 | Renville | Minnesota | 27129 | 652 | 18 |
749823 | 749823 | 2020-11-20 | Renville | Minnesota | 27129 | 620 | 17 |
746577 | 746577 | 2020-11-19 | Renville | Minnesota | 27129 | 580 | 17 |
743330 | 743330 | 2020-11-18 | Renville | Minnesota | 27129 | 552 | 16 |
740083 | 740083 | 2020-11-17 | Renville | Minnesota | 27129 | 531 | 15 |
736839 | 736839 | 2020-11-16 | Renville | Minnesota | 27129 | 515 | 14 |
733593 | 733593 | 2020-11-15 | Renville | Minnesota | 27129 | 501 | 14 |
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);