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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324678 | 324678 | 2020-07-11 | Travis | Texas | 48453 | 14622 | 168 |
321497 | 321497 | 2020-07-10 | Travis | Texas | 48453 | 14304 | 166 |
318318 | 318318 | 2020-07-09 | Travis | Texas | 48453 | 13864 | 159 |
315145 | 315145 | 2020-07-08 | Travis | Texas | 48453 | 13161 | 159 |
311971 | 311971 | 2020-07-07 | Travis | Texas | 48453 | 12408 | 151 |
308802 | 308802 | 2020-07-06 | Travis | Texas | 48453 | 11926 | 144 |
305634 | 305634 | 2020-07-05 | Travis | Texas | 48453 | 11679 | 137 |
302470 | 302470 | 2020-07-04 | Travis | Texas | 48453 | 11131 | 136 |
299306 | 299306 | 2020-07-03 | Travis | Texas | 48453 | 11009 | 134 |
296144 | 296144 | 2020-07-02 | Travis | Texas | 48453 | 10695 | 133 |
292989 | 292989 | 2020-07-01 | Travis | Texas | 48453 | 10124 | 128 |
289836 | 289836 | 2020-06-30 | Travis | Texas | 48453 | 9527 | 124 |
286686 | 286686 | 2020-06-29 | Travis | Texas | 48453 | 8969 | 121 |
283540 | 283540 | 2020-06-28 | Travis | Texas | 48453 | 8461 | 117 |
280394 | 280394 | 2020-06-27 | Travis | Texas | 48453 | 7825 | 117 |
277246 | 277246 | 2020-06-26 | Travis | Texas | 48453 | 7097 | 116 |
274098 | 274098 | 2020-06-25 | Travis | Texas | 48453 | 7097 | 116 |
270958 | 270958 | 2020-06-24 | Travis | Texas | 48453 | 6914 | 116 |
267824 | 267824 | 2020-06-23 | Travis | Texas | 48453 | 6596 | 114 |
264695 | 264695 | 2020-06-22 | Travis | Texas | 48453 | 6339 | 112 |
261566 | 261566 | 2020-06-21 | Travis | Texas | 48453 | 6210 | 110 |
258439 | 258439 | 2020-06-20 | Travis | Texas | 48453 | 5704 | 109 |
255312 | 255312 | 2020-06-19 | Travis | Texas | 48453 | 5286 | 108 |
252196 | 252196 | 2020-06-18 | Travis | Texas | 48453 | 4991 | 108 |
249081 | 249081 | 2020-06-17 | Travis | Texas | 48453 | 4991 | 108 |
245968 | 245968 | 2020-06-16 | Travis | Texas | 48453 | 4771 | 106 |
242856 | 242856 | 2020-06-15 | Travis | Texas | 48453 | 4664 | 106 |
239746 | 239746 | 2020-06-14 | Travis | Texas | 48453 | 4545 | 104 |
236638 | 236638 | 2020-06-13 | Travis | Texas | 48453 | 4461 | 104 |
233531 | 233531 | 2020-06-12 | Travis | Texas | 48453 | 4314 | 104 |
230427 | 230427 | 2020-06-11 | Travis | Texas | 48453 | 4238 | 101 |
227323 | 227323 | 2020-06-10 | Travis | Texas | 48453 | 4109 | 99 |
224223 | 224223 | 2020-06-09 | Travis | Texas | 48453 | 3976 | 99 |
221127 | 221127 | 2020-06-08 | Travis | Texas | 48453 | 3815 | 98 |
218035 | 218035 | 2020-06-07 | Travis | Texas | 48453 | 3697 | 97 |
214945 | 214945 | 2020-06-06 | Travis | Texas | 48453 | 3662 | 97 |
211858 | 211858 | 2020-06-05 | Travis | Texas | 48453 | 3616 | 97 |
208773 | 208773 | 2020-06-04 | Travis | Texas | 48453 | 3562 | 95 |
205691 | 205691 | 2020-06-03 | Travis | Texas | 48453 | 3501 | 95 |
202612 | 202612 | 2020-06-02 | Travis | Texas | 48453 | 3433 | 93 |
199536 | 199536 | 2020-06-01 | Travis | Texas | 48453 | 3360 | 93 |
196463 | 196463 | 2020-05-31 | Travis | Texas | 48453 | 3272 | 93 |
193393 | 193393 | 2020-05-30 | Travis | Texas | 48453 | 3232 | 93 |
190327 | 190327 | 2020-05-29 | Travis | Texas | 48453 | 3186 | 93 |
187263 | 187263 | 2020-05-28 | Travis | Texas | 48453 | 3124 | 92 |
184206 | 184206 | 2020-05-27 | Travis | Texas | 48453 | 3057 | 91 |
181155 | 181155 | 2020-05-26 | Travis | Texas | 48453 | 2984 | 88 |
178111 | 178111 | 2020-05-25 | Travis | Texas | 48453 | 2933 | 85 |
175066 | 175066 | 2020-05-24 | Travis | Texas | 48453 | 2847 | 84 |
172023 | 172023 | 2020-05-23 | Travis | Texas | 48453 | 2788 | 83 |
168983 | 168983 | 2020-05-22 | Travis | Texas | 48453 | 2761 | 83 |
165947 | 165947 | 2020-05-21 | Travis | Texas | 48453 | 2712 | 83 |
162918 | 162918 | 2020-05-20 | Travis | Texas | 48453 | 2644 | 82 |
159890 | 159890 | 2020-05-19 | Travis | Texas | 48453 | 2595 | 81 |
156866 | 156866 | 2020-05-18 | Travis | Texas | 48453 | 2537 | 79 |
153849 | 153849 | 2020-05-17 | Travis | Texas | 48453 | 2459 | 77 |
150838 | 150838 | 2020-05-16 | Travis | Texas | 48453 | 2425 | 77 |
147830 | 147830 | 2020-05-15 | Travis | Texas | 48453 | 2381 | 77 |
144826 | 144826 | 2020-05-14 | Travis | Texas | 48453 | 2345 | 74 |
141829 | 141829 | 2020-05-13 | Travis | Texas | 48453 | 2288 | 72 |
138833 | 138833 | 2020-05-12 | Travis | Texas | 48453 | 2235 | 71 |
135843 | 135843 | 2020-05-11 | Travis | Texas | 48453 | 2171 | 65 |
132852 | 132852 | 2020-05-10 | Travis | Texas | 48453 | 2127 | 60 |
129862 | 129862 | 2020-05-09 | Travis | Texas | 48453 | 2095 | 60 |
126873 | 126873 | 2020-05-08 | Travis | Texas | 48453 | 2071 | 60 |
123888 | 123888 | 2020-05-07 | Travis | Texas | 48453 | 2002 | 59 |
120908 | 120908 | 2020-05-06 | Travis | Texas | 48453 | 1946 | 58 |
117944 | 117944 | 2020-05-05 | Travis | Texas | 48453 | 1876 | 58 |
114985 | 114985 | 2020-05-04 | Travis | Texas | 48453 | 1816 | 53 |
112102 | 112102 | 2020-05-03 | Travis | Texas | 48453 | 1756 | 52 |
109228 | 109228 | 2020-05-02 | Travis | Texas | 48453 | 1714 | 51 |
106359 | 106359 | 2020-05-01 | Travis | Texas | 48453 | 1683 | 51 |
103495 | 103495 | 2020-04-30 | Travis | Texas | 48453 | 1654 | 47 |
100640 | 100640 | 2020-04-29 | Travis | Texas | 48453 | 1591 | 44 |
97790 | 97790 | 2020-04-28 | Travis | Texas | 48453 | 1539 | 42 |
94948 | 94948 | 2020-04-27 | Travis | Texas | 48453 | 1464 | 42 |
92119 | 92119 | 2020-04-26 | Travis | Texas | 48453 | 1412 | 39 |
89302 | 89302 | 2020-04-25 | Travis | Texas | 48453 | 1396 | 36 |
86487 | 86487 | 2020-04-24 | Travis | Texas | 48453 | 1379 | 32 |
83680 | 83680 | 2020-04-23 | Travis | Texas | 48453 | 1312 | 31 |
80879 | 80879 | 2020-04-22 | Travis | Texas | 48453 | 1263 | 28 |
78088 | 78088 | 2020-04-21 | Travis | Texas | 48453 | 1233 | 27 |
75306 | 75306 | 2020-04-20 | Travis | Texas | 48453 | 1174 | 26 |
72530 | 72530 | 2020-04-19 | Travis | Texas | 48453 | 1108 | 25 |
69760 | 69760 | 2020-04-18 | Travis | Texas | 48453 | 1092 | 23 |
67000 | 67000 | 2020-04-17 | Travis | Texas | 48453 | 1074 | 21 |
64253 | 64253 | 2020-04-16 | Travis | Texas | 48453 | 977 | 17 |
61521 | 61521 | 2020-04-15 | Travis | Texas | 48453 | 900 | 14 |
58803 | 58803 | 2020-04-14 | Travis | Texas | 48453 | 900 | 14 |
56098 | 56098 | 2020-04-13 | Travis | Texas | 48453 | 856 | 11 |
53409 | 53409 | 2020-04-12 | Travis | Texas | 48453 | 774 | 9 |
50734 | 50734 | 2020-04-11 | Travis | Texas | 48453 | 690 | 9 |
48076 | 48076 | 2020-04-10 | Travis | Texas | 48453 | 642 | 7 |
45453 | 45453 | 2020-04-09 | Travis | Texas | 48453 | 597 | 7 |
42859 | 42859 | 2020-04-08 | Travis | Texas | 48453 | 596 | 7 |
40291 | 40291 | 2020-04-07 | Travis | Texas | 48453 | 502 | 6 |
37762 | 37762 | 2020-04-06 | Travis | Texas | 48453 | 502 | 6 |
35285 | 35285 | 2020-04-05 | Travis | Texas | 48453 | 460 | 6 |
32847 | 32847 | 2020-04-04 | Travis | Texas | 48453 | 430 | 6 |
30451 | 30451 | 2020-04-03 | Travis | Texas | 48453 | 351 | 3 |
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);