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 |
---|---|---|---|---|---|---|---|
1278707 | 1278707 | 2021-05-02 | St. Bernard | Louisiana | 22087 | 4003 | 50 |
1275460 | 1275460 | 2021-05-01 | St. Bernard | Louisiana | 22087 | 4003 | 50 |
1272213 | 1272213 | 2021-04-30 | St. Bernard | Louisiana | 22087 | 4003 | 50 |
1268966 | 1268966 | 2021-04-29 | St. Bernard | Louisiana | 22087 | 3997 | 50 |
1265719 | 1265719 | 2021-04-28 | St. Bernard | Louisiana | 22087 | 3995 | 50 |
1262472 | 1262472 | 2021-04-27 | St. Bernard | Louisiana | 22087 | 3997 | 50 |
1259225 | 1259225 | 2021-04-26 | St. Bernard | Louisiana | 22087 | 3991 | 50 |
1255978 | 1255978 | 2021-04-25 | St. Bernard | Louisiana | 22087 | 3984 | 49 |
1252731 | 1252731 | 2021-04-24 | St. Bernard | Louisiana | 22087 | 3984 | 49 |
1249484 | 1249484 | 2021-04-23 | St. Bernard | Louisiana | 22087 | 3984 | 49 |
1246237 | 1246237 | 2021-04-22 | St. Bernard | Louisiana | 22087 | 3980 | 49 |
1242990 | 1242990 | 2021-04-21 | St. Bernard | Louisiana | 22087 | 3977 | 49 |
1239743 | 1239743 | 2021-04-20 | St. Bernard | Louisiana | 22087 | 3976 | 49 |
1236496 | 1236496 | 2021-04-19 | St. Bernard | Louisiana | 22087 | 3974 | 49 |
1233249 | 1233249 | 2021-04-18 | St. Bernard | Louisiana | 22087 | 3973 | 49 |
1230001 | 1230001 | 2021-04-17 | St. Bernard | Louisiana | 22087 | 3973 | 49 |
1226753 | 1226753 | 2021-04-16 | St. Bernard | Louisiana | 22087 | 3973 | 49 |
1223506 | 1223506 | 2021-04-15 | St. Bernard | Louisiana | 22087 | 3971 | 49 |
1220258 | 1220258 | 2021-04-14 | St. Bernard | Louisiana | 22087 | 3973 | 49 |
1217010 | 1217010 | 2021-04-13 | St. Bernard | Louisiana | 22087 | 3968 | 49 |
1213763 | 1213763 | 2021-04-12 | St. Bernard | Louisiana | 22087 | 3965 | 49 |
1210515 | 1210515 | 2021-04-11 | St. Bernard | Louisiana | 22087 | 3964 | 49 |
1207266 | 1207266 | 2021-04-10 | St. Bernard | Louisiana | 22087 | 3964 | 49 |
1204018 | 1204018 | 2021-04-09 | St. Bernard | Louisiana | 22087 | 3964 | 49 |
1200770 | 1200770 | 2021-04-08 | St. Bernard | Louisiana | 22087 | 3957 | 48 |
1197521 | 1197521 | 2021-04-07 | St. Bernard | Louisiana | 22087 | 3955 | 48 |
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 |
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);