ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 18011 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535129 | 535129 | 2020-09-15 | Boone | Indiana | 18011 | 956 | 49 |
531894 | 531894 | 2020-09-14 | Boone | Indiana | 18011 | 952 | 49 |
528657 | 528657 | 2020-09-13 | Boone | Indiana | 18011 | 947 | 49 |
525421 | 525421 | 2020-09-12 | Boone | Indiana | 18011 | 938 | 49 |
522185 | 522185 | 2020-09-11 | Boone | Indiana | 18011 | 932 | 49 |
518948 | 518948 | 2020-09-10 | Boone | Indiana | 18011 | 921 | 49 |
515713 | 515713 | 2020-09-09 | Boone | Indiana | 18011 | 915 | 49 |
512480 | 512480 | 2020-09-08 | Boone | Indiana | 18011 | 912 | 49 |
509247 | 509247 | 2020-09-07 | Boone | Indiana | 18011 | 912 | 49 |
506015 | 506015 | 2020-09-06 | Boone | Indiana | 18011 | 909 | 49 |
502781 | 502781 | 2020-09-05 | Boone | Indiana | 18011 | 905 | 49 |
499547 | 499547 | 2020-09-04 | Boone | Indiana | 18011 | 893 | 49 |
496314 | 496314 | 2020-09-03 | Boone | Indiana | 18011 | 887 | 49 |
493080 | 493080 | 2020-09-02 | Boone | Indiana | 18011 | 880 | 49 |
489847 | 489847 | 2020-09-01 | Boone | Indiana | 18011 | 866 | 49 |
486614 | 486614 | 2020-08-31 | Boone | Indiana | 18011 | 862 | 49 |
483379 | 483379 | 2020-08-30 | Boone | Indiana | 18011 | 852 | 49 |
480145 | 480145 | 2020-08-29 | Boone | Indiana | 18011 | 846 | 49 |
476912 | 476912 | 2020-08-28 | Boone | Indiana | 18011 | 839 | 49 |
473679 | 473679 | 2020-08-27 | Boone | Indiana | 18011 | 833 | 49 |
470447 | 470447 | 2020-08-26 | Boone | Indiana | 18011 | 817 | 49 |
467218 | 467218 | 2020-08-25 | Boone | Indiana | 18011 | 808 | 49 |
463989 | 463989 | 2020-08-24 | Boone | Indiana | 18011 | 804 | 49 |
460760 | 460760 | 2020-08-23 | Boone | Indiana | 18011 | 798 | 49 |
457533 | 457533 | 2020-08-22 | Boone | Indiana | 18011 | 795 | 49 |
454305 | 454305 | 2020-08-21 | Boone | Indiana | 18011 | 790 | 49 |
451077 | 451077 | 2020-08-20 | Boone | Indiana | 18011 | 776 | 49 |
447849 | 447849 | 2020-08-19 | Boone | Indiana | 18011 | 770 | 49 |
444622 | 444622 | 2020-08-18 | Boone | Indiana | 18011 | 767 | 49 |
441396 | 441396 | 2020-08-17 | Boone | Indiana | 18011 | 759 | 49 |
438170 | 438170 | 2020-08-16 | Boone | Indiana | 18011 | 753 | 49 |
434944 | 434944 | 2020-08-15 | Boone | Indiana | 18011 | 745 | 49 |
431719 | 431719 | 2020-08-14 | Boone | Indiana | 18011 | 735 | 49 |
428491 | 428491 | 2020-08-13 | Boone | Indiana | 18011 | 723 | 49 |
425267 | 425267 | 2020-08-12 | Boone | Indiana | 18011 | 716 | 49 |
422046 | 422046 | 2020-08-11 | Boone | Indiana | 18011 | 706 | 49 |
418823 | 418823 | 2020-08-10 | Boone | Indiana | 18011 | 702 | 49 |
415602 | 415602 | 2020-08-09 | Boone | Indiana | 18011 | 697 | 49 |
412382 | 412382 | 2020-08-08 | Boone | Indiana | 18011 | 691 | 49 |
409163 | 409163 | 2020-08-07 | Boone | Indiana | 18011 | 681 | 49 |
405943 | 405943 | 2020-08-06 | Boone | Indiana | 18011 | 672 | 49 |
402725 | 402725 | 2020-08-05 | Boone | Indiana | 18011 | 668 | 49 |
399509 | 399509 | 2020-08-04 | Boone | Indiana | 18011 | 663 | 49 |
396293 | 396293 | 2020-08-03 | Boone | Indiana | 18011 | 654 | 49 |
393077 | 393077 | 2020-08-02 | Boone | Indiana | 18011 | 651 | 49 |
389860 | 389860 | 2020-08-01 | Boone | Indiana | 18011 | 645 | 49 |
386643 | 386643 | 2020-07-31 | Boone | Indiana | 18011 | 632 | 49 |
383425 | 383425 | 2020-07-30 | Boone | Indiana | 18011 | 627 | 48 |
380208 | 380208 | 2020-07-29 | Boone | Indiana | 18011 | 616 | 48 |
376991 | 376991 | 2020-07-28 | Boone | Indiana | 18011 | 610 | 48 |
373776 | 373776 | 2020-07-27 | Boone | Indiana | 18011 | 602 | 48 |
370564 | 370564 | 2020-07-26 | Boone | Indiana | 18011 | 597 | 48 |
367354 | 367354 | 2020-07-25 | Boone | Indiana | 18011 | 589 | 48 |
364147 | 364147 | 2020-07-24 | Boone | Indiana | 18011 | 582 | 48 |
360940 | 360940 | 2020-07-23 | Boone | Indiana | 18011 | 578 | 48 |
357735 | 357735 | 2020-07-22 | Boone | Indiana | 18011 | 572 | 48 |
354533 | 354533 | 2020-07-21 | Boone | Indiana | 18011 | 565 | 48 |
351331 | 351331 | 2020-07-20 | Boone | Indiana | 18011 | 552 | 48 |
348131 | 348131 | 2020-07-19 | Boone | Indiana | 18011 | 548 | 48 |
344930 | 344930 | 2020-07-18 | Boone | Indiana | 18011 | 538 | 48 |
341730 | 341730 | 2020-07-17 | Boone | Indiana | 18011 | 528 | 47 |
338534 | 338534 | 2020-07-16 | Boone | Indiana | 18011 | 524 | 47 |
335338 | 335338 | 2020-07-15 | Boone | Indiana | 18011 | 519 | 47 |
332145 | 332145 | 2020-07-14 | Boone | Indiana | 18011 | 515 | 47 |
328958 | 328958 | 2020-07-13 | Boone | Indiana | 18011 | 510 | 47 |
325772 | 325772 | 2020-07-12 | Boone | Indiana | 18011 | 509 | 47 |
322591 | 322591 | 2020-07-11 | Boone | Indiana | 18011 | 500 | 47 |
319412 | 319412 | 2020-07-10 | Boone | Indiana | 18011 | 492 | 47 |
316239 | 316239 | 2020-07-09 | Boone | Indiana | 18011 | 477 | 47 |
313065 | 313065 | 2020-07-08 | Boone | Indiana | 18011 | 472 | 46 |
309895 | 309895 | 2020-07-07 | Boone | Indiana | 18011 | 467 | 46 |
306727 | 306727 | 2020-07-06 | Boone | Indiana | 18011 | 463 | 46 |
303562 | 303562 | 2020-07-05 | Boone | Indiana | 18011 | 460 | 46 |
300398 | 300398 | 2020-07-04 | Boone | Indiana | 18011 | 455 | 46 |
297236 | 297236 | 2020-07-03 | Boone | Indiana | 18011 | 452 | 46 |
294078 | 294078 | 2020-07-02 | Boone | Indiana | 18011 | 445 | 46 |
290924 | 290924 | 2020-07-01 | Boone | Indiana | 18011 | 440 | 45 |
287774 | 287774 | 2020-06-30 | Boone | Indiana | 18011 | 439 | 45 |
284625 | 284625 | 2020-06-29 | Boone | Indiana | 18011 | 434 | 44 |
281480 | 281480 | 2020-06-28 | Boone | Indiana | 18011 | 429 | 44 |
278332 | 278332 | 2020-06-27 | Boone | Indiana | 18011 | 427 | 44 |
275184 | 275184 | 2020-06-26 | Boone | Indiana | 18011 | 424 | 44 |
272042 | 272042 | 2020-06-25 | Boone | Indiana | 18011 | 420 | 44 |
268905 | 268905 | 2020-06-24 | Boone | Indiana | 18011 | 418 | 44 |
265775 | 265775 | 2020-06-23 | Boone | Indiana | 18011 | 414 | 44 |
262647 | 262647 | 2020-06-22 | Boone | Indiana | 18011 | 411 | 43 |
259520 | 259520 | 2020-06-21 | Boone | Indiana | 18011 | 408 | 43 |
256394 | 256394 | 2020-06-20 | Boone | Indiana | 18011 | 406 | 43 |
253274 | 253274 | 2020-06-19 | Boone | Indiana | 18011 | 399 | 42 |
250159 | 250159 | 2020-06-18 | Boone | Indiana | 18011 | 398 | 42 |
247047 | 247047 | 2020-06-17 | Boone | Indiana | 18011 | 401 | 42 |
243934 | 243934 | 2020-06-16 | Boone | Indiana | 18011 | 400 | 41 |
240823 | 240823 | 2020-06-15 | Boone | Indiana | 18011 | 404 | 41 |
237715 | 237715 | 2020-06-14 | Boone | Indiana | 18011 | 378 | 40 |
234608 | 234608 | 2020-06-13 | Boone | Indiana | 18011 | 376 | 40 |
231502 | 231502 | 2020-06-12 | Boone | Indiana | 18011 | 375 | 39 |
228399 | 228399 | 2020-06-11 | Boone | Indiana | 18011 | 365 | 39 |
225297 | 225297 | 2020-06-10 | Boone | Indiana | 18011 | 357 | 39 |
222202 | 222202 | 2020-06-09 | Boone | Indiana | 18011 | 355 | 39 |
219107 | 219107 | 2020-06-08 | Boone | Indiana | 18011 | 349 | 39 |
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);