ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48491 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537279 | 537279 | 2020-09-15 | Williamson | Texas | 48491 | 8446 | 135 |
534043 | 534043 | 2020-09-14 | Williamson | Texas | 48491 | 8421 | 135 |
530808 | 530808 | 2020-09-13 | Williamson | Texas | 48491 | 8337 | 135 |
527571 | 527571 | 2020-09-12 | Williamson | Texas | 48491 | 8337 | 135 |
524335 | 524335 | 2020-09-11 | Williamson | Texas | 48491 | 8337 | 135 |
521099 | 521099 | 2020-09-10 | Williamson | Texas | 48491 | 8318 | 133 |
517863 | 517863 | 2020-09-09 | Williamson | Texas | 48491 | 8296 | 132 |
514628 | 514628 | 2020-09-08 | Williamson | Texas | 48491 | 8281 | 132 |
511395 | 511395 | 2020-09-07 | Williamson | Texas | 48491 | 8213 | 131 |
508162 | 508162 | 2020-09-06 | Williamson | Texas | 48491 | 8213 | 131 |
504930 | 504930 | 2020-09-05 | Williamson | Texas | 48491 | 8213 | 130 |
501696 | 501696 | 2020-09-04 | Williamson | Texas | 48491 | 8213 | 128 |
498462 | 498462 | 2020-09-03 | Williamson | Texas | 48491 | 8195 | 126 |
495229 | 495229 | 2020-09-02 | Williamson | Texas | 48491 | 8173 | 126 |
491995 | 491995 | 2020-09-01 | Williamson | Texas | 48491 | 8158 | 124 |
488762 | 488762 | 2020-08-31 | Williamson | Texas | 48491 | 8138 | 124 |
485529 | 485529 | 2020-08-30 | Williamson | Texas | 48491 | 8079 | 123 |
482294 | 482294 | 2020-08-29 | Williamson | Texas | 48491 | 8079 | 123 |
479060 | 479060 | 2020-08-28 | Williamson | Texas | 48491 | 8079 | 120 |
475827 | 475827 | 2020-08-27 | Williamson | Texas | 48491 | 8053 | 119 |
472594 | 472594 | 2020-08-26 | Williamson | Texas | 48491 | 8006 | 116 |
469362 | 469362 | 2020-08-25 | Williamson | Texas | 48491 | 7976 | 115 |
466133 | 466133 | 2020-08-24 | Williamson | Texas | 48491 | 7927 | 114 |
462904 | 462904 | 2020-08-23 | Williamson | Texas | 48491 | 7867 | 113 |
459675 | 459675 | 2020-08-22 | Williamson | Texas | 48491 | 7867 | 113 |
456448 | 456448 | 2020-08-21 | Williamson | Texas | 48491 | 7867 | 113 |
453220 | 453220 | 2020-08-20 | Williamson | Texas | 48491 | 7827 | 113 |
449992 | 449992 | 2020-08-19 | Williamson | Texas | 48491 | 7803 | 110 |
446764 | 446764 | 2020-08-18 | Williamson | Texas | 48491 | 7759 | 105 |
443537 | 443537 | 2020-08-17 | Williamson | Texas | 48491 | 7661 | 103 |
440311 | 440311 | 2020-08-16 | Williamson | Texas | 48491 | 7506 | 103 |
437085 | 437085 | 2020-08-15 | Williamson | Texas | 48491 | 7506 | 103 |
433859 | 433859 | 2020-08-14 | Williamson | Texas | 48491 | 7506 | 103 |
430634 | 430634 | 2020-08-13 | Williamson | Texas | 48491 | 7326 | 99 |
427406 | 427406 | 2020-08-12 | Williamson | Texas | 48491 | 7252 | 98 |
424182 | 424182 | 2020-08-11 | Williamson | Texas | 48491 | 7189 | 95 |
420961 | 420961 | 2020-08-10 | Williamson | Texas | 48491 | 7070 | 94 |
417740 | 417740 | 2020-08-09 | Williamson | Texas | 48491 | 6245 | 93 |
414519 | 414519 | 2020-08-08 | Williamson | Texas | 48491 | 6245 | 91 |
411299 | 411299 | 2020-08-07 | Williamson | Texas | 48491 | 6245 | 90 |
408080 | 408080 | 2020-08-06 | Williamson | Texas | 48491 | 6058 | 86 |
404860 | 404860 | 2020-08-05 | Williamson | Texas | 48491 | 5949 | 83 |
401642 | 401642 | 2020-08-04 | Williamson | Texas | 48491 | 5930 | 80 |
398426 | 398426 | 2020-08-03 | Williamson | Texas | 48491 | 5832 | 80 |
395210 | 395210 | 2020-08-02 | Williamson | Texas | 48491 | 5715 | 79 |
391994 | 391994 | 2020-08-01 | Williamson | Texas | 48491 | 5715 | 79 |
388777 | 388777 | 2020-07-31 | Williamson | Texas | 48491 | 5715 | 79 |
385560 | 385560 | 2020-07-30 | Williamson | Texas | 48491 | 5616 | 79 |
382342 | 382342 | 2020-07-29 | Williamson | Texas | 48491 | 5551 | 79 |
379125 | 379125 | 2020-07-28 | Williamson | Texas | 48491 | 5433 | 100 |
375909 | 375909 | 2020-07-27 | Williamson | Texas | 48491 | 5366 | 99 |
372696 | 372696 | 2020-07-26 | Williamson | Texas | 48491 | 5304 | 94 |
369484 | 369484 | 2020-07-25 | Williamson | Texas | 48491 | 5246 | 92 |
366275 | 366275 | 2020-07-24 | Williamson | Texas | 48491 | 5203 | 90 |
363069 | 363069 | 2020-07-23 | Williamson | Texas | 48491 | 5145 | 89 |
359862 | 359862 | 2020-07-22 | Williamson | Texas | 48491 | 5071 | 79 |
356657 | 356657 | 2020-07-21 | Williamson | Texas | 48491 | 4981 | 77 |
353454 | 353454 | 2020-07-20 | Williamson | Texas | 48491 | 4888 | 74 |
350252 | 350252 | 2020-07-19 | Williamson | Texas | 48491 | 4792 | 72 |
347052 | 347052 | 2020-07-18 | Williamson | Texas | 48491 | 4686 | 70 |
343851 | 343851 | 2020-07-17 | Williamson | Texas | 48491 | 4490 | 67 |
340652 | 340652 | 2020-07-16 | Williamson | Texas | 48491 | 4420 | 65 |
337456 | 337456 | 2020-07-15 | Williamson | Texas | 48491 | 4327 | 61 |
334261 | 334261 | 2020-07-14 | Williamson | Texas | 48491 | 4153 | 56 |
331068 | 331068 | 2020-07-13 | Williamson | Texas | 48491 | 4042 | 56 |
327882 | 327882 | 2020-07-12 | Williamson | Texas | 48491 | 3810 | 54 |
324697 | 324697 | 2020-07-11 | Williamson | Texas | 48491 | 3745 | 52 |
321516 | 321516 | 2020-07-10 | Williamson | Texas | 48491 | 3654 | 51 |
318337 | 318337 | 2020-07-09 | Williamson | Texas | 48491 | 3617 | 51 |
315164 | 315164 | 2020-07-08 | Williamson | Texas | 48491 | 3442 | 48 |
311990 | 311990 | 2020-07-07 | Williamson | Texas | 48491 | 3318 | 46 |
308821 | 308821 | 2020-07-06 | Williamson | Texas | 48491 | 3151 | 45 |
305653 | 305653 | 2020-07-05 | Williamson | Texas | 48491 | 2469 | 42 |
302489 | 302489 | 2020-07-04 | Williamson | Texas | 48491 | 2469 | 42 |
299325 | 299325 | 2020-07-03 | Williamson | Texas | 48491 | 2469 | 42 |
296163 | 296163 | 2020-07-02 | Williamson | Texas | 48491 | 2388 | 39 |
293008 | 293008 | 2020-07-01 | Williamson | Texas | 48491 | 2339 | 39 |
289855 | 289855 | 2020-06-30 | Williamson | Texas | 48491 | 2230 | 39 |
286705 | 286705 | 2020-06-29 | Williamson | Texas | 48491 | 2100 | 37 |
283559 | 283559 | 2020-06-28 | Williamson | Texas | 48491 | 2019 | 35 |
280413 | 280413 | 2020-06-27 | Williamson | Texas | 48491 | 1850 | 35 |
277265 | 277265 | 2020-06-26 | Williamson | Texas | 48491 | 1770 | 35 |
274117 | 274117 | 2020-06-25 | Williamson | Texas | 48491 | 1702 | 32 |
270977 | 270977 | 2020-06-24 | Williamson | Texas | 48491 | 1614 | 32 |
267843 | 267843 | 2020-06-23 | Williamson | Texas | 48491 | 1498 | 32 |
264714 | 264714 | 2020-06-22 | Williamson | Texas | 48491 | 1411 | 32 |
261585 | 261585 | 2020-06-21 | Williamson | Texas | 48491 | 1337 | 32 |
258458 | 258458 | 2020-06-20 | Williamson | Texas | 48491 | 1237 | 32 |
255331 | 255331 | 2020-06-19 | Williamson | Texas | 48491 | 1159 | 32 |
252214 | 252214 | 2020-06-18 | Williamson | Texas | 48491 | 1114 | 32 |
249099 | 249099 | 2020-06-17 | Williamson | Texas | 48491 | 1068 | 32 |
245986 | 245986 | 2020-06-16 | Williamson | Texas | 48491 | 1021 | 30 |
242874 | 242874 | 2020-06-15 | Williamson | Texas | 48491 | 960 | 30 |
239764 | 239764 | 2020-06-14 | Williamson | Texas | 48491 | 904 | 30 |
236656 | 236656 | 2020-06-13 | Williamson | Texas | 48491 | 862 | 30 |
233549 | 233549 | 2020-06-12 | Williamson | Texas | 48491 | 820 | 30 |
230445 | 230445 | 2020-06-11 | Williamson | Texas | 48491 | 787 | 30 |
227341 | 227341 | 2020-06-10 | Williamson | Texas | 48491 | 763 | 29 |
224241 | 224241 | 2020-06-09 | Williamson | Texas | 48491 | 745 | 29 |
221145 | 221145 | 2020-06-08 | Williamson | Texas | 48491 | 698 | 28 |
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);