ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18035 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535141 | 535141 | 2020-09-15 | Delaware | Indiana | 18035 | 1758 | 60 |
531906 | 531906 | 2020-09-14 | Delaware | Indiana | 18035 | 1752 | 60 |
528669 | 528669 | 2020-09-13 | Delaware | Indiana | 18035 | 1722 | 60 |
525433 | 525433 | 2020-09-12 | Delaware | Indiana | 18035 | 1706 | 60 |
522197 | 522197 | 2020-09-11 | Delaware | Indiana | 18035 | 1683 | 59 |
518960 | 518960 | 2020-09-10 | Delaware | Indiana | 18035 | 1646 | 59 |
515725 | 515725 | 2020-09-09 | Delaware | Indiana | 18035 | 1618 | 59 |
512492 | 512492 | 2020-09-08 | Delaware | Indiana | 18035 | 1599 | 59 |
509259 | 509259 | 2020-09-07 | Delaware | Indiana | 18035 | 1588 | 59 |
506027 | 506027 | 2020-09-06 | Delaware | Indiana | 18035 | 1573 | 58 |
502793 | 502793 | 2020-09-05 | Delaware | Indiana | 18035 | 1516 | 58 |
499559 | 499559 | 2020-09-04 | Delaware | Indiana | 18035 | 1455 | 58 |
496326 | 496326 | 2020-09-03 | Delaware | Indiana | 18035 | 1349 | 58 |
493092 | 493092 | 2020-09-02 | Delaware | Indiana | 18035 | 1272 | 58 |
489859 | 489859 | 2020-09-01 | Delaware | Indiana | 18035 | 1234 | 58 |
486626 | 486626 | 2020-08-31 | Delaware | Indiana | 18035 | 1179 | 58 |
483391 | 483391 | 2020-08-30 | Delaware | Indiana | 18035 | 1144 | 57 |
480157 | 480157 | 2020-08-29 | Delaware | Indiana | 18035 | 1081 | 57 |
476924 | 476924 | 2020-08-28 | Delaware | Indiana | 18035 | 1010 | 57 |
473691 | 473691 | 2020-08-27 | Delaware | Indiana | 18035 | 975 | 56 |
470459 | 470459 | 2020-08-26 | Delaware | Indiana | 18035 | 935 | 55 |
467230 | 467230 | 2020-08-25 | Delaware | Indiana | 18035 | 912 | 55 |
464001 | 464001 | 2020-08-24 | Delaware | Indiana | 18035 | 901 | 54 |
460772 | 460772 | 2020-08-23 | Delaware | Indiana | 18035 | 870 | 54 |
457545 | 457545 | 2020-08-22 | Delaware | Indiana | 18035 | 864 | 54 |
454317 | 454317 | 2020-08-21 | Delaware | Indiana | 18035 | 851 | 54 |
451089 | 451089 | 2020-08-20 | Delaware | Indiana | 18035 | 835 | 54 |
447861 | 447861 | 2020-08-19 | Delaware | Indiana | 18035 | 829 | 54 |
444634 | 444634 | 2020-08-18 | Delaware | Indiana | 18035 | 817 | 54 |
441408 | 441408 | 2020-08-17 | Delaware | Indiana | 18035 | 809 | 54 |
438182 | 438182 | 2020-08-16 | Delaware | Indiana | 18035 | 805 | 54 |
434956 | 434956 | 2020-08-15 | Delaware | Indiana | 18035 | 799 | 54 |
431731 | 431731 | 2020-08-14 | Delaware | Indiana | 18035 | 780 | 53 |
428503 | 428503 | 2020-08-13 | Delaware | Indiana | 18035 | 771 | 53 |
425279 | 425279 | 2020-08-12 | Delaware | Indiana | 18035 | 763 | 53 |
422058 | 422058 | 2020-08-11 | Delaware | Indiana | 18035 | 748 | 53 |
418835 | 418835 | 2020-08-10 | Delaware | Indiana | 18035 | 741 | 53 |
415614 | 415614 | 2020-08-09 | Delaware | Indiana | 18035 | 733 | 53 |
412394 | 412394 | 2020-08-08 | Delaware | Indiana | 18035 | 717 | 53 |
409175 | 409175 | 2020-08-07 | Delaware | Indiana | 18035 | 704 | 53 |
405955 | 405955 | 2020-08-06 | Delaware | Indiana | 18035 | 683 | 53 |
402737 | 402737 | 2020-08-05 | Delaware | Indiana | 18035 | 668 | 53 |
399521 | 399521 | 2020-08-04 | Delaware | Indiana | 18035 | 657 | 53 |
396305 | 396305 | 2020-08-03 | Delaware | Indiana | 18035 | 640 | 53 |
393089 | 393089 | 2020-08-02 | Delaware | Indiana | 18035 | 635 | 53 |
389872 | 389872 | 2020-08-01 | Delaware | Indiana | 18035 | 630 | 53 |
386655 | 386655 | 2020-07-31 | Delaware | Indiana | 18035 | 616 | 53 |
383437 | 383437 | 2020-07-30 | Delaware | Indiana | 18035 | 599 | 53 |
380220 | 380220 | 2020-07-29 | Delaware | Indiana | 18035 | 581 | 53 |
377003 | 377003 | 2020-07-28 | Delaware | Indiana | 18035 | 575 | 53 |
373788 | 373788 | 2020-07-27 | Delaware | Indiana | 18035 | 563 | 53 |
370576 | 370576 | 2020-07-26 | Delaware | Indiana | 18035 | 558 | 53 |
367366 | 367366 | 2020-07-25 | Delaware | Indiana | 18035 | 550 | 53 |
364159 | 364159 | 2020-07-24 | Delaware | Indiana | 18035 | 541 | 53 |
360952 | 360952 | 2020-07-23 | Delaware | Indiana | 18035 | 530 | 53 |
357747 | 357747 | 2020-07-22 | Delaware | Indiana | 18035 | 520 | 53 |
354545 | 354545 | 2020-07-21 | Delaware | Indiana | 18035 | 518 | 53 |
351343 | 351343 | 2020-07-20 | Delaware | Indiana | 18035 | 515 | 53 |
348143 | 348143 | 2020-07-19 | Delaware | Indiana | 18035 | 514 | 53 |
344942 | 344942 | 2020-07-18 | Delaware | Indiana | 18035 | 502 | 53 |
341742 | 341742 | 2020-07-17 | Delaware | Indiana | 18035 | 502 | 53 |
338546 | 338546 | 2020-07-16 | Delaware | Indiana | 18035 | 494 | 53 |
335350 | 335350 | 2020-07-15 | Delaware | Indiana | 18035 | 489 | 53 |
332157 | 332157 | 2020-07-14 | Delaware | Indiana | 18035 | 486 | 53 |
328970 | 328970 | 2020-07-13 | Delaware | Indiana | 18035 | 483 | 53 |
325784 | 325784 | 2020-07-12 | Delaware | Indiana | 18035 | 477 | 53 |
322603 | 322603 | 2020-07-11 | Delaware | Indiana | 18035 | 473 | 53 |
319424 | 319424 | 2020-07-10 | Delaware | Indiana | 18035 | 471 | 53 |
316251 | 316251 | 2020-07-09 | Delaware | Indiana | 18035 | 462 | 53 |
313077 | 313077 | 2020-07-08 | Delaware | Indiana | 18035 | 454 | 53 |
309907 | 309907 | 2020-07-07 | Delaware | Indiana | 18035 | 452 | 51 |
306739 | 306739 | 2020-07-06 | Delaware | Indiana | 18035 | 447 | 51 |
303574 | 303574 | 2020-07-05 | Delaware | Indiana | 18035 | 444 | 51 |
300410 | 300410 | 2020-07-04 | Delaware | Indiana | 18035 | 433 | 51 |
297248 | 297248 | 2020-07-03 | Delaware | Indiana | 18035 | 431 | 50 |
294090 | 294090 | 2020-07-02 | Delaware | Indiana | 18035 | 431 | 50 |
290936 | 290936 | 2020-07-01 | Delaware | Indiana | 18035 | 428 | 49 |
287786 | 287786 | 2020-06-30 | Delaware | Indiana | 18035 | 427 | 49 |
284637 | 284637 | 2020-06-29 | Delaware | Indiana | 18035 | 425 | 49 |
281492 | 281492 | 2020-06-28 | Delaware | Indiana | 18035 | 424 | 49 |
278344 | 278344 | 2020-06-27 | Delaware | Indiana | 18035 | 421 | 49 |
275196 | 275196 | 2020-06-26 | Delaware | Indiana | 18035 | 416 | 48 |
272054 | 272054 | 2020-06-25 | Delaware | Indiana | 18035 | 415 | 48 |
268917 | 268917 | 2020-06-24 | Delaware | Indiana | 18035 | 414 | 48 |
265787 | 265787 | 2020-06-23 | Delaware | Indiana | 18035 | 412 | 48 |
262659 | 262659 | 2020-06-22 | Delaware | Indiana | 18035 | 409 | 48 |
259532 | 259532 | 2020-06-21 | Delaware | Indiana | 18035 | 409 | 47 |
256406 | 256406 | 2020-06-20 | Delaware | Indiana | 18035 | 410 | 47 |
253286 | 253286 | 2020-06-19 | Delaware | Indiana | 18035 | 409 | 46 |
250171 | 250171 | 2020-06-18 | Delaware | Indiana | 18035 | 407 | 45 |
247059 | 247059 | 2020-06-17 | Delaware | Indiana | 18035 | 405 | 45 |
243946 | 243946 | 2020-06-16 | Delaware | Indiana | 18035 | 404 | 45 |
240835 | 240835 | 2020-06-15 | Delaware | Indiana | 18035 | 404 | 45 |
237727 | 237727 | 2020-06-14 | Delaware | Indiana | 18035 | 404 | 45 |
234620 | 234620 | 2020-06-13 | Delaware | Indiana | 18035 | 403 | 45 |
231514 | 231514 | 2020-06-12 | Delaware | Indiana | 18035 | 401 | 44 |
228411 | 228411 | 2020-06-11 | Delaware | Indiana | 18035 | 401 | 44 |
225309 | 225309 | 2020-06-10 | Delaware | Indiana | 18035 | 401 | 44 |
222214 | 222214 | 2020-06-09 | Delaware | Indiana | 18035 | 402 | 43 |
219119 | 219119 | 2020-06-08 | Delaware | Indiana | 18035 | 401 | 42 |
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);