ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Monroe" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076274 | 1076274 | 2021-03-01 | Monroe | Alabama | 1099 | 1661 | 39 |
1073028 | 1073028 | 2021-02-28 | Monroe | Alabama | 1099 | 1661 | 39 |
1069782 | 1069782 | 2021-02-27 | Monroe | Alabama | 1099 | 1661 | 39 |
1066537 | 1066537 | 2021-02-26 | Monroe | Alabama | 1099 | 1660 | 38 |
1063292 | 1063292 | 2021-02-25 | Monroe | Alabama | 1099 | 1659 | 38 |
1060047 | 1060047 | 2021-02-24 | Monroe | Alabama | 1099 | 1656 | 38 |
1056801 | 1056801 | 2021-02-23 | Monroe | Alabama | 1099 | 1655 | 38 |
1053555 | 1053555 | 2021-02-22 | Monroe | Alabama | 1099 | 1653 | 38 |
1050308 | 1050308 | 2021-02-21 | Monroe | Alabama | 1099 | 1652 | 38 |
1047061 | 1047061 | 2021-02-20 | Monroe | Alabama | 1099 | 1652 | 38 |
1043816 | 1043816 | 2021-02-19 | Monroe | Alabama | 1099 | 1650 | 38 |
1040571 | 1040571 | 2021-02-18 | Monroe | Alabama | 1099 | 1651 | 37 |
1037326 | 1037326 | 2021-02-17 | Monroe | Alabama | 1099 | 1646 | 37 |
1034081 | 1034081 | 2021-02-16 | Monroe | Alabama | 1099 | 1644 | 33 |
1030835 | 1030835 | 2021-02-15 | Monroe | Alabama | 1099 | 1644 | 33 |
1027588 | 1027588 | 2021-02-14 | Monroe | Alabama | 1099 | 1644 | 33 |
1024343 | 1024343 | 2021-02-13 | Monroe | Alabama | 1099 | 1641 | 33 |
1021098 | 1021098 | 2021-02-12 | Monroe | Alabama | 1099 | 1640 | 32 |
1017853 | 1017853 | 2021-02-11 | Monroe | Alabama | 1099 | 1639 | 32 |
1014608 | 1014608 | 2021-02-10 | Monroe | Alabama | 1099 | 1635 | 32 |
1011363 | 1011363 | 2021-02-09 | Monroe | Alabama | 1099 | 1633 | 30 |
1008117 | 1008117 | 2021-02-08 | Monroe | Alabama | 1099 | 1627 | 29 |
1004871 | 1004871 | 2021-02-07 | Monroe | Alabama | 1099 | 1624 | 29 |
1001625 | 1001625 | 2021-02-06 | Monroe | Alabama | 1099 | 1623 | 29 |
998379 | 998379 | 2021-02-05 | Monroe | Alabama | 1099 | 1618 | 28 |
995133 | 995133 | 2021-02-04 | Monroe | Alabama | 1099 | 1615 | 26 |
991887 | 991887 | 2021-02-03 | Monroe | Alabama | 1099 | 1603 | 25 |
988641 | 988641 | 2021-02-02 | Monroe | Alabama | 1099 | 1596 | 23 |
985394 | 985394 | 2021-02-01 | Monroe | Alabama | 1099 | 1576 | 22 |
982147 | 982147 | 2021-01-31 | Monroe | Alabama | 1099 | 1569 | 22 |
978901 | 978901 | 2021-01-30 | Monroe | Alabama | 1099 | 1559 | 22 |
975656 | 975656 | 2021-01-29 | Monroe | Alabama | 1099 | 1559 | 22 |
972411 | 972411 | 2021-01-28 | Monroe | Alabama | 1099 | 1554 | 21 |
969166 | 969166 | 2021-01-27 | Monroe | Alabama | 1099 | 1542 | 21 |
965922 | 965922 | 2021-01-26 | Monroe | Alabama | 1099 | 1535 | 21 |
962677 | 962677 | 2021-01-25 | Monroe | Alabama | 1099 | 1526 | 21 |
959432 | 959432 | 2021-01-24 | Monroe | Alabama | 1099 | 1524 | 21 |
956186 | 956186 | 2021-01-23 | Monroe | Alabama | 1099 | 1520 | 21 |
952941 | 952941 | 2021-01-22 | Monroe | Alabama | 1099 | 1513 | 20 |
949696 | 949696 | 2021-01-21 | Monroe | Alabama | 1099 | 1507 | 18 |
946450 | 946450 | 2021-01-20 | Monroe | Alabama | 1099 | 1498 | 18 |
943203 | 943203 | 2021-01-19 | Monroe | Alabama | 1099 | 1473 | 17 |
939958 | 939958 | 2021-01-18 | Monroe | Alabama | 1099 | 1456 | 17 |
936713 | 936713 | 2021-01-17 | Monroe | Alabama | 1099 | 1452 | 17 |
933468 | 933468 | 2021-01-16 | Monroe | Alabama | 1099 | 1450 | 17 |
930223 | 930223 | 2021-01-15 | Monroe | Alabama | 1099 | 1444 | 17 |
926978 | 926978 | 2021-01-14 | Monroe | Alabama | 1099 | 1436 | 17 |
923732 | 923732 | 2021-01-13 | Monroe | Alabama | 1099 | 1421 | 12 |
920487 | 920487 | 2021-01-12 | Monroe | Alabama | 1099 | 1416 | 12 |
917242 | 917242 | 2021-01-11 | Monroe | Alabama | 1099 | 1387 | 12 |
913997 | 913997 | 2021-01-10 | Monroe | Alabama | 1099 | 1384 | 12 |
910752 | 910752 | 2021-01-09 | Monroe | Alabama | 1099 | 1378 | 12 |
907507 | 907507 | 2021-01-08 | Monroe | Alabama | 1099 | 1355 | 12 |
904261 | 904261 | 2021-01-07 | Monroe | Alabama | 1099 | 1338 | 12 |
901016 | 901016 | 2021-01-06 | Monroe | Alabama | 1099 | 1317 | 12 |
897771 | 897771 | 2021-01-05 | Monroe | Alabama | 1099 | 1271 | 11 |
894525 | 894525 | 2021-01-04 | Monroe | Alabama | 1099 | 1238 | 11 |
891279 | 891279 | 2021-01-03 | Monroe | Alabama | 1099 | 1233 | 11 |
888032 | 888032 | 2021-01-02 | Monroe | Alabama | 1099 | 1231 | 11 |
884787 | 884787 | 2021-01-01 | Monroe | Alabama | 1099 | 1226 | 11 |
881542 | 881542 | 2020-12-31 | Monroe | Alabama | 1099 | 1215 | 11 |
878297 | 878297 | 2020-12-30 | Monroe | Alabama | 1099 | 1195 | 11 |
875052 | 875052 | 2020-12-29 | Monroe | Alabama | 1099 | 1155 | 11 |
871807 | 871807 | 2020-12-28 | Monroe | Alabama | 1099 | 1112 | 11 |
868562 | 868562 | 2020-12-27 | Monroe | Alabama | 1099 | 1109 | 11 |
865317 | 865317 | 2020-12-26 | Monroe | Alabama | 1099 | 1104 | 11 |
862072 | 862072 | 2020-12-25 | Monroe | Alabama | 1099 | 1101 | 11 |
858827 | 858827 | 2020-12-24 | Monroe | Alabama | 1099 | 1090 | 11 |
855582 | 855582 | 2020-12-23 | Monroe | Alabama | 1099 | 1086 | 11 |
852337 | 852337 | 2020-12-22 | Monroe | Alabama | 1099 | 1064 | 10 |
849092 | 849092 | 2020-12-21 | Monroe | Alabama | 1099 | 1030 | 10 |
845847 | 845847 | 2020-12-20 | Monroe | Alabama | 1099 | 1027 | 10 |
842601 | 842601 | 2020-12-19 | Monroe | Alabama | 1099 | 1024 | 10 |
839356 | 839356 | 2020-12-18 | Monroe | Alabama | 1099 | 997 | 10 |
836111 | 836111 | 2020-12-17 | Monroe | Alabama | 1099 | 977 | 10 |
832865 | 832865 | 2020-12-16 | Monroe | Alabama | 1099 | 957 | 10 |
829618 | 829618 | 2020-12-15 | Monroe | Alabama | 1099 | 939 | 10 |
826372 | 826372 | 2020-12-14 | Monroe | Alabama | 1099 | 923 | 10 |
823125 | 823125 | 2020-12-13 | Monroe | Alabama | 1099 | 922 | 10 |
819879 | 819879 | 2020-12-12 | Monroe | Alabama | 1099 | 921 | 10 |
816633 | 816633 | 2020-12-11 | Monroe | Alabama | 1099 | 908 | 11 |
813387 | 813387 | 2020-12-10 | Monroe | Alabama | 1099 | 895 | 11 |
810143 | 810143 | 2020-12-09 | Monroe | Alabama | 1099 | 885 | 11 |
806898 | 806898 | 2020-12-08 | Monroe | Alabama | 1099 | 881 | 11 |
803653 | 803653 | 2020-12-07 | Monroe | Alabama | 1099 | 858 | 11 |
800408 | 800408 | 2020-12-06 | Monroe | Alabama | 1099 | 855 | 11 |
797163 | 797163 | 2020-12-05 | Monroe | Alabama | 1099 | 855 | 11 |
793918 | 793918 | 2020-12-04 | Monroe | Alabama | 1099 | 853 | 11 |
790673 | 790673 | 2020-12-03 | Monroe | Alabama | 1099 | 846 | 11 |
787428 | 787428 | 2020-12-02 | Monroe | Alabama | 1099 | 838 | 11 |
784184 | 784184 | 2020-12-01 | Monroe | Alabama | 1099 | 830 | 11 |
780939 | 780939 | 2020-11-30 | Monroe | Alabama | 1099 | 790 | 11 |
777693 | 777693 | 2020-11-29 | Monroe | Alabama | 1099 | 790 | 11 |
774448 | 774448 | 2020-11-28 | Monroe | Alabama | 1099 | 789 | 11 |
771203 | 771203 | 2020-11-27 | Monroe | Alabama | 1099 | 787 | 11 |
767957 | 767957 | 2020-11-26 | Monroe | Alabama | 1099 | 783 | 11 |
764712 | 764712 | 2020-11-25 | Monroe | Alabama | 1099 | 781 | 11 |
761467 | 761467 | 2020-11-24 | Monroe | Alabama | 1099 | 779 | 11 |
758222 | 758222 | 2020-11-23 | Monroe | Alabama | 1099 | 768 | 11 |
754975 | 754975 | 2020-11-22 | Monroe | Alabama | 1099 | 768 | 11 |
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);