ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Gregg" and state = "Texas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
255188 | 255188 | 2020-06-19 | Gregg | Texas | 48183 | 306 | 13 |
258315 | 258315 | 2020-06-20 | Gregg | Texas | 48183 | 306 | 13 |
261442 | 261442 | 2020-06-21 | Gregg | Texas | 48183 | 306 | 13 |
264570 | 264570 | 2020-06-22 | Gregg | Texas | 48183 | 309 | 13 |
267698 | 267698 | 2020-06-23 | Gregg | Texas | 48183 | 317 | 13 |
270832 | 270832 | 2020-06-24 | Gregg | Texas | 48183 | 320 | 14 |
273972 | 273972 | 2020-06-25 | Gregg | Texas | 48183 | 334 | 14 |
277119 | 277119 | 2020-06-26 | Gregg | Texas | 48183 | 340 | 14 |
280267 | 280267 | 2020-06-27 | Gregg | Texas | 48183 | 340 | 14 |
283413 | 283413 | 2020-06-28 | Gregg | Texas | 48183 | 340 | 14 |
286559 | 286559 | 2020-06-29 | Gregg | Texas | 48183 | 354 | 14 |
289709 | 289709 | 2020-06-30 | Gregg | Texas | 48183 | 355 | 14 |
292862 | 292862 | 2020-07-01 | Gregg | Texas | 48183 | 397 | 14 |
296017 | 296017 | 2020-07-02 | Gregg | Texas | 48183 | 417 | 14 |
299177 | 299177 | 2020-07-03 | Gregg | Texas | 48183 | 417 | 14 |
302341 | 302341 | 2020-07-04 | Gregg | Texas | 48183 | 417 | 14 |
305505 | 305505 | 2020-07-05 | Gregg | Texas | 48183 | 417 | 14 |
308673 | 308673 | 2020-07-06 | Gregg | Texas | 48183 | 486 | 14 |
311842 | 311842 | 2020-07-07 | Gregg | Texas | 48183 | 486 | 14 |
315016 | 315016 | 2020-07-08 | Gregg | Texas | 48183 | 668 | 14 |
318189 | 318189 | 2020-07-09 | Gregg | Texas | 48183 | 745 | 14 |
321368 | 321368 | 2020-07-10 | Gregg | Texas | 48183 | 788 | 14 |
324549 | 324549 | 2020-07-11 | Gregg | Texas | 48183 | 788 | 14 |
327734 | 327734 | 2020-07-12 | Gregg | Texas | 48183 | 788 | 14 |
330920 | 330920 | 2020-07-13 | Gregg | Texas | 48183 | 863 | 16 |
334111 | 334111 | 2020-07-14 | Gregg | Texas | 48183 | 863 | 16 |
337306 | 337306 | 2020-07-15 | Gregg | Texas | 48183 | 941 | 16 |
340502 | 340502 | 2020-07-16 | Gregg | Texas | 48183 | 981 | 16 |
343701 | 343701 | 2020-07-17 | Gregg | Texas | 48183 | 1034 | 16 |
346901 | 346901 | 2020-07-18 | Gregg | Texas | 48183 | 1034 | 16 |
350101 | 350101 | 2020-07-19 | Gregg | Texas | 48183 | 1034 | 16 |
353303 | 353303 | 2020-07-20 | Gregg | Texas | 48183 | 1134 | 16 |
356506 | 356506 | 2020-07-21 | Gregg | Texas | 48183 | 1154 | 16 |
359711 | 359711 | 2020-07-22 | Gregg | Texas | 48183 | 1177 | 16 |
362918 | 362918 | 2020-07-23 | Gregg | Texas | 48183 | 1207 | 17 |
366124 | 366124 | 2020-07-24 | Gregg | Texas | 48183 | 1207 | 17 |
369333 | 369333 | 2020-07-25 | Gregg | Texas | 48183 | 1207 | 17 |
372545 | 372545 | 2020-07-26 | Gregg | Texas | 48183 | 1207 | 17 |
375758 | 375758 | 2020-07-27 | Gregg | Texas | 48183 | 1287 | 19 |
378974 | 378974 | 2020-07-28 | Gregg | Texas | 48183 | 1307 | 20 |
382191 | 382191 | 2020-07-29 | Gregg | Texas | 48183 | 1307 | 20 |
385409 | 385409 | 2020-07-30 | Gregg | Texas | 48183 | 1345 | 22 |
388626 | 388626 | 2020-07-31 | Gregg | Texas | 48183 | 1381 | 22 |
391843 | 391843 | 2020-08-01 | Gregg | Texas | 48183 | 1381 | 22 |
395059 | 395059 | 2020-08-02 | Gregg | Texas | 48183 | 1381 | 22 |
398275 | 398275 | 2020-08-03 | Gregg | Texas | 48183 | 1410 | 23 |
401491 | 401491 | 2020-08-04 | Gregg | Texas | 48183 | 1432 | 23 |
404709 | 404709 | 2020-08-05 | Gregg | Texas | 48183 | 1444 | 23 |
407929 | 407929 | 2020-08-06 | Gregg | Texas | 48183 | 1458 | 24 |
411148 | 411148 | 2020-08-07 | Gregg | Texas | 48183 | 1502 | 25 |
414368 | 414368 | 2020-08-08 | Gregg | Texas | 48183 | 1502 | 25 |
417589 | 417589 | 2020-08-09 | Gregg | Texas | 48183 | 1502 | 26 |
420810 | 420810 | 2020-08-10 | Gregg | Texas | 48183 | 1659 | 29 |
424031 | 424031 | 2020-08-11 | Gregg | Texas | 48183 | 1659 | 29 |
427255 | 427255 | 2020-08-12 | Gregg | Texas | 48183 | 1675 | 29 |
430482 | 430482 | 2020-08-13 | Gregg | Texas | 48183 | 1689 | 31 |
433707 | 433707 | 2020-08-14 | Gregg | Texas | 48183 | 1689 | 31 |
436933 | 436933 | 2020-08-15 | Gregg | Texas | 48183 | 1737 | 33 |
440159 | 440159 | 2020-08-16 | Gregg | Texas | 48183 | 1747 | 33 |
443385 | 443385 | 2020-08-17 | Gregg | Texas | 48183 | 1784 | 33 |
446612 | 446612 | 2020-08-18 | Gregg | Texas | 48183 | 1811 | 33 |
449840 | 449840 | 2020-08-19 | Gregg | Texas | 48183 | 1829 | 34 |
453068 | 453068 | 2020-08-20 | Gregg | Texas | 48183 | 1829 | 38 |
456296 | 456296 | 2020-08-21 | Gregg | Texas | 48183 | 1865 | 43 |
459523 | 459523 | 2020-08-22 | Gregg | Texas | 48183 | 1865 | 43 |
462752 | 462752 | 2020-08-23 | Gregg | Texas | 48183 | 1865 | 43 |
465981 | 465981 | 2020-08-24 | Gregg | Texas | 48183 | 1897 | 43 |
469210 | 469210 | 2020-08-25 | Gregg | Texas | 48183 | 1922 | 43 |
472442 | 472442 | 2020-08-26 | Gregg | Texas | 48183 | 1937 | 43 |
475675 | 475675 | 2020-08-27 | Gregg | Texas | 48183 | 1952 | 44 |
478908 | 478908 | 2020-08-28 | Gregg | Texas | 48183 | 1983 | 45 |
482142 | 482142 | 2020-08-29 | Gregg | Texas | 48183 | 1983 | 46 |
485377 | 485377 | 2020-08-30 | Gregg | Texas | 48183 | 1983 | 47 |
488610 | 488610 | 2020-08-31 | Gregg | Texas | 48183 | 2001 | 48 |
491843 | 491843 | 2020-09-01 | Gregg | Texas | 48183 | 2001 | 48 |
495077 | 495077 | 2020-09-02 | Gregg | Texas | 48183 | 2001 | 51 |
498310 | 498310 | 2020-09-03 | Gregg | Texas | 48183 | 2001 | 51 |
501544 | 501544 | 2020-09-04 | Gregg | Texas | 48183 | 2001 | 51 |
504778 | 504778 | 2020-09-05 | Gregg | Texas | 48183 | 2001 | 51 |
508010 | 508010 | 2020-09-06 | Gregg | Texas | 48183 | 2001 | 51 |
511243 | 511243 | 2020-09-07 | Gregg | Texas | 48183 | 2001 | 51 |
514476 | 514476 | 2020-09-08 | Gregg | Texas | 48183 | 2001 | 51 |
517711 | 517711 | 2020-09-09 | Gregg | Texas | 48183 | 2001 | 52 |
520947 | 520947 | 2020-09-10 | Gregg | Texas | 48183 | 2001 | 52 |
524183 | 524183 | 2020-09-11 | Gregg | Texas | 48183 | 2001 | 56 |
527419 | 527419 | 2020-09-12 | Gregg | Texas | 48183 | 2012 | 58 |
530656 | 530656 | 2020-09-13 | Gregg | Texas | 48183 | 2012 | 59 |
533891 | 533891 | 2020-09-14 | Gregg | Texas | 48183 | 2012 | 59 |
537127 | 537127 | 2020-09-15 | Gregg | Texas | 48183 | 2062 | 59 |
540364 | 540364 | 2020-09-16 | Gregg | Texas | 48183 | 2085 | 59 |
543600 | 543600 | 2020-09-17 | Gregg | Texas | 48183 | 2111 | 60 |
546837 | 546837 | 2020-09-18 | Gregg | Texas | 48183 | 2121 | 60 |
550076 | 550076 | 2020-09-19 | Gregg | Texas | 48183 | 2131 | 59 |
553315 | 553315 | 2020-09-20 | Gregg | Texas | 48183 | 2518 | 59 |
556552 | 556552 | 2020-09-21 | Gregg | Texas | 48183 | 2573 | 59 |
559788 | 559788 | 2020-09-22 | Gregg | Texas | 48183 | 2619 | 61 |
563027 | 563027 | 2020-09-23 | Gregg | Texas | 48183 | 2636 | 61 |
566268 | 566268 | 2020-09-24 | Gregg | Texas | 48183 | 2661 | 63 |
569509 | 569509 | 2020-09-25 | Gregg | Texas | 48183 | 2674 | 63 |
572751 | 572751 | 2020-09-26 | Gregg | Texas | 48183 | 2674 | 66 |
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);