ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,658 rows where county = "Sullivan" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Tennessee 795
- New York 788
- New Hampshire 783
- Pennsylvania 770
- Missouri 741
- Indiana 681
county 1
- Sullivan · 4,558 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
294149 | 294149 | 2020-07-02 | Sullivan | Indiana | 18153 | 46 | 1 |
297307 | 297307 | 2020-07-03 | Sullivan | Indiana | 18153 | 46 | 1 |
300469 | 300469 | 2020-07-04 | Sullivan | Indiana | 18153 | 46 | 1 |
303633 | 303633 | 2020-07-05 | Sullivan | Indiana | 18153 | 46 | 1 |
306798 | 306798 | 2020-07-06 | Sullivan | Indiana | 18153 | 47 | 1 |
309966 | 309966 | 2020-07-07 | Sullivan | Indiana | 18153 | 47 | 1 |
313136 | 313136 | 2020-07-08 | Sullivan | Indiana | 18153 | 47 | 1 |
316310 | 316310 | 2020-07-09 | Sullivan | Indiana | 18153 | 47 | 1 |
319483 | 319483 | 2020-07-10 | Sullivan | Indiana | 18153 | 49 | 1 |
322662 | 322662 | 2020-07-11 | Sullivan | Indiana | 18153 | 52 | 1 |
325843 | 325843 | 2020-07-12 | Sullivan | Indiana | 18153 | 52 | 1 |
329029 | 329029 | 2020-07-13 | Sullivan | Indiana | 18153 | 53 | 1 |
332216 | 332216 | 2020-07-14 | Sullivan | Indiana | 18153 | 56 | 1 |
335409 | 335409 | 2020-07-15 | Sullivan | Indiana | 18153 | 60 | 1 |
338605 | 338605 | 2020-07-16 | Sullivan | Indiana | 18153 | 64 | 1 |
341801 | 341801 | 2020-07-17 | Sullivan | Indiana | 18153 | 65 | 1 |
345001 | 345001 | 2020-07-18 | Sullivan | Indiana | 18153 | 66 | 1 |
348202 | 348202 | 2020-07-19 | Sullivan | Indiana | 18153 | 66 | 1 |
351402 | 351402 | 2020-07-20 | Sullivan | Indiana | 18153 | 67 | 1 |
354604 | 354604 | 2020-07-21 | Sullivan | Indiana | 18153 | 67 | 1 |
357806 | 357806 | 2020-07-22 | Sullivan | Indiana | 18153 | 68 | 1 |
361011 | 361011 | 2020-07-23 | Sullivan | Indiana | 18153 | 69 | 1 |
364218 | 364218 | 2020-07-24 | Sullivan | Indiana | 18153 | 69 | 1 |
367425 | 367425 | 2020-07-25 | Sullivan | Indiana | 18153 | 69 | 1 |
370635 | 370635 | 2020-07-26 | Sullivan | Indiana | 18153 | 69 | 1 |
373847 | 373847 | 2020-07-27 | Sullivan | Indiana | 18153 | 69 | 1 |
377062 | 377062 | 2020-07-28 | Sullivan | Indiana | 18153 | 69 | 1 |
380279 | 380279 | 2020-07-29 | Sullivan | Indiana | 18153 | 69 | 1 |
383496 | 383496 | 2020-07-30 | Sullivan | Indiana | 18153 | 72 | 1 |
386714 | 386714 | 2020-07-31 | Sullivan | Indiana | 18153 | 72 | 1 |
389931 | 389931 | 2020-08-01 | Sullivan | Indiana | 18153 | 77 | 1 |
393148 | 393148 | 2020-08-02 | Sullivan | Indiana | 18153 | 78 | 1 |
396364 | 396364 | 2020-08-03 | Sullivan | Indiana | 18153 | 80 | 1 |
399580 | 399580 | 2020-08-04 | Sullivan | Indiana | 18153 | 82 | 1 |
402796 | 402796 | 2020-08-05 | Sullivan | Indiana | 18153 | 87 | 1 |
406014 | 406014 | 2020-08-06 | Sullivan | Indiana | 18153 | 95 | 1 |
409234 | 409234 | 2020-08-07 | Sullivan | Indiana | 18153 | 107 | 1 |
412453 | 412453 | 2020-08-08 | Sullivan | Indiana | 18153 | 117 | 1 |
415673 | 415673 | 2020-08-09 | Sullivan | Indiana | 18153 | 130 | 1 |
418894 | 418894 | 2020-08-10 | Sullivan | Indiana | 18153 | 138 | 1 |
422117 | 422117 | 2020-08-11 | Sullivan | Indiana | 18153 | 142 | 1 |
425338 | 425338 | 2020-08-12 | Sullivan | Indiana | 18153 | 145 | 1 |
428562 | 428562 | 2020-08-13 | Sullivan | Indiana | 18153 | 156 | 1 |
431790 | 431790 | 2020-08-14 | Sullivan | Indiana | 18153 | 167 | 1 |
435015 | 435015 | 2020-08-15 | Sullivan | Indiana | 18153 | 177 | 1 |
438241 | 438241 | 2020-08-16 | Sullivan | Indiana | 18153 | 184 | 1 |
441467 | 441467 | 2020-08-17 | Sullivan | Indiana | 18153 | 197 | 1 |
444693 | 444693 | 2020-08-18 | Sullivan | Indiana | 18153 | 207 | 1 |
447920 | 447920 | 2020-08-19 | Sullivan | Indiana | 18153 | 208 | 1 |
451148 | 451148 | 2020-08-20 | Sullivan | Indiana | 18153 | 226 | 2 |
454376 | 454376 | 2020-08-21 | Sullivan | Indiana | 18153 | 245 | 4 |
457604 | 457604 | 2020-08-22 | Sullivan | Indiana | 18153 | 256 | 4 |
460831 | 460831 | 2020-08-23 | Sullivan | Indiana | 18153 | 261 | 4 |
464060 | 464060 | 2020-08-24 | Sullivan | Indiana | 18153 | 262 | 5 |
467289 | 467289 | 2020-08-25 | Sullivan | Indiana | 18153 | 270 | 6 |
470518 | 470518 | 2020-08-26 | Sullivan | Indiana | 18153 | 275 | 7 |
473750 | 473750 | 2020-08-27 | Sullivan | Indiana | 18153 | 279 | 7 |
476983 | 476983 | 2020-08-28 | Sullivan | Indiana | 18153 | 286 | 8 |
480216 | 480216 | 2020-08-29 | Sullivan | Indiana | 18153 | 291 | 8 |
483450 | 483450 | 2020-08-30 | Sullivan | Indiana | 18153 | 293 | 8 |
486685 | 486685 | 2020-08-31 | Sullivan | Indiana | 18153 | 294 | 8 |
489918 | 489918 | 2020-09-01 | Sullivan | Indiana | 18153 | 295 | 8 |
493151 | 493151 | 2020-09-02 | Sullivan | Indiana | 18153 | 300 | 9 |
496385 | 496385 | 2020-09-03 | Sullivan | Indiana | 18153 | 302 | 9 |
499618 | 499618 | 2020-09-04 | Sullivan | Indiana | 18153 | 305 | 9 |
502852 | 502852 | 2020-09-05 | Sullivan | Indiana | 18153 | 308 | 10 |
506086 | 506086 | 2020-09-06 | Sullivan | Indiana | 18153 | 312 | 10 |
509318 | 509318 | 2020-09-07 | Sullivan | Indiana | 18153 | 312 | 11 |
512551 | 512551 | 2020-09-08 | Sullivan | Indiana | 18153 | 312 | 11 |
515784 | 515784 | 2020-09-09 | Sullivan | Indiana | 18153 | 315 | 11 |
519019 | 519019 | 2020-09-10 | Sullivan | Indiana | 18153 | 317 | 11 |
522256 | 522256 | 2020-09-11 | Sullivan | Indiana | 18153 | 320 | 11 |
525492 | 525492 | 2020-09-12 | Sullivan | Indiana | 18153 | 323 | 12 |
528728 | 528728 | 2020-09-13 | Sullivan | Indiana | 18153 | 323 | 12 |
531965 | 531965 | 2020-09-14 | Sullivan | Indiana | 18153 | 324 | 12 |
535200 | 535200 | 2020-09-15 | Sullivan | Indiana | 18153 | 328 | 12 |
538436 | 538436 | 2020-09-16 | Sullivan | Indiana | 18153 | 329 | 12 |
541673 | 541673 | 2020-09-17 | Sullivan | Indiana | 18153 | 330 | 12 |
544909 | 544909 | 2020-09-18 | Sullivan | Indiana | 18153 | 330 | 12 |
548147 | 548147 | 2020-09-19 | Sullivan | Indiana | 18153 | 332 | 12 |
551386 | 551386 | 2020-09-20 | Sullivan | Indiana | 18153 | 333 | 12 |
554625 | 554625 | 2020-09-21 | Sullivan | Indiana | 18153 | 334 | 12 |
557862 | 557862 | 2020-09-22 | Sullivan | Indiana | 18153 | 334 | 12 |
561098 | 561098 | 2020-09-23 | Sullivan | Indiana | 18153 | 335 | 12 |
564338 | 564338 | 2020-09-24 | Sullivan | Indiana | 18153 | 337 | 12 |
567578 | 567578 | 2020-09-25 | Sullivan | Indiana | 18153 | 341 | 12 |
570820 | 570820 | 2020-09-26 | Sullivan | Indiana | 18153 | 341 | 12 |
574063 | 574063 | 2020-09-27 | Sullivan | Indiana | 18153 | 342 | 12 |
577305 | 577305 | 2020-09-28 | Sullivan | Indiana | 18153 | 342 | 12 |
580546 | 580546 | 2020-09-29 | Sullivan | Indiana | 18153 | 342 | 12 |
583785 | 583785 | 2020-09-30 | Sullivan | Indiana | 18153 | 343 | 12 |
587025 | 587025 | 2020-10-01 | Sullivan | Indiana | 18153 | 347 | 12 |
590266 | 590266 | 2020-10-02 | Sullivan | Indiana | 18153 | 350 | 12 |
593507 | 593507 | 2020-10-03 | Sullivan | Indiana | 18153 | 350 | 12 |
596749 | 596749 | 2020-10-04 | Sullivan | Indiana | 18153 | 352 | 12 |
599991 | 599991 | 2020-10-05 | Sullivan | Indiana | 18153 | 356 | 12 |
603234 | 603234 | 2020-10-06 | Sullivan | Indiana | 18153 | 357 | 12 |
606476 | 606476 | 2020-10-07 | Sullivan | Indiana | 18153 | 358 | 12 |
609719 | 609719 | 2020-10-08 | Sullivan | Indiana | 18153 | 364 | 12 |
612961 | 612961 | 2020-10-09 | Sullivan | Indiana | 18153 | 370 | 12 |
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);