ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18053 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535150 | 535150 | 2020-09-15 | Grant | Indiana | 18053 | 1175 | 35 |
531915 | 531915 | 2020-09-14 | Grant | Indiana | 18053 | 1171 | 35 |
528678 | 528678 | 2020-09-13 | Grant | Indiana | 18053 | 1160 | 35 |
525442 | 525442 | 2020-09-12 | Grant | Indiana | 18053 | 1151 | 35 |
522206 | 522206 | 2020-09-11 | Grant | Indiana | 18053 | 1138 | 35 |
518969 | 518969 | 2020-09-10 | Grant | Indiana | 18053 | 1119 | 35 |
515734 | 515734 | 2020-09-09 | Grant | Indiana | 18053 | 1086 | 35 |
512501 | 512501 | 2020-09-08 | Grant | Indiana | 18053 | 1069 | 35 |
509268 | 509268 | 2020-09-07 | Grant | Indiana | 18053 | 1058 | 34 |
506036 | 506036 | 2020-09-06 | Grant | Indiana | 18053 | 1049 | 34 |
502802 | 502802 | 2020-09-05 | Grant | Indiana | 18053 | 1043 | 34 |
499568 | 499568 | 2020-09-04 | Grant | Indiana | 18053 | 1022 | 34 |
496335 | 496335 | 2020-09-03 | Grant | Indiana | 18053 | 1006 | 34 |
493101 | 493101 | 2020-09-02 | Grant | Indiana | 18053 | 983 | 34 |
489868 | 489868 | 2020-09-01 | Grant | Indiana | 18053 | 968 | 34 |
486635 | 486635 | 2020-08-31 | Grant | Indiana | 18053 | 957 | 33 |
483400 | 483400 | 2020-08-30 | Grant | Indiana | 18053 | 946 | 33 |
480166 | 480166 | 2020-08-29 | Grant | Indiana | 18053 | 935 | 33 |
476933 | 476933 | 2020-08-28 | Grant | Indiana | 18053 | 921 | 33 |
473700 | 473700 | 2020-08-27 | Grant | Indiana | 18053 | 918 | 33 |
470468 | 470468 | 2020-08-26 | Grant | Indiana | 18053 | 909 | 33 |
467239 | 467239 | 2020-08-25 | Grant | Indiana | 18053 | 903 | 33 |
464010 | 464010 | 2020-08-24 | Grant | Indiana | 18053 | 897 | 33 |
460781 | 460781 | 2020-08-23 | Grant | Indiana | 18053 | 875 | 33 |
457554 | 457554 | 2020-08-22 | Grant | Indiana | 18053 | 868 | 33 |
454326 | 454326 | 2020-08-21 | Grant | Indiana | 18053 | 857 | 33 |
451098 | 451098 | 2020-08-20 | Grant | Indiana | 18053 | 850 | 33 |
447870 | 447870 | 2020-08-19 | Grant | Indiana | 18053 | 841 | 33 |
444643 | 444643 | 2020-08-18 | Grant | Indiana | 18053 | 841 | 33 |
441417 | 441417 | 2020-08-17 | Grant | Indiana | 18053 | 833 | 33 |
438191 | 438191 | 2020-08-16 | Grant | Indiana | 18053 | 829 | 33 |
434965 | 434965 | 2020-08-15 | Grant | Indiana | 18053 | 827 | 33 |
431740 | 431740 | 2020-08-14 | Grant | Indiana | 18053 | 814 | 33 |
428512 | 428512 | 2020-08-13 | Grant | Indiana | 18053 | 799 | 33 |
425288 | 425288 | 2020-08-12 | Grant | Indiana | 18053 | 786 | 33 |
422067 | 422067 | 2020-08-11 | Grant | Indiana | 18053 | 783 | 33 |
418844 | 418844 | 2020-08-10 | Grant | Indiana | 18053 | 782 | 33 |
415623 | 415623 | 2020-08-09 | Grant | Indiana | 18053 | 780 | 33 |
412403 | 412403 | 2020-08-08 | Grant | Indiana | 18053 | 780 | 33 |
409184 | 409184 | 2020-08-07 | Grant | Indiana | 18053 | 775 | 33 |
405964 | 405964 | 2020-08-06 | Grant | Indiana | 18053 | 772 | 32 |
402746 | 402746 | 2020-08-05 | Grant | Indiana | 18053 | 760 | 32 |
399530 | 399530 | 2020-08-04 | Grant | Indiana | 18053 | 745 | 32 |
396314 | 396314 | 2020-08-03 | Grant | Indiana | 18053 | 734 | 32 |
393098 | 393098 | 2020-08-02 | Grant | Indiana | 18053 | 733 | 32 |
389881 | 389881 | 2020-08-01 | Grant | Indiana | 18053 | 711 | 32 |
386664 | 386664 | 2020-07-31 | Grant | Indiana | 18053 | 707 | 32 |
383446 | 383446 | 2020-07-30 | Grant | Indiana | 18053 | 702 | 32 |
380229 | 380229 | 2020-07-29 | Grant | Indiana | 18053 | 689 | 32 |
377012 | 377012 | 2020-07-28 | Grant | Indiana | 18053 | 681 | 32 |
373797 | 373797 | 2020-07-27 | Grant | Indiana | 18053 | 657 | 32 |
370585 | 370585 | 2020-07-26 | Grant | Indiana | 18053 | 655 | 32 |
367375 | 367375 | 2020-07-25 | Grant | Indiana | 18053 | 649 | 32 |
364168 | 364168 | 2020-07-24 | Grant | Indiana | 18053 | 627 | 32 |
360961 | 360961 | 2020-07-23 | Grant | Indiana | 18053 | 618 | 32 |
357756 | 357756 | 2020-07-22 | Grant | Indiana | 18053 | 604 | 31 |
354554 | 354554 | 2020-07-21 | Grant | Indiana | 18053 | 582 | 31 |
351352 | 351352 | 2020-07-20 | Grant | Indiana | 18053 | 572 | 30 |
348152 | 348152 | 2020-07-19 | Grant | Indiana | 18053 | 556 | 30 |
344951 | 344951 | 2020-07-18 | Grant | Indiana | 18053 | 542 | 30 |
341751 | 341751 | 2020-07-17 | Grant | Indiana | 18053 | 519 | 30 |
338555 | 338555 | 2020-07-16 | Grant | Indiana | 18053 | 512 | 30 |
335359 | 335359 | 2020-07-15 | Grant | Indiana | 18053 | 489 | 29 |
332166 | 332166 | 2020-07-14 | Grant | Indiana | 18053 | 476 | 29 |
328979 | 328979 | 2020-07-13 | Grant | Indiana | 18053 | 449 | 29 |
325793 | 325793 | 2020-07-12 | Grant | Indiana | 18053 | 449 | 29 |
322612 | 322612 | 2020-07-11 | Grant | Indiana | 18053 | 445 | 29 |
319433 | 319433 | 2020-07-10 | Grant | Indiana | 18053 | 428 | 29 |
316260 | 316260 | 2020-07-09 | Grant | Indiana | 18053 | 421 | 29 |
313086 | 313086 | 2020-07-08 | Grant | Indiana | 18053 | 414 | 29 |
309916 | 309916 | 2020-07-07 | Grant | Indiana | 18053 | 405 | 29 |
306748 | 306748 | 2020-07-06 | Grant | Indiana | 18053 | 402 | 29 |
303583 | 303583 | 2020-07-05 | Grant | Indiana | 18053 | 401 | 29 |
300419 | 300419 | 2020-07-04 | Grant | Indiana | 18053 | 398 | 29 |
297257 | 297257 | 2020-07-03 | Grant | Indiana | 18053 | 391 | 29 |
294099 | 294099 | 2020-07-02 | Grant | Indiana | 18053 | 387 | 29 |
290945 | 290945 | 2020-07-01 | Grant | Indiana | 18053 | 385 | 29 |
287795 | 287795 | 2020-06-30 | Grant | Indiana | 18053 | 376 | 29 |
284646 | 284646 | 2020-06-29 | Grant | Indiana | 18053 | 374 | 29 |
281501 | 281501 | 2020-06-28 | Grant | Indiana | 18053 | 373 | 29 |
278353 | 278353 | 2020-06-27 | Grant | Indiana | 18053 | 368 | 29 |
275205 | 275205 | 2020-06-26 | Grant | Indiana | 18053 | 371 | 29 |
272063 | 272063 | 2020-06-25 | Grant | Indiana | 18053 | 364 | 29 |
268926 | 268926 | 2020-06-24 | Grant | Indiana | 18053 | 364 | 29 |
265796 | 265796 | 2020-06-23 | Grant | Indiana | 18053 | 361 | 29 |
262668 | 262668 | 2020-06-22 | Grant | Indiana | 18053 | 354 | 29 |
259541 | 259541 | 2020-06-21 | Grant | Indiana | 18053 | 354 | 28 |
256415 | 256415 | 2020-06-20 | Grant | Indiana | 18053 | 352 | 28 |
253295 | 253295 | 2020-06-19 | Grant | Indiana | 18053 | 347 | 28 |
250180 | 250180 | 2020-06-18 | Grant | Indiana | 18053 | 341 | 27 |
247068 | 247068 | 2020-06-17 | Grant | Indiana | 18053 | 334 | 27 |
243955 | 243955 | 2020-06-16 | Grant | Indiana | 18053 | 331 | 27 |
240844 | 240844 | 2020-06-15 | Grant | Indiana | 18053 | 329 | 27 |
237736 | 237736 | 2020-06-14 | Grant | Indiana | 18053 | 328 | 27 |
234629 | 234629 | 2020-06-13 | Grant | Indiana | 18053 | 326 | 27 |
231523 | 231523 | 2020-06-12 | Grant | Indiana | 18053 | 320 | 27 |
228420 | 228420 | 2020-06-11 | Grant | Indiana | 18053 | 317 | 27 |
225318 | 225318 | 2020-06-10 | Grant | Indiana | 18053 | 311 | 26 |
222223 | 222223 | 2020-06-09 | Grant | Indiana | 18053 | 309 | 26 |
219128 | 219128 | 2020-06-08 | Grant | Indiana | 18053 | 303 | 26 |
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);