ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Wabash", deaths = 77 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1226376 | 1226376 | 2021-04-16 | Wabash | Indiana | 18169 | 3478 | 77 |
1223129 | 1223129 | 2021-04-15 | Wabash | Indiana | 18169 | 3471 | 77 |
1219881 | 1219881 | 2021-04-14 | Wabash | Indiana | 18169 | 3463 | 77 |
1216633 | 1216633 | 2021-04-13 | Wabash | Indiana | 18169 | 3462 | 77 |
1213386 | 1213386 | 2021-04-12 | Wabash | Indiana | 18169 | 3457 | 77 |
1210138 | 1210138 | 2021-04-11 | Wabash | Indiana | 18169 | 3454 | 77 |
1206889 | 1206889 | 2021-04-10 | Wabash | Indiana | 18169 | 3451 | 77 |
1203641 | 1203641 | 2021-04-09 | Wabash | Indiana | 18169 | 3448 | 77 |
1200393 | 1200393 | 2021-04-08 | Wabash | Indiana | 18169 | 3441 | 77 |
1197144 | 1197144 | 2021-04-07 | Wabash | Indiana | 18169 | 3438 | 77 |
1193896 | 1193896 | 2021-04-06 | Wabash | Indiana | 18169 | 3433 | 77 |
1190646 | 1190646 | 2021-04-05 | Wabash | Indiana | 18169 | 3433 | 77 |
1187399 | 1187399 | 2021-04-04 | Wabash | Indiana | 18169 | 3431 | 77 |
1184152 | 1184152 | 2021-04-03 | Wabash | Indiana | 18169 | 3427 | 77 |
1180905 | 1180905 | 2021-04-02 | Wabash | Indiana | 18169 | 3427 | 77 |
1177658 | 1177658 | 2021-04-01 | Wabash | Indiana | 18169 | 3425 | 77 |
1174411 | 1174411 | 2021-03-31 | Wabash | Indiana | 18169 | 3424 | 77 |
1171164 | 1171164 | 2021-03-30 | Wabash | Indiana | 18169 | 3420 | 77 |
1167916 | 1167916 | 2021-03-29 | Wabash | Indiana | 18169 | 3418 | 77 |
1164668 | 1164668 | 2021-03-28 | Wabash | Indiana | 18169 | 3410 | 77 |
1161420 | 1161420 | 2021-03-27 | Wabash | Indiana | 18169 | 3403 | 77 |
1158172 | 1158172 | 2021-03-26 | Wabash | Indiana | 18169 | 3400 | 77 |
1154925 | 1154925 | 2021-03-25 | Wabash | Indiana | 18169 | 3397 | 77 |
1151678 | 1151678 | 2021-03-24 | Wabash | Indiana | 18169 | 3395 | 77 |
1148431 | 1148431 | 2021-03-23 | Wabash | Indiana | 18169 | 3387 | 77 |
1145184 | 1145184 | 2021-03-22 | Wabash | Indiana | 18169 | 3384 | 77 |
1141937 | 1141937 | 2021-03-21 | Wabash | Indiana | 18169 | 3382 | 77 |
1138691 | 1138691 | 2021-03-20 | Wabash | Indiana | 18169 | 3377 | 77 |
1135445 | 1135445 | 2021-03-19 | Wabash | Indiana | 18169 | 3372 | 77 |
1132198 | 1132198 | 2021-03-18 | Wabash | Indiana | 18169 | 3371 | 77 |
1128950 | 1128950 | 2021-03-17 | Wabash | Indiana | 18169 | 3368 | 77 |
1125704 | 1125704 | 2021-03-16 | Wabash | Indiana | 18169 | 3365 | 77 |
1122458 | 1122458 | 2021-03-15 | Wabash | Indiana | 18169 | 3363 | 77 |
1119211 | 1119211 | 2021-03-14 | Wabash | Indiana | 18169 | 3363 | 77 |
1115964 | 1115964 | 2021-03-13 | Wabash | Indiana | 18169 | 3360 | 77 |
1112718 | 1112718 | 2021-03-12 | Wabash | Indiana | 18169 | 3357 | 77 |
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);