ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Brown" and deaths = 8 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 4
- Indiana 24
- Illinois 10
- South Dakota 6
- Texas 3
county 1
- Brown · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
882201 | 882201 | 2020-12-31 | Brown | Indiana | 18013 | 739 | 8 |
878956 | 878956 | 2020-12-30 | Brown | Indiana | 18013 | 728 | 8 |
875711 | 875711 | 2020-12-29 | Brown | Indiana | 18013 | 702 | 8 |
872466 | 872466 | 2020-12-28 | Brown | Indiana | 18013 | 693 | 8 |
869221 | 869221 | 2020-12-27 | Brown | Indiana | 18013 | 681 | 8 |
865976 | 865976 | 2020-12-26 | Brown | Indiana | 18013 | 679 | 8 |
862731 | 862731 | 2020-12-25 | Brown | Indiana | 18013 | 667 | 8 |
859486 | 859486 | 2020-12-24 | Brown | Indiana | 18013 | 658 | 8 |
856241 | 856241 | 2020-12-23 | Brown | Indiana | 18013 | 650 | 8 |
852996 | 852996 | 2020-12-22 | Brown | Indiana | 18013 | 632 | 8 |
849751 | 849751 | 2020-12-21 | Brown | Indiana | 18013 | 617 | 8 |
846506 | 846506 | 2020-12-20 | Brown | Indiana | 18013 | 613 | 8 |
843260 | 843260 | 2020-12-19 | Brown | Indiana | 18013 | 602 | 8 |
839911 | 839911 | 2020-12-18 | Brown | Illinois | 17009 | 403 | 8 |
840015 | 840015 | 2020-12-18 | Brown | Indiana | 18013 | 594 | 8 |
836666 | 836666 | 2020-12-17 | Brown | Illinois | 17009 | 395 | 8 |
836770 | 836770 | 2020-12-17 | Brown | Indiana | 18013 | 574 | 8 |
833420 | 833420 | 2020-12-16 | Brown | Illinois | 17009 | 393 | 8 |
833524 | 833524 | 2020-12-16 | Brown | Indiana | 18013 | 556 | 8 |
830173 | 830173 | 2020-12-15 | Brown | Illinois | 17009 | 388 | 8 |
830277 | 830277 | 2020-12-15 | Brown | Indiana | 18013 | 552 | 8 |
826927 | 826927 | 2020-12-14 | Brown | Illinois | 17009 | 383 | 8 |
827031 | 827031 | 2020-12-14 | Brown | Indiana | 18013 | 534 | 8 |
823680 | 823680 | 2020-12-13 | Brown | Illinois | 17009 | 381 | 8 |
823784 | 823784 | 2020-12-13 | Brown | Indiana | 18013 | 533 | 8 |
820434 | 820434 | 2020-12-12 | Brown | Illinois | 17009 | 379 | 8 |
820538 | 820538 | 2020-12-12 | Brown | Indiana | 18013 | 528 | 8 |
817188 | 817188 | 2020-12-11 | Brown | Illinois | 17009 | 379 | 8 |
817292 | 817292 | 2020-12-11 | Brown | Indiana | 18013 | 498 | 8 |
813942 | 813942 | 2020-12-10 | Brown | Illinois | 17009 | 372 | 8 |
814046 | 814046 | 2020-12-10 | Brown | Indiana | 18013 | 493 | 8 |
810697 | 810697 | 2020-12-09 | Brown | Illinois | 17009 | 367 | 8 |
810801 | 810801 | 2020-12-09 | Brown | Indiana | 18013 | 485 | 8 |
807556 | 807556 | 2020-12-08 | Brown | Indiana | 18013 | 483 | 8 |
728179 | 728179 | 2020-11-13 | Brown | South Dakota | 46013 | 2766 | 8 |
724935 | 724935 | 2020-11-12 | Brown | South Dakota | 46013 | 2720 | 8 |
721692 | 721692 | 2020-11-11 | Brown | South Dakota | 46013 | 2644 | 8 |
718449 | 718449 | 2020-11-10 | Brown | South Dakota | 46013 | 2613 | 8 |
715206 | 715206 | 2020-11-09 | Brown | South Dakota | 46013 | 2585 | 8 |
711962 | 711962 | 2020-11-08 | Brown | South Dakota | 46013 | 2556 | 8 |
177932 | 177932 | 2020-05-25 | Brown | Texas | 48049 | 56 | 8 |
174888 | 174888 | 2020-05-24 | Brown | Texas | 48049 | 56 | 8 |
171845 | 171845 | 2020-05-23 | Brown | Texas | 48049 | 56 | 8 |
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);