ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Shelby" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054280 | 1054280 | 2021-02-22 | Shelby | Indiana | 18145 | 5496 | 100 |
1051033 | 1051033 | 2021-02-21 | Shelby | Indiana | 18145 | 5493 | 100 |
1047786 | 1047786 | 2021-02-20 | Shelby | Indiana | 18145 | 5490 | 100 |
1044541 | 1044541 | 2021-02-19 | Shelby | Indiana | 18145 | 5478 | 100 |
1041296 | 1041296 | 2021-02-18 | Shelby | Indiana | 18145 | 5469 | 99 |
1038051 | 1038051 | 2021-02-17 | Shelby | Indiana | 18145 | 5464 | 98 |
1034806 | 1034806 | 2021-02-16 | Shelby | Indiana | 18145 | 5458 | 98 |
1031560 | 1031560 | 2021-02-15 | Shelby | Indiana | 18145 | 5455 | 98 |
1028313 | 1028313 | 2021-02-14 | Shelby | Indiana | 18145 | 5444 | 98 |
1025068 | 1025068 | 2021-02-13 | Shelby | Indiana | 18145 | 5432 | 98 |
1021823 | 1021823 | 2021-02-12 | Shelby | Indiana | 18145 | 5425 | 98 |
1018578 | 1018578 | 2021-02-11 | Shelby | Indiana | 18145 | 5413 | 97 |
1015333 | 1015333 | 2021-02-10 | Shelby | Indiana | 18145 | 5394 | 97 |
1012088 | 1012088 | 2021-02-09 | Shelby | Indiana | 18145 | 5376 | 97 |
1008842 | 1008842 | 2021-02-08 | Shelby | Indiana | 18145 | 5352 | 97 |
1005596 | 1005596 | 2021-02-07 | Shelby | Indiana | 18145 | 5347 | 96 |
1002350 | 1002350 | 2021-02-06 | Shelby | Indiana | 18145 | 5336 | 96 |
999104 | 999104 | 2021-02-05 | Shelby | Indiana | 18145 | 5312 | 95 |
995858 | 995858 | 2021-02-04 | Shelby | Indiana | 18145 | 5297 | 95 |
992612 | 992612 | 2021-02-03 | Shelby | Indiana | 18145 | 5271 | 93 |
989366 | 989366 | 2021-02-02 | Shelby | Indiana | 18145 | 5257 | 92 |
986119 | 986119 | 2021-02-01 | Shelby | Indiana | 18145 | 5235 | 92 |
982872 | 982872 | 2021-01-31 | Shelby | Indiana | 18145 | 5216 | 92 |
979626 | 979626 | 2021-01-30 | Shelby | Indiana | 18145 | 5206 | 92 |
976380 | 976380 | 2021-01-29 | Shelby | Indiana | 18145 | 5182 | 92 |
973135 | 973135 | 2021-01-28 | Shelby | Indiana | 18145 | 5161 | 92 |
969890 | 969890 | 2021-01-27 | Shelby | Indiana | 18145 | 5134 | 92 |
966646 | 966646 | 2021-01-26 | Shelby | Indiana | 18145 | 5111 | 91 |
963401 | 963401 | 2021-01-25 | Shelby | Indiana | 18145 | 5079 | 91 |
960156 | 960156 | 2021-01-24 | Shelby | Indiana | 18145 | 5066 | 91 |
956910 | 956910 | 2021-01-23 | Shelby | Indiana | 18145 | 5046 | 91 |
953665 | 953665 | 2021-01-22 | Shelby | Indiana | 18145 | 5003 | 91 |
950420 | 950420 | 2021-01-21 | Shelby | Indiana | 18145 | 4969 | 91 |
947174 | 947174 | 2021-01-20 | Shelby | Indiana | 18145 | 4942 | 90 |
943927 | 943927 | 2021-01-19 | Shelby | Indiana | 18145 | 4911 | 90 |
940682 | 940682 | 2021-01-18 | Shelby | Indiana | 18145 | 4893 | 89 |
937437 | 937437 | 2021-01-17 | Shelby | Indiana | 18145 | 4872 | 89 |
934192 | 934192 | 2021-01-16 | Shelby | Indiana | 18145 | 4857 | 88 |
930947 | 930947 | 2021-01-15 | Shelby | Indiana | 18145 | 4826 | 87 |
927702 | 927702 | 2021-01-14 | Shelby | Indiana | 18145 | 4784 | 85 |
924456 | 924456 | 2021-01-13 | Shelby | Indiana | 18145 | 4751 | 85 |
921211 | 921211 | 2021-01-12 | Shelby | Indiana | 18145 | 4722 | 84 |
917966 | 917966 | 2021-01-11 | Shelby | Indiana | 18145 | 4676 | 84 |
914721 | 914721 | 2021-01-10 | Shelby | Indiana | 18145 | 4652 | 84 |
911476 | 911476 | 2021-01-09 | Shelby | Indiana | 18145 | 4611 | 84 |
908231 | 908231 | 2021-01-08 | Shelby | Indiana | 18145 | 4560 | 84 |
904985 | 904985 | 2021-01-07 | Shelby | Indiana | 18145 | 4512 | 84 |
901740 | 901740 | 2021-01-06 | Shelby | Indiana | 18145 | 4436 | 84 |
898495 | 898495 | 2021-01-05 | Shelby | Indiana | 18145 | 4373 | 84 |
895250 | 895250 | 2021-01-04 | Shelby | Indiana | 18145 | 4329 | 83 |
892003 | 892003 | 2021-01-03 | Shelby | Indiana | 18145 | 4311 | 83 |
888757 | 888757 | 2021-01-02 | Shelby | Indiana | 18145 | 4292 | 83 |
885511 | 885511 | 2021-01-01 | Shelby | Indiana | 18145 | 4250 | 82 |
882266 | 882266 | 2020-12-31 | Shelby | Indiana | 18145 | 4202 | 82 |
879021 | 879021 | 2020-12-30 | Shelby | Indiana | 18145 | 4130 | 81 |
875776 | 875776 | 2020-12-29 | Shelby | Indiana | 18145 | 4072 | 81 |
872531 | 872531 | 2020-12-28 | Shelby | Indiana | 18145 | 4031 | 79 |
869286 | 869286 | 2020-12-27 | Shelby | Indiana | 18145 | 4009 | 78 |
866041 | 866041 | 2020-12-26 | Shelby | Indiana | 18145 | 4003 | 78 |
862796 | 862796 | 2020-12-25 | Shelby | Indiana | 18145 | 3987 | 78 |
859551 | 859551 | 2020-12-24 | Shelby | Indiana | 18145 | 3962 | 78 |
856306 | 856306 | 2020-12-23 | Shelby | Indiana | 18145 | 3913 | 78 |
853061 | 853061 | 2020-12-22 | Shelby | Indiana | 18145 | 3868 | 78 |
849816 | 849816 | 2020-12-21 | Shelby | Indiana | 18145 | 3822 | 78 |
846571 | 846571 | 2020-12-20 | Shelby | Indiana | 18145 | 3805 | 77 |
843325 | 843325 | 2020-12-19 | Shelby | Indiana | 18145 | 3757 | 77 |
840080 | 840080 | 2020-12-18 | Shelby | Indiana | 18145 | 3709 | 77 |
836835 | 836835 | 2020-12-17 | Shelby | Indiana | 18145 | 3676 | 77 |
833589 | 833589 | 2020-12-16 | Shelby | Indiana | 18145 | 3622 | 77 |
830342 | 830342 | 2020-12-15 | Shelby | Indiana | 18145 | 3579 | 77 |
827096 | 827096 | 2020-12-14 | Shelby | Indiana | 18145 | 3519 | 76 |
823849 | 823849 | 2020-12-13 | Shelby | Indiana | 18145 | 3494 | 76 |
820603 | 820603 | 2020-12-12 | Shelby | Indiana | 18145 | 3435 | 76 |
817357 | 817357 | 2020-12-11 | Shelby | Indiana | 18145 | 3385 | 75 |
814111 | 814111 | 2020-12-10 | Shelby | Indiana | 18145 | 3298 | 74 |
810866 | 810866 | 2020-12-09 | Shelby | Indiana | 18145 | 3215 | 74 |
807621 | 807621 | 2020-12-08 | Shelby | Indiana | 18145 | 3135 | 74 |
804376 | 804376 | 2020-12-07 | Shelby | Indiana | 18145 | 3076 | 72 |
801131 | 801131 | 2020-12-06 | Shelby | Indiana | 18145 | 3040 | 72 |
797886 | 797886 | 2020-12-05 | Shelby | Indiana | 18145 | 2982 | 71 |
794641 | 794641 | 2020-12-04 | Shelby | Indiana | 18145 | 2912 | 71 |
791396 | 791396 | 2020-12-03 | Shelby | Indiana | 18145 | 2837 | 70 |
788151 | 788151 | 2020-12-02 | Shelby | Indiana | 18145 | 2796 | 70 |
784907 | 784907 | 2020-12-01 | Shelby | Indiana | 18145 | 2750 | 68 |
781662 | 781662 | 2020-11-30 | Shelby | Indiana | 18145 | 2702 | 68 |
778416 | 778416 | 2020-11-29 | Shelby | Indiana | 18145 | 2655 | 68 |
775171 | 775171 | 2020-11-28 | Shelby | Indiana | 18145 | 2605 | 66 |
771926 | 771926 | 2020-11-27 | Shelby | Indiana | 18145 | 2568 | 65 |
768681 | 768681 | 2020-11-26 | Shelby | Indiana | 18145 | 2538 | 65 |
765435 | 765435 | 2020-11-25 | Shelby | Indiana | 18145 | 2463 | 64 |
762190 | 762190 | 2020-11-24 | Shelby | Indiana | 18145 | 2416 | 63 |
758945 | 758945 | 2020-11-23 | Shelby | Indiana | 18145 | 2359 | 63 |
755698 | 755698 | 2020-11-22 | Shelby | Indiana | 18145 | 2318 | 62 |
752452 | 752452 | 2020-11-21 | Shelby | Indiana | 18145 | 2278 | 62 |
749206 | 749206 | 2020-11-20 | Shelby | Indiana | 18145 | 2217 | 62 |
745960 | 745960 | 2020-11-19 | Shelby | Indiana | 18145 | 2189 | 61 |
742713 | 742713 | 2020-11-18 | Shelby | Indiana | 18145 | 2150 | 58 |
739466 | 739466 | 2020-11-17 | Shelby | Indiana | 18145 | 2103 | 58 |
736222 | 736222 | 2020-11-16 | Shelby | Indiana | 18145 | 2038 | 57 |
732976 | 732976 | 2020-11-15 | Shelby | Indiana | 18145 | 2020 | 57 |
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);