ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 18095 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535171 | 535171 | 2020-09-15 | Madison | Indiana | 18095 | 1519 | 86 |
531936 | 531936 | 2020-09-14 | Madison | Indiana | 18095 | 1513 | 85 |
528699 | 528699 | 2020-09-13 | Madison | Indiana | 18095 | 1503 | 85 |
525463 | 525463 | 2020-09-12 | Madison | Indiana | 18095 | 1489 | 85 |
522227 | 522227 | 2020-09-11 | Madison | Indiana | 18095 | 1473 | 85 |
518990 | 518990 | 2020-09-10 | Madison | Indiana | 18095 | 1459 | 85 |
515755 | 515755 | 2020-09-09 | Madison | Indiana | 18095 | 1448 | 85 |
512522 | 512522 | 2020-09-08 | Madison | Indiana | 18095 | 1434 | 85 |
509289 | 509289 | 2020-09-07 | Madison | Indiana | 18095 | 1426 | 85 |
506057 | 506057 | 2020-09-06 | Madison | Indiana | 18095 | 1418 | 85 |
502823 | 502823 | 2020-09-05 | Madison | Indiana | 18095 | 1403 | 85 |
499589 | 499589 | 2020-09-04 | Madison | Indiana | 18095 | 1390 | 85 |
496356 | 496356 | 2020-09-03 | Madison | Indiana | 18095 | 1375 | 85 |
493122 | 493122 | 2020-09-02 | Madison | Indiana | 18095 | 1353 | 83 |
489889 | 489889 | 2020-09-01 | Madison | Indiana | 18095 | 1343 | 80 |
486656 | 486656 | 2020-08-31 | Madison | Indiana | 18095 | 1313 | 80 |
483421 | 483421 | 2020-08-30 | Madison | Indiana | 18095 | 1295 | 80 |
480187 | 480187 | 2020-08-29 | Madison | Indiana | 18095 | 1286 | 80 |
476954 | 476954 | 2020-08-28 | Madison | Indiana | 18095 | 1266 | 80 |
473721 | 473721 | 2020-08-27 | Madison | Indiana | 18095 | 1261 | 79 |
470489 | 470489 | 2020-08-26 | Madison | Indiana | 18095 | 1246 | 79 |
467260 | 467260 | 2020-08-25 | Madison | Indiana | 18095 | 1229 | 78 |
464031 | 464031 | 2020-08-24 | Madison | Indiana | 18095 | 1217 | 78 |
460802 | 460802 | 2020-08-23 | Madison | Indiana | 18095 | 1199 | 78 |
457575 | 457575 | 2020-08-22 | Madison | Indiana | 18095 | 1190 | 78 |
454347 | 454347 | 2020-08-21 | Madison | Indiana | 18095 | 1176 | 78 |
451119 | 451119 | 2020-08-20 | Madison | Indiana | 18095 | 1162 | 78 |
447891 | 447891 | 2020-08-19 | Madison | Indiana | 18095 | 1153 | 78 |
444664 | 444664 | 2020-08-18 | Madison | Indiana | 18095 | 1142 | 77 |
441438 | 441438 | 2020-08-17 | Madison | Indiana | 18095 | 1124 | 77 |
438212 | 438212 | 2020-08-16 | Madison | Indiana | 18095 | 1118 | 77 |
434986 | 434986 | 2020-08-15 | Madison | Indiana | 18095 | 1097 | 77 |
431761 | 431761 | 2020-08-14 | Madison | Indiana | 18095 | 1080 | 77 |
428533 | 428533 | 2020-08-13 | Madison | Indiana | 18095 | 1065 | 77 |
425309 | 425309 | 2020-08-12 | Madison | Indiana | 18095 | 1045 | 77 |
422088 | 422088 | 2020-08-11 | Madison | Indiana | 18095 | 1021 | 76 |
418865 | 418865 | 2020-08-10 | Madison | Indiana | 18095 | 1002 | 76 |
415644 | 415644 | 2020-08-09 | Madison | Indiana | 18095 | 994 | 76 |
412424 | 412424 | 2020-08-08 | Madison | Indiana | 18095 | 958 | 76 |
409205 | 409205 | 2020-08-07 | Madison | Indiana | 18095 | 930 | 76 |
405985 | 405985 | 2020-08-06 | Madison | Indiana | 18095 | 910 | 76 |
402767 | 402767 | 2020-08-05 | Madison | Indiana | 18095 | 887 | 76 |
399551 | 399551 | 2020-08-04 | Madison | Indiana | 18095 | 877 | 76 |
396335 | 396335 | 2020-08-03 | Madison | Indiana | 18095 | 862 | 76 |
393119 | 393119 | 2020-08-02 | Madison | Indiana | 18095 | 857 | 76 |
389902 | 389902 | 2020-08-01 | Madison | Indiana | 18095 | 848 | 75 |
386685 | 386685 | 2020-07-31 | Madison | Indiana | 18095 | 827 | 75 |
383467 | 383467 | 2020-07-30 | Madison | Indiana | 18095 | 804 | 75 |
380250 | 380250 | 2020-07-29 | Madison | Indiana | 18095 | 800 | 75 |
377033 | 377033 | 2020-07-28 | Madison | Indiana | 18095 | 789 | 75 |
373818 | 373818 | 2020-07-27 | Madison | Indiana | 18095 | 781 | 75 |
370606 | 370606 | 2020-07-26 | Madison | Indiana | 18095 | 774 | 75 |
367396 | 367396 | 2020-07-25 | Madison | Indiana | 18095 | 767 | 75 |
364189 | 364189 | 2020-07-24 | Madison | Indiana | 18095 | 761 | 75 |
360982 | 360982 | 2020-07-23 | Madison | Indiana | 18095 | 752 | 75 |
357777 | 357777 | 2020-07-22 | Madison | Indiana | 18095 | 733 | 75 |
354575 | 354575 | 2020-07-21 | Madison | Indiana | 18095 | 729 | 75 |
351373 | 351373 | 2020-07-20 | Madison | Indiana | 18095 | 727 | 74 |
348173 | 348173 | 2020-07-19 | Madison | Indiana | 18095 | 726 | 74 |
344972 | 344972 | 2020-07-18 | Madison | Indiana | 18095 | 716 | 74 |
341772 | 341772 | 2020-07-17 | Madison | Indiana | 18095 | 715 | 74 |
338576 | 338576 | 2020-07-16 | Madison | Indiana | 18095 | 712 | 74 |
335380 | 335380 | 2020-07-15 | Madison | Indiana | 18095 | 705 | 74 |
332187 | 332187 | 2020-07-14 | Madison | Indiana | 18095 | 697 | 74 |
329000 | 329000 | 2020-07-13 | Madison | Indiana | 18095 | 692 | 74 |
325814 | 325814 | 2020-07-12 | Madison | Indiana | 18095 | 689 | 74 |
322633 | 322633 | 2020-07-11 | Madison | Indiana | 18095 | 685 | 74 |
319454 | 319454 | 2020-07-10 | Madison | Indiana | 18095 | 683 | 74 |
316281 | 316281 | 2020-07-09 | Madison | Indiana | 18095 | 679 | 74 |
313107 | 313107 | 2020-07-08 | Madison | Indiana | 18095 | 678 | 74 |
309937 | 309937 | 2020-07-07 | Madison | Indiana | 18095 | 674 | 74 |
306769 | 306769 | 2020-07-06 | Madison | Indiana | 18095 | 670 | 74 |
303604 | 303604 | 2020-07-05 | Madison | Indiana | 18095 | 669 | 74 |
300440 | 300440 | 2020-07-04 | Madison | Indiana | 18095 | 666 | 74 |
297278 | 297278 | 2020-07-03 | Madison | Indiana | 18095 | 659 | 74 |
294120 | 294120 | 2020-07-02 | Madison | Indiana | 18095 | 654 | 73 |
290966 | 290966 | 2020-07-01 | Madison | Indiana | 18095 | 653 | 73 |
287816 | 287816 | 2020-06-30 | Madison | Indiana | 18095 | 652 | 73 |
284667 | 284667 | 2020-06-29 | Madison | Indiana | 18095 | 652 | 73 |
281522 | 281522 | 2020-06-28 | Madison | Indiana | 18095 | 649 | 73 |
278374 | 278374 | 2020-06-27 | Madison | Indiana | 18095 | 648 | 73 |
275226 | 275226 | 2020-06-26 | Madison | Indiana | 18095 | 642 | 73 |
272084 | 272084 | 2020-06-25 | Madison | Indiana | 18095 | 634 | 73 |
268947 | 268947 | 2020-06-24 | Madison | Indiana | 18095 | 634 | 73 |
265817 | 265817 | 2020-06-23 | Madison | Indiana | 18095 | 631 | 73 |
262689 | 262689 | 2020-06-22 | Madison | Indiana | 18095 | 631 | 73 |
259562 | 259562 | 2020-06-21 | Madison | Indiana | 18095 | 630 | 73 |
256436 | 256436 | 2020-06-20 | Madison | Indiana | 18095 | 628 | 73 |
253316 | 253316 | 2020-06-19 | Madison | Indiana | 18095 | 628 | 73 |
250201 | 250201 | 2020-06-18 | Madison | Indiana | 18095 | 628 | 72 |
247089 | 247089 | 2020-06-17 | Madison | Indiana | 18095 | 625 | 72 |
243976 | 243976 | 2020-06-16 | Madison | Indiana | 18095 | 625 | 72 |
240865 | 240865 | 2020-06-15 | Madison | Indiana | 18095 | 624 | 71 |
237757 | 237757 | 2020-06-14 | Madison | Indiana | 18095 | 624 | 71 |
234650 | 234650 | 2020-06-13 | Madison | Indiana | 18095 | 622 | 71 |
231544 | 231544 | 2020-06-12 | Madison | Indiana | 18095 | 622 | 71 |
228441 | 228441 | 2020-06-11 | Madison | Indiana | 18095 | 620 | 71 |
225339 | 225339 | 2020-06-10 | Madison | Indiana | 18095 | 616 | 71 |
222244 | 222244 | 2020-06-09 | Madison | Indiana | 18095 | 615 | 71 |
219149 | 219149 | 2020-06-08 | Madison | Indiana | 18095 | 615 | 71 |
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);