ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Blue Earth" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090539 | 1090539 | 2021-03-05 | Blue Earth | Minnesota | 27013 | 5996 | 35 |
1087294 | 1087294 | 2021-03-04 | Blue Earth | Minnesota | 27013 | 5983 | 35 |
1084049 | 1084049 | 2021-03-03 | Blue Earth | Minnesota | 27013 | 5966 | 35 |
1080803 | 1080803 | 2021-03-02 | Blue Earth | Minnesota | 27013 | 5947 | 35 |
1077557 | 1077557 | 2021-03-01 | Blue Earth | Minnesota | 27013 | 5938 | 35 |
1074311 | 1074311 | 2021-02-28 | Blue Earth | Minnesota | 27013 | 5926 | 35 |
1071065 | 1071065 | 2021-02-27 | Blue Earth | Minnesota | 27013 | 5910 | 35 |
1067820 | 1067820 | 2021-02-26 | Blue Earth | Minnesota | 27013 | 5896 | 35 |
1064575 | 1064575 | 2021-02-25 | Blue Earth | Minnesota | 27013 | 5880 | 35 |
1061331 | 1061331 | 2021-02-24 | Blue Earth | Minnesota | 27013 | 5872 | 35 |
1058085 | 1058085 | 2021-02-23 | Blue Earth | Minnesota | 27013 | 5855 | 35 |
1054839 | 1054839 | 2021-02-22 | Blue Earth | Minnesota | 27013 | 5848 | 35 |
1051592 | 1051592 | 2021-02-21 | Blue Earth | Minnesota | 27013 | 5834 | 35 |
1048345 | 1048345 | 2021-02-20 | Blue Earth | Minnesota | 27013 | 5811 | 34 |
1045099 | 1045099 | 2021-02-19 | Blue Earth | Minnesota | 27013 | 5796 | 34 |
1041854 | 1041854 | 2021-02-18 | Blue Earth | Minnesota | 27013 | 5790 | 34 |
1038609 | 1038609 | 2021-02-17 | Blue Earth | Minnesota | 27013 | 5766 | 34 |
1035364 | 1035364 | 2021-02-16 | Blue Earth | Minnesota | 27013 | 5745 | 34 |
1032119 | 1032119 | 2021-02-15 | Blue Earth | Minnesota | 27013 | 5736 | 34 |
1028872 | 1028872 | 2021-02-14 | Blue Earth | Minnesota | 27013 | 5723 | 34 |
1025626 | 1025626 | 2021-02-13 | Blue Earth | Minnesota | 27013 | 5707 | 34 |
1022381 | 1022381 | 2021-02-12 | Blue Earth | Minnesota | 27013 | 5690 | 34 |
1019136 | 1019136 | 2021-02-11 | Blue Earth | Minnesota | 27013 | 5675 | 34 |
1015891 | 1015891 | 2021-02-10 | Blue Earth | Minnesota | 27013 | 5661 | 34 |
1012646 | 1012646 | 2021-02-09 | Blue Earth | Minnesota | 27013 | 5643 | 34 |
1009401 | 1009401 | 2021-02-08 | Blue Earth | Minnesota | 27013 | 5627 | 34 |
1006154 | 1006154 | 2021-02-07 | Blue Earth | Minnesota | 27013 | 5619 | 34 |
1002908 | 1002908 | 2021-02-06 | Blue Earth | Minnesota | 27013 | 5608 | 34 |
999663 | 999663 | 2021-02-05 | Blue Earth | Minnesota | 27013 | 5600 | 34 |
996417 | 996417 | 2021-02-04 | Blue Earth | Minnesota | 27013 | 5592 | 34 |
993171 | 993171 | 2021-02-03 | Blue Earth | Minnesota | 27013 | 5578 | 34 |
989925 | 989925 | 2021-02-02 | Blue Earth | Minnesota | 27013 | 5568 | 33 |
986678 | 986678 | 2021-02-01 | Blue Earth | Minnesota | 27013 | 5556 | 33 |
983431 | 983431 | 2021-01-31 | Blue Earth | Minnesota | 27013 | 5545 | 33 |
980185 | 980185 | 2021-01-30 | Blue Earth | Minnesota | 27013 | 5544 | 33 |
976939 | 976939 | 2021-01-29 | Blue Earth | Minnesota | 27013 | 5534 | 33 |
973694 | 973694 | 2021-01-28 | Blue Earth | Minnesota | 27013 | 5523 | 33 |
970449 | 970449 | 2021-01-27 | Blue Earth | Minnesota | 27013 | 5508 | 33 |
967204 | 967204 | 2021-01-26 | Blue Earth | Minnesota | 27013 | 5496 | 33 |
963960 | 963960 | 2021-01-25 | Blue Earth | Minnesota | 27013 | 5495 | 33 |
960715 | 960715 | 2021-01-24 | Blue Earth | Minnesota | 27013 | 5480 | 33 |
957469 | 957469 | 2021-01-23 | Blue Earth | Minnesota | 27013 | 5468 | 33 |
954224 | 954224 | 2021-01-22 | Blue Earth | Minnesota | 27013 | 5459 | 33 |
950979 | 950979 | 2021-01-21 | Blue Earth | Minnesota | 27013 | 5448 | 33 |
947733 | 947733 | 2021-01-20 | Blue Earth | Minnesota | 27013 | 5432 | 33 |
944486 | 944486 | 2021-01-19 | Blue Earth | Minnesota | 27013 | 5410 | 33 |
941241 | 941241 | 2021-01-18 | Blue Earth | Minnesota | 27013 | 5399 | 33 |
937996 | 937996 | 2021-01-17 | Blue Earth | Minnesota | 27013 | 5389 | 33 |
934751 | 934751 | 2021-01-16 | Blue Earth | Minnesota | 27013 | 5380 | 33 |
931506 | 931506 | 2021-01-15 | Blue Earth | Minnesota | 27013 | 5363 | 33 |
928261 | 928261 | 2021-01-14 | Blue Earth | Minnesota | 27013 | 5338 | 33 |
925015 | 925015 | 2021-01-13 | Blue Earth | Minnesota | 27013 | 5326 | 33 |
921770 | 921770 | 2021-01-12 | Blue Earth | Minnesota | 27013 | 5306 | 32 |
918525 | 918525 | 2021-01-11 | Blue Earth | Minnesota | 27013 | 5274 | 32 |
915280 | 915280 | 2021-01-10 | Blue Earth | Minnesota | 27013 | 5272 | 32 |
912035 | 912035 | 2021-01-09 | Blue Earth | Minnesota | 27013 | 5263 | 32 |
908790 | 908790 | 2021-01-08 | Blue Earth | Minnesota | 27013 | 5226 | 32 |
905544 | 905544 | 2021-01-07 | Blue Earth | Minnesota | 27013 | 5192 | 32 |
902299 | 902299 | 2021-01-06 | Blue Earth | Minnesota | 27013 | 5171 | 29 |
899054 | 899054 | 2021-01-05 | Blue Earth | Minnesota | 27013 | 5153 | 30 |
895809 | 895809 | 2021-01-04 | Blue Earth | Minnesota | 27013 | 5135 | 30 |
892562 | 892562 | 2021-01-03 | Blue Earth | Minnesota | 27013 | 5091 | 30 |
889316 | 889316 | 2021-01-02 | Blue Earth | Minnesota | 27013 | 5072 | 28 |
886070 | 886070 | 2021-01-01 | Blue Earth | Minnesota | 27013 | 5040 | 28 |
882825 | 882825 | 2020-12-31 | Blue Earth | Minnesota | 27013 | 5040 | 28 |
879580 | 879580 | 2020-12-30 | Blue Earth | Minnesota | 27013 | 5026 | 28 |
876335 | 876335 | 2020-12-29 | Blue Earth | Minnesota | 27013 | 4994 | 28 |
873090 | 873090 | 2020-12-28 | Blue Earth | Minnesota | 27013 | 4975 | 28 |
869845 | 869845 | 2020-12-27 | Blue Earth | Minnesota | 27013 | 4967 | 28 |
866600 | 866600 | 2020-12-26 | Blue Earth | Minnesota | 27013 | 4941 | 28 |
863355 | 863355 | 2020-12-25 | Blue Earth | Minnesota | 27013 | 4910 | 27 |
860110 | 860110 | 2020-12-24 | Blue Earth | Minnesota | 27013 | 4910 | 27 |
856865 | 856865 | 2020-12-23 | Blue Earth | Minnesota | 27013 | 4879 | 27 |
853620 | 853620 | 2020-12-22 | Blue Earth | Minnesota | 27013 | 4867 | 26 |
850375 | 850375 | 2020-12-21 | Blue Earth | Minnesota | 27013 | 4850 | 25 |
847130 | 847130 | 2020-12-20 | Blue Earth | Minnesota | 27013 | 4831 | 24 |
843884 | 843884 | 2020-12-19 | Blue Earth | Minnesota | 27013 | 4817 | 23 |
840639 | 840639 | 2020-12-18 | Blue Earth | Minnesota | 27013 | 4793 | 22 |
837394 | 837394 | 2020-12-17 | Blue Earth | Minnesota | 27013 | 4765 | 22 |
834148 | 834148 | 2020-12-16 | Blue Earth | Minnesota | 27013 | 4746 | 22 |
830901 | 830901 | 2020-12-15 | Blue Earth | Minnesota | 27013 | 4732 | 22 |
827655 | 827655 | 2020-12-14 | Blue Earth | Minnesota | 27013 | 4710 | 22 |
824408 | 824408 | 2020-12-13 | Blue Earth | Minnesota | 27013 | 4696 | 22 |
821162 | 821162 | 2020-12-12 | Blue Earth | Minnesota | 27013 | 4655 | 22 |
817916 | 817916 | 2020-12-11 | Blue Earth | Minnesota | 27013 | 4609 | 22 |
814670 | 814670 | 2020-12-10 | Blue Earth | Minnesota | 27013 | 4590 | 19 |
811425 | 811425 | 2020-12-09 | Blue Earth | Minnesota | 27013 | 4558 | 18 |
808180 | 808180 | 2020-12-08 | Blue Earth | Minnesota | 27013 | 4508 | 17 |
804935 | 804935 | 2020-12-07 | Blue Earth | Minnesota | 27013 | 4479 | 17 |
801690 | 801690 | 2020-12-06 | Blue Earth | Minnesota | 27013 | 4452 | 17 |
798445 | 798445 | 2020-12-05 | Blue Earth | Minnesota | 27013 | 4415 | 17 |
795200 | 795200 | 2020-12-04 | Blue Earth | Minnesota | 27013 | 4362 | 17 |
791955 | 791955 | 2020-12-03 | Blue Earth | Minnesota | 27013 | 4312 | 17 |
788710 | 788710 | 2020-12-02 | Blue Earth | Minnesota | 27013 | 4266 | 17 |
785465 | 785465 | 2020-12-01 | Blue Earth | Minnesota | 27013 | 4213 | 16 |
782221 | 782221 | 2020-11-30 | Blue Earth | Minnesota | 27013 | 4180 | 16 |
778975 | 778975 | 2020-11-29 | Blue Earth | Minnesota | 27013 | 4141 | 16 |
775730 | 775730 | 2020-11-28 | Blue Earth | Minnesota | 27013 | 4052 | 14 |
772485 | 772485 | 2020-11-27 | Blue Earth | Minnesota | 27013 | 3958 | 13 |
769240 | 769240 | 2020-11-26 | Blue Earth | Minnesota | 27013 | 3871 | 12 |
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);