ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 18091 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535168 | 535168 | 2020-09-15 | LaPorte | Indiana | 18091 | 1332 | 37 |
531933 | 531933 | 2020-09-14 | LaPorte | Indiana | 18091 | 1328 | 37 |
528696 | 528696 | 2020-09-13 | LaPorte | Indiana | 18091 | 1319 | 37 |
525460 | 525460 | 2020-09-12 | LaPorte | Indiana | 18091 | 1306 | 37 |
522224 | 522224 | 2020-09-11 | LaPorte | Indiana | 18091 | 1297 | 37 |
518987 | 518987 | 2020-09-10 | LaPorte | Indiana | 18091 | 1275 | 37 |
515752 | 515752 | 2020-09-09 | LaPorte | Indiana | 18091 | 1258 | 37 |
512519 | 512519 | 2020-09-08 | LaPorte | Indiana | 18091 | 1254 | 37 |
509286 | 509286 | 2020-09-07 | LaPorte | Indiana | 18091 | 1249 | 37 |
506054 | 506054 | 2020-09-06 | LaPorte | Indiana | 18091 | 1233 | 37 |
502820 | 502820 | 2020-09-05 | LaPorte | Indiana | 18091 | 1226 | 37 |
499586 | 499586 | 2020-09-04 | LaPorte | Indiana | 18091 | 1216 | 35 |
496353 | 496353 | 2020-09-03 | LaPorte | Indiana | 18091 | 1208 | 31 |
493119 | 493119 | 2020-09-02 | LaPorte | Indiana | 18091 | 1198 | 31 |
489886 | 489886 | 2020-09-01 | LaPorte | Indiana | 18091 | 1193 | 31 |
486653 | 486653 | 2020-08-31 | LaPorte | Indiana | 18091 | 1189 | 31 |
483418 | 483418 | 2020-08-30 | LaPorte | Indiana | 18091 | 1177 | 31 |
480184 | 480184 | 2020-08-29 | LaPorte | Indiana | 18091 | 1174 | 31 |
476951 | 476951 | 2020-08-28 | LaPorte | Indiana | 18091 | 1158 | 31 |
473718 | 473718 | 2020-08-27 | LaPorte | Indiana | 18091 | 1144 | 31 |
470486 | 470486 | 2020-08-26 | LaPorte | Indiana | 18091 | 1131 | 31 |
467257 | 467257 | 2020-08-25 | LaPorte | Indiana | 18091 | 1126 | 31 |
464028 | 464028 | 2020-08-24 | LaPorte | Indiana | 18091 | 1118 | 31 |
460799 | 460799 | 2020-08-23 | LaPorte | Indiana | 18091 | 1101 | 31 |
457572 | 457572 | 2020-08-22 | LaPorte | Indiana | 18091 | 1092 | 31 |
454344 | 454344 | 2020-08-21 | LaPorte | Indiana | 18091 | 1071 | 30 |
451116 | 451116 | 2020-08-20 | LaPorte | Indiana | 18091 | 1046 | 30 |
447888 | 447888 | 2020-08-19 | LaPorte | Indiana | 18091 | 1021 | 30 |
444661 | 444661 | 2020-08-18 | LaPorte | Indiana | 18091 | 1016 | 30 |
441435 | 441435 | 2020-08-17 | LaPorte | Indiana | 18091 | 1015 | 30 |
438209 | 438209 | 2020-08-16 | LaPorte | Indiana | 18091 | 1004 | 30 |
434983 | 434983 | 2020-08-15 | LaPorte | Indiana | 18091 | 983 | 30 |
431758 | 431758 | 2020-08-14 | LaPorte | Indiana | 18091 | 971 | 30 |
428530 | 428530 | 2020-08-13 | LaPorte | Indiana | 18091 | 961 | 30 |
425306 | 425306 | 2020-08-12 | LaPorte | Indiana | 18091 | 939 | 30 |
422085 | 422085 | 2020-08-11 | LaPorte | Indiana | 18091 | 935 | 30 |
418862 | 418862 | 2020-08-10 | LaPorte | Indiana | 18091 | 925 | 30 |
415641 | 415641 | 2020-08-09 | LaPorte | Indiana | 18091 | 915 | 30 |
412421 | 412421 | 2020-08-08 | LaPorte | Indiana | 18091 | 898 | 30 |
409202 | 409202 | 2020-08-07 | LaPorte | Indiana | 18091 | 887 | 30 |
405982 | 405982 | 2020-08-06 | LaPorte | Indiana | 18091 | 873 | 30 |
402764 | 402764 | 2020-08-05 | LaPorte | Indiana | 18091 | 854 | 29 |
399548 | 399548 | 2020-08-04 | LaPorte | Indiana | 18091 | 847 | 29 |
396332 | 396332 | 2020-08-03 | LaPorte | Indiana | 18091 | 842 | 29 |
393116 | 393116 | 2020-08-02 | LaPorte | Indiana | 18091 | 832 | 29 |
389899 | 389899 | 2020-08-01 | LaPorte | Indiana | 18091 | 821 | 29 |
386682 | 386682 | 2020-07-31 | LaPorte | Indiana | 18091 | 803 | 29 |
383464 | 383464 | 2020-07-30 | LaPorte | Indiana | 18091 | 790 | 29 |
380247 | 380247 | 2020-07-29 | LaPorte | Indiana | 18091 | 773 | 29 |
377030 | 377030 | 2020-07-28 | LaPorte | Indiana | 18091 | 774 | 29 |
373815 | 373815 | 2020-07-27 | LaPorte | Indiana | 18091 | 762 | 29 |
370603 | 370603 | 2020-07-26 | LaPorte | Indiana | 18091 | 753 | 29 |
367393 | 367393 | 2020-07-25 | LaPorte | Indiana | 18091 | 747 | 29 |
364186 | 364186 | 2020-07-24 | LaPorte | Indiana | 18091 | 738 | 29 |
360979 | 360979 | 2020-07-23 | LaPorte | Indiana | 18091 | 717 | 28 |
357774 | 357774 | 2020-07-22 | LaPorte | Indiana | 18091 | 708 | 28 |
354572 | 354572 | 2020-07-21 | LaPorte | Indiana | 18091 | 701 | 28 |
351370 | 351370 | 2020-07-20 | LaPorte | Indiana | 18091 | 697 | 28 |
348170 | 348170 | 2020-07-19 | LaPorte | Indiana | 18091 | 690 | 28 |
344969 | 344969 | 2020-07-18 | LaPorte | Indiana | 18091 | 686 | 28 |
341769 | 341769 | 2020-07-17 | LaPorte | Indiana | 18091 | 672 | 28 |
338573 | 338573 | 2020-07-16 | LaPorte | Indiana | 18091 | 660 | 28 |
335377 | 335377 | 2020-07-15 | LaPorte | Indiana | 18091 | 650 | 28 |
332184 | 332184 | 2020-07-14 | LaPorte | Indiana | 18091 | 641 | 28 |
328997 | 328997 | 2020-07-13 | LaPorte | Indiana | 18091 | 631 | 28 |
325811 | 325811 | 2020-07-12 | LaPorte | Indiana | 18091 | 625 | 28 |
322630 | 322630 | 2020-07-11 | LaPorte | Indiana | 18091 | 618 | 28 |
319451 | 319451 | 2020-07-10 | LaPorte | Indiana | 18091 | 607 | 27 |
316278 | 316278 | 2020-07-09 | LaPorte | Indiana | 18091 | 599 | 27 |
313104 | 313104 | 2020-07-08 | LaPorte | Indiana | 18091 | 585 | 26 |
309934 | 309934 | 2020-07-07 | LaPorte | Indiana | 18091 | 581 | 26 |
306766 | 306766 | 2020-07-06 | LaPorte | Indiana | 18091 | 582 | 26 |
303601 | 303601 | 2020-07-05 | LaPorte | Indiana | 18091 | 575 | 26 |
300437 | 300437 | 2020-07-04 | LaPorte | Indiana | 18091 | 565 | 26 |
297275 | 297275 | 2020-07-03 | LaPorte | Indiana | 18091 | 555 | 26 |
294117 | 294117 | 2020-07-02 | LaPorte | Indiana | 18091 | 543 | 25 |
290963 | 290963 | 2020-07-01 | LaPorte | Indiana | 18091 | 541 | 25 |
287813 | 287813 | 2020-06-30 | LaPorte | Indiana | 18091 | 536 | 25 |
284664 | 284664 | 2020-06-29 | LaPorte | Indiana | 18091 | 524 | 25 |
281519 | 281519 | 2020-06-28 | LaPorte | Indiana | 18091 | 523 | 25 |
278371 | 278371 | 2020-06-27 | LaPorte | Indiana | 18091 | 514 | 25 |
275223 | 275223 | 2020-06-26 | LaPorte | Indiana | 18091 | 512 | 25 |
272081 | 272081 | 2020-06-25 | LaPorte | Indiana | 18091 | 504 | 25 |
268944 | 268944 | 2020-06-24 | LaPorte | Indiana | 18091 | 496 | 25 |
265814 | 265814 | 2020-06-23 | LaPorte | Indiana | 18091 | 494 | 25 |
262686 | 262686 | 2020-06-22 | LaPorte | Indiana | 18091 | 491 | 25 |
259559 | 259559 | 2020-06-21 | LaPorte | Indiana | 18091 | 487 | 25 |
256433 | 256433 | 2020-06-20 | LaPorte | Indiana | 18091 | 484 | 25 |
253313 | 253313 | 2020-06-19 | LaPorte | Indiana | 18091 | 483 | 25 |
250198 | 250198 | 2020-06-18 | LaPorte | Indiana | 18091 | 480 | 25 |
247086 | 247086 | 2020-06-17 | LaPorte | Indiana | 18091 | 474 | 25 |
243973 | 243973 | 2020-06-16 | LaPorte | Indiana | 18091 | 472 | 24 |
240862 | 240862 | 2020-06-15 | LaPorte | Indiana | 18091 | 471 | 24 |
237754 | 237754 | 2020-06-14 | LaPorte | Indiana | 18091 | 471 | 24 |
234647 | 234647 | 2020-06-13 | LaPorte | Indiana | 18091 | 468 | 24 |
231541 | 231541 | 2020-06-12 | LaPorte | Indiana | 18091 | 466 | 24 |
228438 | 228438 | 2020-06-11 | LaPorte | Indiana | 18091 | 466 | 24 |
225336 | 225336 | 2020-06-10 | LaPorte | Indiana | 18091 | 464 | 24 |
222241 | 222241 | 2020-06-09 | LaPorte | Indiana | 18091 | 463 | 24 |
219146 | 219146 | 2020-06-08 | LaPorte | Indiana | 18091 | 461 | 24 |
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);