ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where county = "Marshall", deaths = 3 and fips = 18099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
300442 | 300442 | 2020-07-04 | Marshall | Indiana | 18099 | 482 | 3 |
297280 | 297280 | 2020-07-03 | Marshall | Indiana | 18099 | 427 | 3 |
294122 | 294122 | 2020-07-02 | Marshall | Indiana | 18099 | 418 | 3 |
290968 | 290968 | 2020-07-01 | Marshall | Indiana | 18099 | 412 | 3 |
287818 | 287818 | 2020-06-30 | Marshall | Indiana | 18099 | 409 | 3 |
284669 | 284669 | 2020-06-29 | Marshall | Indiana | 18099 | 407 | 3 |
281524 | 281524 | 2020-06-28 | Marshall | Indiana | 18099 | 403 | 3 |
278376 | 278376 | 2020-06-27 | Marshall | Indiana | 18099 | 401 | 3 |
275228 | 275228 | 2020-06-26 | Marshall | Indiana | 18099 | 393 | 3 |
272086 | 272086 | 2020-06-25 | Marshall | Indiana | 18099 | 385 | 3 |
268949 | 268949 | 2020-06-24 | Marshall | Indiana | 18099 | 374 | 3 |
265819 | 265819 | 2020-06-23 | Marshall | Indiana | 18099 | 369 | 3 |
262691 | 262691 | 2020-06-22 | Marshall | Indiana | 18099 | 365 | 3 |
259564 | 259564 | 2020-06-21 | Marshall | Indiana | 18099 | 359 | 3 |
256438 | 256438 | 2020-06-20 | Marshall | Indiana | 18099 | 347 | 3 |
253318 | 253318 | 2020-06-19 | Marshall | Indiana | 18099 | 344 | 3 |
250203 | 250203 | 2020-06-18 | Marshall | Indiana | 18099 | 338 | 3 |
247091 | 247091 | 2020-06-17 | Marshall | Indiana | 18099 | 322 | 3 |
243978 | 243978 | 2020-06-16 | Marshall | Indiana | 18099 | 315 | 3 |
240867 | 240867 | 2020-06-15 | Marshall | Indiana | 18099 | 305 | 3 |
237759 | 237759 | 2020-06-14 | Marshall | Indiana | 18099 | 301 | 3 |
234652 | 234652 | 2020-06-13 | Marshall | Indiana | 18099 | 287 | 3 |
231546 | 231546 | 2020-06-12 | Marshall | Indiana | 18099 | 276 | 3 |
228443 | 228443 | 2020-06-11 | Marshall | Indiana | 18099 | 261 | 3 |
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);