ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
708 rows where county = "Crockett" and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
211701 | 211701 | 2020-06-05 | Crockett | Texas | 48105 | 1 | 0 |
214788 | 214788 | 2020-06-06 | Crockett | Texas | 48105 | 1 | 0 |
217878 | 217878 | 2020-06-07 | Crockett | Texas | 48105 | 1 | 0 |
220970 | 220970 | 2020-06-08 | Crockett | Texas | 48105 | 1 | 0 |
224065 | 224065 | 2020-06-09 | Crockett | Texas | 48105 | 4 | 0 |
227165 | 227165 | 2020-06-10 | Crockett | Texas | 48105 | 5 | 0 |
230269 | 230269 | 2020-06-11 | Crockett | Texas | 48105 | 5 | 0 |
233373 | 233373 | 2020-06-12 | Crockett | Texas | 48105 | 5 | 0 |
236479 | 236479 | 2020-06-13 | Crockett | Texas | 48105 | 5 | 0 |
239587 | 239587 | 2020-06-14 | Crockett | Texas | 48105 | 5 | 0 |
242697 | 242697 | 2020-06-15 | Crockett | Texas | 48105 | 5 | 0 |
245809 | 245809 | 2020-06-16 | Crockett | Texas | 48105 | 5 | 0 |
248922 | 248922 | 2020-06-17 | Crockett | Texas | 48105 | 5 | 0 |
252037 | 252037 | 2020-06-18 | Crockett | Texas | 48105 | 5 | 0 |
255152 | 255152 | 2020-06-19 | Crockett | Texas | 48105 | 5 | 0 |
258278 | 258278 | 2020-06-20 | Crockett | Texas | 48105 | 5 | 0 |
261405 | 261405 | 2020-06-21 | Crockett | Texas | 48105 | 5 | 0 |
264533 | 264533 | 2020-06-22 | Crockett | Texas | 48105 | 5 | 0 |
267661 | 267661 | 2020-06-23 | Crockett | Texas | 48105 | 5 | 0 |
270795 | 270795 | 2020-06-24 | Crockett | Texas | 48105 | 5 | 0 |
273934 | 273934 | 2020-06-25 | Crockett | Texas | 48105 | 5 | 0 |
277081 | 277081 | 2020-06-26 | Crockett | Texas | 48105 | 5 | 0 |
280229 | 280229 | 2020-06-27 | Crockett | Texas | 48105 | 7 | 0 |
283375 | 283375 | 2020-06-28 | Crockett | Texas | 48105 | 7 | 0 |
286521 | 286521 | 2020-06-29 | Crockett | Texas | 48105 | 8 | 0 |
289671 | 289671 | 2020-06-30 | Crockett | Texas | 48105 | 9 | 0 |
292824 | 292824 | 2020-07-01 | Crockett | Texas | 48105 | 10 | 0 |
295979 | 295979 | 2020-07-02 | Crockett | Texas | 48105 | 11 | 0 |
299139 | 299139 | 2020-07-03 | Crockett | Texas | 48105 | 13 | 0 |
302303 | 302303 | 2020-07-04 | Crockett | Texas | 48105 | 13 | 0 |
305467 | 305467 | 2020-07-05 | Crockett | Texas | 48105 | 13 | 0 |
308635 | 308635 | 2020-07-06 | Crockett | Texas | 48105 | 13 | 0 |
311804 | 311804 | 2020-07-07 | Crockett | Texas | 48105 | 15 | 0 |
314978 | 314978 | 2020-07-08 | Crockett | Texas | 48105 | 16 | 0 |
318151 | 318151 | 2020-07-09 | Crockett | Texas | 48105 | 18 | 0 |
321329 | 321329 | 2020-07-10 | Crockett | Texas | 48105 | 29 | 0 |
324510 | 324510 | 2020-07-11 | Crockett | Texas | 48105 | 35 | 0 |
327695 | 327695 | 2020-07-12 | Crockett | Texas | 48105 | 35 | 0 |
330881 | 330881 | 2020-07-13 | Crockett | Texas | 48105 | 38 | 1 |
334072 | 334072 | 2020-07-14 | Crockett | Texas | 48105 | 41 | 1 |
337267 | 337267 | 2020-07-15 | Crockett | Texas | 48105 | 41 | 1 |
340463 | 340463 | 2020-07-16 | Crockett | Texas | 48105 | 71 | 1 |
343662 | 343662 | 2020-07-17 | Crockett | Texas | 48105 | 84 | 1 |
346862 | 346862 | 2020-07-18 | Crockett | Texas | 48105 | 96 | 1 |
350062 | 350062 | 2020-07-19 | Crockett | Texas | 48105 | 96 | 1 |
353264 | 353264 | 2020-07-20 | Crockett | Texas | 48105 | 103 | 1 |
356467 | 356467 | 2020-07-21 | Crockett | Texas | 48105 | 115 | 1 |
359672 | 359672 | 2020-07-22 | Crockett | Texas | 48105 | 118 | 1 |
362879 | 362879 | 2020-07-23 | Crockett | Texas | 48105 | 126 | 1 |
369294 | 369294 | 2020-07-25 | Crockett | Texas | 48105 | 135 | 4 |
372506 | 372506 | 2020-07-26 | Crockett | Texas | 48105 | 135 | 4 |
375719 | 375719 | 2020-07-27 | Crockett | Texas | 48105 | 135 | 2 |
366085 | 366085 | 2020-07-24 | Crockett | Texas | 48105 | 136 | 1 |
378935 | 378935 | 2020-07-28 | Crockett | Texas | 48105 | 140 | 2 |
382152 | 382152 | 2020-07-29 | Crockett | Texas | 48105 | 141 | 2 |
385370 | 385370 | 2020-07-30 | Crockett | Texas | 48105 | 150 | 2 |
388587 | 388587 | 2020-07-31 | Crockett | Texas | 48105 | 153 | 2 |
391804 | 391804 | 2020-08-01 | Crockett | Texas | 48105 | 153 | 3 |
395020 | 395020 | 2020-08-02 | Crockett | Texas | 48105 | 153 | 3 |
398236 | 398236 | 2020-08-03 | Crockett | Texas | 48105 | 154 | 3 |
411109 | 411109 | 2020-08-07 | Crockett | Texas | 48105 | 155 | 3 |
414329 | 414329 | 2020-08-08 | Crockett | Texas | 48105 | 155 | 3 |
417550 | 417550 | 2020-08-09 | Crockett | Texas | 48105 | 155 | 3 |
420771 | 420771 | 2020-08-10 | Crockett | Texas | 48105 | 155 | 3 |
401452 | 401452 | 2020-08-04 | Crockett | Texas | 48105 | 156 | 3 |
404670 | 404670 | 2020-08-05 | Crockett | Texas | 48105 | 156 | 3 |
427216 | 427216 | 2020-08-12 | Crockett | Texas | 48105 | 156 | 3 |
407890 | 407890 | 2020-08-06 | Crockett | Texas | 48105 | 157 | 3 |
430443 | 430443 | 2020-08-13 | Crockett | Texas | 48105 | 157 | 4 |
433668 | 433668 | 2020-08-14 | Crockett | Texas | 48105 | 157 | 4 |
436894 | 436894 | 2020-08-15 | Crockett | Texas | 48105 | 157 | 4 |
440120 | 440120 | 2020-08-16 | Crockett | Texas | 48105 | 157 | 4 |
443346 | 443346 | 2020-08-17 | Crockett | Texas | 48105 | 157 | 4 |
446573 | 446573 | 2020-08-18 | Crockett | Texas | 48105 | 157 | 4 |
449801 | 449801 | 2020-08-19 | Crockett | Texas | 48105 | 157 | 4 |
453029 | 453029 | 2020-08-20 | Crockett | Texas | 48105 | 157 | 4 |
423992 | 423992 | 2020-08-11 | Crockett | Texas | 48105 | 158 | 3 |
456257 | 456257 | 2020-08-21 | Crockett | Texas | 48105 | 159 | 4 |
459484 | 459484 | 2020-08-22 | Crockett | Texas | 48105 | 160 | 4 |
462713 | 462713 | 2020-08-23 | Crockett | Texas | 48105 | 160 | 4 |
465942 | 465942 | 2020-08-24 | Crockett | Texas | 48105 | 160 | 4 |
469171 | 469171 | 2020-08-25 | Crockett | Texas | 48105 | 161 | 5 |
472403 | 472403 | 2020-08-26 | Crockett | Texas | 48105 | 161 | 5 |
475636 | 475636 | 2020-08-27 | Crockett | Texas | 48105 | 162 | 5 |
478869 | 478869 | 2020-08-28 | Crockett | Texas | 48105 | 162 | 5 |
482103 | 482103 | 2020-08-29 | Crockett | Texas | 48105 | 162 | 6 |
485338 | 485338 | 2020-08-30 | Crockett | Texas | 48105 | 162 | 6 |
488571 | 488571 | 2020-08-31 | Crockett | Texas | 48105 | 162 | 6 |
491804 | 491804 | 2020-09-01 | Crockett | Texas | 48105 | 162 | 6 |
495038 | 495038 | 2020-09-02 | Crockett | Texas | 48105 | 162 | 6 |
498271 | 498271 | 2020-09-03 | Crockett | Texas | 48105 | 162 | 6 |
501505 | 501505 | 2020-09-04 | Crockett | Texas | 48105 | 162 | 6 |
504739 | 504739 | 2020-09-05 | Crockett | Texas | 48105 | 164 | 6 |
507971 | 507971 | 2020-09-06 | Crockett | Texas | 48105 | 164 | 6 |
511204 | 511204 | 2020-09-07 | Crockett | Texas | 48105 | 164 | 6 |
514437 | 514437 | 2020-09-08 | Crockett | Texas | 48105 | 164 | 6 |
517672 | 517672 | 2020-09-09 | Crockett | Texas | 48105 | 164 | 6 |
520908 | 520908 | 2020-09-10 | Crockett | Texas | 48105 | 164 | 6 |
524144 | 524144 | 2020-09-11 | Crockett | Texas | 48105 | 164 | 6 |
527380 | 527380 | 2020-09-12 | Crockett | Texas | 48105 | 164 | 6 |
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);