ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48113 and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1134 | 1134 | 2020-03-10 | Dallas | Texas | 48113 | 2 | 0 |
1330 | 1330 | 2020-03-11 | Dallas | Texas | 48113 | 3 | 0 |
1577 | 1577 | 2020-03-12 | Dallas | Texas | 48113 | 8 | 0 |
1882 | 1882 | 2020-03-13 | Dallas | Texas | 48113 | 9 | 0 |
2248 | 2248 | 2020-03-14 | Dallas | Texas | 48113 | 11 | 0 |
2673 | 2673 | 2020-03-15 | Dallas | Texas | 48113 | 14 | 0 |
3141 | 3141 | 2020-03-16 | Dallas | Texas | 48113 | 14 | 0 |
3675 | 3675 | 2020-03-17 | Dallas | Texas | 48113 | 23 | 0 |
4298 | 4298 | 2020-03-18 | Dallas | Texas | 48113 | 34 | 0 |
5051 | 5051 | 2020-03-19 | Dallas | Texas | 48113 | 56 | 1 |
5942 | 5942 | 2020-03-20 | Dallas | Texas | 48113 | 74 | 1 |
6961 | 6961 | 2020-03-21 | Dallas | Texas | 48113 | 95 | 1 |
8091 | 8091 | 2020-03-22 | Dallas | Texas | 48113 | 132 | 2 |
9309 | 9309 | 2020-03-23 | Dallas | Texas | 48113 | 159 | 2 |
10645 | 10645 | 2020-03-24 | Dallas | Texas | 48113 | 169 | 5 |
12130 | 12130 | 2020-03-25 | Dallas | Texas | 48113 | 169 | 6 |
13759 | 13759 | 2020-03-26 | Dallas | Texas | 48113 | 303 | 7 |
15513 | 15513 | 2020-03-27 | Dallas | Texas | 48113 | 367 | 7 |
17382 | 17382 | 2020-03-28 | Dallas | Texas | 48113 | 439 | 9 |
19332 | 19332 | 2020-03-29 | Dallas | Texas | 48113 | 443 | 9 |
21391 | 21391 | 2020-03-30 | Dallas | Texas | 48113 | 549 | 11 |
23530 | 23530 | 2020-03-31 | Dallas | Texas | 48113 | 631 | 13 |
25738 | 25738 | 2020-04-01 | Dallas | Texas | 48113 | 731 | 15 |
28018 | 28018 | 2020-04-02 | Dallas | Texas | 48113 | 831 | 17 |
30353 | 30353 | 2020-04-03 | Dallas | Texas | 48113 | 921 | 17 |
32746 | 32746 | 2020-04-04 | Dallas | Texas | 48113 | 1015 | 18 |
35184 | 35184 | 2020-04-05 | Dallas | Texas | 48113 | 1112 | 18 |
37660 | 37660 | 2020-04-06 | Dallas | Texas | 48113 | 1155 | 18 |
40185 | 40185 | 2020-04-07 | Dallas | Texas | 48113 | 1261 | 19 |
42748 | 42748 | 2020-04-08 | Dallas | Texas | 48113 | 1324 | 20 |
45337 | 45337 | 2020-04-09 | Dallas | Texas | 48113 | 1432 | 22 |
47957 | 47957 | 2020-04-10 | Dallas | Texas | 48113 | 1537 | 25 |
50614 | 50614 | 2020-04-11 | Dallas | Texas | 48113 | 1648 | 27 |
53289 | 53289 | 2020-04-12 | Dallas | Texas | 48113 | 1723 | 31 |
55977 | 55977 | 2020-04-13 | Dallas | Texas | 48113 | 1788 | 32 |
58681 | 58681 | 2020-04-14 | Dallas | Texas | 48113 | 1877 | 42 |
61398 | 61398 | 2020-04-15 | Dallas | Texas | 48113 | 1986 | 43 |
64125 | 64125 | 2020-04-16 | Dallas | Texas | 48113 | 2066 | 50 |
66872 | 66872 | 2020-04-17 | Dallas | Texas | 48113 | 2190 | 55 |
69632 | 69632 | 2020-04-18 | Dallas | Texas | 48113 | 2324 | 60 |
72400 | 72400 | 2020-04-19 | Dallas | Texas | 48113 | 2428 | 60 |
75175 | 75175 | 2020-04-20 | Dallas | Texas | 48113 | 2512 | 60 |
77957 | 77957 | 2020-04-21 | Dallas | Texas | 48113 | 2602 | 64 |
80748 | 80748 | 2020-04-22 | Dallas | Texas | 48113 | 2683 | 65 |
83548 | 83548 | 2020-04-23 | Dallas | Texas | 48113 | 2763 | 72 |
86353 | 86353 | 2020-04-24 | Dallas | Texas | 48113 | 2834 | 77 |
89168 | 89168 | 2020-04-25 | Dallas | Texas | 48113 | 2909 | 81 |
91985 | 91985 | 2020-04-26 | Dallas | Texas | 48113 | 3014 | 82 |
94814 | 94814 | 2020-04-27 | Dallas | Texas | 48113 | 3105 | 84 |
97654 | 97654 | 2020-04-28 | Dallas | Texas | 48113 | 3240 | 94 |
100504 | 100504 | 2020-04-29 | Dallas | Texas | 48113 | 3352 | 99 |
103357 | 103357 | 2020-04-30 | Dallas | Texas | 48113 | 3531 | 104 |
106221 | 106221 | 2020-05-01 | Dallas | Texas | 48113 | 3718 | 106 |
109090 | 109090 | 2020-05-02 | Dallas | Texas | 48113 | 3899 | 110 |
111964 | 111964 | 2020-05-03 | Dallas | Texas | 48113 | 4133 | 111 |
114846 | 114846 | 2020-05-04 | Dallas | Texas | 48113 | 4370 | 114 |
117805 | 117805 | 2020-05-05 | Dallas | Texas | 48113 | 4623 | 121 |
120769 | 120769 | 2020-05-06 | Dallas | Texas | 48113 | 4869 | 123 |
123748 | 123748 | 2020-05-07 | Dallas | Texas | 48113 | 5120 | 125 |
126731 | 126731 | 2020-05-08 | Dallas | Texas | 48113 | 5369 | 135 |
129720 | 129720 | 2020-05-09 | Dallas | Texas | 48113 | 5619 | 143 |
132710 | 132710 | 2020-05-10 | Dallas | Texas | 48113 | 5870 | 143 |
135701 | 135701 | 2020-05-11 | Dallas | Texas | 48113 | 6123 | 145 |
138691 | 138691 | 2020-05-12 | Dallas | Texas | 48113 | 6359 | 148 |
141687 | 141687 | 2020-05-13 | Dallas | Texas | 48113 | 6602 | 153 |
144684 | 144684 | 2020-05-14 | Dallas | Texas | 48113 | 6837 | 159 |
147686 | 147686 | 2020-05-15 | Dallas | Texas | 48113 | 7036 | 164 |
150694 | 150694 | 2020-05-16 | Dallas | Texas | 48113 | 7250 | 170 |
153705 | 153705 | 2020-05-17 | Dallas | Texas | 48113 | 7455 | 176 |
156722 | 156722 | 2020-05-18 | Dallas | Texas | 48113 | 7679 | 177 |
159744 | 159744 | 2020-05-19 | Dallas | Texas | 48113 | 7904 | 191 |
162771 | 162771 | 2020-05-20 | Dallas | Texas | 48113 | 8090 | 196 |
165800 | 165800 | 2020-05-21 | Dallas | Texas | 48113 | 8273 | 203 |
168836 | 168836 | 2020-05-22 | Dallas | Texas | 48113 | 8477 | 207 |
171875 | 171875 | 2020-05-23 | Dallas | Texas | 48113 | 8649 | 210 |
174918 | 174918 | 2020-05-24 | Dallas | Texas | 48113 | 8827 | 211 |
177962 | 177962 | 2020-05-25 | Dallas | Texas | 48113 | 8998 | 211 |
181005 | 181005 | 2020-05-26 | Dallas | Texas | 48113 | 9188 | 213 |
184055 | 184055 | 2020-05-27 | Dallas | Texas | 48113 | 9385 | 221 |
187112 | 187112 | 2020-05-28 | Dallas | Texas | 48113 | 9587 | 222 |
190176 | 190176 | 2020-05-29 | Dallas | Texas | 48113 | 9787 | 223 |
193241 | 193241 | 2020-05-30 | Dallas | Texas | 48113 | 10006 | 228 |
196311 | 196311 | 2020-05-31 | Dallas | Texas | 48113 | 10234 | 229 |
199384 | 199384 | 2020-06-01 | Dallas | Texas | 48113 | 10462 | 229 |
202459 | 202459 | 2020-06-02 | Dallas | Texas | 48113 | 10719 | 245 |
205538 | 205538 | 2020-06-03 | Dallas | Texas | 48113 | 10958 | 249 |
208620 | 208620 | 2020-06-04 | Dallas | Texas | 48113 | 11243 | 250 |
211704 | 211704 | 2020-06-05 | Dallas | Texas | 48113 | 11541 | 260 |
214791 | 214791 | 2020-06-06 | Dallas | Texas | 48113 | 11830 | 262 |
217881 | 217881 | 2020-06-07 | Dallas | Texas | 48113 | 12093 | 264 |
220973 | 220973 | 2020-06-08 | Dallas | Texas | 48113 | 12347 | 264 |
224068 | 224068 | 2020-06-09 | Dallas | Texas | 48113 | 12645 | 271 |
227168 | 227168 | 2020-06-10 | Dallas | Texas | 48113 | 12945 | 274 |
230272 | 230272 | 2020-06-11 | Dallas | Texas | 48113 | 13257 | 277 |
233376 | 233376 | 2020-06-12 | Dallas | Texas | 48113 | 13585 | 280 |
236482 | 236482 | 2020-06-13 | Dallas | Texas | 48113 | 13930 | 283 |
239590 | 239590 | 2020-06-14 | Dallas | Texas | 48113 | 14232 | 284 |
242700 | 242700 | 2020-06-15 | Dallas | Texas | 48113 | 14537 | 285 |
245812 | 245812 | 2020-06-16 | Dallas | Texas | 48113 | 14843 | 293 |
248925 | 248925 | 2020-06-17 | Dallas | Texas | 48113 | 15256 | 302 |
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);