ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48453 and state = "Texas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 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
- …
state 1
- Texas · 792 ✖
fips 1
- 48453 · 792 ✖
county 1
- Travis 792
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1891 | 1891 | 2020-03-13 | Travis | Texas | 48453 | 4 | 0 |
2258 | 2258 | 2020-03-14 | Travis | Texas | 48453 | 4 | 0 |
2684 | 2684 | 2020-03-15 | Travis | Texas | 48453 | 6 | 0 |
3153 | 3153 | 2020-03-16 | Travis | Texas | 48453 | 6 | 0 |
3689 | 3689 | 2020-03-17 | Travis | Texas | 48453 | 6 | 0 |
4316 | 4316 | 2020-03-18 | Travis | Texas | 48453 | 6 | 0 |
5071 | 5071 | 2020-03-19 | Travis | Texas | 48453 | 7 | 0 |
5964 | 5964 | 2020-03-20 | Travis | Texas | 48453 | 21 | 0 |
6987 | 6987 | 2020-03-21 | Travis | Texas | 48453 | 62 | 0 |
8117 | 8117 | 2020-03-22 | Travis | Texas | 48453 | 79 | 0 |
9336 | 9336 | 2020-03-23 | Travis | Texas | 48453 | 79 | 0 |
10678 | 10678 | 2020-03-24 | Travis | Texas | 48453 | 79 | 0 |
12186 | 12186 | 2020-03-25 | Travis | Texas | 48453 | 119 | 0 |
13820 | 13820 | 2020-03-26 | Travis | Texas | 48453 | 137 | 0 |
15582 | 15582 | 2020-03-27 | Travis | Texas | 48453 | 160 | 1 |
17453 | 17453 | 2020-03-28 | Travis | Texas | 48453 | 160 | 1 |
19411 | 19411 | 2020-03-29 | Travis | Texas | 48453 | 179 | 1 |
21473 | 21473 | 2020-03-30 | Travis | Texas | 48453 | 206 | 2 |
23612 | 23612 | 2020-03-31 | Travis | Texas | 48453 | 206 | 2 |
25826 | 25826 | 2020-04-01 | Travis | Texas | 48453 | 244 | 2 |
28114 | 28114 | 2020-04-02 | Travis | Texas | 48453 | 305 | 3 |
30451 | 30451 | 2020-04-03 | Travis | Texas | 48453 | 351 | 3 |
32847 | 32847 | 2020-04-04 | Travis | Texas | 48453 | 430 | 6 |
35285 | 35285 | 2020-04-05 | Travis | Texas | 48453 | 460 | 6 |
37762 | 37762 | 2020-04-06 | Travis | Texas | 48453 | 502 | 6 |
40291 | 40291 | 2020-04-07 | Travis | Texas | 48453 | 502 | 6 |
42859 | 42859 | 2020-04-08 | Travis | Texas | 48453 | 596 | 7 |
45453 | 45453 | 2020-04-09 | Travis | Texas | 48453 | 597 | 7 |
48076 | 48076 | 2020-04-10 | Travis | Texas | 48453 | 642 | 7 |
50734 | 50734 | 2020-04-11 | Travis | Texas | 48453 | 690 | 9 |
53409 | 53409 | 2020-04-12 | Travis | Texas | 48453 | 774 | 9 |
56098 | 56098 | 2020-04-13 | Travis | Texas | 48453 | 856 | 11 |
58803 | 58803 | 2020-04-14 | Travis | Texas | 48453 | 900 | 14 |
61521 | 61521 | 2020-04-15 | Travis | Texas | 48453 | 900 | 14 |
64253 | 64253 | 2020-04-16 | Travis | Texas | 48453 | 977 | 17 |
67000 | 67000 | 2020-04-17 | Travis | Texas | 48453 | 1074 | 21 |
69760 | 69760 | 2020-04-18 | Travis | Texas | 48453 | 1092 | 23 |
72530 | 72530 | 2020-04-19 | Travis | Texas | 48453 | 1108 | 25 |
75306 | 75306 | 2020-04-20 | Travis | Texas | 48453 | 1174 | 26 |
78088 | 78088 | 2020-04-21 | Travis | Texas | 48453 | 1233 | 27 |
80879 | 80879 | 2020-04-22 | Travis | Texas | 48453 | 1263 | 28 |
83680 | 83680 | 2020-04-23 | Travis | Texas | 48453 | 1312 | 31 |
86487 | 86487 | 2020-04-24 | Travis | Texas | 48453 | 1379 | 32 |
89302 | 89302 | 2020-04-25 | Travis | Texas | 48453 | 1396 | 36 |
92119 | 92119 | 2020-04-26 | Travis | Texas | 48453 | 1412 | 39 |
94948 | 94948 | 2020-04-27 | Travis | Texas | 48453 | 1464 | 42 |
97790 | 97790 | 2020-04-28 | Travis | Texas | 48453 | 1539 | 42 |
100640 | 100640 | 2020-04-29 | Travis | Texas | 48453 | 1591 | 44 |
103495 | 103495 | 2020-04-30 | Travis | Texas | 48453 | 1654 | 47 |
106359 | 106359 | 2020-05-01 | Travis | Texas | 48453 | 1683 | 51 |
109228 | 109228 | 2020-05-02 | Travis | Texas | 48453 | 1714 | 51 |
112102 | 112102 | 2020-05-03 | Travis | Texas | 48453 | 1756 | 52 |
114985 | 114985 | 2020-05-04 | Travis | Texas | 48453 | 1816 | 53 |
117944 | 117944 | 2020-05-05 | Travis | Texas | 48453 | 1876 | 58 |
120908 | 120908 | 2020-05-06 | Travis | Texas | 48453 | 1946 | 58 |
123888 | 123888 | 2020-05-07 | Travis | Texas | 48453 | 2002 | 59 |
126873 | 126873 | 2020-05-08 | Travis | Texas | 48453 | 2071 | 60 |
129862 | 129862 | 2020-05-09 | Travis | Texas | 48453 | 2095 | 60 |
132852 | 132852 | 2020-05-10 | Travis | Texas | 48453 | 2127 | 60 |
135843 | 135843 | 2020-05-11 | Travis | Texas | 48453 | 2171 | 65 |
138833 | 138833 | 2020-05-12 | Travis | Texas | 48453 | 2235 | 71 |
141829 | 141829 | 2020-05-13 | Travis | Texas | 48453 | 2288 | 72 |
144826 | 144826 | 2020-05-14 | Travis | Texas | 48453 | 2345 | 74 |
147830 | 147830 | 2020-05-15 | Travis | Texas | 48453 | 2381 | 77 |
150838 | 150838 | 2020-05-16 | Travis | Texas | 48453 | 2425 | 77 |
153849 | 153849 | 2020-05-17 | Travis | Texas | 48453 | 2459 | 77 |
156866 | 156866 | 2020-05-18 | Travis | Texas | 48453 | 2537 | 79 |
159890 | 159890 | 2020-05-19 | Travis | Texas | 48453 | 2595 | 81 |
162918 | 162918 | 2020-05-20 | Travis | Texas | 48453 | 2644 | 82 |
165947 | 165947 | 2020-05-21 | Travis | Texas | 48453 | 2712 | 83 |
168983 | 168983 | 2020-05-22 | Travis | Texas | 48453 | 2761 | 83 |
172023 | 172023 | 2020-05-23 | Travis | Texas | 48453 | 2788 | 83 |
175066 | 175066 | 2020-05-24 | Travis | Texas | 48453 | 2847 | 84 |
178111 | 178111 | 2020-05-25 | Travis | Texas | 48453 | 2933 | 85 |
181155 | 181155 | 2020-05-26 | Travis | Texas | 48453 | 2984 | 88 |
184206 | 184206 | 2020-05-27 | Travis | Texas | 48453 | 3057 | 91 |
187263 | 187263 | 2020-05-28 | Travis | Texas | 48453 | 3124 | 92 |
190327 | 190327 | 2020-05-29 | Travis | Texas | 48453 | 3186 | 93 |
193393 | 193393 | 2020-05-30 | Travis | Texas | 48453 | 3232 | 93 |
196463 | 196463 | 2020-05-31 | Travis | Texas | 48453 | 3272 | 93 |
199536 | 199536 | 2020-06-01 | Travis | Texas | 48453 | 3360 | 93 |
202612 | 202612 | 2020-06-02 | Travis | Texas | 48453 | 3433 | 93 |
205691 | 205691 | 2020-06-03 | Travis | Texas | 48453 | 3501 | 95 |
208773 | 208773 | 2020-06-04 | Travis | Texas | 48453 | 3562 | 95 |
211858 | 211858 | 2020-06-05 | Travis | Texas | 48453 | 3616 | 97 |
214945 | 214945 | 2020-06-06 | Travis | Texas | 48453 | 3662 | 97 |
218035 | 218035 | 2020-06-07 | Travis | Texas | 48453 | 3697 | 97 |
221127 | 221127 | 2020-06-08 | Travis | Texas | 48453 | 3815 | 98 |
224223 | 224223 | 2020-06-09 | Travis | Texas | 48453 | 3976 | 99 |
227323 | 227323 | 2020-06-10 | Travis | Texas | 48453 | 4109 | 99 |
230427 | 230427 | 2020-06-11 | Travis | Texas | 48453 | 4238 | 101 |
233531 | 233531 | 2020-06-12 | Travis | Texas | 48453 | 4314 | 104 |
236638 | 236638 | 2020-06-13 | Travis | Texas | 48453 | 4461 | 104 |
239746 | 239746 | 2020-06-14 | Travis | Texas | 48453 | 4545 | 104 |
242856 | 242856 | 2020-06-15 | Travis | Texas | 48453 | 4664 | 106 |
245968 | 245968 | 2020-06-16 | Travis | Texas | 48453 | 4771 | 106 |
249081 | 249081 | 2020-06-17 | Travis | Texas | 48453 | 4991 | 108 |
252196 | 252196 | 2020-06-18 | Travis | Texas | 48453 | 4991 | 108 |
255312 | 255312 | 2020-06-19 | Travis | Texas | 48453 | 5286 | 108 |
258439 | 258439 | 2020-06-20 | Travis | Texas | 48453 | 5704 | 109 |
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);