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 |
---|---|---|---|---|---|---|---|
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 |
218053 | 218053 | 2020-06-07 | Williamson | Texas | 48491 | 691 | 28 |
214963 | 214963 | 2020-06-06 | Williamson | Texas | 48491 | 684 | 28 |
211876 | 211876 | 2020-06-05 | Williamson | Texas | 48491 | 672 | 27 |
208791 | 208791 | 2020-06-04 | Williamson | Texas | 48491 | 660 | 27 |
205709 | 205709 | 2020-06-03 | Williamson | Texas | 48491 | 649 | 25 |
202630 | 202630 | 2020-06-02 | Williamson | Texas | 48491 | 636 | 25 |
199554 | 199554 | 2020-06-01 | Williamson | Texas | 48491 | 630 | 25 |
196481 | 196481 | 2020-05-31 | Williamson | Texas | 48491 | 621 | 24 |
193411 | 193411 | 2020-05-30 | Williamson | Texas | 48491 | 612 | 24 |
190345 | 190345 | 2020-05-29 | Williamson | Texas | 48491 | 605 | 24 |
187281 | 187281 | 2020-05-28 | Williamson | Texas | 48491 | 596 | 23 |
184224 | 184224 | 2020-05-27 | Williamson | Texas | 48491 | 588 | 22 |
181173 | 181173 | 2020-05-26 | Williamson | Texas | 48491 | 584 | 22 |
178129 | 178129 | 2020-05-25 | Williamson | Texas | 48491 | 565 | 22 |
175084 | 175084 | 2020-05-24 | Williamson | Texas | 48491 | 553 | 21 |
172041 | 172041 | 2020-05-23 | Williamson | Texas | 48491 | 541 | 21 |
169000 | 169000 | 2020-05-22 | Williamson | Texas | 48491 | 528 | 21 |
165964 | 165964 | 2020-05-21 | Williamson | Texas | 48491 | 520 | 20 |
162935 | 162935 | 2020-05-20 | Williamson | Texas | 48491 | 513 | 20 |
159907 | 159907 | 2020-05-19 | Williamson | Texas | 48491 | 501 | 20 |
156883 | 156883 | 2020-05-18 | Williamson | Texas | 48491 | 486 | 19 |
153866 | 153866 | 2020-05-17 | Williamson | Texas | 48491 | 481 | 19 |
150855 | 150855 | 2020-05-16 | Williamson | Texas | 48491 | 463 | 19 |
147847 | 147847 | 2020-05-15 | Williamson | Texas | 48491 | 451 | 19 |
144843 | 144843 | 2020-05-14 | Williamson | Texas | 48491 | 442 | 19 |
141846 | 141846 | 2020-05-13 | Williamson | Texas | 48491 | 424 | 16 |
138850 | 138850 | 2020-05-12 | Williamson | Texas | 48491 | 397 | 16 |
135860 | 135860 | 2020-05-11 | Williamson | Texas | 48491 | 380 | 14 |
132869 | 132869 | 2020-05-10 | Williamson | Texas | 48491 | 377 | 13 |
129879 | 129879 | 2020-05-09 | Williamson | Texas | 48491 | 368 | 13 |
126890 | 126890 | 2020-05-08 | Williamson | Texas | 48491 | 361 | 12 |
123905 | 123905 | 2020-05-07 | Williamson | Texas | 48491 | 352 | 12 |
120925 | 120925 | 2020-05-06 | Williamson | Texas | 48491 | 341 | 12 |
117961 | 117961 | 2020-05-05 | Williamson | Texas | 48491 | 333 | 11 |
115002 | 115002 | 2020-05-04 | Williamson | Texas | 48491 | 328 | 10 |
112119 | 112119 | 2020-05-03 | Williamson | Texas | 48491 | 323 | 10 |
109245 | 109245 | 2020-05-02 | Williamson | Texas | 48491 | 313 | 10 |
106376 | 106376 | 2020-05-01 | Williamson | Texas | 48491 | 306 | 10 |
103512 | 103512 | 2020-04-30 | Williamson | Texas | 48491 | 301 | 9 |
100657 | 100657 | 2020-04-29 | Williamson | Texas | 48491 | 293 | 8 |
97807 | 97807 | 2020-04-28 | Williamson | Texas | 48491 | 287 | 7 |
94965 | 94965 | 2020-04-27 | Williamson | Texas | 48491 | 287 | 6 |
92136 | 92136 | 2020-04-26 | Williamson | Texas | 48491 | 262 | 6 |
89319 | 89319 | 2020-04-25 | Williamson | Texas | 48491 | 211 | 6 |
86504 | 86504 | 2020-04-24 | Williamson | Texas | 48491 | 206 | 5 |
83697 | 83697 | 2020-04-23 | Williamson | Texas | 48491 | 184 | 5 |
80896 | 80896 | 2020-04-22 | Williamson | Texas | 48491 | 167 | 5 |
78104 | 78104 | 2020-04-21 | Williamson | Texas | 48491 | 158 | 5 |
75322 | 75322 | 2020-04-20 | Williamson | Texas | 48491 | 156 | 4 |
72546 | 72546 | 2020-04-19 | Williamson | Texas | 48491 | 155 | 4 |
69776 | 69776 | 2020-04-18 | Williamson | Texas | 48491 | 151 | 4 |
67016 | 67016 | 2020-04-17 | Williamson | Texas | 48491 | 146 | 4 |
64269 | 64269 | 2020-04-16 | Williamson | Texas | 48491 | 140 | 4 |
61537 | 61537 | 2020-04-15 | Williamson | Texas | 48491 | 128 | 4 |
58819 | 58819 | 2020-04-14 | Williamson | Texas | 48491 | 124 | 4 |
56113 | 56113 | 2020-04-13 | Williamson | Texas | 48491 | 119 | 4 |
53424 | 53424 | 2020-04-12 | Williamson | Texas | 48491 | 117 | 4 |
50749 | 50749 | 2020-04-11 | Williamson | Texas | 48491 | 110 | 4 |
48091 | 48091 | 2020-04-10 | Williamson | Texas | 48491 | 110 | 4 |
45468 | 45468 | 2020-04-09 | Williamson | Texas | 48491 | 103 | 4 |
42874 | 42874 | 2020-04-08 | Williamson | Texas | 48491 | 87 | 4 |
40306 | 40306 | 2020-04-07 | Williamson | Texas | 48491 | 81 | 3 |
37777 | 37777 | 2020-04-06 | Williamson | Texas | 48491 | 81 | 3 |
35300 | 35300 | 2020-04-05 | Williamson | Texas | 48491 | 77 | 2 |
32862 | 32862 | 2020-04-04 | Williamson | Texas | 48491 | 71 | 1 |
30464 | 30464 | 2020-04-03 | Williamson | Texas | 48491 | 71 | 1 |
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);