ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,807 rows where county = "Brown" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Brown · 6,707 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
415498 | 415498 | 2020-08-09 | Brown | Illinois | 17009 | 14 | 0 |
418719 | 418719 | 2020-08-10 | Brown | Illinois | 17009 | 14 | 0 |
421942 | 421942 | 2020-08-11 | Brown | Illinois | 17009 | 15 | 0 |
425163 | 425163 | 2020-08-12 | Brown | Illinois | 17009 | 15 | 0 |
428387 | 428387 | 2020-08-13 | Brown | Illinois | 17009 | 15 | 0 |
431615 | 431615 | 2020-08-14 | Brown | Illinois | 17009 | 15 | 0 |
434840 | 434840 | 2020-08-15 | Brown | Illinois | 17009 | 15 | 0 |
438066 | 438066 | 2020-08-16 | Brown | Illinois | 17009 | 15 | 0 |
441292 | 441292 | 2020-08-17 | Brown | Illinois | 17009 | 16 | 0 |
444518 | 444518 | 2020-08-18 | Brown | Illinois | 17009 | 15 | 0 |
447745 | 447745 | 2020-08-19 | Brown | Illinois | 17009 | 15 | 0 |
450973 | 450973 | 2020-08-20 | Brown | Illinois | 17009 | 16 | 0 |
454201 | 454201 | 2020-08-21 | Brown | Illinois | 17009 | 16 | 0 |
457429 | 457429 | 2020-08-22 | Brown | Illinois | 17009 | 16 | 0 |
460656 | 460656 | 2020-08-23 | Brown | Illinois | 17009 | 16 | 0 |
463885 | 463885 | 2020-08-24 | Brown | Illinois | 17009 | 16 | 0 |
467114 | 467114 | 2020-08-25 | Brown | Illinois | 17009 | 16 | 0 |
470343 | 470343 | 2020-08-26 | Brown | Illinois | 17009 | 16 | 0 |
473575 | 473575 | 2020-08-27 | Brown | Illinois | 17009 | 18 | 0 |
476808 | 476808 | 2020-08-28 | Brown | Illinois | 17009 | 20 | 0 |
480041 | 480041 | 2020-08-29 | Brown | Illinois | 17009 | 21 | 0 |
483275 | 483275 | 2020-08-30 | Brown | Illinois | 17009 | 20 | 0 |
486510 | 486510 | 2020-08-31 | Brown | Illinois | 17009 | 20 | 0 |
489743 | 489743 | 2020-09-01 | Brown | Illinois | 17009 | 20 | 0 |
492976 | 492976 | 2020-09-02 | Brown | Illinois | 17009 | 23 | 0 |
496210 | 496210 | 2020-09-03 | Brown | Illinois | 17009 | 23 | 0 |
499443 | 499443 | 2020-09-04 | Brown | Illinois | 17009 | 24 | 0 |
502677 | 502677 | 2020-09-05 | Brown | Illinois | 17009 | 24 | 0 |
505911 | 505911 | 2020-09-06 | Brown | Illinois | 17009 | 24 | 0 |
509143 | 509143 | 2020-09-07 | Brown | Illinois | 17009 | 24 | 0 |
512376 | 512376 | 2020-09-08 | Brown | Illinois | 17009 | 25 | 0 |
515609 | 515609 | 2020-09-09 | Brown | Illinois | 17009 | 25 | 0 |
518844 | 518844 | 2020-09-10 | Brown | Illinois | 17009 | 25 | 0 |
522081 | 522081 | 2020-09-11 | Brown | Illinois | 17009 | 26 | 0 |
525317 | 525317 | 2020-09-12 | Brown | Illinois | 17009 | 26 | 0 |
528553 | 528553 | 2020-09-13 | Brown | Illinois | 17009 | 26 | 0 |
531790 | 531790 | 2020-09-14 | Brown | Illinois | 17009 | 29 | 0 |
535025 | 535025 | 2020-09-15 | Brown | Illinois | 17009 | 31 | 0 |
538261 | 538261 | 2020-09-16 | Brown | Illinois | 17009 | 30 | 0 |
541498 | 541498 | 2020-09-17 | Brown | Illinois | 17009 | 35 | 0 |
544734 | 544734 | 2020-09-18 | Brown | Illinois | 17009 | 36 | 0 |
547972 | 547972 | 2020-09-19 | Brown | Illinois | 17009 | 36 | 0 |
551211 | 551211 | 2020-09-20 | Brown | Illinois | 17009 | 37 | 0 |
554450 | 554450 | 2020-09-21 | Brown | Illinois | 17009 | 39 | 0 |
557687 | 557687 | 2020-09-22 | Brown | Illinois | 17009 | 41 | 0 |
560923 | 560923 | 2020-09-23 | Brown | Illinois | 17009 | 43 | 0 |
564163 | 564163 | 2020-09-24 | Brown | Illinois | 17009 | 45 | 0 |
567403 | 567403 | 2020-09-25 | Brown | Illinois | 17009 | 56 | 0 |
570645 | 570645 | 2020-09-26 | Brown | Illinois | 17009 | 59 | 0 |
573888 | 573888 | 2020-09-27 | Brown | Illinois | 17009 | 61 | 0 |
577130 | 577130 | 2020-09-28 | Brown | Illinois | 17009 | 62 | 0 |
580371 | 580371 | 2020-09-29 | Brown | Illinois | 17009 | 67 | 0 |
583610 | 583610 | 2020-09-30 | Brown | Illinois | 17009 | 69 | 0 |
586850 | 586850 | 2020-10-01 | Brown | Illinois | 17009 | 70 | 0 |
590091 | 590091 | 2020-10-02 | Brown | Illinois | 17009 | 70 | 0 |
593332 | 593332 | 2020-10-03 | Brown | Illinois | 17009 | 71 | 0 |
596574 | 596574 | 2020-10-04 | Brown | Illinois | 17009 | 71 | 0 |
599816 | 599816 | 2020-10-05 | Brown | Illinois | 17009 | 71 | 0 |
603059 | 603059 | 2020-10-06 | Brown | Illinois | 17009 | 72 | 0 |
606301 | 606301 | 2020-10-07 | Brown | Illinois | 17009 | 75 | 0 |
609544 | 609544 | 2020-10-08 | Brown | Illinois | 17009 | 76 | 0 |
612786 | 612786 | 2020-10-09 | Brown | Illinois | 17009 | 77 | 0 |
616027 | 616027 | 2020-10-10 | Brown | Illinois | 17009 | 78 | 0 |
619269 | 619269 | 2020-10-11 | Brown | Illinois | 17009 | 78 | 0 |
622513 | 622513 | 2020-10-12 | Brown | Illinois | 17009 | 78 | 0 |
625755 | 625755 | 2020-10-13 | Brown | Illinois | 17009 | 80 | 0 |
628998 | 628998 | 2020-10-14 | Brown | Illinois | 17009 | 82 | 0 |
632242 | 632242 | 2020-10-15 | Brown | Illinois | 17009 | 87 | 0 |
635488 | 635488 | 2020-10-16 | Brown | Illinois | 17009 | 94 | 0 |
638734 | 638734 | 2020-10-17 | Brown | Illinois | 17009 | 93 | 0 |
641981 | 641981 | 2020-10-18 | Brown | Illinois | 17009 | 96 | 0 |
645228 | 645228 | 2020-10-19 | Brown | Illinois | 17009 | 96 | 0 |
648473 | 648473 | 2020-10-20 | Brown | Illinois | 17009 | 98 | 0 |
651717 | 651717 | 2020-10-21 | Brown | Illinois | 17009 | 103 | 0 |
654962 | 654962 | 2020-10-22 | Brown | Illinois | 17009 | 103 | 0 |
658207 | 658207 | 2020-10-23 | Brown | Illinois | 17009 | 105 | 0 |
661451 | 661451 | 2020-10-24 | Brown | Illinois | 17009 | 107 | 0 |
664696 | 664696 | 2020-10-25 | Brown | Illinois | 17009 | 107 | 0 |
667940 | 667940 | 2020-10-26 | Brown | Illinois | 17009 | 111 | 0 |
671183 | 671183 | 2020-10-27 | Brown | Illinois | 17009 | 115 | 0 |
674425 | 674425 | 2020-10-28 | Brown | Illinois | 17009 | 117 | 0 |
677668 | 677668 | 2020-10-29 | Brown | Illinois | 17009 | 122 | 0 |
680911 | 680911 | 2020-10-30 | Brown | Illinois | 17009 | 121 | 0 |
684154 | 684154 | 2020-10-31 | Brown | Illinois | 17009 | 121 | 0 |
687398 | 687398 | 2020-11-01 | Brown | Illinois | 17009 | 127 | 0 |
690643 | 690643 | 2020-11-02 | Brown | Illinois | 17009 | 130 | 0 |
693886 | 693886 | 2020-11-03 | Brown | Illinois | 17009 | 133 | 0 |
697128 | 697128 | 2020-11-04 | Brown | Illinois | 17009 | 144 | 0 |
700372 | 700372 | 2020-11-05 | Brown | Illinois | 17009 | 149 | 0 |
703615 | 703615 | 2020-11-06 | Brown | Illinois | 17009 | 161 | 0 |
706858 | 706858 | 2020-11-07 | Brown | Illinois | 17009 | 171 | 0 |
710102 | 710102 | 2020-11-08 | Brown | Illinois | 17009 | 179 | 0 |
713346 | 713346 | 2020-11-09 | Brown | Illinois | 17009 | 188 | 0 |
716590 | 716590 | 2020-11-10 | Brown | Illinois | 17009 | 196 | 0 |
719833 | 719833 | 2020-11-11 | Brown | Illinois | 17009 | 199 | 0 |
723076 | 723076 | 2020-11-12 | Brown | Illinois | 17009 | 202 | 1 |
726319 | 726319 | 2020-11-13 | Brown | Illinois | 17009 | 211 | 1 |
729562 | 729562 | 2020-11-14 | Brown | Illinois | 17009 | 214 | 2 |
732807 | 732807 | 2020-11-15 | Brown | Illinois | 17009 | 218 | 3 |
736053 | 736053 | 2020-11-16 | Brown | Illinois | 17009 | 222 | 3 |
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);