ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Trinity" and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
32848 | 32848 | 2020-04-04 | Trinity | Texas | 48455 | 2 | 0 |
35286 | 35286 | 2020-04-05 | Trinity | Texas | 48455 | 2 | 0 |
37763 | 37763 | 2020-04-06 | Trinity | Texas | 48455 | 2 | 0 |
40292 | 40292 | 2020-04-07 | Trinity | Texas | 48455 | 2 | 0 |
42860 | 42860 | 2020-04-08 | Trinity | Texas | 48455 | 2 | 0 |
45454 | 45454 | 2020-04-09 | Trinity | Texas | 48455 | 3 | 0 |
48077 | 48077 | 2020-04-10 | Trinity | Texas | 48455 | 3 | 0 |
50735 | 50735 | 2020-04-11 | Trinity | Texas | 48455 | 3 | 0 |
53410 | 53410 | 2020-04-12 | Trinity | Texas | 48455 | 3 | 0 |
56099 | 56099 | 2020-04-13 | Trinity | Texas | 48455 | 3 | 0 |
58804 | 58804 | 2020-04-14 | Trinity | Texas | 48455 | 4 | 0 |
61522 | 61522 | 2020-04-15 | Trinity | Texas | 48455 | 4 | 0 |
64254 | 64254 | 2020-04-16 | Trinity | Texas | 48455 | 7 | 0 |
67001 | 67001 | 2020-04-17 | Trinity | Texas | 48455 | 7 | 0 |
69761 | 69761 | 2020-04-18 | Trinity | Texas | 48455 | 7 | 0 |
72531 | 72531 | 2020-04-19 | Trinity | Texas | 48455 | 7 | 0 |
75307 | 75307 | 2020-04-20 | Trinity | Texas | 48455 | 7 | 0 |
78089 | 78089 | 2020-04-21 | Trinity | Texas | 48455 | 7 | 0 |
80880 | 80880 | 2020-04-22 | Trinity | Texas | 48455 | 7 | 0 |
83681 | 83681 | 2020-04-23 | Trinity | Texas | 48455 | 7 | 0 |
86488 | 86488 | 2020-04-24 | Trinity | Texas | 48455 | 8 | 0 |
89303 | 89303 | 2020-04-25 | Trinity | Texas | 48455 | 8 | 0 |
92120 | 92120 | 2020-04-26 | Trinity | Texas | 48455 | 8 | 0 |
94949 | 94949 | 2020-04-27 | Trinity | Texas | 48455 | 8 | 0 |
97791 | 97791 | 2020-04-28 | Trinity | Texas | 48455 | 8 | 0 |
100641 | 100641 | 2020-04-29 | Trinity | Texas | 48455 | 8 | 0 |
103496 | 103496 | 2020-04-30 | Trinity | Texas | 48455 | 8 | 0 |
106360 | 106360 | 2020-05-01 | Trinity | Texas | 48455 | 8 | 0 |
109229 | 109229 | 2020-05-02 | Trinity | Texas | 48455 | 8 | 0 |
112103 | 112103 | 2020-05-03 | Trinity | Texas | 48455 | 8 | 0 |
114986 | 114986 | 2020-05-04 | Trinity | Texas | 48455 | 8 | 0 |
117945 | 117945 | 2020-05-05 | Trinity | Texas | 48455 | 9 | 0 |
120909 | 120909 | 2020-05-06 | Trinity | Texas | 48455 | 10 | 0 |
123889 | 123889 | 2020-05-07 | Trinity | Texas | 48455 | 10 | 0 |
126874 | 126874 | 2020-05-08 | Trinity | Texas | 48455 | 11 | 0 |
129863 | 129863 | 2020-05-09 | Trinity | Texas | 48455 | 11 | 0 |
132853 | 132853 | 2020-05-10 | Trinity | Texas | 48455 | 11 | 0 |
135844 | 135844 | 2020-05-11 | Trinity | Texas | 48455 | 11 | 0 |
138834 | 138834 | 2020-05-12 | Trinity | Texas | 48455 | 11 | 0 |
141830 | 141830 | 2020-05-13 | Trinity | Texas | 48455 | 11 | 0 |
144827 | 144827 | 2020-05-14 | Trinity | Texas | 48455 | 11 | 0 |
147831 | 147831 | 2020-05-15 | Trinity | Texas | 48455 | 11 | 0 |
150839 | 150839 | 2020-05-16 | Trinity | Texas | 48455 | 11 | 0 |
153850 | 153850 | 2020-05-17 | Trinity | Texas | 48455 | 11 | 0 |
156867 | 156867 | 2020-05-18 | Trinity | Texas | 48455 | 11 | 0 |
159891 | 159891 | 2020-05-19 | Trinity | Texas | 48455 | 11 | 0 |
162919 | 162919 | 2020-05-20 | Trinity | Texas | 48455 | 11 | 0 |
165948 | 165948 | 2020-05-21 | Trinity | Texas | 48455 | 11 | 0 |
168984 | 168984 | 2020-05-22 | Trinity | Texas | 48455 | 11 | 0 |
172024 | 172024 | 2020-05-23 | Trinity | Texas | 48455 | 13 | 0 |
175067 | 175067 | 2020-05-24 | Trinity | Texas | 48455 | 13 | 0 |
178112 | 178112 | 2020-05-25 | Trinity | Texas | 48455 | 13 | 0 |
181156 | 181156 | 2020-05-26 | Trinity | Texas | 48455 | 13 | 0 |
184207 | 184207 | 2020-05-27 | Trinity | Texas | 48455 | 13 | 0 |
187264 | 187264 | 2020-05-28 | Trinity | Texas | 48455 | 13 | 0 |
190328 | 190328 | 2020-05-29 | Trinity | Texas | 48455 | 13 | 0 |
193394 | 193394 | 2020-05-30 | Trinity | Texas | 48455 | 14 | 0 |
196464 | 196464 | 2020-05-31 | Trinity | Texas | 48455 | 15 | 0 |
199537 | 199537 | 2020-06-01 | Trinity | Texas | 48455 | 15 | 0 |
202613 | 202613 | 2020-06-02 | Trinity | Texas | 48455 | 15 | 0 |
205692 | 205692 | 2020-06-03 | Trinity | Texas | 48455 | 15 | 0 |
208774 | 208774 | 2020-06-04 | Trinity | Texas | 48455 | 20 | 0 |
211859 | 211859 | 2020-06-05 | Trinity | Texas | 48455 | 20 | 0 |
214946 | 214946 | 2020-06-06 | Trinity | Texas | 48455 | 20 | 0 |
218036 | 218036 | 2020-06-07 | Trinity | Texas | 48455 | 20 | 0 |
221128 | 221128 | 2020-06-08 | Trinity | Texas | 48455 | 20 | 0 |
224224 | 224224 | 2020-06-09 | Trinity | Texas | 48455 | 22 | 0 |
227324 | 227324 | 2020-06-10 | Trinity | Texas | 48455 | 22 | 0 |
230428 | 230428 | 2020-06-11 | Trinity | Texas | 48455 | 22 | 0 |
233532 | 233532 | 2020-06-12 | Trinity | Texas | 48455 | 22 | 0 |
236639 | 236639 | 2020-06-13 | Trinity | Texas | 48455 | 22 | 0 |
239747 | 239747 | 2020-06-14 | Trinity | Texas | 48455 | 22 | 0 |
242857 | 242857 | 2020-06-15 | Trinity | Texas | 48455 | 22 | 0 |
245969 | 245969 | 2020-06-16 | Trinity | Texas | 48455 | 17 | 0 |
249082 | 249082 | 2020-06-17 | Trinity | Texas | 48455 | 20 | 0 |
252197 | 252197 | 2020-06-18 | Trinity | Texas | 48455 | 21 | 0 |
255313 | 255313 | 2020-06-19 | Trinity | Texas | 48455 | 21 | 0 |
258440 | 258440 | 2020-06-20 | Trinity | Texas | 48455 | 22 | 0 |
261567 | 261567 | 2020-06-21 | Trinity | Texas | 48455 | 23 | 0 |
264696 | 264696 | 2020-06-22 | Trinity | Texas | 48455 | 23 | 0 |
267825 | 267825 | 2020-06-23 | Trinity | Texas | 48455 | 24 | 0 |
270959 | 270959 | 2020-06-24 | Trinity | Texas | 48455 | 26 | 0 |
274099 | 274099 | 2020-06-25 | Trinity | Texas | 48455 | 28 | 0 |
277247 | 277247 | 2020-06-26 | Trinity | Texas | 48455 | 28 | 0 |
280395 | 280395 | 2020-06-27 | Trinity | Texas | 48455 | 32 | 0 |
283541 | 283541 | 2020-06-28 | Trinity | Texas | 48455 | 32 | 0 |
286687 | 286687 | 2020-06-29 | Trinity | Texas | 48455 | 32 | 0 |
289837 | 289837 | 2020-06-30 | Trinity | Texas | 48455 | 32 | 0 |
292990 | 292990 | 2020-07-01 | Trinity | Texas | 48455 | 36 | 0 |
296145 | 296145 | 2020-07-02 | Trinity | Texas | 48455 | 39 | 0 |
299307 | 299307 | 2020-07-03 | Trinity | Texas | 48455 | 42 | 0 |
302471 | 302471 | 2020-07-04 | Trinity | Texas | 48455 | 44 | 0 |
305635 | 305635 | 2020-07-05 | Trinity | Texas | 48455 | 48 | 0 |
308803 | 308803 | 2020-07-06 | Trinity | Texas | 48455 | 48 | 0 |
311972 | 311972 | 2020-07-07 | Trinity | Texas | 48455 | 48 | 0 |
315146 | 315146 | 2020-07-08 | Trinity | Texas | 48455 | 48 | 0 |
318319 | 318319 | 2020-07-09 | Trinity | Texas | 48455 | 52 | 0 |
321498 | 321498 | 2020-07-10 | Trinity | Texas | 48455 | 56 | 0 |
324679 | 324679 | 2020-07-11 | Trinity | Texas | 48455 | 60 | 0 |
327864 | 327864 | 2020-07-12 | Trinity | Texas | 48455 | 69 | 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);