ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 48201 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28046 | 28046 | 2020-04-02 | Harris | Texas | 48201 | 895 | 10 |
25763 | 25763 | 2020-04-01 | Harris | Texas | 48201 | 847 | 6 |
23553 | 23553 | 2020-03-31 | Harris | Texas | 48201 | 680 | 6 |
21414 | 21414 | 2020-03-30 | Harris | Texas | 48201 | 563 | 7 |
19355 | 19355 | 2020-03-29 | Harris | Texas | 48201 | 526 | 4 |
17402 | 17402 | 2020-03-28 | Harris | Texas | 48201 | 445 | 3 |
15533 | 15533 | 2020-03-27 | Harris | Texas | 48201 | 229 | 2 |
13779 | 13779 | 2020-03-26 | Harris | Texas | 48201 | 203 | 2 |
12150 | 12150 | 2020-03-25 | Harris | Texas | 48201 | 185 | 1 |
10657 | 10657 | 2020-03-24 | Harris | Texas | 48201 | 134 | 1 |
9319 | 9319 | 2020-03-23 | Harris | Texas | 48201 | 78 | 1 |
8101 | 8101 | 2020-03-22 | Harris | Texas | 48201 | 74 | 1 |
6971 | 6971 | 2020-03-21 | Harris | Texas | 48201 | 68 | 1 |
5951 | 5951 | 2020-03-20 | Harris | Texas | 48201 | 55 | 1 |
5059 | 5059 | 2020-03-19 | Harris | Texas | 48201 | 35 | 1 |
4305 | 4305 | 2020-03-18 | Harris | Texas | 48201 | 28 | 0 |
3682 | 3682 | 2020-03-17 | Harris | Texas | 48201 | 16 | 0 |
3147 | 3147 | 2020-03-16 | Harris | Texas | 48201 | 13 | 0 |
2679 | 2679 | 2020-03-15 | Harris | Texas | 48201 | 13 | 0 |
2253 | 2253 | 2020-03-14 | Harris | Texas | 48201 | 11 | 0 |
1887 | 1887 | 2020-03-13 | Harris | Texas | 48201 | 10 | 0 |
1580 | 1580 | 2020-03-12 | Harris | Texas | 48201 | 9 | 0 |
1333 | 1333 | 2020-03-11 | Harris | Texas | 48201 | 7 | 0 |
1136 | 1136 | 2020-03-10 | Harris | Texas | 48201 | 7 | 0 |
977 | 977 | 2020-03-09 | Harris | Texas | 48201 | 6 | 0 |
847 | 847 | 2020-03-08 | Harris | Texas | 48201 | 6 | 0 |
735 | 735 | 2020-03-07 | Harris | Texas | 48201 | 5 | 0 |
643 | 643 | 2020-03-06 | Harris | Texas | 48201 | 5 | 0 |
574 | 574 | 2020-03-05 | Harris | Texas | 48201 | 4 | 0 |
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);