ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where county = "Lawrence", deaths = 6 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
420673 | 420673 | 2020-08-10 | Lawrence | Tennessee | 47099 | 575 | 6 |
417452 | 417452 | 2020-08-09 | Lawrence | Tennessee | 47099 | 562 | 6 |
414231 | 414231 | 2020-08-08 | Lawrence | Tennessee | 47099 | 550 | 6 |
411011 | 411011 | 2020-08-07 | Lawrence | Tennessee | 47099 | 534 | 6 |
407792 | 407792 | 2020-08-06 | Lawrence | Tennessee | 47099 | 527 | 6 |
404572 | 404572 | 2020-08-05 | Lawrence | Tennessee | 47099 | 497 | 6 |
401354 | 401354 | 2020-08-04 | Lawrence | Tennessee | 47099 | 491 | 6 |
398139 | 398139 | 2020-08-03 | Lawrence | Tennessee | 47099 | 478 | 6 |
394922 | 394922 | 2020-08-02 | Lawrence | Tennessee | 47099 | 474 | 6 |
391706 | 391706 | 2020-08-01 | Lawrence | Tennessee | 47099 | 458 | 6 |
388489 | 388489 | 2020-07-31 | Lawrence | Tennessee | 47099 | 444 | 6 |
385272 | 385272 | 2020-07-30 | Lawrence | Tennessee | 47099 | 421 | 6 |
382054 | 382054 | 2020-07-29 | Lawrence | Tennessee | 47099 | 408 | 6 |
378837 | 378837 | 2020-07-28 | Lawrence | Tennessee | 47099 | 404 | 6 |
375621 | 375621 | 2020-07-27 | Lawrence | Tennessee | 47099 | 388 | 6 |
372408 | 372408 | 2020-07-26 | Lawrence | Tennessee | 47099 | 375 | 6 |
369196 | 369196 | 2020-07-25 | Lawrence | Tennessee | 47099 | 353 | 6 |
365987 | 365987 | 2020-07-24 | Lawrence | Tennessee | 47099 | 342 | 6 |
362781 | 362781 | 2020-07-23 | Lawrence | Tennessee | 47099 | 332 | 6 |
359574 | 359574 | 2020-07-22 | Lawrence | Tennessee | 47099 | 324 | 6 |
356370 | 356370 | 2020-07-21 | Lawrence | Tennessee | 47099 | 321 | 6 |
353167 | 353167 | 2020-07-20 | Lawrence | Tennessee | 47099 | 302 | 6 |
349964 | 349964 | 2020-07-19 | Lawrence | Tennessee | 47099 | 296 | 6 |
346764 | 346764 | 2020-07-18 | Lawrence | Tennessee | 47099 | 288 | 6 |
343564 | 343564 | 2020-07-17 | Lawrence | Tennessee | 47099 | 280 | 6 |
340366 | 340366 | 2020-07-16 | Lawrence | Tennessee | 47099 | 272 | 6 |
337169 | 337169 | 2020-07-15 | Lawrence | Tennessee | 47099 | 262 | 6 |
333975 | 333975 | 2020-07-14 | Lawrence | Tennessee | 47099 | 259 | 6 |
330783 | 330783 | 2020-07-13 | Lawrence | Tennessee | 47099 | 250 | 6 |
327597 | 327597 | 2020-07-12 | Lawrence | Tennessee | 47099 | 239 | 6 |
324412 | 324412 | 2020-07-11 | Lawrence | Tennessee | 47099 | 232 | 6 |
321231 | 321231 | 2020-07-10 | Lawrence | Tennessee | 47099 | 227 | 6 |
318053 | 318053 | 2020-07-09 | Lawrence | Tennessee | 47099 | 202 | 6 |
314880 | 314880 | 2020-07-08 | Lawrence | Tennessee | 47099 | 192 | 6 |
311706 | 311706 | 2020-07-07 | Lawrence | Tennessee | 47099 | 172 | 6 |
308537 | 308537 | 2020-07-06 | Lawrence | Tennessee | 47099 | 164 | 6 |
305369 | 305369 | 2020-07-05 | Lawrence | Tennessee | 47099 | 163 | 6 |
302206 | 302206 | 2020-07-04 | Lawrence | Tennessee | 47099 | 157 | 6 |
299042 | 299042 | 2020-07-03 | Lawrence | Tennessee | 47099 | 152 | 6 |
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);