ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18177 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535212 | 535212 | 2020-09-15 | Wayne | Indiana | 18177 | 1073 | 14 |
531977 | 531977 | 2020-09-14 | Wayne | Indiana | 18177 | 1065 | 13 |
528740 | 528740 | 2020-09-13 | Wayne | Indiana | 18177 | 1055 | 13 |
525504 | 525504 | 2020-09-12 | Wayne | Indiana | 18177 | 1047 | 13 |
522268 | 522268 | 2020-09-11 | Wayne | Indiana | 18177 | 1035 | 13 |
519031 | 519031 | 2020-09-10 | Wayne | Indiana | 18177 | 1025 | 12 |
515796 | 515796 | 2020-09-09 | Wayne | Indiana | 18177 | 1011 | 12 |
512563 | 512563 | 2020-09-08 | Wayne | Indiana | 18177 | 995 | 11 |
509330 | 509330 | 2020-09-07 | Wayne | Indiana | 18177 | 990 | 10 |
506098 | 506098 | 2020-09-06 | Wayne | Indiana | 18177 | 981 | 10 |
502864 | 502864 | 2020-09-05 | Wayne | Indiana | 18177 | 971 | 10 |
499630 | 499630 | 2020-09-04 | Wayne | Indiana | 18177 | 938 | 10 |
496397 | 496397 | 2020-09-03 | Wayne | Indiana | 18177 | 923 | 10 |
493163 | 493163 | 2020-09-02 | Wayne | Indiana | 18177 | 907 | 10 |
489930 | 489930 | 2020-09-01 | Wayne | Indiana | 18177 | 897 | 10 |
486697 | 486697 | 2020-08-31 | Wayne | Indiana | 18177 | 887 | 10 |
483462 | 483462 | 2020-08-30 | Wayne | Indiana | 18177 | 876 | 10 |
480228 | 480228 | 2020-08-29 | Wayne | Indiana | 18177 | 865 | 10 |
476995 | 476995 | 2020-08-28 | Wayne | Indiana | 18177 | 859 | 10 |
473762 | 473762 | 2020-08-27 | Wayne | Indiana | 18177 | 855 | 10 |
470530 | 470530 | 2020-08-26 | Wayne | Indiana | 18177 | 832 | 10 |
467301 | 467301 | 2020-08-25 | Wayne | Indiana | 18177 | 829 | 10 |
464072 | 464072 | 2020-08-24 | Wayne | Indiana | 18177 | 820 | 10 |
460843 | 460843 | 2020-08-23 | Wayne | Indiana | 18177 | 802 | 10 |
457616 | 457616 | 2020-08-22 | Wayne | Indiana | 18177 | 793 | 10 |
454388 | 454388 | 2020-08-21 | Wayne | Indiana | 18177 | 784 | 10 |
451160 | 451160 | 2020-08-20 | Wayne | Indiana | 18177 | 775 | 10 |
447932 | 447932 | 2020-08-19 | Wayne | Indiana | 18177 | 763 | 10 |
444705 | 444705 | 2020-08-18 | Wayne | Indiana | 18177 | 754 | 10 |
441479 | 441479 | 2020-08-17 | Wayne | Indiana | 18177 | 746 | 10 |
438253 | 438253 | 2020-08-16 | Wayne | Indiana | 18177 | 741 | 10 |
435027 | 435027 | 2020-08-15 | Wayne | Indiana | 18177 | 735 | 10 |
431802 | 431802 | 2020-08-14 | Wayne | Indiana | 18177 | 721 | 10 |
428574 | 428574 | 2020-08-13 | Wayne | Indiana | 18177 | 710 | 10 |
425350 | 425350 | 2020-08-12 | Wayne | Indiana | 18177 | 696 | 10 |
422129 | 422129 | 2020-08-11 | Wayne | Indiana | 18177 | 669 | 10 |
418906 | 418906 | 2020-08-10 | Wayne | Indiana | 18177 | 662 | 10 |
415685 | 415685 | 2020-08-09 | Wayne | Indiana | 18177 | 662 | 10 |
412465 | 412465 | 2020-08-08 | Wayne | Indiana | 18177 | 653 | 10 |
409246 | 409246 | 2020-08-07 | Wayne | Indiana | 18177 | 639 | 10 |
406026 | 406026 | 2020-08-06 | Wayne | Indiana | 18177 | 631 | 10 |
402808 | 402808 | 2020-08-05 | Wayne | Indiana | 18177 | 622 | 10 |
399592 | 399592 | 2020-08-04 | Wayne | Indiana | 18177 | 610 | 10 |
396376 | 396376 | 2020-08-03 | Wayne | Indiana | 18177 | 593 | 9 |
393160 | 393160 | 2020-08-02 | Wayne | Indiana | 18177 | 591 | 9 |
389943 | 389943 | 2020-08-01 | Wayne | Indiana | 18177 | 588 | 9 |
386726 | 386726 | 2020-07-31 | Wayne | Indiana | 18177 | 579 | 9 |
383508 | 383508 | 2020-07-30 | Wayne | Indiana | 18177 | 560 | 8 |
380291 | 380291 | 2020-07-29 | Wayne | Indiana | 18177 | 549 | 8 |
377074 | 377074 | 2020-07-28 | Wayne | Indiana | 18177 | 522 | 8 |
373859 | 373859 | 2020-07-27 | Wayne | Indiana | 18177 | 502 | 7 |
370647 | 370647 | 2020-07-26 | Wayne | Indiana | 18177 | 494 | 7 |
367437 | 367437 | 2020-07-25 | Wayne | Indiana | 18177 | 485 | 7 |
364230 | 364230 | 2020-07-24 | Wayne | Indiana | 18177 | 471 | 7 |
361023 | 361023 | 2020-07-23 | Wayne | Indiana | 18177 | 458 | 7 |
357818 | 357818 | 2020-07-22 | Wayne | Indiana | 18177 | 436 | 7 |
354616 | 354616 | 2020-07-21 | Wayne | Indiana | 18177 | 432 | 7 |
351414 | 351414 | 2020-07-20 | Wayne | Indiana | 18177 | 408 | 6 |
348214 | 348214 | 2020-07-19 | Wayne | Indiana | 18177 | 400 | 6 |
345013 | 345013 | 2020-07-18 | Wayne | Indiana | 18177 | 395 | 6 |
341813 | 341813 | 2020-07-17 | Wayne | Indiana | 18177 | 381 | 6 |
338617 | 338617 | 2020-07-16 | Wayne | Indiana | 18177 | 378 | 6 |
335421 | 335421 | 2020-07-15 | Wayne | Indiana | 18177 | 364 | 6 |
332228 | 332228 | 2020-07-14 | Wayne | Indiana | 18177 | 360 | 6 |
329041 | 329041 | 2020-07-13 | Wayne | Indiana | 18177 | 354 | 6 |
325855 | 325855 | 2020-07-12 | Wayne | Indiana | 18177 | 346 | 6 |
322674 | 322674 | 2020-07-11 | Wayne | Indiana | 18177 | 342 | 6 |
319495 | 319495 | 2020-07-10 | Wayne | Indiana | 18177 | 340 | 6 |
316322 | 316322 | 2020-07-09 | Wayne | Indiana | 18177 | 330 | 6 |
313148 | 313148 | 2020-07-08 | Wayne | Indiana | 18177 | 321 | 6 |
309978 | 309978 | 2020-07-07 | Wayne | Indiana | 18177 | 320 | 6 |
306810 | 306810 | 2020-07-06 | Wayne | Indiana | 18177 | 318 | 6 |
303645 | 303645 | 2020-07-05 | Wayne | Indiana | 18177 | 316 | 6 |
300481 | 300481 | 2020-07-04 | Wayne | Indiana | 18177 | 314 | 6 |
297319 | 297319 | 2020-07-03 | Wayne | Indiana | 18177 | 312 | 6 |
294161 | 294161 | 2020-07-02 | Wayne | Indiana | 18177 | 307 | 6 |
291007 | 291007 | 2020-07-01 | Wayne | Indiana | 18177 | 306 | 6 |
287857 | 287857 | 2020-06-30 | Wayne | Indiana | 18177 | 305 | 6 |
284708 | 284708 | 2020-06-29 | Wayne | Indiana | 18177 | 304 | 6 |
281563 | 281563 | 2020-06-28 | Wayne | Indiana | 18177 | 302 | 6 |
278415 | 278415 | 2020-06-27 | Wayne | Indiana | 18177 | 298 | 6 |
275267 | 275267 | 2020-06-26 | Wayne | Indiana | 18177 | 297 | 6 |
272125 | 272125 | 2020-06-25 | Wayne | Indiana | 18177 | 293 | 6 |
268988 | 268988 | 2020-06-24 | Wayne | Indiana | 18177 | 290 | 6 |
265858 | 265858 | 2020-06-23 | Wayne | Indiana | 18177 | 281 | 6 |
262730 | 262730 | 2020-06-22 | Wayne | Indiana | 18177 | 281 | 6 |
259603 | 259603 | 2020-06-21 | Wayne | Indiana | 18177 | 279 | 6 |
256477 | 256477 | 2020-06-20 | Wayne | Indiana | 18177 | 278 | 6 |
253357 | 253357 | 2020-06-19 | Wayne | Indiana | 18177 | 278 | 6 |
250242 | 250242 | 2020-06-18 | Wayne | Indiana | 18177 | 275 | 6 |
247130 | 247130 | 2020-06-17 | Wayne | Indiana | 18177 | 274 | 6 |
244017 | 244017 | 2020-06-16 | Wayne | Indiana | 18177 | 270 | 6 |
240906 | 240906 | 2020-06-15 | Wayne | Indiana | 18177 | 271 | 6 |
237798 | 237798 | 2020-06-14 | Wayne | Indiana | 18177 | 270 | 6 |
234691 | 234691 | 2020-06-13 | Wayne | Indiana | 18177 | 265 | 6 |
231585 | 231585 | 2020-06-12 | Wayne | Indiana | 18177 | 259 | 6 |
228482 | 228482 | 2020-06-11 | Wayne | Indiana | 18177 | 255 | 6 |
225380 | 225380 | 2020-06-10 | Wayne | Indiana | 18177 | 251 | 6 |
222285 | 222285 | 2020-06-09 | Wayne | Indiana | 18177 | 248 | 6 |
219190 | 219190 | 2020-06-08 | Wayne | Indiana | 18177 | 248 | 6 |
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);