ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 18097 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535172 | 535172 | 2020-09-15 | Marion | Indiana | 18097 | 20363 | 807 |
531937 | 531937 | 2020-09-14 | Marion | Indiana | 18097 | 20314 | 806 |
528700 | 528700 | 2020-09-13 | Marion | Indiana | 18097 | 20233 | 805 |
525464 | 525464 | 2020-09-12 | Marion | Indiana | 18097 | 19822 | 805 |
522228 | 522228 | 2020-09-11 | Marion | Indiana | 18097 | 19717 | 805 |
518991 | 518991 | 2020-09-10 | Marion | Indiana | 18097 | 19641 | 804 |
515756 | 515756 | 2020-09-09 | Marion | Indiana | 18097 | 19555 | 803 |
512523 | 512523 | 2020-09-08 | Marion | Indiana | 18097 | 19474 | 801 |
509290 | 509290 | 2020-09-07 | Marion | Indiana | 18097 | 19439 | 801 |
506058 | 506058 | 2020-09-06 | Marion | Indiana | 18097 | 19363 | 801 |
502824 | 502824 | 2020-09-05 | Marion | Indiana | 18097 | 19240 | 801 |
499590 | 499590 | 2020-09-04 | Marion | Indiana | 18097 | 19123 | 801 |
496357 | 496357 | 2020-09-03 | Marion | Indiana | 18097 | 19004 | 800 |
493123 | 493123 | 2020-09-02 | Marion | Indiana | 18097 | 18888 | 800 |
489890 | 489890 | 2020-09-01 | Marion | Indiana | 18097 | 18734 | 798 |
486657 | 486657 | 2020-08-31 | Marion | Indiana | 18097 | 18631 | 799 |
483422 | 483422 | 2020-08-30 | Marion | Indiana | 18097 | 18500 | 799 |
480188 | 480188 | 2020-08-29 | Marion | Indiana | 18097 | 18377 | 799 |
476955 | 476955 | 2020-08-28 | Marion | Indiana | 18097 | 18252 | 797 |
473722 | 473722 | 2020-08-27 | Marion | Indiana | 18097 | 18141 | 797 |
470490 | 470490 | 2020-08-26 | Marion | Indiana | 18097 | 17997 | 796 |
467261 | 467261 | 2020-08-25 | Marion | Indiana | 18097 | 17854 | 796 |
464032 | 464032 | 2020-08-24 | Marion | Indiana | 18097 | 17757 | 794 |
460803 | 460803 | 2020-08-23 | Marion | Indiana | 18097 | 17587 | 794 |
457576 | 457576 | 2020-08-22 | Marion | Indiana | 18097 | 17502 | 794 |
454348 | 454348 | 2020-08-21 | Marion | Indiana | 18097 | 17362 | 794 |
451120 | 451120 | 2020-08-20 | Marion | Indiana | 18097 | 17228 | 792 |
447892 | 447892 | 2020-08-19 | Marion | Indiana | 18097 | 17104 | 790 |
444665 | 444665 | 2020-08-18 | Marion | Indiana | 18097 | 17027 | 788 |
441439 | 441439 | 2020-08-17 | Marion | Indiana | 18097 | 16863 | 785 |
438213 | 438213 | 2020-08-16 | Marion | Indiana | 18097 | 16796 | 785 |
434987 | 434987 | 2020-08-15 | Marion | Indiana | 18097 | 16694 | 785 |
431762 | 431762 | 2020-08-14 | Marion | Indiana | 18097 | 16592 | 784 |
428534 | 428534 | 2020-08-13 | Marion | Indiana | 18097 | 16457 | 783 |
425310 | 425310 | 2020-08-12 | Marion | Indiana | 18097 | 16346 | 781 |
422089 | 422089 | 2020-08-11 | Marion | Indiana | 18097 | 16239 | 780 |
418866 | 418866 | 2020-08-10 | Marion | Indiana | 18097 | 16113 | 775 |
415645 | 415645 | 2020-08-09 | Marion | Indiana | 18097 | 16010 | 775 |
412425 | 412425 | 2020-08-08 | Marion | Indiana | 18097 | 15849 | 773 |
409206 | 409206 | 2020-08-07 | Marion | Indiana | 18097 | 15651 | 773 |
405986 | 405986 | 2020-08-06 | Marion | Indiana | 18097 | 15470 | 771 |
402768 | 402768 | 2020-08-05 | Marion | Indiana | 18097 | 15296 | 772 |
399552 | 399552 | 2020-08-04 | Marion | Indiana | 18097 | 15173 | 772 |
396336 | 396336 | 2020-08-03 | Marion | Indiana | 18097 | 15007 | 767 |
393120 | 393120 | 2020-08-02 | Marion | Indiana | 18097 | 14853 | 767 |
389903 | 389903 | 2020-08-01 | Marion | Indiana | 18097 | 14721 | 766 |
386686 | 386686 | 2020-07-31 | Marion | Indiana | 18097 | 14575 | 766 |
383468 | 383468 | 2020-07-30 | Marion | Indiana | 18097 | 14412 | 765 |
380251 | 380251 | 2020-07-29 | Marion | Indiana | 18097 | 14237 | 762 |
377034 | 377034 | 2020-07-28 | Marion | Indiana | 18097 | 14094 | 761 |
373819 | 373819 | 2020-07-27 | Marion | Indiana | 18097 | 13953 | 760 |
370607 | 370607 | 2020-07-26 | Marion | Indiana | 18097 | 13835 | 759 |
367397 | 367397 | 2020-07-25 | Marion | Indiana | 18097 | 13685 | 759 |
364190 | 364190 | 2020-07-24 | Marion | Indiana | 18097 | 13545 | 758 |
360983 | 360983 | 2020-07-23 | Marion | Indiana | 18097 | 13380 | 758 |
357778 | 357778 | 2020-07-22 | Marion | Indiana | 18097 | 13228 | 758 |
354576 | 354576 | 2020-07-21 | Marion | Indiana | 18097 | 13124 | 755 |
351374 | 351374 | 2020-07-20 | Marion | Indiana | 18097 | 12976 | 752 |
348174 | 348174 | 2020-07-19 | Marion | Indiana | 18097 | 12883 | 752 |
344973 | 344973 | 2020-07-18 | Marion | Indiana | 18097 | 12742 | 752 |
341773 | 341773 | 2020-07-17 | Marion | Indiana | 18097 | 12617 | 748 |
338577 | 338577 | 2020-07-16 | Marion | Indiana | 18097 | 12494 | 747 |
335381 | 335381 | 2020-07-15 | Marion | Indiana | 18097 | 12409 | 745 |
332188 | 332188 | 2020-07-14 | Marion | Indiana | 18097 | 12323 | 743 |
329001 | 329001 | 2020-07-13 | Marion | Indiana | 18097 | 12243 | 739 |
325815 | 325815 | 2020-07-12 | Marion | Indiana | 18097 | 12206 | 739 |
322634 | 322634 | 2020-07-11 | Marion | Indiana | 18097 | 12151 | 739 |
319455 | 319455 | 2020-07-10 | Marion | Indiana | 18097 | 12052 | 738 |
316282 | 316282 | 2020-07-09 | Marion | Indiana | 18097 | 11943 | 736 |
313108 | 313108 | 2020-07-08 | Marion | Indiana | 18097 | 11891 | 735 |
309938 | 309938 | 2020-07-07 | Marion | Indiana | 18097 | 11854 | 735 |
306770 | 306770 | 2020-07-06 | Marion | Indiana | 18097 | 11814 | 731 |
303605 | 303605 | 2020-07-05 | Marion | Indiana | 18097 | 11755 | 730 |
300441 | 300441 | 2020-07-04 | Marion | Indiana | 18097 | 11678 | 730 |
297279 | 297279 | 2020-07-03 | Marion | Indiana | 18097 | 11630 | 730 |
294121 | 294121 | 2020-07-02 | Marion | Indiana | 18097 | 11560 | 727 |
290967 | 290967 | 2020-07-01 | Marion | Indiana | 18097 | 11513 | 727 |
287817 | 287817 | 2020-06-30 | Marion | Indiana | 18097 | 11451 | 726 |
284668 | 284668 | 2020-06-29 | Marion | Indiana | 18097 | 11401 | 724 |
281523 | 281523 | 2020-06-28 | Marion | Indiana | 18097 | 11358 | 724 |
278375 | 278375 | 2020-06-27 | Marion | Indiana | 18097 | 11304 | 724 |
275227 | 275227 | 2020-06-26 | Marion | Indiana | 18097 | 11226 | 723 |
272085 | 272085 | 2020-06-25 | Marion | Indiana | 18097 | 11164 | 722 |
268948 | 268948 | 2020-06-24 | Marion | Indiana | 18097 | 11118 | 720 |
265818 | 265818 | 2020-06-23 | Marion | Indiana | 18097 | 11099 | 716 |
262690 | 262690 | 2020-06-22 | Marion | Indiana | 18097 | 11083 | 715 |
259563 | 259563 | 2020-06-21 | Marion | Indiana | 18097 | 11067 | 714 |
256437 | 256437 | 2020-06-20 | Marion | Indiana | 18097 | 11026 | 713 |
253317 | 253317 | 2020-06-19 | Marion | Indiana | 18097 | 11007 | 711 |
250202 | 250202 | 2020-06-18 | Marion | Indiana | 18097 | 10973 | 706 |
247090 | 247090 | 2020-06-17 | Marion | Indiana | 18097 | 10982 | 702 |
243977 | 243977 | 2020-06-16 | Marion | Indiana | 18097 | 10950 | 699 |
240866 | 240866 | 2020-06-15 | Marion | Indiana | 18097 | 10905 | 697 |
237758 | 237758 | 2020-06-14 | Marion | Indiana | 18097 | 10779 | 694 |
234651 | 234651 | 2020-06-13 | Marion | Indiana | 18097 | 10736 | 693 |
231545 | 231545 | 2020-06-12 | Marion | Indiana | 18097 | 10694 | 689 |
228442 | 228442 | 2020-06-11 | Marion | Indiana | 18097 | 10609 | 689 |
225340 | 225340 | 2020-06-10 | Marion | Indiana | 18097 | 10581 | 680 |
222245 | 222245 | 2020-06-09 | Marion | Indiana | 18097 | 10559 | 676 |
219150 | 219150 | 2020-06-08 | Marion | Indiana | 18097 | 10471 | 669 |
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);