ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 48039 and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
264500 | 264500 | 2020-06-22 | Brazoria | Texas | 48039 | 1762 | 19 |
267628 | 267628 | 2020-06-23 | Brazoria | Texas | 48039 | 1814 | 19 |
270762 | 270762 | 2020-06-24 | Brazoria | Texas | 48039 | 1838 | 19 |
273901 | 273901 | 2020-06-25 | Brazoria | Texas | 48039 | 1913 | 19 |
277048 | 277048 | 2020-06-26 | Brazoria | Texas | 48039 | 1986 | 20 |
280196 | 280196 | 2020-06-27 | Brazoria | Texas | 48039 | 2064 | 21 |
283342 | 283342 | 2020-06-28 | Brazoria | Texas | 48039 | 2161 | 21 |
286488 | 286488 | 2020-06-29 | Brazoria | Texas | 48039 | 2217 | 21 |
289638 | 289638 | 2020-06-30 | Brazoria | Texas | 48039 | 2269 | 21 |
292791 | 292791 | 2020-07-01 | Brazoria | Texas | 48039 | 2336 | 21 |
295946 | 295946 | 2020-07-02 | Brazoria | Texas | 48039 | 2438 | 22 |
299106 | 299106 | 2020-07-03 | Brazoria | Texas | 48039 | 2516 | 22 |
302270 | 302270 | 2020-07-04 | Brazoria | Texas | 48039 | 2626 | 22 |
305434 | 305434 | 2020-07-05 | Brazoria | Texas | 48039 | 2715 | 22 |
308602 | 308602 | 2020-07-06 | Brazoria | Texas | 48039 | 2829 | 22 |
311771 | 311771 | 2020-07-07 | Brazoria | Texas | 48039 | 2925 | 22 |
314945 | 314945 | 2020-07-08 | Brazoria | Texas | 48039 | 3036 | 23 |
318118 | 318118 | 2020-07-09 | Brazoria | Texas | 48039 | 3146 | 24 |
321296 | 321296 | 2020-07-10 | Brazoria | Texas | 48039 | 3272 | 24 |
324477 | 324477 | 2020-07-11 | Brazoria | Texas | 48039 | 3358 | 25 |
327662 | 327662 | 2020-07-12 | Brazoria | Texas | 48039 | 3458 | 25 |
330848 | 330848 | 2020-07-13 | Brazoria | Texas | 48039 | 3550 | 28 |
334039 | 334039 | 2020-07-14 | Brazoria | Texas | 48039 | 3834 | 28 |
337234 | 337234 | 2020-07-15 | Brazoria | Texas | 48039 | 3988 | 28 |
340430 | 340430 | 2020-07-16 | Brazoria | Texas | 48039 | 4190 | 28 |
343629 | 343629 | 2020-07-17 | Brazoria | Texas | 48039 | 4359 | 29 |
346829 | 346829 | 2020-07-18 | Brazoria | Texas | 48039 | 4545 | 31 |
350029 | 350029 | 2020-07-19 | Brazoria | Texas | 48039 | 4675 | 32 |
353231 | 353231 | 2020-07-20 | Brazoria | Texas | 48039 | 4767 | 34 |
356434 | 356434 | 2020-07-21 | Brazoria | Texas | 48039 | 4896 | 34 |
359639 | 359639 | 2020-07-22 | Brazoria | Texas | 48039 | 5068 | 34 |
362846 | 362846 | 2020-07-23 | Brazoria | Texas | 48039 | 5177 | 35 |
366052 | 366052 | 2020-07-24 | Brazoria | Texas | 48039 | 5277 | 36 |
369261 | 369261 | 2020-07-25 | Brazoria | Texas | 48039 | 5299 | 37 |
372473 | 372473 | 2020-07-26 | Brazoria | Texas | 48039 | 5443 | 38 |
375686 | 375686 | 2020-07-27 | Brazoria | Texas | 48039 | 5573 | 50 |
378902 | 378902 | 2020-07-28 | Brazoria | Texas | 48039 | 5896 | 52 |
382119 | 382119 | 2020-07-29 | Brazoria | Texas | 48039 | 6032 | 60 |
385337 | 385337 | 2020-07-30 | Brazoria | Texas | 48039 | 6218 | 62 |
388554 | 388554 | 2020-07-31 | Brazoria | Texas | 48039 | 6384 | 67 |
391771 | 391771 | 2020-08-01 | Brazoria | Texas | 48039 | 6534 | 72 |
394987 | 394987 | 2020-08-02 | Brazoria | Texas | 48039 | 6655 | 72 |
398203 | 398203 | 2020-08-03 | Brazoria | Texas | 48039 | 6732 | 73 |
401419 | 401419 | 2020-08-04 | Brazoria | Texas | 48039 | 6732 | 78 |
404637 | 404637 | 2020-08-05 | Brazoria | Texas | 48039 | 6887 | 84 |
407857 | 407857 | 2020-08-06 | Brazoria | Texas | 48039 | 6988 | 85 |
411076 | 411076 | 2020-08-07 | Brazoria | Texas | 48039 | 7090 | 88 |
414296 | 414296 | 2020-08-08 | Brazoria | Texas | 48039 | 7215 | 92 |
417517 | 417517 | 2020-08-09 | Brazoria | Texas | 48039 | 7357 | 93 |
420738 | 420738 | 2020-08-10 | Brazoria | Texas | 48039 | 7481 | 93 |
423959 | 423959 | 2020-08-11 | Brazoria | Texas | 48039 | 7591 | 96 |
427183 | 427183 | 2020-08-12 | Brazoria | Texas | 48039 | 7591 | 100 |
430410 | 430410 | 2020-08-13 | Brazoria | Texas | 48039 | 7789 | 105 |
433635 | 433635 | 2020-08-14 | Brazoria | Texas | 48039 | 7917 | 105 |
436861 | 436861 | 2020-08-15 | Brazoria | Texas | 48039 | 8025 | 110 |
440087 | 440087 | 2020-08-16 | Brazoria | Texas | 48039 | 8148 | 111 |
443313 | 443313 | 2020-08-17 | Brazoria | Texas | 48039 | 8233 | 111 |
446540 | 446540 | 2020-08-18 | Brazoria | Texas | 48039 | 8303 | 114 |
449768 | 449768 | 2020-08-19 | Brazoria | Texas | 48039 | 8367 | 118 |
452996 | 452996 | 2020-08-20 | Brazoria | Texas | 48039 | 8438 | 121 |
456224 | 456224 | 2020-08-21 | Brazoria | Texas | 48039 | 8514 | 122 |
459451 | 459451 | 2020-08-22 | Brazoria | Texas | 48039 | 8605 | 124 |
462680 | 462680 | 2020-08-23 | Brazoria | Texas | 48039 | 8662 | 124 |
465909 | 465909 | 2020-08-24 | Brazoria | Texas | 48039 | 8662 | 124 |
469138 | 469138 | 2020-08-25 | Brazoria | Texas | 48039 | 8824 | 127 |
472370 | 472370 | 2020-08-26 | Brazoria | Texas | 48039 | 8886 | 130 |
475603 | 475603 | 2020-08-27 | Brazoria | Texas | 48039 | 8981 | 131 |
478836 | 478836 | 2020-08-28 | Brazoria | Texas | 48039 | 9093 | 134 |
482070 | 482070 | 2020-08-29 | Brazoria | Texas | 48039 | 9220 | 137 |
485305 | 485305 | 2020-08-30 | Brazoria | Texas | 48039 | 9309 | 138 |
488538 | 488538 | 2020-08-31 | Brazoria | Texas | 48039 | 9389 | 138 |
491771 | 491771 | 2020-09-01 | Brazoria | Texas | 48039 | 9419 | 138 |
495005 | 495005 | 2020-09-02 | Brazoria | Texas | 48039 | 9592 | 139 |
498238 | 498238 | 2020-09-03 | Brazoria | Texas | 48039 | 9591 | 143 |
501472 | 501472 | 2020-09-04 | Brazoria | Texas | 48039 | 9670 | 145 |
504706 | 504706 | 2020-09-05 | Brazoria | Texas | 48039 | 9642 | 146 |
507938 | 507938 | 2020-09-06 | Brazoria | Texas | 48039 | 9817 | 146 |
511171 | 511171 | 2020-09-07 | Brazoria | Texas | 48039 | 9882 | 146 |
514404 | 514404 | 2020-09-08 | Brazoria | Texas | 48039 | 9924 | 147 |
517639 | 517639 | 2020-09-09 | Brazoria | Texas | 48039 | 10004 | 148 |
520875 | 520875 | 2020-09-10 | Brazoria | Texas | 48039 | 10004 | 148 |
524111 | 524111 | 2020-09-11 | Brazoria | Texas | 48039 | 10219 | 154 |
527347 | 527347 | 2020-09-12 | Brazoria | Texas | 48039 | 10347 | 155 |
530584 | 530584 | 2020-09-13 | Brazoria | Texas | 48039 | 10545 | 155 |
533819 | 533819 | 2020-09-14 | Brazoria | Texas | 48039 | 10545 | 155 |
537055 | 537055 | 2020-09-15 | Brazoria | Texas | 48039 | 10721 | 155 |
540292 | 540292 | 2020-09-16 | Brazoria | Texas | 48039 | 10772 | 155 |
543528 | 543528 | 2020-09-17 | Brazoria | Texas | 48039 | 10872 | 156 |
546765 | 546765 | 2020-09-18 | Brazoria | Texas | 48039 | 10948 | 157 |
550004 | 550004 | 2020-09-19 | Brazoria | Texas | 48039 | 10976 | 158 |
553243 | 553243 | 2020-09-20 | Brazoria | Texas | 48039 | 11034 | 158 |
556480 | 556480 | 2020-09-21 | Brazoria | Texas | 48039 | 11047 | 158 |
559716 | 559716 | 2020-09-22 | Brazoria | Texas | 48039 | 11045 | 159 |
562955 | 562955 | 2020-09-23 | Brazoria | Texas | 48039 | 11144 | 161 |
566196 | 566196 | 2020-09-24 | Brazoria | Texas | 48039 | 11169 | 163 |
569437 | 569437 | 2020-09-25 | Brazoria | Texas | 48039 | 11169 | 163 |
572679 | 572679 | 2020-09-26 | Brazoria | Texas | 48039 | 11281 | 165 |
575923 | 575923 | 2020-09-27 | Brazoria | Texas | 48039 | 11281 | 167 |
579164 | 579164 | 2020-09-28 | Brazoria | Texas | 48039 | 11395 | 167 |
582403 | 582403 | 2020-09-29 | Brazoria | Texas | 48039 | 11412 | 167 |
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);