ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Clay" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635597 | 635597 | 2020-10-16 | Clay | Indiana | 18021 | 405 | 6 |
632351 | 632351 | 2020-10-15 | Clay | Indiana | 18021 | 393 | 6 |
629107 | 629107 | 2020-10-14 | Clay | Indiana | 18021 | 385 | 6 |
625864 | 625864 | 2020-10-13 | Clay | Indiana | 18021 | 382 | 6 |
622622 | 622622 | 2020-10-12 | Clay | Indiana | 18021 | 376 | 6 |
619378 | 619378 | 2020-10-11 | Clay | Indiana | 18021 | 372 | 6 |
616136 | 616136 | 2020-10-10 | Clay | Indiana | 18021 | 367 | 6 |
612895 | 612895 | 2020-10-09 | Clay | Indiana | 18021 | 352 | 6 |
609653 | 609653 | 2020-10-08 | Clay | Indiana | 18021 | 348 | 5 |
606410 | 606410 | 2020-10-07 | Clay | Indiana | 18021 | 342 | 5 |
603168 | 603168 | 2020-10-06 | Clay | Indiana | 18021 | 338 | 5 |
599925 | 599925 | 2020-10-05 | Clay | Indiana | 18021 | 334 | 5 |
596683 | 596683 | 2020-10-04 | Clay | Indiana | 18021 | 333 | 5 |
593441 | 593441 | 2020-10-03 | Clay | Indiana | 18021 | 329 | 5 |
590200 | 590200 | 2020-10-02 | Clay | Indiana | 18021 | 323 | 5 |
586959 | 586959 | 2020-10-01 | Clay | Indiana | 18021 | 317 | 5 |
583719 | 583719 | 2020-09-30 | Clay | Indiana | 18021 | 315 | 5 |
580480 | 580480 | 2020-09-29 | Clay | Indiana | 18021 | 310 | 5 |
577239 | 577239 | 2020-09-28 | Clay | Indiana | 18021 | 308 | 5 |
573997 | 573997 | 2020-09-27 | Clay | Indiana | 18021 | 302 | 5 |
570754 | 570754 | 2020-09-26 | Clay | Indiana | 18021 | 301 | 5 |
567512 | 567512 | 2020-09-25 | Clay | Indiana | 18021 | 300 | 5 |
564272 | 564272 | 2020-09-24 | Clay | Indiana | 18021 | 299 | 5 |
561032 | 561032 | 2020-09-23 | Clay | Indiana | 18021 | 298 | 5 |
557796 | 557796 | 2020-09-22 | Clay | Indiana | 18021 | 293 | 5 |
554559 | 554559 | 2020-09-21 | Clay | Indiana | 18021 | 293 | 5 |
551320 | 551320 | 2020-09-20 | Clay | Indiana | 18021 | 292 | 5 |
548081 | 548081 | 2020-09-19 | Clay | Indiana | 18021 | 292 | 5 |
544843 | 544843 | 2020-09-18 | Clay | Indiana | 18021 | 288 | 5 |
541607 | 541607 | 2020-09-17 | Clay | Indiana | 18021 | 285 | 5 |
538370 | 538370 | 2020-09-16 | Clay | Indiana | 18021 | 284 | 5 |
535134 | 535134 | 2020-09-15 | Clay | Indiana | 18021 | 280 | 5 |
531899 | 531899 | 2020-09-14 | Clay | Indiana | 18021 | 277 | 5 |
528662 | 528662 | 2020-09-13 | Clay | Indiana | 18021 | 272 | 5 |
525426 | 525426 | 2020-09-12 | Clay | Indiana | 18021 | 271 | 5 |
522190 | 522190 | 2020-09-11 | Clay | Indiana | 18021 | 269 | 5 |
518953 | 518953 | 2020-09-10 | Clay | Indiana | 18021 | 265 | 5 |
515718 | 515718 | 2020-09-09 | Clay | Indiana | 18021 | 256 | 5 |
512485 | 512485 | 2020-09-08 | Clay | Indiana | 18021 | 253 | 5 |
509252 | 509252 | 2020-09-07 | Clay | Indiana | 18021 | 251 | 5 |
506020 | 506020 | 2020-09-06 | Clay | Indiana | 18021 | 250 | 5 |
502786 | 502786 | 2020-09-05 | Clay | Indiana | 18021 | 248 | 5 |
499552 | 499552 | 2020-09-04 | Clay | Indiana | 18021 | 246 | 5 |
496319 | 496319 | 2020-09-03 | Clay | Indiana | 18021 | 245 | 5 |
493085 | 493085 | 2020-09-02 | Clay | Indiana | 18021 | 241 | 5 |
489852 | 489852 | 2020-09-01 | Clay | Indiana | 18021 | 233 | 5 |
486619 | 486619 | 2020-08-31 | Clay | Indiana | 18021 | 229 | 5 |
483384 | 483384 | 2020-08-30 | Clay | Indiana | 18021 | 227 | 5 |
480150 | 480150 | 2020-08-29 | Clay | Indiana | 18021 | 224 | 5 |
476917 | 476917 | 2020-08-28 | Clay | Indiana | 18021 | 218 | 5 |
473684 | 473684 | 2020-08-27 | Clay | Indiana | 18021 | 214 | 5 |
470452 | 470452 | 2020-08-26 | Clay | Indiana | 18021 | 209 | 5 |
467223 | 467223 | 2020-08-25 | Clay | Indiana | 18021 | 209 | 5 |
463994 | 463994 | 2020-08-24 | Clay | Indiana | 18021 | 207 | 5 |
460765 | 460765 | 2020-08-23 | Clay | Indiana | 18021 | 205 | 5 |
457538 | 457538 | 2020-08-22 | Clay | Indiana | 18021 | 197 | 5 |
454310 | 454310 | 2020-08-21 | Clay | Indiana | 18021 | 193 | 5 |
451082 | 451082 | 2020-08-20 | Clay | Indiana | 18021 | 188 | 5 |
447854 | 447854 | 2020-08-19 | Clay | Indiana | 18021 | 187 | 5 |
444627 | 444627 | 2020-08-18 | Clay | Indiana | 18021 | 187 | 5 |
441401 | 441401 | 2020-08-17 | Clay | Indiana | 18021 | 175 | 5 |
438175 | 438175 | 2020-08-16 | Clay | Indiana | 18021 | 169 | 5 |
434949 | 434949 | 2020-08-15 | Clay | Indiana | 18021 | 163 | 5 |
431724 | 431724 | 2020-08-14 | Clay | Indiana | 18021 | 150 | 5 |
428496 | 428496 | 2020-08-13 | Clay | Indiana | 18021 | 141 | 5 |
425272 | 425272 | 2020-08-12 | Clay | Indiana | 18021 | 131 | 5 |
422051 | 422051 | 2020-08-11 | Clay | Indiana | 18021 | 124 | 5 |
418828 | 418828 | 2020-08-10 | Clay | Indiana | 18021 | 124 | 5 |
415607 | 415607 | 2020-08-09 | Clay | Indiana | 18021 | 121 | 5 |
412387 | 412387 | 2020-08-08 | Clay | Indiana | 18021 | 116 | 5 |
409168 | 409168 | 2020-08-07 | Clay | Indiana | 18021 | 109 | 5 |
405948 | 405948 | 2020-08-06 | Clay | Indiana | 18021 | 104 | 5 |
402730 | 402730 | 2020-08-05 | Clay | Indiana | 18021 | 102 | 5 |
399514 | 399514 | 2020-08-04 | Clay | Indiana | 18021 | 101 | 5 |
396298 | 396298 | 2020-08-03 | Clay | Indiana | 18021 | 97 | 5 |
393082 | 393082 | 2020-08-02 | Clay | Indiana | 18021 | 97 | 5 |
389865 | 389865 | 2020-08-01 | Clay | Indiana | 18021 | 94 | 5 |
386648 | 386648 | 2020-07-31 | Clay | Indiana | 18021 | 94 | 5 |
383430 | 383430 | 2020-07-30 | Clay | Indiana | 18021 | 92 | 5 |
380213 | 380213 | 2020-07-29 | Clay | Indiana | 18021 | 89 | 5 |
376996 | 376996 | 2020-07-28 | Clay | Indiana | 18021 | 88 | 5 |
373781 | 373781 | 2020-07-27 | Clay | Indiana | 18021 | 83 | 5 |
370569 | 370569 | 2020-07-26 | Clay | Indiana | 18021 | 83 | 5 |
367359 | 367359 | 2020-07-25 | Clay | Indiana | 18021 | 82 | 5 |
364152 | 364152 | 2020-07-24 | Clay | Indiana | 18021 | 80 | 5 |
360945 | 360945 | 2020-07-23 | Clay | Indiana | 18021 | 76 | 5 |
357740 | 357740 | 2020-07-22 | Clay | Indiana | 18021 | 73 | 5 |
354538 | 354538 | 2020-07-21 | Clay | Indiana | 18021 | 73 | 5 |
351336 | 351336 | 2020-07-20 | Clay | Indiana | 18021 | 73 | 5 |
348136 | 348136 | 2020-07-19 | Clay | Indiana | 18021 | 71 | 5 |
344935 | 344935 | 2020-07-18 | Clay | Indiana | 18021 | 70 | 5 |
341735 | 341735 | 2020-07-17 | Clay | Indiana | 18021 | 69 | 5 |
338539 | 338539 | 2020-07-16 | Clay | Indiana | 18021 | 69 | 5 |
335343 | 335343 | 2020-07-15 | Clay | Indiana | 18021 | 67 | 5 |
332150 | 332150 | 2020-07-14 | Clay | Indiana | 18021 | 65 | 5 |
328963 | 328963 | 2020-07-13 | Clay | Indiana | 18021 | 64 | 5 |
325777 | 325777 | 2020-07-12 | Clay | Indiana | 18021 | 64 | 5 |
322596 | 322596 | 2020-07-11 | Clay | Indiana | 18021 | 64 | 5 |
319417 | 319417 | 2020-07-10 | Clay | Indiana | 18021 | 66 | 5 |
316244 | 316244 | 2020-07-09 | Clay | Indiana | 18021 | 64 | 4 |
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);