ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
700 rows where county = "Schleicher" and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
236623 | 236623 | 2020-06-13 | Schleicher | Texas | 48413 | 1 | 0 |
239731 | 239731 | 2020-06-14 | Schleicher | Texas | 48413 | 1 | 0 |
242841 | 242841 | 2020-06-15 | Schleicher | Texas | 48413 | 1 | 0 |
245953 | 245953 | 2020-06-16 | Schleicher | Texas | 48413 | 6 | 0 |
249066 | 249066 | 2020-06-17 | Schleicher | Texas | 48413 | 8 | 0 |
252181 | 252181 | 2020-06-18 | Schleicher | Texas | 48413 | 8 | 0 |
255296 | 255296 | 2020-06-19 | Schleicher | Texas | 48413 | 10 | 0 |
258423 | 258423 | 2020-06-20 | Schleicher | Texas | 48413 | 12 | 0 |
261550 | 261550 | 2020-06-21 | Schleicher | Texas | 48413 | 12 | 0 |
264679 | 264679 | 2020-06-22 | Schleicher | Texas | 48413 | 12 | 0 |
267807 | 267807 | 2020-06-23 | Schleicher | Texas | 48413 | 12 | 0 |
270941 | 270941 | 2020-06-24 | Schleicher | Texas | 48413 | 12 | 0 |
274081 | 274081 | 2020-06-25 | Schleicher | Texas | 48413 | 12 | 0 |
277229 | 277229 | 2020-06-26 | Schleicher | Texas | 48413 | 12 | 0 |
280377 | 280377 | 2020-06-27 | Schleicher | Texas | 48413 | 14 | 0 |
283523 | 283523 | 2020-06-28 | Schleicher | Texas | 48413 | 14 | 0 |
286669 | 286669 | 2020-06-29 | Schleicher | Texas | 48413 | 15 | 0 |
289819 | 289819 | 2020-06-30 | Schleicher | Texas | 48413 | 20 | 0 |
292972 | 292972 | 2020-07-01 | Schleicher | Texas | 48413 | 20 | 0 |
296127 | 296127 | 2020-07-02 | Schleicher | Texas | 48413 | 21 | 0 |
299288 | 299288 | 2020-07-03 | Schleicher | Texas | 48413 | 21 | 0 |
302452 | 302452 | 2020-07-04 | Schleicher | Texas | 48413 | 21 | 0 |
305616 | 305616 | 2020-07-05 | Schleicher | Texas | 48413 | 21 | 0 |
308784 | 308784 | 2020-07-06 | Schleicher | Texas | 48413 | 21 | 0 |
311953 | 311953 | 2020-07-07 | Schleicher | Texas | 48413 | 21 | 0 |
315127 | 315127 | 2020-07-08 | Schleicher | Texas | 48413 | 21 | 1 |
318300 | 318300 | 2020-07-09 | Schleicher | Texas | 48413 | 21 | 1 |
321479 | 321479 | 2020-07-10 | Schleicher | Texas | 48413 | 23 | 1 |
324660 | 324660 | 2020-07-11 | Schleicher | Texas | 48413 | 24 | 1 |
327845 | 327845 | 2020-07-12 | Schleicher | Texas | 48413 | 24 | 1 |
331031 | 331031 | 2020-07-13 | Schleicher | Texas | 48413 | 24 | 1 |
334224 | 334224 | 2020-07-14 | Schleicher | Texas | 48413 | 25 | 1 |
337419 | 337419 | 2020-07-15 | Schleicher | Texas | 48413 | 25 | 1 |
340615 | 340615 | 2020-07-16 | Schleicher | Texas | 48413 | 26 | 1 |
343814 | 343814 | 2020-07-17 | Schleicher | Texas | 48413 | 28 | 1 |
347014 | 347014 | 2020-07-18 | Schleicher | Texas | 48413 | 30 | 1 |
350214 | 350214 | 2020-07-19 | Schleicher | Texas | 48413 | 30 | 1 |
353416 | 353416 | 2020-07-20 | Schleicher | Texas | 48413 | 30 | 1 |
356619 | 356619 | 2020-07-21 | Schleicher | Texas | 48413 | 31 | 1 |
359824 | 359824 | 2020-07-22 | Schleicher | Texas | 48413 | 33 | 1 |
363031 | 363031 | 2020-07-23 | Schleicher | Texas | 48413 | 33 | 1 |
366237 | 366237 | 2020-07-24 | Schleicher | Texas | 48413 | 33 | 1 |
369446 | 369446 | 2020-07-25 | Schleicher | Texas | 48413 | 33 | 1 |
372658 | 372658 | 2020-07-26 | Schleicher | Texas | 48413 | 33 | 1 |
375871 | 375871 | 2020-07-27 | Schleicher | Texas | 48413 | 33 | 1 |
379087 | 379087 | 2020-07-28 | Schleicher | Texas | 48413 | 33 | 1 |
382304 | 382304 | 2020-07-29 | Schleicher | Texas | 48413 | 34 | 1 |
385522 | 385522 | 2020-07-30 | Schleicher | Texas | 48413 | 34 | 1 |
388739 | 388739 | 2020-07-31 | Schleicher | Texas | 48413 | 34 | 1 |
391956 | 391956 | 2020-08-01 | Schleicher | Texas | 48413 | 35 | 1 |
395172 | 395172 | 2020-08-02 | Schleicher | Texas | 48413 | 35 | 1 |
398388 | 398388 | 2020-08-03 | Schleicher | Texas | 48413 | 35 | 1 |
401604 | 401604 | 2020-08-04 | Schleicher | Texas | 48413 | 35 | 1 |
404822 | 404822 | 2020-08-05 | Schleicher | Texas | 48413 | 35 | 1 |
408042 | 408042 | 2020-08-06 | Schleicher | Texas | 48413 | 36 | 1 |
411261 | 411261 | 2020-08-07 | Schleicher | Texas | 48413 | 36 | 1 |
414481 | 414481 | 2020-08-08 | Schleicher | Texas | 48413 | 36 | 1 |
417702 | 417702 | 2020-08-09 | Schleicher | Texas | 48413 | 36 | 1 |
420923 | 420923 | 2020-08-10 | Schleicher | Texas | 48413 | 36 | 1 |
424144 | 424144 | 2020-08-11 | Schleicher | Texas | 48413 | 36 | 1 |
427368 | 427368 | 2020-08-12 | Schleicher | Texas | 48413 | 36 | 1 |
430595 | 430595 | 2020-08-13 | Schleicher | Texas | 48413 | 36 | 1 |
433820 | 433820 | 2020-08-14 | Schleicher | Texas | 48413 | 36 | 1 |
437046 | 437046 | 2020-08-15 | Schleicher | Texas | 48413 | 36 | 1 |
440272 | 440272 | 2020-08-16 | Schleicher | Texas | 48413 | 36 | 1 |
443498 | 443498 | 2020-08-17 | Schleicher | Texas | 48413 | 36 | 1 |
446725 | 446725 | 2020-08-18 | Schleicher | Texas | 48413 | 36 | 1 |
449953 | 449953 | 2020-08-19 | Schleicher | Texas | 48413 | 36 | 1 |
453181 | 453181 | 2020-08-20 | Schleicher | Texas | 48413 | 36 | 1 |
456409 | 456409 | 2020-08-21 | Schleicher | Texas | 48413 | 36 | 1 |
459636 | 459636 | 2020-08-22 | Schleicher | Texas | 48413 | 36 | 1 |
462865 | 462865 | 2020-08-23 | Schleicher | Texas | 48413 | 36 | 1 |
466094 | 466094 | 2020-08-24 | Schleicher | Texas | 48413 | 36 | 1 |
469323 | 469323 | 2020-08-25 | Schleicher | Texas | 48413 | 38 | 1 |
472555 | 472555 | 2020-08-26 | Schleicher | Texas | 48413 | 38 | 2 |
475788 | 475788 | 2020-08-27 | Schleicher | Texas | 48413 | 38 | 2 |
479021 | 479021 | 2020-08-28 | Schleicher | Texas | 48413 | 38 | 2 |
482255 | 482255 | 2020-08-29 | Schleicher | Texas | 48413 | 38 | 2 |
485490 | 485490 | 2020-08-30 | Schleicher | Texas | 48413 | 38 | 2 |
488723 | 488723 | 2020-08-31 | Schleicher | Texas | 48413 | 38 | 2 |
491956 | 491956 | 2020-09-01 | Schleicher | Texas | 48413 | 38 | 2 |
495190 | 495190 | 2020-09-02 | Schleicher | Texas | 48413 | 38 | 2 |
498423 | 498423 | 2020-09-03 | Schleicher | Texas | 48413 | 51 | 2 |
501657 | 501657 | 2020-09-04 | Schleicher | Texas | 48413 | 51 | 2 |
504891 | 504891 | 2020-09-05 | Schleicher | Texas | 48413 | 51 | 2 |
508123 | 508123 | 2020-09-06 | Schleicher | Texas | 48413 | 51 | 2 |
511356 | 511356 | 2020-09-07 | Schleicher | Texas | 48413 | 51 | 2 |
514589 | 514589 | 2020-09-08 | Schleicher | Texas | 48413 | 51 | 2 |
517824 | 517824 | 2020-09-09 | Schleicher | Texas | 48413 | 51 | 2 |
521060 | 521060 | 2020-09-10 | Schleicher | Texas | 48413 | 51 | 2 |
524296 | 524296 | 2020-09-11 | Schleicher | Texas | 48413 | 51 | 2 |
527532 | 527532 | 2020-09-12 | Schleicher | Texas | 48413 | 51 | 2 |
530769 | 530769 | 2020-09-13 | Schleicher | Texas | 48413 | 51 | 2 |
534004 | 534004 | 2020-09-14 | Schleicher | Texas | 48413 | 51 | 2 |
537240 | 537240 | 2020-09-15 | Schleicher | Texas | 48413 | 51 | 2 |
540477 | 540477 | 2020-09-16 | Schleicher | Texas | 48413 | 51 | 2 |
543713 | 543713 | 2020-09-17 | Schleicher | Texas | 48413 | 51 | 2 |
546950 | 546950 | 2020-09-18 | Schleicher | Texas | 48413 | 52 | 2 |
550189 | 550189 | 2020-09-19 | Schleicher | Texas | 48413 | 52 | 2 |
553428 | 553428 | 2020-09-20 | Schleicher | Texas | 48413 | 52 | 2 |
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);