ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 4, fips = 48503 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
208797 | 208797 | 2020-06-04 | Young | Texas | 48503 | 4 | 1 |
205715 | 205715 | 2020-06-03 | Young | Texas | 48503 | 4 | 1 |
202636 | 202636 | 2020-06-02 | Young | Texas | 48503 | 4 | 1 |
199560 | 199560 | 2020-06-01 | Young | Texas | 48503 | 4 | 1 |
196487 | 196487 | 2020-05-31 | Young | Texas | 48503 | 4 | 1 |
193417 | 193417 | 2020-05-30 | Young | Texas | 48503 | 4 | 1 |
190351 | 190351 | 2020-05-29 | Young | Texas | 48503 | 4 | 1 |
187287 | 187287 | 2020-05-28 | Young | Texas | 48503 | 4 | 1 |
184230 | 184230 | 2020-05-27 | Young | Texas | 48503 | 4 | 1 |
181179 | 181179 | 2020-05-26 | Young | Texas | 48503 | 4 | 1 |
178135 | 178135 | 2020-05-25 | Young | Texas | 48503 | 4 | 1 |
175090 | 175090 | 2020-05-24 | Young | Texas | 48503 | 4 | 1 |
172047 | 172047 | 2020-05-23 | Young | Texas | 48503 | 4 | 1 |
169006 | 169006 | 2020-05-22 | Young | Texas | 48503 | 4 | 1 |
165970 | 165970 | 2020-05-21 | Young | Texas | 48503 | 4 | 1 |
162941 | 162941 | 2020-05-20 | Young | Texas | 48503 | 4 | 1 |
159913 | 159913 | 2020-05-19 | Young | Texas | 48503 | 4 | 1 |
156889 | 156889 | 2020-05-18 | Young | Texas | 48503 | 4 | 1 |
153872 | 153872 | 2020-05-17 | Young | Texas | 48503 | 4 | 1 |
150861 | 150861 | 2020-05-16 | Young | Texas | 48503 | 4 | 1 |
147853 | 147853 | 2020-05-15 | Young | Texas | 48503 | 4 | 1 |
144849 | 144849 | 2020-05-14 | Young | Texas | 48503 | 4 | 1 |
141852 | 141852 | 2020-05-13 | Young | Texas | 48503 | 4 | 1 |
138856 | 138856 | 2020-05-12 | Young | Texas | 48503 | 4 | 1 |
135866 | 135866 | 2020-05-11 | Young | Texas | 48503 | 4 | 1 |
132875 | 132875 | 2020-05-10 | Young | Texas | 48503 | 4 | 1 |
129885 | 129885 | 2020-05-09 | Young | Texas | 48503 | 4 | 1 |
126896 | 126896 | 2020-05-08 | Young | Texas | 48503 | 4 | 1 |
123911 | 123911 | 2020-05-07 | Young | Texas | 48503 | 4 | 1 |
120931 | 120931 | 2020-05-06 | Young | Texas | 48503 | 4 | 1 |
117967 | 117967 | 2020-05-05 | Young | Texas | 48503 | 4 | 1 |
115008 | 115008 | 2020-05-04 | Young | Texas | 48503 | 4 | 1 |
112125 | 112125 | 2020-05-03 | Young | Texas | 48503 | 4 | 1 |
109251 | 109251 | 2020-05-02 | Young | Texas | 48503 | 4 | 1 |
106382 | 106382 | 2020-05-01 | Young | Texas | 48503 | 4 | 1 |
103518 | 103518 | 2020-04-30 | Young | Texas | 48503 | 4 | 1 |
100663 | 100663 | 2020-04-29 | Young | Texas | 48503 | 4 | 1 |
97813 | 97813 | 2020-04-28 | Young | Texas | 48503 | 4 | 1 |
94971 | 94971 | 2020-04-27 | Young | Texas | 48503 | 4 | 1 |
92142 | 92142 | 2020-04-26 | Young | Texas | 48503 | 4 | 1 |
89325 | 89325 | 2020-04-25 | Young | Texas | 48503 | 4 | 1 |
86510 | 86510 | 2020-04-24 | Young | Texas | 48503 | 4 | 1 |
83703 | 83703 | 2020-04-23 | Young | Texas | 48503 | 4 | 1 |
80902 | 80902 | 2020-04-22 | Young | Texas | 48503 | 4 | 1 |
78110 | 78110 | 2020-04-21 | Young | Texas | 48503 | 4 | 1 |
75328 | 75328 | 2020-04-20 | Young | Texas | 48503 | 4 | 1 |
72552 | 72552 | 2020-04-19 | Young | Texas | 48503 | 4 | 1 |
69782 | 69782 | 2020-04-18 | Young | Texas | 48503 | 4 | 1 |
67021 | 67021 | 2020-04-17 | Young | Texas | 48503 | 4 | 1 |
64274 | 64274 | 2020-04-16 | Young | Texas | 48503 | 4 | 1 |
61542 | 61542 | 2020-04-15 | Young | Texas | 48503 | 4 | 1 |
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);