ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Crawford" and deaths = 100 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Ohio 28
- Missouri 7
- Pennsylvania 1
county 1
- Crawford · 36 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328569 | 2328569 | 2022-03-21 | Crawford | Missouri | 29055 | 5379 | 100 |
2325317 | 2325317 | 2022-03-20 | Crawford | Missouri | 29055 | 5374 | 100 |
2322063 | 2322063 | 2022-03-19 | Crawford | Missouri | 29055 | 5374 | 100 |
2318809 | 2318809 | 2022-03-18 | Crawford | Missouri | 29055 | 5374 | 100 |
2315556 | 2315556 | 2022-03-17 | Crawford | Missouri | 29055 | 5374 | 100 |
2312303 | 2312303 | 2022-03-16 | Crawford | Missouri | 29055 | 5370 | 100 |
2309050 | 2309050 | 2022-03-15 | Crawford | Missouri | 29055 | 5368 | 100 |
1224418 | 1224418 | 2021-04-15 | Crawford | Ohio | 39033 | 3858 | 100 |
1221171 | 1221171 | 2021-04-14 | Crawford | Ohio | 39033 | 3848 | 100 |
1217923 | 1217923 | 2021-04-13 | Crawford | Ohio | 39033 | 3839 | 100 |
1214675 | 1214675 | 2021-04-12 | Crawford | Ohio | 39033 | 3832 | 100 |
1211428 | 1211428 | 2021-04-11 | Crawford | Ohio | 39033 | 3827 | 100 |
1208179 | 1208179 | 2021-04-10 | Crawford | Ohio | 39033 | 3819 | 100 |
1204931 | 1204931 | 2021-04-09 | Crawford | Ohio | 39033 | 3810 | 100 |
1201683 | 1201683 | 2021-04-08 | Crawford | Ohio | 39033 | 3803 | 100 |
1198434 | 1198434 | 2021-04-07 | Crawford | Ohio | 39033 | 3789 | 100 |
1195185 | 1195185 | 2021-04-06 | Crawford | Ohio | 39033 | 3784 | 100 |
1191937 | 1191937 | 2021-04-05 | Crawford | Ohio | 39033 | 3779 | 100 |
1188688 | 1188688 | 2021-04-04 | Crawford | Ohio | 39033 | 3768 | 100 |
1185441 | 1185441 | 2021-04-03 | Crawford | Ohio | 39033 | 3768 | 100 |
1182194 | 1182194 | 2021-04-02 | Crawford | Ohio | 39033 | 3766 | 100 |
1178947 | 1178947 | 2021-04-01 | Crawford | Ohio | 39033 | 3764 | 100 |
1175700 | 1175700 | 2021-03-31 | Crawford | Ohio | 39033 | 3757 | 100 |
1172453 | 1172453 | 2021-03-30 | Crawford | Ohio | 39033 | 3751 | 100 |
1169206 | 1169206 | 2021-03-29 | Crawford | Ohio | 39033 | 3744 | 100 |
1165958 | 1165958 | 2021-03-28 | Crawford | Ohio | 39033 | 3742 | 100 |
1162710 | 1162710 | 2021-03-27 | Crawford | Ohio | 39033 | 3739 | 100 |
1159461 | 1159461 | 2021-03-26 | Crawford | Ohio | 39033 | 3737 | 100 |
1156214 | 1156214 | 2021-03-25 | Crawford | Ohio | 39033 | 3734 | 100 |
1152967 | 1152967 | 2021-03-24 | Crawford | Ohio | 39033 | 3730 | 100 |
1149720 | 1149720 | 2021-03-23 | Crawford | Ohio | 39033 | 3726 | 100 |
1146473 | 1146473 | 2021-03-22 | Crawford | Ohio | 39033 | 3720 | 100 |
1143226 | 1143226 | 2021-03-21 | Crawford | Ohio | 39033 | 3716 | 100 |
1139979 | 1139979 | 2021-03-20 | Crawford | Ohio | 39033 | 3713 | 100 |
1136733 | 1136733 | 2021-03-19 | Crawford | Ohio | 39033 | 3705 | 100 |
912983 | 912983 | 2021-01-09 | Crawford | Pennsylvania | 42039 | 5287 | 100 |
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);