ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
726 rows where county = "Bell" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090214 | 1090214 | 2021-03-05 | Bell | Kentucky | 21013 | 2787 | 35 |
1086969 | 1086969 | 2021-03-04 | Bell | Kentucky | 21013 | 2778 | 35 |
1083723 | 1083723 | 2021-03-03 | Bell | Kentucky | 21013 | 2764 | 35 |
1080477 | 1080477 | 2021-03-02 | Bell | Kentucky | 21013 | 2758 | 35 |
1077232 | 1077232 | 2021-03-01 | Bell | Kentucky | 21013 | 2754 | 35 |
1073986 | 1073986 | 2021-02-28 | Bell | Kentucky | 21013 | 2748 | 35 |
1070740 | 1070740 | 2021-02-27 | Bell | Kentucky | 21013 | 2739 | 35 |
1067495 | 1067495 | 2021-02-26 | Bell | Kentucky | 21013 | 2727 | 35 |
1064250 | 1064250 | 2021-02-25 | Bell | Kentucky | 21013 | 2721 | 35 |
1061005 | 1061005 | 2021-02-24 | Bell | Kentucky | 21013 | 2705 | 34 |
1057759 | 1057759 | 2021-02-23 | Bell | Kentucky | 21013 | 2687 | 34 |
1054513 | 1054513 | 2021-02-22 | Bell | Kentucky | 21013 | 2684 | 34 |
1051266 | 1051266 | 2021-02-21 | Bell | Kentucky | 21013 | 2675 | 34 |
1048019 | 1048019 | 2021-02-20 | Bell | Kentucky | 21013 | 2661 | 33 |
1044774 | 1044774 | 2021-02-19 | Bell | Kentucky | 21013 | 2643 | 33 |
1041529 | 1041529 | 2021-02-18 | Bell | Kentucky | 21013 | 2636 | 33 |
1038284 | 1038284 | 2021-02-17 | Bell | Kentucky | 21013 | 2619 | 33 |
1035039 | 1035039 | 2021-02-16 | Bell | Kentucky | 21013 | 2616 | 33 |
1031793 | 1031793 | 2021-02-15 | Bell | Kentucky | 21013 | 2594 | 33 |
1028546 | 1028546 | 2021-02-14 | Bell | Kentucky | 21013 | 2587 | 33 |
1025301 | 1025301 | 2021-02-13 | Bell | Kentucky | 21013 | 2576 | 33 |
1022056 | 1022056 | 2021-02-12 | Bell | Kentucky | 21013 | 2568 | 33 |
1018811 | 1018811 | 2021-02-11 | Bell | Kentucky | 21013 | 2552 | 33 |
1015566 | 1015566 | 2021-02-10 | Bell | Kentucky | 21013 | 2541 | 33 |
1012321 | 1012321 | 2021-02-09 | Bell | Kentucky | 21013 | 2535 | 33 |
1009075 | 1009075 | 2021-02-08 | Bell | Kentucky | 21013 | 2519 | 33 |
1005829 | 1005829 | 2021-02-07 | Bell | Kentucky | 21013 | 2514 | 33 |
1002583 | 1002583 | 2021-02-06 | Bell | Kentucky | 21013 | 2502 | 33 |
999337 | 999337 | 2021-02-05 | Bell | Kentucky | 21013 | 2492 | 33 |
996091 | 996091 | 2021-02-04 | Bell | Kentucky | 21013 | 2476 | 33 |
992845 | 992845 | 2021-02-03 | Bell | Kentucky | 21013 | 2440 | 33 |
989599 | 989599 | 2021-02-02 | Bell | Kentucky | 21013 | 2438 | 32 |
986352 | 986352 | 2021-02-01 | Bell | Kentucky | 21013 | 2437 | 32 |
983105 | 983105 | 2021-01-31 | Bell | Kentucky | 21013 | 2433 | 32 |
979859 | 979859 | 2021-01-30 | Bell | Kentucky | 21013 | 2423 | 32 |
976613 | 976613 | 2021-01-29 | Bell | Kentucky | 21013 | 2409 | 32 |
973368 | 973368 | 2021-01-28 | Bell | Kentucky | 21013 | 2391 | 32 |
970123 | 970123 | 2021-01-27 | Bell | Kentucky | 21013 | 2370 | 32 |
966879 | 966879 | 2021-01-26 | Bell | Kentucky | 21013 | 2362 | 32 |
963634 | 963634 | 2021-01-25 | Bell | Kentucky | 21013 | 2350 | 32 |
960389 | 960389 | 2021-01-24 | Bell | Kentucky | 21013 | 2347 | 32 |
957143 | 957143 | 2021-01-23 | Bell | Kentucky | 21013 | 2337 | 32 |
953898 | 953898 | 2021-01-22 | Bell | Kentucky | 21013 | 2324 | 32 |
950653 | 950653 | 2021-01-21 | Bell | Kentucky | 21013 | 2296 | 32 |
947407 | 947407 | 2021-01-20 | Bell | Kentucky | 21013 | 2276 | 32 |
944160 | 944160 | 2021-01-19 | Bell | Kentucky | 21013 | 2250 | 32 |
940915 | 940915 | 2021-01-18 | Bell | Kentucky | 21013 | 2234 | 32 |
937670 | 937670 | 2021-01-17 | Bell | Kentucky | 21013 | 2218 | 32 |
934425 | 934425 | 2021-01-16 | Bell | Kentucky | 21013 | 2203 | 32 |
931180 | 931180 | 2021-01-15 | Bell | Kentucky | 21013 | 2181 | 30 |
927935 | 927935 | 2021-01-14 | Bell | Kentucky | 21013 | 2159 | 30 |
924689 | 924689 | 2021-01-13 | Bell | Kentucky | 21013 | 2135 | 30 |
921444 | 921444 | 2021-01-12 | Bell | Kentucky | 21013 | 2110 | 29 |
918199 | 918199 | 2021-01-11 | Bell | Kentucky | 21013 | 2078 | 29 |
914954 | 914954 | 2021-01-10 | Bell | Kentucky | 21013 | 2073 | 29 |
911709 | 911709 | 2021-01-09 | Bell | Kentucky | 21013 | 2037 | 28 |
908464 | 908464 | 2021-01-08 | Bell | Kentucky | 21013 | 2011 | 28 |
905218 | 905218 | 2021-01-07 | Bell | Kentucky | 21013 | 1977 | 28 |
901973 | 901973 | 2021-01-06 | Bell | Kentucky | 21013 | 1946 | 28 |
898728 | 898728 | 2021-01-05 | Bell | Kentucky | 21013 | 1916 | 27 |
895483 | 895483 | 2021-01-04 | Bell | Kentucky | 21013 | 1895 | 27 |
892236 | 892236 | 2021-01-03 | Bell | Kentucky | 21013 | 1889 | 27 |
888990 | 888990 | 2021-01-02 | Bell | Kentucky | 21013 | 1880 | 27 |
885744 | 885744 | 2021-01-01 | Bell | Kentucky | 21013 | 1787 | 26 |
882499 | 882499 | 2020-12-31 | Bell | Kentucky | 21013 | 1787 | 26 |
879254 | 879254 | 2020-12-30 | Bell | Kentucky | 21013 | 1787 | 26 |
876009 | 876009 | 2020-12-29 | Bell | Kentucky | 21013 | 1747 | 25 |
872764 | 872764 | 2020-12-28 | Bell | Kentucky | 21013 | 1730 | 25 |
869519 | 869519 | 2020-12-27 | Bell | Kentucky | 21013 | 1720 | 25 |
866274 | 866274 | 2020-12-26 | Bell | Kentucky | 21013 | 1712 | 23 |
863029 | 863029 | 2020-12-25 | Bell | Kentucky | 21013 | 1683 | 23 |
859784 | 859784 | 2020-12-24 | Bell | Kentucky | 21013 | 1683 | 23 |
856539 | 856539 | 2020-12-23 | Bell | Kentucky | 21013 | 1683 | 23 |
853294 | 853294 | 2020-12-22 | Bell | Kentucky | 21013 | 1667 | 23 |
850049 | 850049 | 2020-12-21 | Bell | Kentucky | 21013 | 1659 | 23 |
846804 | 846804 | 2020-12-20 | Bell | Kentucky | 21013 | 1650 | 23 |
843558 | 843558 | 2020-12-19 | Bell | Kentucky | 21013 | 1640 | 23 |
840313 | 840313 | 2020-12-18 | Bell | Kentucky | 21013 | 1607 | 22 |
837068 | 837068 | 2020-12-17 | Bell | Kentucky | 21013 | 1586 | 22 |
833822 | 833822 | 2020-12-16 | Bell | Kentucky | 21013 | 1551 | 22 |
830575 | 830575 | 2020-12-15 | Bell | Kentucky | 21013 | 1542 | 21 |
827329 | 827329 | 2020-12-14 | Bell | Kentucky | 21013 | 1527 | 21 |
824082 | 824082 | 2020-12-13 | Bell | Kentucky | 21013 | 1515 | 21 |
820836 | 820836 | 2020-12-12 | Bell | Kentucky | 21013 | 1493 | 20 |
817590 | 817590 | 2020-12-11 | Bell | Kentucky | 21013 | 1475 | 20 |
814344 | 814344 | 2020-12-10 | Bell | Kentucky | 21013 | 1455 | 20 |
811099 | 811099 | 2020-12-09 | Bell | Kentucky | 21013 | 1435 | 20 |
807854 | 807854 | 2020-12-08 | Bell | Kentucky | 21013 | 1400 | 20 |
804609 | 804609 | 2020-12-07 | Bell | Kentucky | 21013 | 1386 | 20 |
801364 | 801364 | 2020-12-06 | Bell | Kentucky | 21013 | 1374 | 20 |
798119 | 798119 | 2020-12-05 | Bell | Kentucky | 21013 | 1358 | 20 |
794874 | 794874 | 2020-12-04 | Bell | Kentucky | 21013 | 1340 | 20 |
791629 | 791629 | 2020-12-03 | Bell | Kentucky | 21013 | 1312 | 20 |
788384 | 788384 | 2020-12-02 | Bell | Kentucky | 21013 | 1290 | 19 |
785140 | 785140 | 2020-12-01 | Bell | Kentucky | 21013 | 1275 | 19 |
781895 | 781895 | 2020-11-30 | Bell | Kentucky | 21013 | 1247 | 19 |
778649 | 778649 | 2020-11-29 | Bell | Kentucky | 21013 | 1241 | 19 |
775404 | 775404 | 2020-11-28 | Bell | Kentucky | 21013 | 1232 | 19 |
772159 | 772159 | 2020-11-27 | Bell | Kentucky | 21013 | 1223 | 19 |
768914 | 768914 | 2020-11-26 | Bell | Kentucky | 21013 | 1190 | 18 |
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);