ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 18113 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535180 | 535180 | 2020-09-15 | Noble | Indiana | 18113 | 862 | 33 |
531945 | 531945 | 2020-09-14 | Noble | Indiana | 18113 | 858 | 33 |
528708 | 528708 | 2020-09-13 | Noble | Indiana | 18113 | 854 | 33 |
525472 | 525472 | 2020-09-12 | Noble | Indiana | 18113 | 852 | 33 |
522236 | 522236 | 2020-09-11 | Noble | Indiana | 18113 | 854 | 33 |
518999 | 518999 | 2020-09-10 | Noble | Indiana | 18113 | 848 | 33 |
515764 | 515764 | 2020-09-09 | Noble | Indiana | 18113 | 845 | 33 |
512531 | 512531 | 2020-09-08 | Noble | Indiana | 18113 | 845 | 32 |
509298 | 509298 | 2020-09-07 | Noble | Indiana | 18113 | 842 | 32 |
506066 | 506066 | 2020-09-06 | Noble | Indiana | 18113 | 839 | 32 |
502832 | 502832 | 2020-09-05 | Noble | Indiana | 18113 | 838 | 32 |
499598 | 499598 | 2020-09-04 | Noble | Indiana | 18113 | 829 | 32 |
496365 | 496365 | 2020-09-03 | Noble | Indiana | 18113 | 825 | 32 |
493131 | 493131 | 2020-09-02 | Noble | Indiana | 18113 | 814 | 32 |
489898 | 489898 | 2020-09-01 | Noble | Indiana | 18113 | 814 | 32 |
486665 | 486665 | 2020-08-31 | Noble | Indiana | 18113 | 808 | 32 |
483430 | 483430 | 2020-08-30 | Noble | Indiana | 18113 | 805 | 31 |
480196 | 480196 | 2020-08-29 | Noble | Indiana | 18113 | 802 | 31 |
476963 | 476963 | 2020-08-28 | Noble | Indiana | 18113 | 793 | 31 |
473730 | 473730 | 2020-08-27 | Noble | Indiana | 18113 | 791 | 31 |
470498 | 470498 | 2020-08-26 | Noble | Indiana | 18113 | 783 | 31 |
467269 | 467269 | 2020-08-25 | Noble | Indiana | 18113 | 779 | 31 |
464040 | 464040 | 2020-08-24 | Noble | Indiana | 18113 | 777 | 31 |
460811 | 460811 | 2020-08-23 | Noble | Indiana | 18113 | 770 | 31 |
457584 | 457584 | 2020-08-22 | Noble | Indiana | 18113 | 766 | 31 |
454356 | 454356 | 2020-08-21 | Noble | Indiana | 18113 | 757 | 31 |
451128 | 451128 | 2020-08-20 | Noble | Indiana | 18113 | 753 | 31 |
447900 | 447900 | 2020-08-19 | Noble | Indiana | 18113 | 749 | 30 |
444673 | 444673 | 2020-08-18 | Noble | Indiana | 18113 | 749 | 30 |
441447 | 441447 | 2020-08-17 | Noble | Indiana | 18113 | 745 | 30 |
438221 | 438221 | 2020-08-16 | Noble | Indiana | 18113 | 741 | 30 |
434995 | 434995 | 2020-08-15 | Noble | Indiana | 18113 | 728 | 30 |
431770 | 431770 | 2020-08-14 | Noble | Indiana | 18113 | 721 | 30 |
428542 | 428542 | 2020-08-13 | Noble | Indiana | 18113 | 712 | 30 |
425318 | 425318 | 2020-08-12 | Noble | Indiana | 18113 | 694 | 30 |
422097 | 422097 | 2020-08-11 | Noble | Indiana | 18113 | 692 | 30 |
418874 | 418874 | 2020-08-10 | Noble | Indiana | 18113 | 688 | 30 |
415653 | 415653 | 2020-08-09 | Noble | Indiana | 18113 | 682 | 30 |
412433 | 412433 | 2020-08-08 | Noble | Indiana | 18113 | 667 | 30 |
409214 | 409214 | 2020-08-07 | Noble | Indiana | 18113 | 663 | 30 |
405994 | 405994 | 2020-08-06 | Noble | Indiana | 18113 | 649 | 30 |
402776 | 402776 | 2020-08-05 | Noble | Indiana | 18113 | 642 | 30 |
399560 | 399560 | 2020-08-04 | Noble | Indiana | 18113 | 641 | 30 |
396344 | 396344 | 2020-08-03 | Noble | Indiana | 18113 | 641 | 29 |
393128 | 393128 | 2020-08-02 | Noble | Indiana | 18113 | 639 | 29 |
389911 | 389911 | 2020-08-01 | Noble | Indiana | 18113 | 628 | 29 |
386694 | 386694 | 2020-07-31 | Noble | Indiana | 18113 | 621 | 29 |
383476 | 383476 | 2020-07-30 | Noble | Indiana | 18113 | 617 | 29 |
380259 | 380259 | 2020-07-29 | Noble | Indiana | 18113 | 612 | 29 |
377042 | 377042 | 2020-07-28 | Noble | Indiana | 18113 | 609 | 29 |
373827 | 373827 | 2020-07-27 | Noble | Indiana | 18113 | 606 | 29 |
370615 | 370615 | 2020-07-26 | Noble | Indiana | 18113 | 603 | 29 |
367405 | 367405 | 2020-07-25 | Noble | Indiana | 18113 | 598 | 29 |
364198 | 364198 | 2020-07-24 | Noble | Indiana | 18113 | 595 | 29 |
360991 | 360991 | 2020-07-23 | Noble | Indiana | 18113 | 592 | 29 |
357786 | 357786 | 2020-07-22 | Noble | Indiana | 18113 | 583 | 29 |
354584 | 354584 | 2020-07-21 | Noble | Indiana | 18113 | 578 | 29 |
351382 | 351382 | 2020-07-20 | Noble | Indiana | 18113 | 570 | 29 |
348182 | 348182 | 2020-07-19 | Noble | Indiana | 18113 | 560 | 29 |
344981 | 344981 | 2020-07-18 | Noble | Indiana | 18113 | 555 | 29 |
341781 | 341781 | 2020-07-17 | Noble | Indiana | 18113 | 550 | 29 |
338585 | 338585 | 2020-07-16 | Noble | Indiana | 18113 | 540 | 29 |
335389 | 335389 | 2020-07-15 | Noble | Indiana | 18113 | 534 | 29 |
332196 | 332196 | 2020-07-14 | Noble | Indiana | 18113 | 530 | 29 |
329009 | 329009 | 2020-07-13 | Noble | Indiana | 18113 | 528 | 29 |
325823 | 325823 | 2020-07-12 | Noble | Indiana | 18113 | 524 | 29 |
322642 | 322642 | 2020-07-11 | Noble | Indiana | 18113 | 517 | 29 |
319463 | 319463 | 2020-07-10 | Noble | Indiana | 18113 | 505 | 29 |
316290 | 316290 | 2020-07-09 | Noble | Indiana | 18113 | 495 | 29 |
313116 | 313116 | 2020-07-08 | Noble | Indiana | 18113 | 489 | 29 |
309946 | 309946 | 2020-07-07 | Noble | Indiana | 18113 | 488 | 29 |
306778 | 306778 | 2020-07-06 | Noble | Indiana | 18113 | 486 | 29 |
303613 | 303613 | 2020-07-05 | Noble | Indiana | 18113 | 481 | 29 |
300449 | 300449 | 2020-07-04 | Noble | Indiana | 18113 | 472 | 29 |
297287 | 297287 | 2020-07-03 | Noble | Indiana | 18113 | 460 | 29 |
294129 | 294129 | 2020-07-02 | Noble | Indiana | 18113 | 454 | 29 |
290975 | 290975 | 2020-07-01 | Noble | Indiana | 18113 | 450 | 29 |
287825 | 287825 | 2020-06-30 | Noble | Indiana | 18113 | 437 | 29 |
284676 | 284676 | 2020-06-29 | Noble | Indiana | 18113 | 434 | 29 |
281531 | 281531 | 2020-06-28 | Noble | Indiana | 18113 | 430 | 29 |
278383 | 278383 | 2020-06-27 | Noble | Indiana | 18113 | 420 | 29 |
275235 | 275235 | 2020-06-26 | Noble | Indiana | 18113 | 407 | 29 |
272093 | 272093 | 2020-06-25 | Noble | Indiana | 18113 | 395 | 29 |
268956 | 268956 | 2020-06-24 | Noble | Indiana | 18113 | 385 | 29 |
265826 | 265826 | 2020-06-23 | Noble | Indiana | 18113 | 378 | 28 |
262698 | 262698 | 2020-06-22 | Noble | Indiana | 18113 | 376 | 28 |
259571 | 259571 | 2020-06-21 | Noble | Indiana | 18113 | 369 | 28 |
256445 | 256445 | 2020-06-20 | Noble | Indiana | 18113 | 358 | 28 |
253325 | 253325 | 2020-06-19 | Noble | Indiana | 18113 | 360 | 28 |
250210 | 250210 | 2020-06-18 | Noble | Indiana | 18113 | 356 | 28 |
247098 | 247098 | 2020-06-17 | Noble | Indiana | 18113 | 348 | 28 |
243985 | 243985 | 2020-06-16 | Noble | Indiana | 18113 | 343 | 28 |
240874 | 240874 | 2020-06-15 | Noble | Indiana | 18113 | 339 | 28 |
237766 | 237766 | 2020-06-14 | Noble | Indiana | 18113 | 333 | 28 |
234659 | 234659 | 2020-06-13 | Noble | Indiana | 18113 | 324 | 28 |
231553 | 231553 | 2020-06-12 | Noble | Indiana | 18113 | 320 | 26 |
228450 | 228450 | 2020-06-11 | Noble | Indiana | 18113 | 313 | 25 |
225348 | 225348 | 2020-06-10 | Noble | Indiana | 18113 | 312 | 26 |
222253 | 222253 | 2020-06-09 | Noble | Indiana | 18113 | 307 | 24 |
219158 | 219158 | 2020-06-08 | Noble | Indiana | 18113 | 301 | 23 |
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);