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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324514 | 324514 | 2020-07-11 | Dallas | Texas | 48113 | 32626 | 449 |
321333 | 321333 | 2020-07-10 | Dallas | Texas | 48113 | 31525 | 445 |
318155 | 318155 | 2020-07-09 | Dallas | Texas | 48113 | 30361 | 436 |
314982 | 314982 | 2020-07-08 | Dallas | Texas | 48113 | 29160 | 426 |
311808 | 311808 | 2020-07-07 | Dallas | Texas | 48113 | 28131 | 410 |
308639 | 308639 | 2020-07-06 | Dallas | Texas | 48113 | 27054 | 401 |
305471 | 305471 | 2020-07-05 | Dallas | Texas | 48113 | 25840 | 395 |
302307 | 302307 | 2020-07-04 | Dallas | Texas | 48113 | 24778 | 395 |
299143 | 299143 | 2020-07-03 | Dallas | Texas | 48113 | 23675 | 393 |
295983 | 295983 | 2020-07-02 | Dallas | Texas | 48113 | 22590 | 387 |
292828 | 292828 | 2020-07-01 | Dallas | Texas | 48113 | 21882 | 380 |
289675 | 289675 | 2020-06-30 | Dallas | Texas | 48113 | 21338 | 373 |
286525 | 286525 | 2020-06-29 | Dallas | Texas | 48113 | 20737 | 353 |
283379 | 283379 | 2020-06-28 | Dallas | Texas | 48113 | 20165 | 352 |
280233 | 280233 | 2020-06-27 | Dallas | Texas | 48113 | 19595 | 351 |
277085 | 277085 | 2020-06-26 | Dallas | Texas | 48113 | 19034 | 344 |
273938 | 273938 | 2020-06-25 | Dallas | Texas | 48113 | 18538 | 334 |
270799 | 270799 | 2020-06-24 | Dallas | Texas | 48113 | 18135 | 328 |
267665 | 267665 | 2020-06-23 | Dallas | Texas | 48113 | 17744 | 324 |
264537 | 264537 | 2020-06-22 | Dallas | Texas | 48113 | 17299 | 317 |
261409 | 261409 | 2020-06-21 | Dallas | Texas | 48113 | 16845 | 314 |
258282 | 258282 | 2020-06-20 | Dallas | Texas | 48113 | 16437 | 313 |
255155 | 255155 | 2020-06-19 | Dallas | Texas | 48113 | 16042 | 311 |
252040 | 252040 | 2020-06-18 | Dallas | Texas | 48113 | 15648 | 307 |
248925 | 248925 | 2020-06-17 | Dallas | Texas | 48113 | 15256 | 302 |
245812 | 245812 | 2020-06-16 | Dallas | Texas | 48113 | 14843 | 293 |
242700 | 242700 | 2020-06-15 | Dallas | Texas | 48113 | 14537 | 285 |
239590 | 239590 | 2020-06-14 | Dallas | Texas | 48113 | 14232 | 284 |
236482 | 236482 | 2020-06-13 | Dallas | Texas | 48113 | 13930 | 283 |
233376 | 233376 | 2020-06-12 | Dallas | Texas | 48113 | 13585 | 280 |
230272 | 230272 | 2020-06-11 | Dallas | Texas | 48113 | 13257 | 277 |
227168 | 227168 | 2020-06-10 | Dallas | Texas | 48113 | 12945 | 274 |
224068 | 224068 | 2020-06-09 | Dallas | Texas | 48113 | 12645 | 271 |
220973 | 220973 | 2020-06-08 | Dallas | Texas | 48113 | 12347 | 264 |
217881 | 217881 | 2020-06-07 | Dallas | Texas | 48113 | 12093 | 264 |
214791 | 214791 | 2020-06-06 | Dallas | Texas | 48113 | 11830 | 262 |
211704 | 211704 | 2020-06-05 | Dallas | Texas | 48113 | 11541 | 260 |
208620 | 208620 | 2020-06-04 | Dallas | Texas | 48113 | 11243 | 250 |
205538 | 205538 | 2020-06-03 | Dallas | Texas | 48113 | 10958 | 249 |
202459 | 202459 | 2020-06-02 | Dallas | Texas | 48113 | 10719 | 245 |
199384 | 199384 | 2020-06-01 | Dallas | Texas | 48113 | 10462 | 229 |
196311 | 196311 | 2020-05-31 | Dallas | Texas | 48113 | 10234 | 229 |
193241 | 193241 | 2020-05-30 | Dallas | Texas | 48113 | 10006 | 228 |
190176 | 190176 | 2020-05-29 | Dallas | Texas | 48113 | 9787 | 223 |
187112 | 187112 | 2020-05-28 | Dallas | Texas | 48113 | 9587 | 222 |
184055 | 184055 | 2020-05-27 | Dallas | Texas | 48113 | 9385 | 221 |
181005 | 181005 | 2020-05-26 | Dallas | Texas | 48113 | 9188 | 213 |
177962 | 177962 | 2020-05-25 | Dallas | Texas | 48113 | 8998 | 211 |
174918 | 174918 | 2020-05-24 | Dallas | Texas | 48113 | 8827 | 211 |
171875 | 171875 | 2020-05-23 | Dallas | Texas | 48113 | 8649 | 210 |
168836 | 168836 | 2020-05-22 | Dallas | Texas | 48113 | 8477 | 207 |
165800 | 165800 | 2020-05-21 | Dallas | Texas | 48113 | 8273 | 203 |
162771 | 162771 | 2020-05-20 | Dallas | Texas | 48113 | 8090 | 196 |
159744 | 159744 | 2020-05-19 | Dallas | Texas | 48113 | 7904 | 191 |
156722 | 156722 | 2020-05-18 | Dallas | Texas | 48113 | 7679 | 177 |
153705 | 153705 | 2020-05-17 | Dallas | Texas | 48113 | 7455 | 176 |
150694 | 150694 | 2020-05-16 | Dallas | Texas | 48113 | 7250 | 170 |
147686 | 147686 | 2020-05-15 | Dallas | Texas | 48113 | 7036 | 164 |
144684 | 144684 | 2020-05-14 | Dallas | Texas | 48113 | 6837 | 159 |
141687 | 141687 | 2020-05-13 | Dallas | Texas | 48113 | 6602 | 153 |
138691 | 138691 | 2020-05-12 | Dallas | Texas | 48113 | 6359 | 148 |
135701 | 135701 | 2020-05-11 | Dallas | Texas | 48113 | 6123 | 145 |
132710 | 132710 | 2020-05-10 | Dallas | Texas | 48113 | 5870 | 143 |
129720 | 129720 | 2020-05-09 | Dallas | Texas | 48113 | 5619 | 143 |
126731 | 126731 | 2020-05-08 | Dallas | Texas | 48113 | 5369 | 135 |
123748 | 123748 | 2020-05-07 | Dallas | Texas | 48113 | 5120 | 125 |
120769 | 120769 | 2020-05-06 | Dallas | Texas | 48113 | 4869 | 123 |
117805 | 117805 | 2020-05-05 | Dallas | Texas | 48113 | 4623 | 121 |
114846 | 114846 | 2020-05-04 | Dallas | Texas | 48113 | 4370 | 114 |
111964 | 111964 | 2020-05-03 | Dallas | Texas | 48113 | 4133 | 111 |
109090 | 109090 | 2020-05-02 | Dallas | Texas | 48113 | 3899 | 110 |
106221 | 106221 | 2020-05-01 | Dallas | Texas | 48113 | 3718 | 106 |
103357 | 103357 | 2020-04-30 | Dallas | Texas | 48113 | 3531 | 104 |
100504 | 100504 | 2020-04-29 | Dallas | Texas | 48113 | 3352 | 99 |
97654 | 97654 | 2020-04-28 | Dallas | Texas | 48113 | 3240 | 94 |
94814 | 94814 | 2020-04-27 | Dallas | Texas | 48113 | 3105 | 84 |
91985 | 91985 | 2020-04-26 | Dallas | Texas | 48113 | 3014 | 82 |
89168 | 89168 | 2020-04-25 | Dallas | Texas | 48113 | 2909 | 81 |
86353 | 86353 | 2020-04-24 | Dallas | Texas | 48113 | 2834 | 77 |
83548 | 83548 | 2020-04-23 | Dallas | Texas | 48113 | 2763 | 72 |
80748 | 80748 | 2020-04-22 | Dallas | Texas | 48113 | 2683 | 65 |
77957 | 77957 | 2020-04-21 | Dallas | Texas | 48113 | 2602 | 64 |
75175 | 75175 | 2020-04-20 | Dallas | Texas | 48113 | 2512 | 60 |
72400 | 72400 | 2020-04-19 | Dallas | Texas | 48113 | 2428 | 60 |
69632 | 69632 | 2020-04-18 | Dallas | Texas | 48113 | 2324 | 60 |
66872 | 66872 | 2020-04-17 | Dallas | Texas | 48113 | 2190 | 55 |
64125 | 64125 | 2020-04-16 | Dallas | Texas | 48113 | 2066 | 50 |
61398 | 61398 | 2020-04-15 | Dallas | Texas | 48113 | 1986 | 43 |
58681 | 58681 | 2020-04-14 | Dallas | Texas | 48113 | 1877 | 42 |
55977 | 55977 | 2020-04-13 | Dallas | Texas | 48113 | 1788 | 32 |
53289 | 53289 | 2020-04-12 | Dallas | Texas | 48113 | 1723 | 31 |
50614 | 50614 | 2020-04-11 | Dallas | Texas | 48113 | 1648 | 27 |
47957 | 47957 | 2020-04-10 | Dallas | Texas | 48113 | 1537 | 25 |
45337 | 45337 | 2020-04-09 | Dallas | Texas | 48113 | 1432 | 22 |
42748 | 42748 | 2020-04-08 | Dallas | Texas | 48113 | 1324 | 20 |
40185 | 40185 | 2020-04-07 | Dallas | Texas | 48113 | 1261 | 19 |
37660 | 37660 | 2020-04-06 | Dallas | Texas | 48113 | 1155 | 18 |
35184 | 35184 | 2020-04-05 | Dallas | Texas | 48113 | 1112 | 18 |
32746 | 32746 | 2020-04-04 | Dallas | Texas | 48113 | 1015 | 18 |
30353 | 30353 | 2020-04-03 | Dallas | Texas | 48113 | 921 | 17 |
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);