ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 48329 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324618 | 324618 | 2020-07-11 | Midland | Texas | 48329 | 1104 | 19 |
321437 | 321437 | 2020-07-10 | Midland | Texas | 48329 | 1104 | 19 |
318258 | 318258 | 2020-07-09 | Midland | Texas | 48329 | 1070 | 19 |
315085 | 315085 | 2020-07-08 | Midland | Texas | 48329 | 1020 | 19 |
311911 | 311911 | 2020-07-07 | Midland | Texas | 48329 | 976 | 19 |
308742 | 308742 | 2020-07-06 | Midland | Texas | 48329 | 927 | 17 |
305574 | 305574 | 2020-07-05 | Midland | Texas | 48329 | 772 | 15 |
302410 | 302410 | 2020-07-04 | Midland | Texas | 48329 | 772 | 15 |
299246 | 299246 | 2020-07-03 | Midland | Texas | 48329 | 772 | 15 |
296085 | 296085 | 2020-07-02 | Midland | Texas | 48329 | 772 | 15 |
292930 | 292930 | 2020-07-01 | Midland | Texas | 48329 | 734 | 15 |
289777 | 289777 | 2020-06-30 | Midland | Texas | 48329 | 701 | 15 |
286627 | 286627 | 2020-06-29 | Midland | Texas | 48329 | 651 | 14 |
283481 | 283481 | 2020-06-28 | Midland | Texas | 48329 | 563 | 14 |
280335 | 280335 | 2020-06-27 | Midland | Texas | 48329 | 563 | 14 |
277187 | 277187 | 2020-06-26 | Midland | Texas | 48329 | 563 | 14 |
274039 | 274039 | 2020-06-25 | Midland | Texas | 48329 | 494 | 14 |
270899 | 270899 | 2020-06-24 | Midland | Texas | 48329 | 494 | 14 |
267765 | 267765 | 2020-06-23 | Midland | Texas | 48329 | 454 | 14 |
264637 | 264637 | 2020-06-22 | Midland | Texas | 48329 | 417 | 13 |
261508 | 261508 | 2020-06-21 | Midland | Texas | 48329 | 322 | 13 |
258381 | 258381 | 2020-06-20 | Midland | Texas | 48329 | 322 | 13 |
255254 | 255254 | 2020-06-19 | Midland | Texas | 48329 | 322 | 13 |
252139 | 252139 | 2020-06-18 | Midland | Texas | 48329 | 264 | 13 |
249024 | 249024 | 2020-06-17 | Midland | Texas | 48329 | 264 | 13 |
245911 | 245911 | 2020-06-16 | Midland | Texas | 48329 | 222 | 13 |
242799 | 242799 | 2020-06-15 | Midland | Texas | 48329 | 222 | 13 |
239689 | 239689 | 2020-06-14 | Midland | Texas | 48329 | 201 | 13 |
236581 | 236581 | 2020-06-13 | Midland | Texas | 48329 | 201 | 13 |
233475 | 233475 | 2020-06-12 | Midland | Texas | 48329 | 201 | 13 |
230371 | 230371 | 2020-06-11 | Midland | Texas | 48329 | 194 | 13 |
227267 | 227267 | 2020-06-10 | Midland | Texas | 48329 | 180 | 13 |
224167 | 224167 | 2020-06-09 | Midland | Texas | 48329 | 177 | 13 |
221072 | 221072 | 2020-06-08 | Midland | Texas | 48329 | 155 | 13 |
217980 | 217980 | 2020-06-07 | Midland | Texas | 48329 | 155 | 13 |
214890 | 214890 | 2020-06-06 | Midland | Texas | 48329 | 155 | 13 |
211803 | 211803 | 2020-06-05 | Midland | Texas | 48329 | 155 | 13 |
208719 | 208719 | 2020-06-04 | Midland | Texas | 48329 | 143 | 13 |
205637 | 205637 | 2020-06-03 | Midland | Texas | 48329 | 141 | 13 |
202558 | 202558 | 2020-06-02 | Midland | Texas | 48329 | 137 | 13 |
199482 | 199482 | 2020-06-01 | Midland | Texas | 48329 | 132 | 12 |
196409 | 196409 | 2020-05-31 | Midland | Texas | 48329 | 129 | 12 |
193339 | 193339 | 2020-05-30 | Midland | Texas | 48329 | 129 | 12 |
190273 | 190273 | 2020-05-29 | Midland | Texas | 48329 | 128 | 12 |
187209 | 187209 | 2020-05-28 | Midland | Texas | 48329 | 128 | 12 |
184152 | 184152 | 2020-05-27 | Midland | Texas | 48329 | 126 | 12 |
181102 | 181102 | 2020-05-26 | Midland | Texas | 48329 | 125 | 12 |
178058 | 178058 | 2020-05-25 | Midland | Texas | 48329 | 124 | 12 |
175014 | 175014 | 2020-05-24 | Midland | Texas | 48329 | 124 | 12 |
171971 | 171971 | 2020-05-23 | Midland | Texas | 48329 | 124 | 12 |
168931 | 168931 | 2020-05-22 | Midland | Texas | 48329 | 124 | 12 |
165895 | 165895 | 2020-05-21 | Midland | Texas | 48329 | 123 | 12 |
162866 | 162866 | 2020-05-20 | Midland | Texas | 48329 | 123 | 12 |
159838 | 159838 | 2020-05-19 | Midland | Texas | 48329 | 122 | 12 |
156816 | 156816 | 2020-05-18 | Midland | Texas | 48329 | 122 | 12 |
153799 | 153799 | 2020-05-17 | Midland | Texas | 48329 | 120 | 12 |
150788 | 150788 | 2020-05-16 | Midland | Texas | 48329 | 120 | 12 |
147780 | 147780 | 2020-05-15 | Midland | Texas | 48329 | 116 | 12 |
144776 | 144776 | 2020-05-14 | Midland | Texas | 48329 | 116 | 12 |
141779 | 141779 | 2020-05-13 | Midland | Texas | 48329 | 115 | 12 |
138783 | 138783 | 2020-05-12 | Midland | Texas | 48329 | 107 | 12 |
135793 | 135793 | 2020-05-11 | Midland | Texas | 48329 | 101 | 12 |
132802 | 132802 | 2020-05-10 | Midland | Texas | 48329 | 101 | 11 |
129812 | 129812 | 2020-05-09 | Midland | Texas | 48329 | 101 | 11 |
126823 | 126823 | 2020-05-08 | Midland | Texas | 48329 | 100 | 11 |
123839 | 123839 | 2020-05-07 | Midland | Texas | 48329 | 100 | 10 |
120860 | 120860 | 2020-05-06 | Midland | Texas | 48329 | 91 | 8 |
117896 | 117896 | 2020-05-05 | Midland | Texas | 48329 | 91 | 8 |
114937 | 114937 | 2020-05-04 | Midland | Texas | 48329 | 89 | 8 |
112055 | 112055 | 2020-05-03 | Midland | Texas | 48329 | 82 | 6 |
109181 | 109181 | 2020-05-02 | Midland | Texas | 48329 | 82 | 6 |
106312 | 106312 | 2020-05-01 | Midland | Texas | 48329 | 82 | 6 |
103448 | 103448 | 2020-04-30 | Midland | Texas | 48329 | 79 | 6 |
100593 | 100593 | 2020-04-29 | Midland | Texas | 48329 | 76 | 6 |
97743 | 97743 | 2020-04-28 | Midland | Texas | 48329 | 75 | 6 |
94902 | 94902 | 2020-04-27 | Midland | Texas | 48329 | 74 | 5 |
92073 | 92073 | 2020-04-26 | Midland | Texas | 48329 | 73 | 5 |
89256 | 89256 | 2020-04-25 | Midland | Texas | 48329 | 71 | 5 |
86441 | 86441 | 2020-04-24 | Midland | Texas | 48329 | 70 | 5 |
83636 | 83636 | 2020-04-23 | Midland | Texas | 48329 | 69 | 5 |
80835 | 80835 | 2020-04-22 | Midland | Texas | 48329 | 67 | 4 |
78044 | 78044 | 2020-04-21 | Midland | Texas | 48329 | 65 | 4 |
75262 | 75262 | 2020-04-20 | Midland | Texas | 48329 | 64 | 3 |
72486 | 72486 | 2020-04-19 | Midland | Texas | 48329 | 43 | 3 |
69717 | 69717 | 2020-04-18 | Midland | Texas | 48329 | 42 | 3 |
66957 | 66957 | 2020-04-17 | Midland | Texas | 48329 | 42 | 3 |
64210 | 64210 | 2020-04-16 | Midland | Texas | 48329 | 39 | 2 |
61481 | 61481 | 2020-04-15 | Midland | Texas | 48329 | 35 | 2 |
58763 | 58763 | 2020-04-14 | Midland | Texas | 48329 | 35 | 2 |
56058 | 56058 | 2020-04-13 | Midland | Texas | 48329 | 32 | 2 |
53370 | 53370 | 2020-04-12 | Midland | Texas | 48329 | 32 | 2 |
50695 | 50695 | 2020-04-11 | Midland | Texas | 48329 | 31 | 1 |
48037 | 48037 | 2020-04-10 | Midland | Texas | 48329 | 31 | 1 |
45416 | 45416 | 2020-04-09 | Midland | Texas | 48329 | 30 | 1 |
42824 | 42824 | 2020-04-08 | Midland | Texas | 48329 | 30 | 1 |
40256 | 40256 | 2020-04-07 | Midland | Texas | 48329 | 27 | 1 |
37728 | 37728 | 2020-04-06 | Midland | Texas | 48329 | 27 | 1 |
35252 | 35252 | 2020-04-05 | Midland | Texas | 48329 | 24 | 1 |
32814 | 32814 | 2020-04-04 | Midland | Texas | 48329 | 22 | 1 |
30418 | 30418 | 2020-04-03 | Midland | Texas | 48329 | 19 | 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);