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
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- …
state 1
- Texas · 787 ✖
fips 1
- 48491 · 787 ✖
county 1
- Williamson 787
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4319 | 4319 | 2020-03-18 | Williamson | Texas | 48491 | 4 | 0 |
5075 | 5075 | 2020-03-19 | Williamson | Texas | 48491 | 8 | 0 |
5969 | 5969 | 2020-03-20 | Williamson | Texas | 48491 | 9 | 0 |
6992 | 6992 | 2020-03-21 | Williamson | Texas | 48491 | 9 | 0 |
8122 | 8122 | 2020-03-22 | Williamson | Texas | 48491 | 9 | 0 |
9341 | 9341 | 2020-03-23 | Williamson | Texas | 48491 | 14 | 0 |
10685 | 10685 | 2020-03-24 | Williamson | Texas | 48491 | 14 | 0 |
12194 | 12194 | 2020-03-25 | Williamson | Texas | 48491 | 22 | 0 |
13829 | 13829 | 2020-03-26 | Williamson | Texas | 48491 | 27 | 0 |
15593 | 15593 | 2020-03-27 | Williamson | Texas | 48491 | 34 | 0 |
17465 | 17465 | 2020-03-28 | Williamson | Texas | 48491 | 34 | 0 |
19424 | 19424 | 2020-03-29 | Williamson | Texas | 48491 | 37 | 1 |
21486 | 21486 | 2020-03-30 | Williamson | Texas | 48491 | 37 | 1 |
23625 | 23625 | 2020-03-31 | Williamson | Texas | 48491 | 42 | 1 |
25839 | 25839 | 2020-04-01 | Williamson | Texas | 48491 | 55 | 1 |
28127 | 28127 | 2020-04-02 | Williamson | Texas | 48491 | 55 | 1 |
30464 | 30464 | 2020-04-03 | Williamson | Texas | 48491 | 71 | 1 |
32862 | 32862 | 2020-04-04 | Williamson | Texas | 48491 | 71 | 1 |
35300 | 35300 | 2020-04-05 | Williamson | Texas | 48491 | 77 | 2 |
37777 | 37777 | 2020-04-06 | Williamson | Texas | 48491 | 81 | 3 |
40306 | 40306 | 2020-04-07 | Williamson | Texas | 48491 | 81 | 3 |
42874 | 42874 | 2020-04-08 | Williamson | Texas | 48491 | 87 | 4 |
45468 | 45468 | 2020-04-09 | Williamson | Texas | 48491 | 103 | 4 |
48091 | 48091 | 2020-04-10 | Williamson | Texas | 48491 | 110 | 4 |
50749 | 50749 | 2020-04-11 | Williamson | Texas | 48491 | 110 | 4 |
53424 | 53424 | 2020-04-12 | Williamson | Texas | 48491 | 117 | 4 |
56113 | 56113 | 2020-04-13 | Williamson | Texas | 48491 | 119 | 4 |
58819 | 58819 | 2020-04-14 | Williamson | Texas | 48491 | 124 | 4 |
61537 | 61537 | 2020-04-15 | Williamson | Texas | 48491 | 128 | 4 |
64269 | 64269 | 2020-04-16 | Williamson | Texas | 48491 | 140 | 4 |
67016 | 67016 | 2020-04-17 | Williamson | Texas | 48491 | 146 | 4 |
69776 | 69776 | 2020-04-18 | Williamson | Texas | 48491 | 151 | 4 |
72546 | 72546 | 2020-04-19 | Williamson | Texas | 48491 | 155 | 4 |
75322 | 75322 | 2020-04-20 | Williamson | Texas | 48491 | 156 | 4 |
78104 | 78104 | 2020-04-21 | Williamson | Texas | 48491 | 158 | 5 |
80896 | 80896 | 2020-04-22 | Williamson | Texas | 48491 | 167 | 5 |
83697 | 83697 | 2020-04-23 | Williamson | Texas | 48491 | 184 | 5 |
86504 | 86504 | 2020-04-24 | Williamson | Texas | 48491 | 206 | 5 |
89319 | 89319 | 2020-04-25 | Williamson | Texas | 48491 | 211 | 6 |
92136 | 92136 | 2020-04-26 | Williamson | Texas | 48491 | 262 | 6 |
94965 | 94965 | 2020-04-27 | Williamson | Texas | 48491 | 287 | 6 |
97807 | 97807 | 2020-04-28 | Williamson | Texas | 48491 | 287 | 7 |
100657 | 100657 | 2020-04-29 | Williamson | Texas | 48491 | 293 | 8 |
103512 | 103512 | 2020-04-30 | Williamson | Texas | 48491 | 301 | 9 |
106376 | 106376 | 2020-05-01 | Williamson | Texas | 48491 | 306 | 10 |
109245 | 109245 | 2020-05-02 | Williamson | Texas | 48491 | 313 | 10 |
112119 | 112119 | 2020-05-03 | Williamson | Texas | 48491 | 323 | 10 |
115002 | 115002 | 2020-05-04 | Williamson | Texas | 48491 | 328 | 10 |
117961 | 117961 | 2020-05-05 | Williamson | Texas | 48491 | 333 | 11 |
120925 | 120925 | 2020-05-06 | Williamson | Texas | 48491 | 341 | 12 |
123905 | 123905 | 2020-05-07 | Williamson | Texas | 48491 | 352 | 12 |
126890 | 126890 | 2020-05-08 | Williamson | Texas | 48491 | 361 | 12 |
129879 | 129879 | 2020-05-09 | Williamson | Texas | 48491 | 368 | 13 |
132869 | 132869 | 2020-05-10 | Williamson | Texas | 48491 | 377 | 13 |
135860 | 135860 | 2020-05-11 | Williamson | Texas | 48491 | 380 | 14 |
138850 | 138850 | 2020-05-12 | Williamson | Texas | 48491 | 397 | 16 |
141846 | 141846 | 2020-05-13 | Williamson | Texas | 48491 | 424 | 16 |
144843 | 144843 | 2020-05-14 | Williamson | Texas | 48491 | 442 | 19 |
147847 | 147847 | 2020-05-15 | Williamson | Texas | 48491 | 451 | 19 |
150855 | 150855 | 2020-05-16 | Williamson | Texas | 48491 | 463 | 19 |
153866 | 153866 | 2020-05-17 | Williamson | Texas | 48491 | 481 | 19 |
156883 | 156883 | 2020-05-18 | Williamson | Texas | 48491 | 486 | 19 |
159907 | 159907 | 2020-05-19 | Williamson | Texas | 48491 | 501 | 20 |
162935 | 162935 | 2020-05-20 | Williamson | Texas | 48491 | 513 | 20 |
165964 | 165964 | 2020-05-21 | Williamson | Texas | 48491 | 520 | 20 |
169000 | 169000 | 2020-05-22 | Williamson | Texas | 48491 | 528 | 21 |
172041 | 172041 | 2020-05-23 | Williamson | Texas | 48491 | 541 | 21 |
175084 | 175084 | 2020-05-24 | Williamson | Texas | 48491 | 553 | 21 |
178129 | 178129 | 2020-05-25 | Williamson | Texas | 48491 | 565 | 22 |
181173 | 181173 | 2020-05-26 | Williamson | Texas | 48491 | 584 | 22 |
184224 | 184224 | 2020-05-27 | Williamson | Texas | 48491 | 588 | 22 |
187281 | 187281 | 2020-05-28 | Williamson | Texas | 48491 | 596 | 23 |
190345 | 190345 | 2020-05-29 | Williamson | Texas | 48491 | 605 | 24 |
193411 | 193411 | 2020-05-30 | Williamson | Texas | 48491 | 612 | 24 |
196481 | 196481 | 2020-05-31 | Williamson | Texas | 48491 | 621 | 24 |
199554 | 199554 | 2020-06-01 | Williamson | Texas | 48491 | 630 | 25 |
202630 | 202630 | 2020-06-02 | Williamson | Texas | 48491 | 636 | 25 |
205709 | 205709 | 2020-06-03 | Williamson | Texas | 48491 | 649 | 25 |
208791 | 208791 | 2020-06-04 | Williamson | Texas | 48491 | 660 | 27 |
211876 | 211876 | 2020-06-05 | Williamson | Texas | 48491 | 672 | 27 |
214963 | 214963 | 2020-06-06 | Williamson | Texas | 48491 | 684 | 28 |
218053 | 218053 | 2020-06-07 | Williamson | Texas | 48491 | 691 | 28 |
221145 | 221145 | 2020-06-08 | Williamson | Texas | 48491 | 698 | 28 |
224241 | 224241 | 2020-06-09 | Williamson | Texas | 48491 | 745 | 29 |
227341 | 227341 | 2020-06-10 | Williamson | Texas | 48491 | 763 | 29 |
230445 | 230445 | 2020-06-11 | Williamson | Texas | 48491 | 787 | 30 |
233549 | 233549 | 2020-06-12 | Williamson | Texas | 48491 | 820 | 30 |
236656 | 236656 | 2020-06-13 | Williamson | Texas | 48491 | 862 | 30 |
239764 | 239764 | 2020-06-14 | Williamson | Texas | 48491 | 904 | 30 |
242874 | 242874 | 2020-06-15 | Williamson | Texas | 48491 | 960 | 30 |
245986 | 245986 | 2020-06-16 | Williamson | Texas | 48491 | 1021 | 30 |
249099 | 249099 | 2020-06-17 | Williamson | Texas | 48491 | 1068 | 32 |
252214 | 252214 | 2020-06-18 | Williamson | Texas | 48491 | 1114 | 32 |
255331 | 255331 | 2020-06-19 | Williamson | Texas | 48491 | 1159 | 32 |
258458 | 258458 | 2020-06-20 | Williamson | Texas | 48491 | 1237 | 32 |
261585 | 261585 | 2020-06-21 | Williamson | Texas | 48491 | 1337 | 32 |
264714 | 264714 | 2020-06-22 | Williamson | Texas | 48491 | 1411 | 32 |
267843 | 267843 | 2020-06-23 | Williamson | Texas | 48491 | 1498 | 32 |
270977 | 270977 | 2020-06-24 | Williamson | Texas | 48491 | 1614 | 32 |
274117 | 274117 | 2020-06-25 | Williamson | Texas | 48491 | 1702 | 32 |
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);