ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Marion" and fips = 20115 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535372 | 535372 | 2020-09-15 | Marion | Kansas | 20115 | 85 | 1 |
532137 | 532137 | 2020-09-14 | Marion | Kansas | 20115 | 85 | 1 |
528900 | 528900 | 2020-09-13 | Marion | Kansas | 20115 | 84 | 1 |
525664 | 525664 | 2020-09-12 | Marion | Kansas | 20115 | 84 | 1 |
522428 | 522428 | 2020-09-11 | Marion | Kansas | 20115 | 84 | 1 |
519191 | 519191 | 2020-09-10 | Marion | Kansas | 20115 | 84 | 1 |
515956 | 515956 | 2020-09-09 | Marion | Kansas | 20115 | 84 | 1 |
512723 | 512723 | 2020-09-08 | Marion | Kansas | 20115 | 83 | 1 |
509490 | 509490 | 2020-09-07 | Marion | Kansas | 20115 | 83 | 1 |
506258 | 506258 | 2020-09-06 | Marion | Kansas | 20115 | 82 | 1 |
503024 | 503024 | 2020-09-05 | Marion | Kansas | 20115 | 82 | 1 |
499790 | 499790 | 2020-09-04 | Marion | Kansas | 20115 | 82 | 1 |
496557 | 496557 | 2020-09-03 | Marion | Kansas | 20115 | 72 | 1 |
493323 | 493323 | 2020-09-02 | Marion | Kansas | 20115 | 72 | 1 |
490090 | 490090 | 2020-09-01 | Marion | Kansas | 20115 | 68 | 1 |
486857 | 486857 | 2020-08-31 | Marion | Kansas | 20115 | 68 | 1 |
483622 | 483622 | 2020-08-30 | Marion | Kansas | 20115 | 64 | 1 |
480388 | 480388 | 2020-08-29 | Marion | Kansas | 20115 | 64 | 1 |
477155 | 477155 | 2020-08-28 | Marion | Kansas | 20115 | 64 | 1 |
473922 | 473922 | 2020-08-27 | Marion | Kansas | 20115 | 63 | 1 |
470690 | 470690 | 2020-08-26 | Marion | Kansas | 20115 | 63 | 1 |
467461 | 467461 | 2020-08-25 | Marion | Kansas | 20115 | 61 | 1 |
464232 | 464232 | 2020-08-24 | Marion | Kansas | 20115 | 61 | 1 |
461003 | 461003 | 2020-08-23 | Marion | Kansas | 20115 | 61 | 1 |
457776 | 457776 | 2020-08-22 | Marion | Kansas | 20115 | 61 | 1 |
454548 | 454548 | 2020-08-21 | Marion | Kansas | 20115 | 61 | 1 |
451320 | 451320 | 2020-08-20 | Marion | Kansas | 20115 | 60 | 1 |
448092 | 448092 | 2020-08-19 | Marion | Kansas | 20115 | 60 | 1 |
444865 | 444865 | 2020-08-18 | Marion | Kansas | 20115 | 60 | 1 |
441639 | 441639 | 2020-08-17 | Marion | Kansas | 20115 | 60 | 1 |
438412 | 438412 | 2020-08-16 | Marion | Kansas | 20115 | 59 | 1 |
435187 | 435187 | 2020-08-15 | Marion | Kansas | 20115 | 59 | 1 |
431962 | 431962 | 2020-08-14 | Marion | Kansas | 20115 | 59 | 1 |
428734 | 428734 | 2020-08-13 | Marion | Kansas | 20115 | 58 | 1 |
425510 | 425510 | 2020-08-12 | Marion | Kansas | 20115 | 58 | 1 |
422289 | 422289 | 2020-08-11 | Marion | Kansas | 20115 | 58 | 1 |
419066 | 419066 | 2020-08-10 | Marion | Kansas | 20115 | 58 | 1 |
415845 | 415845 | 2020-08-09 | Marion | Kansas | 20115 | 58 | 1 |
412625 | 412625 | 2020-08-08 | Marion | Kansas | 20115 | 58 | 1 |
409405 | 409405 | 2020-08-07 | Marion | Kansas | 20115 | 58 | 1 |
406186 | 406186 | 2020-08-06 | Marion | Kansas | 20115 | 56 | 1 |
402968 | 402968 | 2020-08-05 | Marion | Kansas | 20115 | 56 | 1 |
399751 | 399751 | 2020-08-04 | Marion | Kansas | 20115 | 52 | 1 |
396536 | 396536 | 2020-08-03 | Marion | Kansas | 20115 | 52 | 1 |
393320 | 393320 | 2020-08-02 | Marion | Kansas | 20115 | 51 | 1 |
390103 | 390103 | 2020-08-01 | Marion | Kansas | 20115 | 51 | 1 |
386886 | 386886 | 2020-07-31 | Marion | Kansas | 20115 | 51 | 1 |
383668 | 383668 | 2020-07-30 | Marion | Kansas | 20115 | 50 | 1 |
380451 | 380451 | 2020-07-29 | Marion | Kansas | 20115 | 50 | 1 |
377234 | 377234 | 2020-07-28 | Marion | Kansas | 20115 | 46 | 1 |
374019 | 374019 | 2020-07-27 | Marion | Kansas | 20115 | 46 | 1 |
370807 | 370807 | 2020-07-26 | Marion | Kansas | 20115 | 42 | 1 |
367597 | 367597 | 2020-07-25 | Marion | Kansas | 20115 | 42 | 1 |
364390 | 364390 | 2020-07-24 | Marion | Kansas | 20115 | 42 | 1 |
361183 | 361183 | 2020-07-23 | Marion | Kansas | 20115 | 36 | 1 |
357978 | 357978 | 2020-07-22 | Marion | Kansas | 20115 | 36 | 1 |
354776 | 354776 | 2020-07-21 | Marion | Kansas | 20115 | 34 | 1 |
351574 | 351574 | 2020-07-20 | Marion | Kansas | 20115 | 34 | 1 |
348374 | 348374 | 2020-07-19 | Marion | Kansas | 20115 | 27 | 1 |
345173 | 345173 | 2020-07-18 | Marion | Kansas | 20115 | 27 | 1 |
341973 | 341973 | 2020-07-17 | Marion | Kansas | 20115 | 27 | 1 |
338777 | 338777 | 2020-07-16 | Marion | Kansas | 20115 | 26 | 1 |
335581 | 335581 | 2020-07-15 | Marion | Kansas | 20115 | 26 | 1 |
332388 | 332388 | 2020-07-14 | Marion | Kansas | 20115 | 24 | 1 |
329201 | 329201 | 2020-07-13 | Marion | Kansas | 20115 | 24 | 1 |
326015 | 326015 | 2020-07-12 | Marion | Kansas | 20115 | 22 | 1 |
322832 | 322832 | 2020-07-11 | Marion | Kansas | 20115 | 22 | 1 |
319653 | 319653 | 2020-07-10 | Marion | Kansas | 20115 | 22 | 1 |
316479 | 316479 | 2020-07-09 | Marion | Kansas | 20115 | 15 | 1 |
313305 | 313305 | 2020-07-08 | Marion | Kansas | 20115 | 15 | 1 |
310135 | 310135 | 2020-07-07 | Marion | Kansas | 20115 | 12 | 1 |
306967 | 306967 | 2020-07-06 | Marion | Kansas | 20115 | 12 | 1 |
303800 | 303800 | 2020-07-05 | Marion | Kansas | 20115 | 12 | 1 |
300636 | 300636 | 2020-07-04 | Marion | Kansas | 20115 | 12 | 1 |
297474 | 297474 | 2020-07-03 | Marion | Kansas | 20115 | 12 | 1 |
294316 | 294316 | 2020-07-02 | Marion | Kansas | 20115 | 11 | 1 |
291162 | 291162 | 2020-07-01 | Marion | Kansas | 20115 | 11 | 1 |
288012 | 288012 | 2020-06-30 | Marion | Kansas | 20115 | 11 | 1 |
284863 | 284863 | 2020-06-29 | Marion | Kansas | 20115 | 11 | 1 |
281718 | 281718 | 2020-06-28 | Marion | Kansas | 20115 | 10 | 1 |
278570 | 278570 | 2020-06-27 | Marion | Kansas | 20115 | 10 | 1 |
275422 | 275422 | 2020-06-26 | Marion | Kansas | 20115 | 10 | 1 |
272279 | 272279 | 2020-06-25 | Marion | Kansas | 20115 | 9 | 1 |
269142 | 269142 | 2020-06-24 | Marion | Kansas | 20115 | 9 | 1 |
266011 | 266011 | 2020-06-23 | Marion | Kansas | 20115 | 9 | 1 |
262883 | 262883 | 2020-06-22 | Marion | Kansas | 20115 | 9 | 1 |
259756 | 259756 | 2020-06-21 | Marion | Kansas | 20115 | 7 | 1 |
256630 | 256630 | 2020-06-20 | Marion | Kansas | 20115 | 7 | 1 |
253510 | 253510 | 2020-06-19 | Marion | Kansas | 20115 | 7 | 1 |
250395 | 250395 | 2020-06-18 | Marion | Kansas | 20115 | 7 | 1 |
247283 | 247283 | 2020-06-17 | Marion | Kansas | 20115 | 7 | 1 |
244170 | 244170 | 2020-06-16 | Marion | Kansas | 20115 | 7 | 1 |
241059 | 241059 | 2020-06-15 | Marion | Kansas | 20115 | 7 | 1 |
237950 | 237950 | 2020-06-14 | Marion | Kansas | 20115 | 7 | 1 |
234843 | 234843 | 2020-06-13 | Marion | Kansas | 20115 | 7 | 1 |
231737 | 231737 | 2020-06-12 | Marion | Kansas | 20115 | 7 | 1 |
228634 | 228634 | 2020-06-11 | Marion | Kansas | 20115 | 7 | 1 |
225532 | 225532 | 2020-06-10 | Marion | Kansas | 20115 | 7 | 1 |
222437 | 222437 | 2020-06-09 | Marion | Kansas | 20115 | 7 | 1 |
219342 | 219342 | 2020-06-08 | Marion | Kansas | 20115 | 7 | 1 |
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);