ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and fips = 27027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1048352 | 1048352 | 2021-02-20 | Clay | Minnesota | 27027 | 6790 | 84 |
1045106 | 1045106 | 2021-02-19 | Clay | Minnesota | 27027 | 6780 | 84 |
1041861 | 1041861 | 2021-02-18 | Clay | Minnesota | 27027 | 6768 | 84 |
1038616 | 1038616 | 2021-02-17 | Clay | Minnesota | 27027 | 6752 | 84 |
1035371 | 1035371 | 2021-02-16 | Clay | Minnesota | 27027 | 6746 | 84 |
1032126 | 1032126 | 2021-02-15 | Clay | Minnesota | 27027 | 6740 | 84 |
1028879 | 1028879 | 2021-02-14 | Clay | Minnesota | 27027 | 6735 | 84 |
1025633 | 1025633 | 2021-02-13 | Clay | Minnesota | 27027 | 6729 | 84 |
1022388 | 1022388 | 2021-02-12 | Clay | Minnesota | 27027 | 6729 | 83 |
1019143 | 1019143 | 2021-02-11 | Clay | Minnesota | 27027 | 6725 | 83 |
1015898 | 1015898 | 2021-02-10 | Clay | Minnesota | 27027 | 6716 | 83 |
1012653 | 1012653 | 2021-02-09 | Clay | Minnesota | 27027 | 6712 | 83 |
1009408 | 1009408 | 2021-02-08 | Clay | Minnesota | 27027 | 6710 | 83 |
1006161 | 1006161 | 2021-02-07 | Clay | Minnesota | 27027 | 6710 | 83 |
1002915 | 1002915 | 2021-02-06 | Clay | Minnesota | 27027 | 6707 | 83 |
999670 | 999670 | 2021-02-05 | Clay | Minnesota | 27027 | 6701 | 84 |
996424 | 996424 | 2021-02-04 | Clay | Minnesota | 27027 | 6690 | 84 |
993178 | 993178 | 2021-02-03 | Clay | Minnesota | 27027 | 6675 | 84 |
989932 | 989932 | 2021-02-02 | Clay | Minnesota | 27027 | 6669 | 84 |
986685 | 986685 | 2021-02-01 | Clay | Minnesota | 27027 | 6667 | 84 |
983438 | 983438 | 2021-01-31 | Clay | Minnesota | 27027 | 6665 | 84 |
980192 | 980192 | 2021-01-30 | Clay | Minnesota | 27027 | 6655 | 84 |
976946 | 976946 | 2021-01-29 | Clay | Minnesota | 27027 | 6645 | 84 |
973701 | 973701 | 2021-01-28 | Clay | Minnesota | 27027 | 6636 | 84 |
970456 | 970456 | 2021-01-27 | Clay | Minnesota | 27027 | 6621 | 84 |
967211 | 967211 | 2021-01-26 | Clay | Minnesota | 27027 | 6613 | 84 |
963967 | 963967 | 2021-01-25 | Clay | Minnesota | 27027 | 6606 | 84 |
960722 | 960722 | 2021-01-24 | Clay | Minnesota | 27027 | 6588 | 84 |
957476 | 957476 | 2021-01-23 | Clay | Minnesota | 27027 | 6576 | 84 |
954231 | 954231 | 2021-01-22 | Clay | Minnesota | 27027 | 6555 | 82 |
950986 | 950986 | 2021-01-21 | Clay | Minnesota | 27027 | 6546 | 81 |
947740 | 947740 | 2021-01-20 | Clay | Minnesota | 27027 | 6539 | 81 |
944493 | 944493 | 2021-01-19 | Clay | Minnesota | 27027 | 6532 | 80 |
941248 | 941248 | 2021-01-18 | Clay | Minnesota | 27027 | 6516 | 80 |
938003 | 938003 | 2021-01-17 | Clay | Minnesota | 27027 | 6502 | 80 |
934758 | 934758 | 2021-01-16 | Clay | Minnesota | 27027 | 6484 | 78 |
931513 | 931513 | 2021-01-15 | Clay | Minnesota | 27027 | 6466 | 78 |
928268 | 928268 | 2021-01-14 | Clay | Minnesota | 27027 | 6432 | 78 |
925022 | 925022 | 2021-01-13 | Clay | Minnesota | 27027 | 6410 | 78 |
921777 | 921777 | 2021-01-12 | Clay | Minnesota | 27027 | 6392 | 78 |
918532 | 918532 | 2021-01-11 | Clay | Minnesota | 27027 | 6372 | 78 |
915287 | 915287 | 2021-01-10 | Clay | Minnesota | 27027 | 6369 | 78 |
912042 | 912042 | 2021-01-09 | Clay | Minnesota | 27027 | 6357 | 78 |
908797 | 908797 | 2021-01-08 | Clay | Minnesota | 27027 | 6345 | 78 |
905551 | 905551 | 2021-01-07 | Clay | Minnesota | 27027 | 6320 | 78 |
902306 | 902306 | 2021-01-06 | Clay | Minnesota | 27027 | 6306 | 78 |
899061 | 899061 | 2021-01-05 | Clay | Minnesota | 27027 | 6280 | 78 |
895816 | 895816 | 2021-01-04 | Clay | Minnesota | 27027 | 6261 | 78 |
892569 | 892569 | 2021-01-03 | Clay | Minnesota | 27027 | 6212 | 78 |
889323 | 889323 | 2021-01-02 | Clay | Minnesota | 27027 | 6188 | 78 |
886077 | 886077 | 2021-01-01 | Clay | Minnesota | 27027 | 6163 | 78 |
882832 | 882832 | 2020-12-31 | Clay | Minnesota | 27027 | 6163 | 78 |
879587 | 879587 | 2020-12-30 | Clay | Minnesota | 27027 | 6143 | 78 |
876342 | 876342 | 2020-12-29 | Clay | Minnesota | 27027 | 6129 | 77 |
873097 | 873097 | 2020-12-28 | Clay | Minnesota | 27027 | 6123 | 77 |
869852 | 869852 | 2020-12-27 | Clay | Minnesota | 27027 | 6115 | 77 |
866607 | 866607 | 2020-12-26 | Clay | Minnesota | 27027 | 6090 | 75 |
863362 | 863362 | 2020-12-25 | Clay | Minnesota | 27027 | 6065 | 75 |
860117 | 860117 | 2020-12-24 | Clay | Minnesota | 27027 | 6065 | 75 |
856872 | 856872 | 2020-12-23 | Clay | Minnesota | 27027 | 6050 | 73 |
853627 | 853627 | 2020-12-22 | Clay | Minnesota | 27027 | 6036 | 73 |
850382 | 850382 | 2020-12-21 | Clay | Minnesota | 27027 | 6003 | 73 |
847137 | 847137 | 2020-12-20 | Clay | Minnesota | 27027 | 5983 | 73 |
843891 | 843891 | 2020-12-19 | Clay | Minnesota | 27027 | 5955 | 73 |
840646 | 840646 | 2020-12-18 | Clay | Minnesota | 27027 | 5920 | 71 |
837401 | 837401 | 2020-12-17 | Clay | Minnesota | 27027 | 5896 | 70 |
834155 | 834155 | 2020-12-16 | Clay | Minnesota | 27027 | 5864 | 69 |
830908 | 830908 | 2020-12-15 | Clay | Minnesota | 27027 | 5827 | 69 |
827662 | 827662 | 2020-12-14 | Clay | Minnesota | 27027 | 5799 | 69 |
824415 | 824415 | 2020-12-13 | Clay | Minnesota | 27027 | 5757 | 69 |
821169 | 821169 | 2020-12-12 | Clay | Minnesota | 27027 | 5730 | 68 |
817923 | 817923 | 2020-12-11 | Clay | Minnesota | 27027 | 5691 | 68 |
814677 | 814677 | 2020-12-10 | Clay | Minnesota | 27027 | 5655 | 67 |
811432 | 811432 | 2020-12-09 | Clay | Minnesota | 27027 | 5623 | 64 |
808187 | 808187 | 2020-12-08 | Clay | Minnesota | 27027 | 5537 | 64 |
804942 | 804942 | 2020-12-07 | Clay | Minnesota | 27027 | 5510 | 64 |
801697 | 801697 | 2020-12-06 | Clay | Minnesota | 27027 | 5453 | 64 |
798452 | 798452 | 2020-12-05 | Clay | Minnesota | 27027 | 5405 | 62 |
795207 | 795207 | 2020-12-04 | Clay | Minnesota | 27027 | 5355 | 62 |
791962 | 791962 | 2020-12-03 | Clay | Minnesota | 27027 | 5299 | 60 |
788717 | 788717 | 2020-12-02 | Clay | Minnesota | 27027 | 5213 | 59 |
785472 | 785472 | 2020-12-01 | Clay | Minnesota | 27027 | 5141 | 57 |
782228 | 782228 | 2020-11-30 | Clay | Minnesota | 27027 | 5089 | 57 |
778982 | 778982 | 2020-11-29 | Clay | Minnesota | 27027 | 4984 | 57 |
775737 | 775737 | 2020-11-28 | Clay | Minnesota | 27027 | 4839 | 56 |
772492 | 772492 | 2020-11-27 | Clay | Minnesota | 27027 | 4733 | 56 |
769247 | 769247 | 2020-11-26 | Clay | Minnesota | 27027 | 4638 | 56 |
766001 | 766001 | 2020-11-25 | Clay | Minnesota | 27027 | 4638 | 56 |
762756 | 762756 | 2020-11-24 | Clay | Minnesota | 27027 | 4496 | 55 |
759511 | 759511 | 2020-11-23 | Clay | Minnesota | 27027 | 4451 | 55 |
756264 | 756264 | 2020-11-22 | Clay | Minnesota | 27027 | 4359 | 54 |
753018 | 753018 | 2020-11-21 | Clay | Minnesota | 27027 | 4248 | 52 |
749772 | 749772 | 2020-11-20 | Clay | Minnesota | 27027 | 4144 | 52 |
746526 | 746526 | 2020-11-19 | Clay | Minnesota | 27027 | 4076 | 51 |
743279 | 743279 | 2020-11-18 | Clay | Minnesota | 27027 | 3955 | 51 |
740032 | 740032 | 2020-11-17 | Clay | Minnesota | 27027 | 3902 | 50 |
736788 | 736788 | 2020-11-16 | Clay | Minnesota | 27027 | 3841 | 50 |
733542 | 733542 | 2020-11-15 | Clay | Minnesota | 27027 | 3773 | 50 |
730297 | 730297 | 2020-11-14 | Clay | Minnesota | 27027 | 3693 | 50 |
727054 | 727054 | 2020-11-13 | Clay | Minnesota | 27027 | 3582 | 50 |
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);