ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18157 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535202 | 535202 | 2020-09-15 | Tippecanoe | Indiana | 18157 | 2032 | 14 |
531967 | 531967 | 2020-09-14 | Tippecanoe | Indiana | 18157 | 2001 | 14 |
528730 | 528730 | 2020-09-13 | Tippecanoe | Indiana | 18157 | 1994 | 14 |
525494 | 525494 | 2020-09-12 | Tippecanoe | Indiana | 18157 | 1967 | 14 |
522258 | 522258 | 2020-09-11 | Tippecanoe | Indiana | 18157 | 1905 | 14 |
519021 | 519021 | 2020-09-10 | Tippecanoe | Indiana | 18157 | 1822 | 14 |
515786 | 515786 | 2020-09-09 | Tippecanoe | Indiana | 18157 | 1788 | 14 |
512553 | 512553 | 2020-09-08 | Tippecanoe | Indiana | 18157 | 1764 | 14 |
509320 | 509320 | 2020-09-07 | Tippecanoe | Indiana | 18157 | 1758 | 14 |
506088 | 506088 | 2020-09-06 | Tippecanoe | Indiana | 18157 | 1739 | 14 |
502854 | 502854 | 2020-09-05 | Tippecanoe | Indiana | 18157 | 1709 | 14 |
499620 | 499620 | 2020-09-04 | Tippecanoe | Indiana | 18157 | 1693 | 14 |
496387 | 496387 | 2020-09-03 | Tippecanoe | Indiana | 18157 | 1637 | 14 |
493153 | 493153 | 2020-09-02 | Tippecanoe | Indiana | 18157 | 1621 | 14 |
489920 | 489920 | 2020-09-01 | Tippecanoe | Indiana | 18157 | 1592 | 14 |
486687 | 486687 | 2020-08-31 | Tippecanoe | Indiana | 18157 | 1587 | 14 |
483452 | 483452 | 2020-08-30 | Tippecanoe | Indiana | 18157 | 1573 | 14 |
480218 | 480218 | 2020-08-29 | Tippecanoe | Indiana | 18157 | 1557 | 14 |
476985 | 476985 | 2020-08-28 | Tippecanoe | Indiana | 18157 | 1529 | 14 |
473752 | 473752 | 2020-08-27 | Tippecanoe | Indiana | 18157 | 1518 | 14 |
470520 | 470520 | 2020-08-26 | Tippecanoe | Indiana | 18157 | 1503 | 14 |
467291 | 467291 | 2020-08-25 | Tippecanoe | Indiana | 18157 | 1478 | 14 |
464062 | 464062 | 2020-08-24 | Tippecanoe | Indiana | 18157 | 1467 | 14 |
460833 | 460833 | 2020-08-23 | Tippecanoe | Indiana | 18157 | 1445 | 14 |
457606 | 457606 | 2020-08-22 | Tippecanoe | Indiana | 18157 | 1436 | 14 |
454378 | 454378 | 2020-08-21 | Tippecanoe | Indiana | 18157 | 1405 | 14 |
451150 | 451150 | 2020-08-20 | Tippecanoe | Indiana | 18157 | 1386 | 13 |
447922 | 447922 | 2020-08-19 | Tippecanoe | Indiana | 18157 | 1372 | 13 |
444695 | 444695 | 2020-08-18 | Tippecanoe | Indiana | 18157 | 1366 | 13 |
441469 | 441469 | 2020-08-17 | Tippecanoe | Indiana | 18157 | 1355 | 13 |
438243 | 438243 | 2020-08-16 | Tippecanoe | Indiana | 18157 | 1340 | 13 |
435017 | 435017 | 2020-08-15 | Tippecanoe | Indiana | 18157 | 1319 | 13 |
431792 | 431792 | 2020-08-14 | Tippecanoe | Indiana | 18157 | 1296 | 13 |
428564 | 428564 | 2020-08-13 | Tippecanoe | Indiana | 18157 | 1266 | 13 |
425340 | 425340 | 2020-08-12 | Tippecanoe | Indiana | 18157 | 1248 | 12 |
422119 | 422119 | 2020-08-11 | Tippecanoe | Indiana | 18157 | 1241 | 12 |
418896 | 418896 | 2020-08-10 | Tippecanoe | Indiana | 18157 | 1224 | 12 |
415675 | 415675 | 2020-08-09 | Tippecanoe | Indiana | 18157 | 1214 | 12 |
412455 | 412455 | 2020-08-08 | Tippecanoe | Indiana | 18157 | 1192 | 12 |
409236 | 409236 | 2020-08-07 | Tippecanoe | Indiana | 18157 | 1180 | 12 |
406016 | 406016 | 2020-08-06 | Tippecanoe | Indiana | 18157 | 1149 | 12 |
402798 | 402798 | 2020-08-05 | Tippecanoe | Indiana | 18157 | 1126 | 12 |
399582 | 399582 | 2020-08-04 | Tippecanoe | Indiana | 18157 | 1121 | 12 |
396366 | 396366 | 2020-08-03 | Tippecanoe | Indiana | 18157 | 1106 | 12 |
393150 | 393150 | 2020-08-02 | Tippecanoe | Indiana | 18157 | 1097 | 12 |
389933 | 389933 | 2020-08-01 | Tippecanoe | Indiana | 18157 | 1088 | 12 |
386716 | 386716 | 2020-07-31 | Tippecanoe | Indiana | 18157 | 1056 | 12 |
383498 | 383498 | 2020-07-30 | Tippecanoe | Indiana | 18157 | 1034 | 12 |
380281 | 380281 | 2020-07-29 | Tippecanoe | Indiana | 18157 | 1022 | 12 |
377064 | 377064 | 2020-07-28 | Tippecanoe | Indiana | 18157 | 1000 | 12 |
373849 | 373849 | 2020-07-27 | Tippecanoe | Indiana | 18157 | 982 | 12 |
370637 | 370637 | 2020-07-26 | Tippecanoe | Indiana | 18157 | 975 | 12 |
367427 | 367427 | 2020-07-25 | Tippecanoe | Indiana | 18157 | 963 | 12 |
364220 | 364220 | 2020-07-24 | Tippecanoe | Indiana | 18157 | 945 | 12 |
361013 | 361013 | 2020-07-23 | Tippecanoe | Indiana | 18157 | 924 | 12 |
357808 | 357808 | 2020-07-22 | Tippecanoe | Indiana | 18157 | 910 | 12 |
354606 | 354606 | 2020-07-21 | Tippecanoe | Indiana | 18157 | 892 | 11 |
351404 | 351404 | 2020-07-20 | Tippecanoe | Indiana | 18157 | 889 | 11 |
348204 | 348204 | 2020-07-19 | Tippecanoe | Indiana | 18157 | 878 | 11 |
345003 | 345003 | 2020-07-18 | Tippecanoe | Indiana | 18157 | 855 | 11 |
341803 | 341803 | 2020-07-17 | Tippecanoe | Indiana | 18157 | 829 | 11 |
338607 | 338607 | 2020-07-16 | Tippecanoe | Indiana | 18157 | 817 | 11 |
335411 | 335411 | 2020-07-15 | Tippecanoe | Indiana | 18157 | 805 | 11 |
332218 | 332218 | 2020-07-14 | Tippecanoe | Indiana | 18157 | 798 | 11 |
329031 | 329031 | 2020-07-13 | Tippecanoe | Indiana | 18157 | 788 | 10 |
325845 | 325845 | 2020-07-12 | Tippecanoe | Indiana | 18157 | 782 | 10 |
322664 | 322664 | 2020-07-11 | Tippecanoe | Indiana | 18157 | 773 | 10 |
319485 | 319485 | 2020-07-10 | Tippecanoe | Indiana | 18157 | 762 | 10 |
316312 | 316312 | 2020-07-09 | Tippecanoe | Indiana | 18157 | 746 | 10 |
313138 | 313138 | 2020-07-08 | Tippecanoe | Indiana | 18157 | 738 | 10 |
309968 | 309968 | 2020-07-07 | Tippecanoe | Indiana | 18157 | 730 | 10 |
306800 | 306800 | 2020-07-06 | Tippecanoe | Indiana | 18157 | 729 | 9 |
303635 | 303635 | 2020-07-05 | Tippecanoe | Indiana | 18157 | 718 | 9 |
300471 | 300471 | 2020-07-04 | Tippecanoe | Indiana | 18157 | 697 | 9 |
297309 | 297309 | 2020-07-03 | Tippecanoe | Indiana | 18157 | 680 | 9 |
294151 | 294151 | 2020-07-02 | Tippecanoe | Indiana | 18157 | 662 | 9 |
290997 | 290997 | 2020-07-01 | Tippecanoe | Indiana | 18157 | 643 | 9 |
287847 | 287847 | 2020-06-30 | Tippecanoe | Indiana | 18157 | 636 | 9 |
284698 | 284698 | 2020-06-29 | Tippecanoe | Indiana | 18157 | 627 | 9 |
281553 | 281553 | 2020-06-28 | Tippecanoe | Indiana | 18157 | 612 | 9 |
278405 | 278405 | 2020-06-27 | Tippecanoe | Indiana | 18157 | 602 | 9 |
275257 | 275257 | 2020-06-26 | Tippecanoe | Indiana | 18157 | 582 | 9 |
272115 | 272115 | 2020-06-25 | Tippecanoe | Indiana | 18157 | 558 | 9 |
268978 | 268978 | 2020-06-24 | Tippecanoe | Indiana | 18157 | 547 | 9 |
265848 | 265848 | 2020-06-23 | Tippecanoe | Indiana | 18157 | 544 | 9 |
262720 | 262720 | 2020-06-22 | Tippecanoe | Indiana | 18157 | 542 | 8 |
259593 | 259593 | 2020-06-21 | Tippecanoe | Indiana | 18157 | 533 | 8 |
256467 | 256467 | 2020-06-20 | Tippecanoe | Indiana | 18157 | 529 | 8 |
253347 | 253347 | 2020-06-19 | Tippecanoe | Indiana | 18157 | 513 | 8 |
250232 | 250232 | 2020-06-18 | Tippecanoe | Indiana | 18157 | 509 | 8 |
247120 | 247120 | 2020-06-17 | Tippecanoe | Indiana | 18157 | 500 | 7 |
244007 | 244007 | 2020-06-16 | Tippecanoe | Indiana | 18157 | 494 | 5 |
240896 | 240896 | 2020-06-15 | Tippecanoe | Indiana | 18157 | 493 | 5 |
237788 | 237788 | 2020-06-14 | Tippecanoe | Indiana | 18157 | 488 | 5 |
234681 | 234681 | 2020-06-13 | Tippecanoe | Indiana | 18157 | 481 | 5 |
231575 | 231575 | 2020-06-12 | Tippecanoe | Indiana | 18157 | 474 | 5 |
228472 | 228472 | 2020-06-11 | Tippecanoe | Indiana | 18157 | 468 | 5 |
225370 | 225370 | 2020-06-10 | Tippecanoe | Indiana | 18157 | 468 | 5 |
222275 | 222275 | 2020-06-09 | Tippecanoe | Indiana | 18157 | 462 | 5 |
219180 | 219180 | 2020-06-08 | Tippecanoe | Indiana | 18157 | 458 | 5 |
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);