ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "St. Bernard" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194273 | 1194273 | 2021-04-06 | St. Bernard | Louisiana | 22087 | 3948 | 48 |
1191023 | 1191023 | 2021-04-05 | St. Bernard | Louisiana | 22087 | 3941 | 48 |
1187776 | 1187776 | 2021-04-04 | St. Bernard | Louisiana | 22087 | 3936 | 48 |
1184529 | 1184529 | 2021-04-03 | St. Bernard | Louisiana | 22087 | 3936 | 48 |
1181282 | 1181282 | 2021-04-02 | St. Bernard | Louisiana | 22087 | 3936 | 48 |
1178035 | 1178035 | 2021-04-01 | St. Bernard | Louisiana | 22087 | 3936 | 48 |
1174788 | 1174788 | 2021-03-31 | St. Bernard | Louisiana | 22087 | 3933 | 48 |
1171541 | 1171541 | 2021-03-30 | St. Bernard | Louisiana | 22087 | 3930 | 48 |
1168293 | 1168293 | 2021-03-29 | St. Bernard | Louisiana | 22087 | 3922 | 48 |
1165045 | 1165045 | 2021-03-28 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1161797 | 1161797 | 2021-03-27 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1158549 | 1158549 | 2021-03-26 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1155302 | 1155302 | 2021-03-25 | St. Bernard | Louisiana | 22087 | 3916 | 48 |
1152055 | 1152055 | 2021-03-24 | St. Bernard | Louisiana | 22087 | 3912 | 48 |
1148808 | 1148808 | 2021-03-23 | St. Bernard | Louisiana | 22087 | 3901 | 48 |
1145561 | 1145561 | 2021-03-22 | St. Bernard | Louisiana | 22087 | 3895 | 48 |
1142314 | 1142314 | 2021-03-21 | St. Bernard | Louisiana | 22087 | 3886 | 48 |
1139068 | 1139068 | 2021-03-20 | St. Bernard | Louisiana | 22087 | 3886 | 48 |
1135822 | 1135822 | 2021-03-19 | St. Bernard | Louisiana | 22087 | 3886 | 48 |
1132575 | 1132575 | 2021-03-18 | St. Bernard | Louisiana | 22087 | 3879 | 48 |
1129327 | 1129327 | 2021-03-17 | St. Bernard | Louisiana | 22087 | 3874 | 48 |
1126081 | 1126081 | 2021-03-16 | St. Bernard | Louisiana | 22087 | 3872 | 48 |
1122835 | 1122835 | 2021-03-15 | St. Bernard | Louisiana | 22087 | 3857 | 48 |
1119588 | 1119588 | 2021-03-14 | St. Bernard | Louisiana | 22087 | 3856 | 47 |
1116341 | 1116341 | 2021-03-13 | St. Bernard | Louisiana | 22087 | 3837 | 47 |
1113095 | 1113095 | 2021-03-12 | St. Bernard | Louisiana | 22087 | 3837 | 47 |
1109849 | 1109849 | 2021-03-11 | St. Bernard | Louisiana | 22087 | 3828 | 46 |
1106603 | 1106603 | 2021-03-10 | St. Bernard | Louisiana | 22087 | 3825 | 46 |
1103357 | 1103357 | 2021-03-09 | St. Bernard | Louisiana | 22087 | 3815 | 46 |
1100111 | 1100111 | 2021-03-08 | St. Bernard | Louisiana | 22087 | 3799 | 46 |
1096863 | 1096863 | 2021-03-07 | St. Bernard | Louisiana | 22087 | 3794 | 46 |
1093617 | 1093617 | 2021-03-06 | St. Bernard | Louisiana | 22087 | 3783 | 46 |
1090371 | 1090371 | 2021-03-05 | St. Bernard | Louisiana | 22087 | 3783 | 46 |
1087126 | 1087126 | 2021-03-04 | St. Bernard | Louisiana | 22087 | 3779 | 46 |
1083880 | 1083880 | 2021-03-03 | St. Bernard | Louisiana | 22087 | 3768 | 46 |
1080634 | 1080634 | 2021-03-02 | St. Bernard | Louisiana | 22087 | 3758 | 46 |
1077389 | 1077389 | 2021-03-01 | St. Bernard | Louisiana | 22087 | 3742 | 46 |
1074143 | 1074143 | 2021-02-28 | St. Bernard | Louisiana | 22087 | 3738 | 46 |
1070897 | 1070897 | 2021-02-27 | St. Bernard | Louisiana | 22087 | 3704 | 46 |
1067652 | 1067652 | 2021-02-26 | St. Bernard | Louisiana | 22087 | 3704 | 46 |
1064407 | 1064407 | 2021-02-25 | St. Bernard | Louisiana | 22087 | 3695 | 46 |
1061162 | 1061162 | 2021-02-24 | St. Bernard | Louisiana | 22087 | 3678 | 46 |
1057916 | 1057916 | 2021-02-23 | St. Bernard | Louisiana | 22087 | 3657 | 46 |
1054670 | 1054670 | 2021-02-22 | St. Bernard | Louisiana | 22087 | 3642 | 46 |
1051423 | 1051423 | 2021-02-21 | St. Bernard | Louisiana | 22087 | 3628 | 46 |
1048176 | 1048176 | 2021-02-20 | St. Bernard | Louisiana | 22087 | 3571 | 46 |
1044931 | 1044931 | 2021-02-19 | St. Bernard | Louisiana | 22087 | 3571 | 46 |
1041686 | 1041686 | 2021-02-18 | St. Bernard | Louisiana | 22087 | 3564 | 46 |
1038441 | 1038441 | 2021-02-17 | St. Bernard | Louisiana | 22087 | 3552 | 46 |
1035196 | 1035196 | 2021-02-16 | St. Bernard | Louisiana | 22087 | 3532 | 46 |
1031950 | 1031950 | 2021-02-15 | St. Bernard | Louisiana | 22087 | 3532 | 46 |
1028703 | 1028703 | 2021-02-14 | St. Bernard | Louisiana | 22087 | 3524 | 46 |
1025458 | 1025458 | 2021-02-13 | St. Bernard | Louisiana | 22087 | 3506 | 46 |
1022213 | 1022213 | 2021-02-12 | St. Bernard | Louisiana | 22087 | 3506 | 46 |
1018968 | 1018968 | 2021-02-11 | St. Bernard | Louisiana | 22087 | 3486 | 46 |
1015723 | 1015723 | 2021-02-10 | St. Bernard | Louisiana | 22087 | 3441 | 46 |
1012478 | 1012478 | 2021-02-09 | St. Bernard | Louisiana | 22087 | 3431 | 46 |
1009232 | 1009232 | 2021-02-08 | St. Bernard | Louisiana | 22087 | 3408 | 46 |
1005986 | 1005986 | 2021-02-07 | St. Bernard | Louisiana | 22087 | 3394 | 46 |
1002740 | 1002740 | 2021-02-06 | St. Bernard | Louisiana | 22087 | 3360 | 46 |
999494 | 999494 | 2021-02-05 | St. Bernard | Louisiana | 22087 | 3360 | 46 |
996248 | 996248 | 2021-02-04 | St. Bernard | Louisiana | 22087 | 3349 | 46 |
993002 | 993002 | 2021-02-03 | St. Bernard | Louisiana | 22087 | 3332 | 46 |
989756 | 989756 | 2021-02-02 | St. Bernard | Louisiana | 22087 | 3312 | 46 |
986509 | 986509 | 2021-02-01 | St. Bernard | Louisiana | 22087 | 3282 | 45 |
983262 | 983262 | 2021-01-31 | St. Bernard | Louisiana | 22087 | 3270 | 45 |
980016 | 980016 | 2021-01-30 | St. Bernard | Louisiana | 22087 | 3226 | 45 |
976770 | 976770 | 2021-01-29 | St. Bernard | Louisiana | 22087 | 3226 | 45 |
973525 | 973525 | 2021-01-28 | St. Bernard | Louisiana | 22087 | 3214 | 45 |
970280 | 970280 | 2021-01-27 | St. Bernard | Louisiana | 22087 | 3189 | 45 |
967036 | 967036 | 2021-01-26 | St. Bernard | Louisiana | 22087 | 3142 | 44 |
963791 | 963791 | 2021-01-25 | St. Bernard | Louisiana | 22087 | 3107 | 43 |
960546 | 960546 | 2021-01-24 | St. Bernard | Louisiana | 22087 | 3092 | 44 |
957300 | 957300 | 2021-01-23 | St. Bernard | Louisiana | 22087 | 3050 | 43 |
954055 | 954055 | 2021-01-22 | St. Bernard | Louisiana | 22087 | 3050 | 43 |
950810 | 950810 | 2021-01-21 | St. Bernard | Louisiana | 22087 | 3028 | 42 |
947564 | 947564 | 2021-01-20 | St. Bernard | Louisiana | 22087 | 2993 | 42 |
944317 | 944317 | 2021-01-19 | St. Bernard | Louisiana | 22087 | 2941 | 41 |
941072 | 941072 | 2021-01-18 | St. Bernard | Louisiana | 22087 | 2923 | 41 |
937827 | 937827 | 2021-01-17 | St. Bernard | Louisiana | 22087 | 2912 | 41 |
934582 | 934582 | 2021-01-16 | St. Bernard | Louisiana | 22087 | 2873 | 41 |
931337 | 931337 | 2021-01-15 | St. Bernard | Louisiana | 22087 | 2873 | 41 |
928092 | 928092 | 2021-01-14 | St. Bernard | Louisiana | 22087 | 2847 | 41 |
924846 | 924846 | 2021-01-13 | St. Bernard | Louisiana | 22087 | 2821 | 41 |
921601 | 921601 | 2021-01-12 | St. Bernard | Louisiana | 22087 | 2777 | 41 |
918356 | 918356 | 2021-01-11 | St. Bernard | Louisiana | 22087 | 2735 | 41 |
915111 | 915111 | 2021-01-10 | St. Bernard | Louisiana | 22087 | 2714 | 40 |
911866 | 911866 | 2021-01-09 | St. Bernard | Louisiana | 22087 | 2662 | 40 |
908621 | 908621 | 2021-01-08 | St. Bernard | Louisiana | 22087 | 2662 | 40 |
905375 | 905375 | 2021-01-07 | St. Bernard | Louisiana | 22087 | 2626 | 39 |
902130 | 902130 | 2021-01-06 | St. Bernard | Louisiana | 22087 | 2590 | 39 |
898885 | 898885 | 2021-01-05 | St. Bernard | Louisiana | 22087 | 2447 | 39 |
895640 | 895640 | 2021-01-04 | St. Bernard | Louisiana | 22087 | 2431 | 39 |
892393 | 892393 | 2021-01-03 | St. Bernard | Louisiana | 22087 | 2420 | 39 |
889147 | 889147 | 2021-01-02 | St. Bernard | Louisiana | 22087 | 2367 | 39 |
885901 | 885901 | 2021-01-01 | St. Bernard | Louisiana | 22087 | 2367 | 39 |
882656 | 882656 | 2020-12-31 | St. Bernard | Louisiana | 22087 | 2367 | 39 |
879411 | 879411 | 2020-12-30 | St. Bernard | Louisiana | 22087 | 2332 | 39 |
876166 | 876166 | 2020-12-29 | St. Bernard | Louisiana | 22087 | 2263 | 39 |
872921 | 872921 | 2020-12-28 | St. Bernard | Louisiana | 22087 | 2234 | 39 |
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);