ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jackson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388654 | 388654 | 2020-07-31 | Jackson | Texas | 48239 | 319 | 4 |
385437 | 385437 | 2020-07-30 | Jackson | Texas | 48239 | 319 | 4 |
382219 | 382219 | 2020-07-29 | Jackson | Texas | 48239 | 272 | 3 |
379002 | 379002 | 2020-07-28 | Jackson | Texas | 48239 | 251 | 3 |
375786 | 375786 | 2020-07-27 | Jackson | Texas | 48239 | 202 | 3 |
372573 | 372573 | 2020-07-26 | Jackson | Texas | 48239 | 202 | 1 |
369361 | 369361 | 2020-07-25 | Jackson | Texas | 48239 | 202 | 1 |
366152 | 366152 | 2020-07-24 | Jackson | Texas | 48239 | 194 | 1 |
362946 | 362946 | 2020-07-23 | Jackson | Texas | 48239 | 171 | 1 |
359739 | 359739 | 2020-07-22 | Jackson | Texas | 48239 | 159 | 1 |
356534 | 356534 | 2020-07-21 | Jackson | Texas | 48239 | 150 | 1 |
353331 | 353331 | 2020-07-20 | Jackson | Texas | 48239 | 147 | 1 |
350129 | 350129 | 2020-07-19 | Jackson | Texas | 48239 | 147 | 1 |
346929 | 346929 | 2020-07-18 | Jackson | Texas | 48239 | 174 | 1 |
343729 | 343729 | 2020-07-17 | Jackson | Texas | 48239 | 130 | 1 |
340530 | 340530 | 2020-07-16 | Jackson | Texas | 48239 | 121 | 1 |
337334 | 337334 | 2020-07-15 | Jackson | Texas | 48239 | 97 | 1 |
334139 | 334139 | 2020-07-14 | Jackson | Texas | 48239 | 90 | 1 |
330948 | 330948 | 2020-07-13 | Jackson | Texas | 48239 | 89 | 1 |
327762 | 327762 | 2020-07-12 | Jackson | Texas | 48239 | 89 | 1 |
324577 | 324577 | 2020-07-11 | Jackson | Texas | 48239 | 89 | 1 |
321396 | 321396 | 2020-07-10 | Jackson | Texas | 48239 | 79 | 1 |
318217 | 318217 | 2020-07-09 | Jackson | Texas | 48239 | 73 | 1 |
315044 | 315044 | 2020-07-08 | Jackson | Texas | 48239 | 68 | 1 |
311870 | 311870 | 2020-07-07 | Jackson | Texas | 48239 | 68 | 1 |
308701 | 308701 | 2020-07-06 | Jackson | Texas | 48239 | 53 | 1 |
305533 | 305533 | 2020-07-05 | Jackson | Texas | 48239 | 53 | 1 |
302369 | 302369 | 2020-07-04 | Jackson | Texas | 48239 | 53 | 1 |
299205 | 299205 | 2020-07-03 | Jackson | Texas | 48239 | 47 | 1 |
296045 | 296045 | 2020-07-02 | Jackson | Texas | 48239 | 47 | 1 |
292890 | 292890 | 2020-07-01 | Jackson | Texas | 48239 | 47 | 1 |
289737 | 289737 | 2020-06-30 | Jackson | Texas | 48239 | 41 | 1 |
286587 | 286587 | 2020-06-29 | Jackson | Texas | 48239 | 40 | 1 |
283441 | 283441 | 2020-06-28 | Jackson | Texas | 48239 | 40 | 1 |
280295 | 280295 | 2020-06-27 | Jackson | Texas | 48239 | 39 | 1 |
277147 | 277147 | 2020-06-26 | Jackson | Texas | 48239 | 39 | 1 |
274000 | 274000 | 2020-06-25 | Jackson | Texas | 48239 | 36 | 1 |
270860 | 270860 | 2020-06-24 | Jackson | Texas | 48239 | 27 | 1 |
267726 | 267726 | 2020-06-23 | Jackson | Texas | 48239 | 27 | 1 |
264598 | 264598 | 2020-06-22 | Jackson | Texas | 48239 | 25 | 1 |
261470 | 261470 | 2020-06-21 | Jackson | Texas | 48239 | 25 | 1 |
258343 | 258343 | 2020-06-20 | Jackson | Texas | 48239 | 25 | 1 |
255216 | 255216 | 2020-06-19 | Jackson | Texas | 48239 | 24 | 1 |
252101 | 252101 | 2020-06-18 | Jackson | Texas | 48239 | 21 | 1 |
248986 | 248986 | 2020-06-17 | Jackson | Texas | 48239 | 21 | 1 |
245873 | 245873 | 2020-06-16 | Jackson | Texas | 48239 | 21 | 1 |
242761 | 242761 | 2020-06-15 | Jackson | Texas | 48239 | 21 | 1 |
239651 | 239651 | 2020-06-14 | Jackson | Texas | 48239 | 21 | 1 |
236543 | 236543 | 2020-06-13 | Jackson | Texas | 48239 | 20 | 1 |
233437 | 233437 | 2020-06-12 | Jackson | Texas | 48239 | 20 | 1 |
230333 | 230333 | 2020-06-11 | Jackson | Texas | 48239 | 20 | 1 |
227229 | 227229 | 2020-06-10 | Jackson | Texas | 48239 | 19 | 1 |
224129 | 224129 | 2020-06-09 | Jackson | Texas | 48239 | 19 | 1 |
221034 | 221034 | 2020-06-08 | Jackson | Texas | 48239 | 19 | 1 |
217942 | 217942 | 2020-06-07 | Jackson | Texas | 48239 | 19 | 1 |
214852 | 214852 | 2020-06-06 | Jackson | Texas | 48239 | 19 | 1 |
211765 | 211765 | 2020-06-05 | Jackson | Texas | 48239 | 19 | 1 |
208681 | 208681 | 2020-06-04 | Jackson | Texas | 48239 | 19 | 1 |
205599 | 205599 | 2020-06-03 | Jackson | Texas | 48239 | 19 | 1 |
202520 | 202520 | 2020-06-02 | Jackson | Texas | 48239 | 19 | 1 |
199444 | 199444 | 2020-06-01 | Jackson | Texas | 48239 | 18 | 1 |
196371 | 196371 | 2020-05-31 | Jackson | Texas | 48239 | 18 | 1 |
193301 | 193301 | 2020-05-30 | Jackson | Texas | 48239 | 18 | 1 |
190236 | 190236 | 2020-05-29 | Jackson | Texas | 48239 | 18 | 1 |
187172 | 187172 | 2020-05-28 | Jackson | Texas | 48239 | 18 | 1 |
184115 | 184115 | 2020-05-27 | Jackson | Texas | 48239 | 17 | 1 |
181065 | 181065 | 2020-05-26 | Jackson | Texas | 48239 | 17 | 1 |
178021 | 178021 | 2020-05-25 | Jackson | Texas | 48239 | 17 | 1 |
174977 | 174977 | 2020-05-24 | Jackson | Texas | 48239 | 17 | 1 |
171934 | 171934 | 2020-05-23 | Jackson | Texas | 48239 | 17 | 1 |
168894 | 168894 | 2020-05-22 | Jackson | Texas | 48239 | 16 | 1 |
165858 | 165858 | 2020-05-21 | Jackson | Texas | 48239 | 16 | 1 |
162829 | 162829 | 2020-05-20 | Jackson | Texas | 48239 | 15 | 1 |
159801 | 159801 | 2020-05-19 | Jackson | Texas | 48239 | 15 | 1 |
156779 | 156779 | 2020-05-18 | Jackson | Texas | 48239 | 15 | 1 |
153762 | 153762 | 2020-05-17 | Jackson | Texas | 48239 | 15 | 1 |
150751 | 150751 | 2020-05-16 | Jackson | Texas | 48239 | 15 | 1 |
147743 | 147743 | 2020-05-15 | Jackson | Texas | 48239 | 15 | 1 |
144739 | 144739 | 2020-05-14 | Jackson | Texas | 48239 | 15 | 1 |
141742 | 141742 | 2020-05-13 | Jackson | Texas | 48239 | 15 | 0 |
138746 | 138746 | 2020-05-12 | Jackson | Texas | 48239 | 15 | 0 |
135756 | 135756 | 2020-05-11 | Jackson | Texas | 48239 | 14 | 0 |
132765 | 132765 | 2020-05-10 | Jackson | Texas | 48239 | 14 | 0 |
129775 | 129775 | 2020-05-09 | Jackson | Texas | 48239 | 14 | 0 |
126786 | 126786 | 2020-05-08 | Jackson | Texas | 48239 | 14 | 0 |
123803 | 123803 | 2020-05-07 | Jackson | Texas | 48239 | 14 | 0 |
120824 | 120824 | 2020-05-06 | Jackson | Texas | 48239 | 14 | 0 |
117860 | 117860 | 2020-05-05 | Jackson | Texas | 48239 | 14 | 0 |
114901 | 114901 | 2020-05-04 | Jackson | Texas | 48239 | 14 | 0 |
112019 | 112019 | 2020-05-03 | Jackson | Texas | 48239 | 14 | 0 |
109145 | 109145 | 2020-05-02 | Jackson | Texas | 48239 | 10 | 0 |
106276 | 106276 | 2020-05-01 | Jackson | Texas | 48239 | 8 | 0 |
103412 | 103412 | 2020-04-30 | Jackson | Texas | 48239 | 6 | 0 |
100557 | 100557 | 2020-04-29 | Jackson | Texas | 48239 | 6 | 0 |
97707 | 97707 | 2020-04-28 | Jackson | Texas | 48239 | 6 | 0 |
94867 | 94867 | 2020-04-27 | Jackson | Texas | 48239 | 6 | 0 |
92038 | 92038 | 2020-04-26 | Jackson | Texas | 48239 | 6 | 0 |
89221 | 89221 | 2020-04-25 | Jackson | Texas | 48239 | 6 | 0 |
86406 | 86406 | 2020-04-24 | Jackson | Texas | 48239 | 6 | 0 |
83601 | 83601 | 2020-04-23 | Jackson | Texas | 48239 | 6 | 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);