ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Boone" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054214 | 1054214 | 2021-02-22 | Boone | Indiana | 18011 | 6049 | 93 |
1050967 | 1050967 | 2021-02-21 | Boone | Indiana | 18011 | 6041 | 93 |
1047720 | 1047720 | 2021-02-20 | Boone | Indiana | 18011 | 6034 | 93 |
1044475 | 1044475 | 2021-02-19 | Boone | Indiana | 18011 | 6025 | 93 |
1041230 | 1041230 | 2021-02-18 | Boone | Indiana | 18011 | 6014 | 93 |
1037985 | 1037985 | 2021-02-17 | Boone | Indiana | 18011 | 6005 | 93 |
1034740 | 1034740 | 2021-02-16 | Boone | Indiana | 18011 | 5997 | 93 |
1031494 | 1031494 | 2021-02-15 | Boone | Indiana | 18011 | 5989 | 92 |
1028247 | 1028247 | 2021-02-14 | Boone | Indiana | 18011 | 5980 | 92 |
1025002 | 1025002 | 2021-02-13 | Boone | Indiana | 18011 | 5975 | 92 |
1021757 | 1021757 | 2021-02-12 | Boone | Indiana | 18011 | 5966 | 92 |
1018512 | 1018512 | 2021-02-11 | Boone | Indiana | 18011 | 5946 | 91 |
1015267 | 1015267 | 2021-02-10 | Boone | Indiana | 18011 | 5912 | 91 |
1012022 | 1012022 | 2021-02-09 | Boone | Indiana | 18011 | 5895 | 91 |
1008776 | 1008776 | 2021-02-08 | Boone | Indiana | 18011 | 5874 | 90 |
1005530 | 1005530 | 2021-02-07 | Boone | Indiana | 18011 | 5856 | 89 |
1002284 | 1002284 | 2021-02-06 | Boone | Indiana | 18011 | 5842 | 88 |
999038 | 999038 | 2021-02-05 | Boone | Indiana | 18011 | 5813 | 88 |
995792 | 995792 | 2021-02-04 | Boone | Indiana | 18011 | 5800 | 88 |
992546 | 992546 | 2021-02-03 | Boone | Indiana | 18011 | 5778 | 75 |
989300 | 989300 | 2021-02-02 | Boone | Indiana | 18011 | 5767 | 74 |
986053 | 986053 | 2021-02-01 | Boone | Indiana | 18011 | 5750 | 74 |
982806 | 982806 | 2021-01-31 | Boone | Indiana | 18011 | 5731 | 73 |
979560 | 979560 | 2021-01-30 | Boone | Indiana | 18011 | 5705 | 73 |
976314 | 976314 | 2021-01-29 | Boone | Indiana | 18011 | 5687 | 73 |
973069 | 973069 | 2021-01-28 | Boone | Indiana | 18011 | 5664 | 72 |
969824 | 969824 | 2021-01-27 | Boone | Indiana | 18011 | 5618 | 72 |
966580 | 966580 | 2021-01-26 | Boone | Indiana | 18011 | 5598 | 72 |
963335 | 963335 | 2021-01-25 | Boone | Indiana | 18011 | 5583 | 72 |
960090 | 960090 | 2021-01-24 | Boone | Indiana | 18011 | 5565 | 72 |
956844 | 956844 | 2021-01-23 | Boone | Indiana | 18011 | 5530 | 72 |
953599 | 953599 | 2021-01-22 | Boone | Indiana | 18011 | 5513 | 71 |
950354 | 950354 | 2021-01-21 | Boone | Indiana | 18011 | 5468 | 71 |
947108 | 947108 | 2021-01-20 | Boone | Indiana | 18011 | 5441 | 71 |
943861 | 943861 | 2021-01-19 | Boone | Indiana | 18011 | 5407 | 71 |
940616 | 940616 | 2021-01-18 | Boone | Indiana | 18011 | 5382 | 71 |
937371 | 937371 | 2021-01-17 | Boone | Indiana | 18011 | 5362 | 71 |
934126 | 934126 | 2021-01-16 | Boone | Indiana | 18011 | 5333 | 71 |
930881 | 930881 | 2021-01-15 | Boone | Indiana | 18011 | 5300 | 71 |
927636 | 927636 | 2021-01-14 | Boone | Indiana | 18011 | 5250 | 71 |
924390 | 924390 | 2021-01-13 | Boone | Indiana | 18011 | 5222 | 71 |
921145 | 921145 | 2021-01-12 | Boone | Indiana | 18011 | 5190 | 69 |
917900 | 917900 | 2021-01-11 | Boone | Indiana | 18011 | 5147 | 69 |
914655 | 914655 | 2021-01-10 | Boone | Indiana | 18011 | 5109 | 69 |
911410 | 911410 | 2021-01-09 | Boone | Indiana | 18011 | 5061 | 69 |
908165 | 908165 | 2021-01-08 | Boone | Indiana | 18011 | 4980 | 69 |
904919 | 904919 | 2021-01-07 | Boone | Indiana | 18011 | 4932 | 69 |
901674 | 901674 | 2021-01-06 | Boone | Indiana | 18011 | 4845 | 68 |
898429 | 898429 | 2021-01-05 | Boone | Indiana | 18011 | 4807 | 68 |
895184 | 895184 | 2021-01-04 | Boone | Indiana | 18011 | 4750 | 67 |
891937 | 891937 | 2021-01-03 | Boone | Indiana | 18011 | 4715 | 67 |
888691 | 888691 | 2021-01-02 | Boone | Indiana | 18011 | 4686 | 65 |
885445 | 885445 | 2021-01-01 | Boone | Indiana | 18011 | 4560 | 65 |
882200 | 882200 | 2020-12-31 | Boone | Indiana | 18011 | 4472 | 64 |
878955 | 878955 | 2020-12-30 | Boone | Indiana | 18011 | 4391 | 63 |
875710 | 875710 | 2020-12-29 | Boone | Indiana | 18011 | 4358 | 63 |
872465 | 872465 | 2020-12-28 | Boone | Indiana | 18011 | 4324 | 62 |
869220 | 869220 | 2020-12-27 | Boone | Indiana | 18011 | 4311 | 62 |
865975 | 865975 | 2020-12-26 | Boone | Indiana | 18011 | 4278 | 62 |
862730 | 862730 | 2020-12-25 | Boone | Indiana | 18011 | 4236 | 62 |
859485 | 859485 | 2020-12-24 | Boone | Indiana | 18011 | 4190 | 61 |
856240 | 856240 | 2020-12-23 | Boone | Indiana | 18011 | 4139 | 61 |
852995 | 852995 | 2020-12-22 | Boone | Indiana | 18011 | 4075 | 61 |
849750 | 849750 | 2020-12-21 | Boone | Indiana | 18011 | 3981 | 61 |
846505 | 846505 | 2020-12-20 | Boone | Indiana | 18011 | 3930 | 61 |
843259 | 843259 | 2020-12-19 | Boone | Indiana | 18011 | 3863 | 61 |
840014 | 840014 | 2020-12-18 | Boone | Indiana | 18011 | 3816 | 60 |
836769 | 836769 | 2020-12-17 | Boone | Indiana | 18011 | 3755 | 60 |
833523 | 833523 | 2020-12-16 | Boone | Indiana | 18011 | 3659 | 60 |
830276 | 830276 | 2020-12-15 | Boone | Indiana | 18011 | 3611 | 59 |
827030 | 827030 | 2020-12-14 | Boone | Indiana | 18011 | 3564 | 59 |
823783 | 823783 | 2020-12-13 | Boone | Indiana | 18011 | 3510 | 59 |
820537 | 820537 | 2020-12-12 | Boone | Indiana | 18011 | 3445 | 59 |
817291 | 817291 | 2020-12-11 | Boone | Indiana | 18011 | 3380 | 59 |
814045 | 814045 | 2020-12-10 | Boone | Indiana | 18011 | 3301 | 59 |
810800 | 810800 | 2020-12-09 | Boone | Indiana | 18011 | 3236 | 59 |
807555 | 807555 | 2020-12-08 | Boone | Indiana | 18011 | 3203 | 59 |
804310 | 804310 | 2020-12-07 | Boone | Indiana | 18011 | 3142 | 59 |
801065 | 801065 | 2020-12-06 | Boone | Indiana | 18011 | 3058 | 59 |
797820 | 797820 | 2020-12-05 | Boone | Indiana | 18011 | 2961 | 59 |
794575 | 794575 | 2020-12-04 | Boone | Indiana | 18011 | 2915 | 59 |
791330 | 791330 | 2020-12-03 | Boone | Indiana | 18011 | 2839 | 59 |
788085 | 788085 | 2020-12-02 | Boone | Indiana | 18011 | 2765 | 59 |
784841 | 784841 | 2020-12-01 | Boone | Indiana | 18011 | 2722 | 59 |
781596 | 781596 | 2020-11-30 | Boone | Indiana | 18011 | 2695 | 58 |
778350 | 778350 | 2020-11-29 | Boone | Indiana | 18011 | 2638 | 58 |
775105 | 775105 | 2020-11-28 | Boone | Indiana | 18011 | 2607 | 58 |
771860 | 771860 | 2020-11-27 | Boone | Indiana | 18011 | 2568 | 57 |
768615 | 768615 | 2020-11-26 | Boone | Indiana | 18011 | 2505 | 57 |
765369 | 765369 | 2020-11-25 | Boone | Indiana | 18011 | 2463 | 57 |
762124 | 762124 | 2020-11-24 | Boone | Indiana | 18011 | 2420 | 57 |
758879 | 758879 | 2020-11-23 | Boone | Indiana | 18011 | 2369 | 57 |
755632 | 755632 | 2020-11-22 | Boone | Indiana | 18011 | 2335 | 57 |
752386 | 752386 | 2020-11-21 | Boone | Indiana | 18011 | 2289 | 57 |
749140 | 749140 | 2020-11-20 | Boone | Indiana | 18011 | 2219 | 56 |
745894 | 745894 | 2020-11-19 | Boone | Indiana | 18011 | 2170 | 56 |
742647 | 742647 | 2020-11-18 | Boone | Indiana | 18011 | 2094 | 56 |
739400 | 739400 | 2020-11-17 | Boone | Indiana | 18011 | 2058 | 56 |
736156 | 736156 | 2020-11-16 | Boone | Indiana | 18011 | 2017 | 56 |
732910 | 732910 | 2020-11-15 | Boone | Indiana | 18011 | 1980 | 56 |
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);