ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 1, fips = 48403 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
120892 | 120892 | 2020-05-06 | Sabine | Texas | 48403 | 1 | 0 |
117928 | 117928 | 2020-05-05 | Sabine | Texas | 48403 | 1 | 0 |
114969 | 114969 | 2020-05-04 | Sabine | Texas | 48403 | 1 | 0 |
112086 | 112086 | 2020-05-03 | Sabine | Texas | 48403 | 1 | 0 |
109212 | 109212 | 2020-05-02 | Sabine | Texas | 48403 | 1 | 0 |
106343 | 106343 | 2020-05-01 | Sabine | Texas | 48403 | 1 | 0 |
103479 | 103479 | 2020-04-30 | Sabine | Texas | 48403 | 1 | 0 |
100624 | 100624 | 2020-04-29 | Sabine | Texas | 48403 | 1 | 0 |
97774 | 97774 | 2020-04-28 | Sabine | Texas | 48403 | 1 | 0 |
94932 | 94932 | 2020-04-27 | Sabine | Texas | 48403 | 1 | 0 |
92103 | 92103 | 2020-04-26 | Sabine | Texas | 48403 | 1 | 0 |
89286 | 89286 | 2020-04-25 | Sabine | Texas | 48403 | 1 | 0 |
86471 | 86471 | 2020-04-24 | Sabine | Texas | 48403 | 1 | 0 |
83664 | 83664 | 2020-04-23 | Sabine | Texas | 48403 | 1 | 0 |
80863 | 80863 | 2020-04-22 | Sabine | Texas | 48403 | 1 | 0 |
78072 | 78072 | 2020-04-21 | Sabine | Texas | 48403 | 1 | 0 |
75290 | 75290 | 2020-04-20 | Sabine | Texas | 48403 | 1 | 0 |
72514 | 72514 | 2020-04-19 | Sabine | Texas | 48403 | 1 | 0 |
69744 | 69744 | 2020-04-18 | Sabine | Texas | 48403 | 1 | 0 |
66984 | 66984 | 2020-04-17 | Sabine | Texas | 48403 | 1 | 0 |
64237 | 64237 | 2020-04-16 | Sabine | Texas | 48403 | 1 | 0 |
61506 | 61506 | 2020-04-15 | Sabine | Texas | 48403 | 1 | 0 |
58788 | 58788 | 2020-04-14 | Sabine | Texas | 48403 | 1 | 0 |
56083 | 56083 | 2020-04-13 | Sabine | Texas | 48403 | 1 | 0 |
53394 | 53394 | 2020-04-12 | Sabine | Texas | 48403 | 1 | 0 |
50719 | 50719 | 2020-04-11 | Sabine | Texas | 48403 | 1 | 0 |
48061 | 48061 | 2020-04-10 | Sabine | Texas | 48403 | 1 | 0 |
45439 | 45439 | 2020-04-09 | Sabine | Texas | 48403 | 1 | 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);