ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Dallas" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388591 | 388591 | 2020-07-31 | Dallas | Texas | 48113 | 51299 | 673 |
385374 | 385374 | 2020-07-30 | Dallas | Texas | 48113 | 49269 | 664 |
382156 | 382156 | 2020-07-29 | Dallas | Texas | 48113 | 48732 | 658 |
378939 | 378939 | 2020-07-28 | Dallas | Texas | 48113 | 48028 | 622 |
375723 | 375723 | 2020-07-27 | Dallas | Texas | 48113 | 47239 | 607 |
372510 | 372510 | 2020-07-26 | Dallas | Texas | 48113 | 46813 | 605 |
369298 | 369298 | 2020-07-25 | Dallas | Texas | 48113 | 46013 | 604 |
366089 | 366089 | 2020-07-24 | Dallas | Texas | 48113 | 44746 | 586 |
362883 | 362883 | 2020-07-23 | Dallas | Texas | 48113 | 44087 | 579 |
359676 | 359676 | 2020-07-22 | Dallas | Texas | 48113 | 43439 | 567 |
356471 | 356471 | 2020-07-21 | Dallas | Texas | 48113 | 43026 | 537 |
353268 | 353268 | 2020-07-20 | Dallas | Texas | 48113 | 42292 | 526 |
350066 | 350066 | 2020-07-19 | Dallas | Texas | 48113 | 41266 | 525 |
346866 | 346866 | 2020-07-18 | Dallas | Texas | 48113 | 40222 | 523 |
343666 | 343666 | 2020-07-17 | Dallas | Texas | 48113 | 39191 | 514 |
340467 | 340467 | 2020-07-16 | Dallas | Texas | 48113 | 37996 | 501 |
337271 | 337271 | 2020-07-15 | Dallas | Texas | 48113 | 36969 | 485 |
334076 | 334076 | 2020-07-14 | Dallas | Texas | 48113 | 35914 | 477 |
330885 | 330885 | 2020-07-13 | Dallas | Texas | 48113 | 34914 | 457 |
327699 | 327699 | 2020-07-12 | Dallas | Texas | 48113 | 33800 | 451 |
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 |
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);