ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48103 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324509 | 324509 | 2020-07-11 | Crane | Texas | 48103 | 64 | 9 |
321328 | 321328 | 2020-07-10 | Crane | Texas | 48103 | 63 | 9 |
318150 | 318150 | 2020-07-09 | Crane | Texas | 48103 | 62 | 9 |
314977 | 314977 | 2020-07-08 | Crane | Texas | 48103 | 62 | 9 |
311803 | 311803 | 2020-07-07 | Crane | Texas | 48103 | 61 | 9 |
308634 | 308634 | 2020-07-06 | Crane | Texas | 48103 | 60 | 9 |
305466 | 305466 | 2020-07-05 | Crane | Texas | 48103 | 60 | 9 |
302302 | 302302 | 2020-07-04 | Crane | Texas | 48103 | 60 | 9 |
299138 | 299138 | 2020-07-03 | Crane | Texas | 48103 | 58 | 9 |
295978 | 295978 | 2020-07-02 | Crane | Texas | 48103 | 57 | 9 |
292823 | 292823 | 2020-07-01 | Crane | Texas | 48103 | 57 | 9 |
289670 | 289670 | 2020-06-30 | Crane | Texas | 48103 | 54 | 8 |
286520 | 286520 | 2020-06-29 | Crane | Texas | 48103 | 50 | 8 |
283374 | 283374 | 2020-06-28 | Crane | Texas | 48103 | 50 | 8 |
280228 | 280228 | 2020-06-27 | Crane | Texas | 48103 | 50 | 8 |
277080 | 277080 | 2020-06-26 | Crane | Texas | 48103 | 50 | 7 |
273933 | 273933 | 2020-06-25 | Crane | Texas | 48103 | 49 | 7 |
270794 | 270794 | 2020-06-24 | Crane | Texas | 48103 | 48 | 6 |
267660 | 267660 | 2020-06-23 | Crane | Texas | 48103 | 47 | 6 |
264532 | 264532 | 2020-06-22 | Crane | Texas | 48103 | 47 | 5 |
261404 | 261404 | 2020-06-21 | Crane | Texas | 48103 | 46 | 5 |
258277 | 258277 | 2020-06-20 | Crane | Texas | 48103 | 46 | 5 |
255151 | 255151 | 2020-06-19 | Crane | Texas | 48103 | 45 | 5 |
252036 | 252036 | 2020-06-18 | Crane | Texas | 48103 | 45 | 5 |
248921 | 248921 | 2020-06-17 | Crane | Texas | 48103 | 39 | 5 |
245808 | 245808 | 2020-06-16 | Crane | Texas | 48103 | 39 | 5 |
242696 | 242696 | 2020-06-15 | Crane | Texas | 48103 | 32 | 5 |
239586 | 239586 | 2020-06-14 | Crane | Texas | 48103 | 32 | 5 |
236478 | 236478 | 2020-06-13 | Crane | Texas | 48103 | 32 | 5 |
233372 | 233372 | 2020-06-12 | Crane | Texas | 48103 | 32 | 5 |
230268 | 230268 | 2020-06-11 | Crane | Texas | 48103 | 32 | 5 |
227164 | 227164 | 2020-06-10 | Crane | Texas | 48103 | 31 | 5 |
224064 | 224064 | 2020-06-09 | Crane | Texas | 48103 | 28 | 5 |
220969 | 220969 | 2020-06-08 | Crane | Texas | 48103 | 27 | 5 |
217877 | 217877 | 2020-06-07 | Crane | Texas | 48103 | 27 | 5 |
214787 | 214787 | 2020-06-06 | Crane | Texas | 48103 | 27 | 5 |
211700 | 211700 | 2020-06-05 | Crane | Texas | 48103 | 26 | 5 |
208617 | 208617 | 2020-06-04 | Crane | Texas | 48103 | 25 | 5 |
205535 | 205535 | 2020-06-03 | Crane | Texas | 48103 | 25 | 5 |
202456 | 202456 | 2020-06-02 | Crane | Texas | 48103 | 25 | 5 |
199381 | 199381 | 2020-06-01 | Crane | Texas | 48103 | 23 | 2 |
196308 | 196308 | 2020-05-31 | Crane | Texas | 48103 | 23 | 2 |
193238 | 193238 | 2020-05-30 | Crane | Texas | 48103 | 23 | 2 |
190173 | 190173 | 2020-05-29 | Crane | Texas | 48103 | 22 | 2 |
187109 | 187109 | 2020-05-28 | Crane | Texas | 48103 | 22 | 2 |
184052 | 184052 | 2020-05-27 | Crane | Texas | 48103 | 22 | 1 |
181002 | 181002 | 2020-05-26 | Crane | Texas | 48103 | 22 | 0 |
177959 | 177959 | 2020-05-25 | Crane | Texas | 48103 | 22 | 0 |
174915 | 174915 | 2020-05-24 | Crane | Texas | 48103 | 7 | 0 |
171872 | 171872 | 2020-05-23 | Crane | Texas | 48103 | 7 | 0 |
168833 | 168833 | 2020-05-22 | Crane | Texas | 48103 | 3 | 0 |
165797 | 165797 | 2020-05-21 | Crane | Texas | 48103 | 3 | 0 |
162768 | 162768 | 2020-05-20 | Crane | Texas | 48103 | 2 | 0 |
159741 | 159741 | 2020-05-19 | Crane | Texas | 48103 | 2 | 0 |
156719 | 156719 | 2020-05-18 | Crane | Texas | 48103 | 2 | 0 |
153702 | 153702 | 2020-05-17 | Crane | Texas | 48103 | 2 | 0 |
150691 | 150691 | 2020-05-16 | Crane | Texas | 48103 | 2 | 0 |
147683 | 147683 | 2020-05-15 | Crane | Texas | 48103 | 2 | 0 |
144681 | 144681 | 2020-05-14 | Crane | Texas | 48103 | 2 | 0 |
141684 | 141684 | 2020-05-13 | Crane | Texas | 48103 | 2 | 0 |
138688 | 138688 | 2020-05-12 | Crane | Texas | 48103 | 2 | 0 |
135698 | 135698 | 2020-05-11 | Crane | Texas | 48103 | 2 | 0 |
132707 | 132707 | 2020-05-10 | Crane | Texas | 48103 | 2 | 0 |
129717 | 129717 | 2020-05-09 | Crane | Texas | 48103 | 2 | 0 |
126728 | 126728 | 2020-05-08 | Crane | Texas | 48103 | 2 | 0 |
123745 | 123745 | 2020-05-07 | Crane | Texas | 48103 | 2 | 0 |
120766 | 120766 | 2020-05-06 | Crane | Texas | 48103 | 2 | 0 |
117802 | 117802 | 2020-05-05 | Crane | Texas | 48103 | 2 | 0 |
114843 | 114843 | 2020-05-04 | Crane | Texas | 48103 | 2 | 0 |
111961 | 111961 | 2020-05-03 | Crane | Texas | 48103 | 2 | 0 |
109087 | 109087 | 2020-05-02 | Crane | Texas | 48103 | 2 | 0 |
106218 | 106218 | 2020-05-01 | Crane | Texas | 48103 | 2 | 0 |
103354 | 103354 | 2020-04-30 | Crane | Texas | 48103 | 2 | 0 |
100501 | 100501 | 2020-04-29 | Crane | Texas | 48103 | 2 | 0 |
97651 | 97651 | 2020-04-28 | Crane | Texas | 48103 | 2 | 0 |
94811 | 94811 | 2020-04-27 | Crane | Texas | 48103 | 2 | 0 |
91982 | 91982 | 2020-04-26 | Crane | Texas | 48103 | 2 | 0 |
89165 | 89165 | 2020-04-25 | Crane | Texas | 48103 | 2 | 0 |
86350 | 86350 | 2020-04-24 | Crane | Texas | 48103 | 2 | 0 |
83545 | 83545 | 2020-04-23 | Crane | Texas | 48103 | 2 | 0 |
80745 | 80745 | 2020-04-22 | Crane | Texas | 48103 | 2 | 0 |
77954 | 77954 | 2020-04-21 | Crane | Texas | 48103 | 2 | 0 |
75172 | 75172 | 2020-04-20 | Crane | Texas | 48103 | 2 | 0 |
72397 | 72397 | 2020-04-19 | Crane | Texas | 48103 | 2 | 0 |
69629 | 69629 | 2020-04-18 | Crane | Texas | 48103 | 2 | 0 |
66869 | 66869 | 2020-04-17 | Crane | Texas | 48103 | 2 | 0 |
64122 | 64122 | 2020-04-16 | Crane | Texas | 48103 | 2 | 0 |
61395 | 61395 | 2020-04-15 | Crane | Texas | 48103 | 2 | 0 |
58678 | 58678 | 2020-04-14 | Crane | Texas | 48103 | 2 | 0 |
55974 | 55974 | 2020-04-13 | Crane | Texas | 48103 | 2 | 0 |
53286 | 53286 | 2020-04-12 | Crane | Texas | 48103 | 2 | 0 |
50611 | 50611 | 2020-04-11 | Crane | Texas | 48103 | 2 | 0 |
47954 | 47954 | 2020-04-10 | Crane | Texas | 48103 | 2 | 0 |
45334 | 45334 | 2020-04-09 | Crane | Texas | 48103 | 2 | 0 |
42745 | 42745 | 2020-04-08 | Crane | Texas | 48103 | 2 | 0 |
40182 | 40182 | 2020-04-07 | Crane | Texas | 48103 | 2 | 0 |
37659 | 37659 | 2020-04-06 | Crane | Texas | 48103 | 2 | 0 |
35183 | 35183 | 2020-04-05 | Crane | Texas | 48103 | 2 | 0 |
32745 | 32745 | 2020-04-04 | Crane | Texas | 48103 | 2 | 0 |
30352 | 30352 | 2020-04-03 | Crane | Texas | 48103 | 2 | 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);