ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Clark", fips = 18019 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054218 | 1054218 | 2021-02-22 | Clark | Indiana | 18019 | 11847 | 187 |
1050971 | 1050971 | 2021-02-21 | Clark | Indiana | 18019 | 11827 | 187 |
1047724 | 1047724 | 2021-02-20 | Clark | Indiana | 18019 | 11811 | 187 |
1044479 | 1044479 | 2021-02-19 | Clark | Indiana | 18019 | 11783 | 187 |
1041234 | 1041234 | 2021-02-18 | Clark | Indiana | 18019 | 11761 | 187 |
1037989 | 1037989 | 2021-02-17 | Clark | Indiana | 18019 | 11747 | 187 |
1034744 | 1034744 | 2021-02-16 | Clark | Indiana | 18019 | 11723 | 185 |
1031498 | 1031498 | 2021-02-15 | Clark | Indiana | 18019 | 11699 | 184 |
1028251 | 1028251 | 2021-02-14 | Clark | Indiana | 18019 | 11675 | 184 |
1025006 | 1025006 | 2021-02-13 | Clark | Indiana | 18019 | 11657 | 183 |
1021761 | 1021761 | 2021-02-12 | Clark | Indiana | 18019 | 11637 | 182 |
1018516 | 1018516 | 2021-02-11 | Clark | Indiana | 18019 | 11602 | 180 |
1015271 | 1015271 | 2021-02-10 | Clark | Indiana | 18019 | 11574 | 179 |
1012026 | 1012026 | 2021-02-09 | Clark | Indiana | 18019 | 11541 | 179 |
1008780 | 1008780 | 2021-02-08 | Clark | Indiana | 18019 | 11498 | 174 |
1005534 | 1005534 | 2021-02-07 | Clark | Indiana | 18019 | 11477 | 174 |
1002288 | 1002288 | 2021-02-06 | Clark | Indiana | 18019 | 11446 | 174 |
999042 | 999042 | 2021-02-05 | Clark | Indiana | 18019 | 11396 | 173 |
995796 | 995796 | 2021-02-04 | Clark | Indiana | 18019 | 11344 | 173 |
992550 | 992550 | 2021-02-03 | Clark | Indiana | 18019 | 11296 | 158 |
989304 | 989304 | 2021-02-02 | Clark | Indiana | 18019 | 11262 | 158 |
986057 | 986057 | 2021-02-01 | Clark | Indiana | 18019 | 11227 | 157 |
982810 | 982810 | 2021-01-31 | Clark | Indiana | 18019 | 11177 | 157 |
979564 | 979564 | 2021-01-30 | Clark | Indiana | 18019 | 11112 | 157 |
976318 | 976318 | 2021-01-29 | Clark | Indiana | 18019 | 11060 | 154 |
973073 | 973073 | 2021-01-28 | Clark | Indiana | 18019 | 10964 | 153 |
969828 | 969828 | 2021-01-27 | Clark | Indiana | 18019 | 10910 | 153 |
966584 | 966584 | 2021-01-26 | Clark | Indiana | 18019 | 10873 | 153 |
963339 | 963339 | 2021-01-25 | Clark | Indiana | 18019 | 10832 | 152 |
960094 | 960094 | 2021-01-24 | Clark | Indiana | 18019 | 10752 | 152 |
956848 | 956848 | 2021-01-23 | Clark | Indiana | 18019 | 10698 | 152 |
953603 | 953603 | 2021-01-22 | Clark | Indiana | 18019 | 10602 | 147 |
950358 | 950358 | 2021-01-21 | Clark | Indiana | 18019 | 10541 | 145 |
947112 | 947112 | 2021-01-20 | Clark | Indiana | 18019 | 10449 | 144 |
943865 | 943865 | 2021-01-19 | Clark | Indiana | 18019 | 10370 | 143 |
940620 | 940620 | 2021-01-18 | Clark | Indiana | 18019 | 10321 | 140 |
937375 | 937375 | 2021-01-17 | Clark | Indiana | 18019 | 10261 | 138 |
934130 | 934130 | 2021-01-16 | Clark | Indiana | 18019 | 10172 | 137 |
930885 | 930885 | 2021-01-15 | Clark | Indiana | 18019 | 10053 | 137 |
927640 | 927640 | 2021-01-14 | Clark | Indiana | 18019 | 9973 | 136 |
924394 | 924394 | 2021-01-13 | Clark | Indiana | 18019 | 9885 | 134 |
921149 | 921149 | 2021-01-12 | Clark | Indiana | 18019 | 9778 | 133 |
917904 | 917904 | 2021-01-11 | Clark | Indiana | 18019 | 9716 | 130 |
914659 | 914659 | 2021-01-10 | Clark | Indiana | 18019 | 9636 | 130 |
911414 | 911414 | 2021-01-09 | Clark | Indiana | 18019 | 9514 | 130 |
908169 | 908169 | 2021-01-08 | Clark | Indiana | 18019 | 9357 | 130 |
904923 | 904923 | 2021-01-07 | Clark | Indiana | 18019 | 9253 | 127 |
901678 | 901678 | 2021-01-06 | Clark | Indiana | 18019 | 9104 | 127 |
898433 | 898433 | 2021-01-05 | Clark | Indiana | 18019 | 9004 | 125 |
895188 | 895188 | 2021-01-04 | Clark | Indiana | 18019 | 8894 | 121 |
891941 | 891941 | 2021-01-03 | Clark | Indiana | 18019 | 8785 | 121 |
888695 | 888695 | 2021-01-02 | Clark | Indiana | 18019 | 8701 | 121 |
885449 | 885449 | 2021-01-01 | Clark | Indiana | 18019 | 8566 | 121 |
882204 | 882204 | 2020-12-31 | Clark | Indiana | 18019 | 8403 | 119 |
878959 | 878959 | 2020-12-30 | Clark | Indiana | 18019 | 8262 | 119 |
875714 | 875714 | 2020-12-29 | Clark | Indiana | 18019 | 8185 | 116 |
872469 | 872469 | 2020-12-28 | Clark | Indiana | 18019 | 8094 | 115 |
869224 | 869224 | 2020-12-27 | Clark | Indiana | 18019 | 8048 | 115 |
865979 | 865979 | 2020-12-26 | Clark | Indiana | 18019 | 7994 | 114 |
862734 | 862734 | 2020-12-25 | Clark | Indiana | 18019 | 7929 | 114 |
859489 | 859489 | 2020-12-24 | Clark | Indiana | 18019 | 7816 | 114 |
856244 | 856244 | 2020-12-23 | Clark | Indiana | 18019 | 7699 | 112 |
852999 | 852999 | 2020-12-22 | Clark | Indiana | 18019 | 7597 | 111 |
849754 | 849754 | 2020-12-21 | Clark | Indiana | 18019 | 7543 | 110 |
846509 | 846509 | 2020-12-20 | Clark | Indiana | 18019 | 7475 | 110 |
843263 | 843263 | 2020-12-19 | Clark | Indiana | 18019 | 7378 | 110 |
840018 | 840018 | 2020-12-18 | Clark | Indiana | 18019 | 7267 | 107 |
836773 | 836773 | 2020-12-17 | Clark | Indiana | 18019 | 7182 | 107 |
833527 | 833527 | 2020-12-16 | Clark | Indiana | 18019 | 7064 | 106 |
830280 | 830280 | 2020-12-15 | Clark | Indiana | 18019 | 6987 | 103 |
827034 | 827034 | 2020-12-14 | Clark | Indiana | 18019 | 6916 | 99 |
823787 | 823787 | 2020-12-13 | Clark | Indiana | 18019 | 6842 | 99 |
820541 | 820541 | 2020-12-12 | Clark | Indiana | 18019 | 6737 | 99 |
817295 | 817295 | 2020-12-11 | Clark | Indiana | 18019 | 6604 | 99 |
814049 | 814049 | 2020-12-10 | Clark | Indiana | 18019 | 6501 | 99 |
810804 | 810804 | 2020-12-09 | Clark | Indiana | 18019 | 6393 | 98 |
807559 | 807559 | 2020-12-08 | Clark | Indiana | 18019 | 6300 | 97 |
804314 | 804314 | 2020-12-07 | Clark | Indiana | 18019 | 6185 | 94 |
801069 | 801069 | 2020-12-06 | Clark | Indiana | 18019 | 6120 | 94 |
797824 | 797824 | 2020-12-05 | Clark | Indiana | 18019 | 6014 | 94 |
794579 | 794579 | 2020-12-04 | Clark | Indiana | 18019 | 5874 | 94 |
791334 | 791334 | 2020-12-03 | Clark | Indiana | 18019 | 5779 | 93 |
788089 | 788089 | 2020-12-02 | Clark | Indiana | 18019 | 5668 | 91 |
784845 | 784845 | 2020-12-01 | Clark | Indiana | 18019 | 5568 | 88 |
781600 | 781600 | 2020-11-30 | Clark | Indiana | 18019 | 5496 | 85 |
778354 | 778354 | 2020-11-29 | Clark | Indiana | 18019 | 5424 | 85 |
775109 | 775109 | 2020-11-28 | Clark | Indiana | 18019 | 5382 | 85 |
771864 | 771864 | 2020-11-27 | Clark | Indiana | 18019 | 5330 | 85 |
768619 | 768619 | 2020-11-26 | Clark | Indiana | 18019 | 5248 | 84 |
765373 | 765373 | 2020-11-25 | Clark | Indiana | 18019 | 5170 | 84 |
762128 | 762128 | 2020-11-24 | Clark | Indiana | 18019 | 5060 | 84 |
758883 | 758883 | 2020-11-23 | Clark | Indiana | 18019 | 4973 | 81 |
755636 | 755636 | 2020-11-22 | Clark | Indiana | 18019 | 4887 | 81 |
752390 | 752390 | 2020-11-21 | Clark | Indiana | 18019 | 4813 | 81 |
749144 | 749144 | 2020-11-20 | Clark | Indiana | 18019 | 4651 | 81 |
745898 | 745898 | 2020-11-19 | Clark | Indiana | 18019 | 4559 | 81 |
742651 | 742651 | 2020-11-18 | Clark | Indiana | 18019 | 4460 | 81 |
739404 | 739404 | 2020-11-17 | Clark | Indiana | 18019 | 4390 | 81 |
736160 | 736160 | 2020-11-16 | Clark | Indiana | 18019 | 4326 | 81 |
732914 | 732914 | 2020-11-15 | Clark | Indiana | 18019 | 4283 | 80 |
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);