ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537110 | 537110 | 2020-09-15 | Fayette | Texas | 48149 | 426 | 18 |
533874 | 533874 | 2020-09-14 | Fayette | Texas | 48149 | 396 | 18 |
530639 | 530639 | 2020-09-13 | Fayette | Texas | 48149 | 396 | 18 |
527402 | 527402 | 2020-09-12 | Fayette | Texas | 48149 | 396 | 18 |
524166 | 524166 | 2020-09-11 | Fayette | Texas | 48149 | 392 | 18 |
520930 | 520930 | 2020-09-10 | Fayette | Texas | 48149 | 382 | 18 |
517694 | 517694 | 2020-09-09 | Fayette | Texas | 48149 | 382 | 18 |
514459 | 514459 | 2020-09-08 | Fayette | Texas | 48149 | 379 | 18 |
511226 | 511226 | 2020-09-07 | Fayette | Texas | 48149 | 379 | 18 |
507993 | 507993 | 2020-09-06 | Fayette | Texas | 48149 | 379 | 18 |
504761 | 504761 | 2020-09-05 | Fayette | Texas | 48149 | 379 | 18 |
501527 | 501527 | 2020-09-04 | Fayette | Texas | 48149 | 379 | 17 |
498293 | 498293 | 2020-09-03 | Fayette | Texas | 48149 | 378 | 17 |
495060 | 495060 | 2020-09-02 | Fayette | Texas | 48149 | 375 | 16 |
491826 | 491826 | 2020-09-01 | Fayette | Texas | 48149 | 374 | 16 |
488593 | 488593 | 2020-08-31 | Fayette | Texas | 48149 | 370 | 16 |
485360 | 485360 | 2020-08-30 | Fayette | Texas | 48149 | 368 | 16 |
482125 | 482125 | 2020-08-29 | Fayette | Texas | 48149 | 368 | 16 |
478891 | 478891 | 2020-08-28 | Fayette | Texas | 48149 | 365 | 16 |
475658 | 475658 | 2020-08-27 | Fayette | Texas | 48149 | 364 | 16 |
472425 | 472425 | 2020-08-26 | Fayette | Texas | 48149 | 359 | 16 |
469193 | 469193 | 2020-08-25 | Fayette | Texas | 48149 | 354 | 15 |
465964 | 465964 | 2020-08-24 | Fayette | Texas | 48149 | 353 | 15 |
462735 | 462735 | 2020-08-23 | Fayette | Texas | 48149 | 353 | 15 |
459506 | 459506 | 2020-08-22 | Fayette | Texas | 48149 | 351 | 15 |
456279 | 456279 | 2020-08-21 | Fayette | Texas | 48149 | 351 | 15 |
453051 | 453051 | 2020-08-20 | Fayette | Texas | 48149 | 340 | 15 |
449823 | 449823 | 2020-08-19 | Fayette | Texas | 48149 | 332 | 15 |
446595 | 446595 | 2020-08-18 | Fayette | Texas | 48149 | 325 | 14 |
443368 | 443368 | 2020-08-17 | Fayette | Texas | 48149 | 323 | 14 |
440142 | 440142 | 2020-08-16 | Fayette | Texas | 48149 | 323 | 14 |
436916 | 436916 | 2020-08-15 | Fayette | Texas | 48149 | 323 | 14 |
433690 | 433690 | 2020-08-14 | Fayette | Texas | 48149 | 323 | 14 |
430465 | 430465 | 2020-08-13 | Fayette | Texas | 48149 | 321 | 14 |
427238 | 427238 | 2020-08-12 | Fayette | Texas | 48149 | 318 | 14 |
424014 | 424014 | 2020-08-11 | Fayette | Texas | 48149 | 313 | 14 |
420793 | 420793 | 2020-08-10 | Fayette | Texas | 48149 | 311 | 14 |
417572 | 417572 | 2020-08-09 | Fayette | Texas | 48149 | 309 | 14 |
414351 | 414351 | 2020-08-08 | Fayette | Texas | 48149 | 308 | 14 |
411131 | 411131 | 2020-08-07 | Fayette | Texas | 48149 | 308 | 14 |
407912 | 407912 | 2020-08-06 | Fayette | Texas | 48149 | 303 | 14 |
404692 | 404692 | 2020-08-05 | Fayette | Texas | 48149 | 301 | 14 |
401474 | 401474 | 2020-08-04 | Fayette | Texas | 48149 | 301 | 13 |
398258 | 398258 | 2020-08-03 | Fayette | Texas | 48149 | 300 | 13 |
395042 | 395042 | 2020-08-02 | Fayette | Texas | 48149 | 300 | 13 |
391826 | 391826 | 2020-08-01 | Fayette | Texas | 48149 | 300 | 13 |
388609 | 388609 | 2020-07-31 | Fayette | Texas | 48149 | 299 | 13 |
385392 | 385392 | 2020-07-30 | Fayette | Texas | 48149 | 297 | 13 |
382174 | 382174 | 2020-07-29 | Fayette | Texas | 48149 | 296 | 13 |
378957 | 378957 | 2020-07-28 | Fayette | Texas | 48149 | 291 | 13 |
375741 | 375741 | 2020-07-27 | Fayette | Texas | 48149 | 281 | 12 |
372528 | 372528 | 2020-07-26 | Fayette | Texas | 48149 | 281 | 5 |
369316 | 369316 | 2020-07-25 | Fayette | Texas | 48149 | 281 | 5 |
366107 | 366107 | 2020-07-24 | Fayette | Texas | 48149 | 275 | 5 |
362901 | 362901 | 2020-07-23 | Fayette | Texas | 48149 | 270 | 5 |
359694 | 359694 | 2020-07-22 | Fayette | Texas | 48149 | 253 | 5 |
356489 | 356489 | 2020-07-21 | Fayette | Texas | 48149 | 224 | 4 |
353286 | 353286 | 2020-07-20 | Fayette | Texas | 48149 | 216 | 4 |
350084 | 350084 | 2020-07-19 | Fayette | Texas | 48149 | 217 | 4 |
346884 | 346884 | 2020-07-18 | Fayette | Texas | 48149 | 206 | 4 |
343684 | 343684 | 2020-07-17 | Fayette | Texas | 48149 | 206 | 4 |
340485 | 340485 | 2020-07-16 | Fayette | Texas | 48149 | 197 | 4 |
337289 | 337289 | 2020-07-15 | Fayette | Texas | 48149 | 179 | 4 |
334094 | 334094 | 2020-07-14 | Fayette | Texas | 48149 | 174 | 4 |
330903 | 330903 | 2020-07-13 | Fayette | Texas | 48149 | 158 | 4 |
327717 | 327717 | 2020-07-12 | Fayette | Texas | 48149 | 156 | 3 |
324532 | 324532 | 2020-07-11 | Fayette | Texas | 48149 | 151 | 3 |
321351 | 321351 | 2020-07-10 | Fayette | Texas | 48149 | 142 | 3 |
318173 | 318173 | 2020-07-09 | Fayette | Texas | 48149 | 136 | 3 |
315000 | 315000 | 2020-07-08 | Fayette | Texas | 48149 | 134 | 3 |
311826 | 311826 | 2020-07-07 | Fayette | Texas | 48149 | 104 | 3 |
308657 | 308657 | 2020-07-06 | Fayette | Texas | 48149 | 104 | 3 |
305489 | 305489 | 2020-07-05 | Fayette | Texas | 48149 | 104 | 3 |
302325 | 302325 | 2020-07-04 | Fayette | Texas | 48149 | 104 | 3 |
299161 | 299161 | 2020-07-03 | Fayette | Texas | 48149 | 96 | 2 |
296001 | 296001 | 2020-07-02 | Fayette | Texas | 48149 | 95 | 2 |
292846 | 292846 | 2020-07-01 | Fayette | Texas | 48149 | 90 | 2 |
289693 | 289693 | 2020-06-30 | Fayette | Texas | 48149 | 86 | 2 |
286543 | 286543 | 2020-06-29 | Fayette | Texas | 48149 | 86 | 2 |
283397 | 283397 | 2020-06-28 | Fayette | Texas | 48149 | 80 | 2 |
280251 | 280251 | 2020-06-27 | Fayette | Texas | 48149 | 75 | 2 |
277103 | 277103 | 2020-06-26 | Fayette | Texas | 48149 | 75 | 2 |
273956 | 273956 | 2020-06-25 | Fayette | Texas | 48149 | 76 | 2 |
270816 | 270816 | 2020-06-24 | Fayette | Texas | 48149 | 75 | 2 |
267682 | 267682 | 2020-06-23 | Fayette | Texas | 48149 | 71 | 2 |
264554 | 264554 | 2020-06-22 | Fayette | Texas | 48149 | 66 | 2 |
261426 | 261426 | 2020-06-21 | Fayette | Texas | 48149 | 60 | 2 |
258299 | 258299 | 2020-06-20 | Fayette | Texas | 48149 | 58 | 2 |
255172 | 255172 | 2020-06-19 | Fayette | Texas | 48149 | 52 | 2 |
252057 | 252057 | 2020-06-18 | Fayette | Texas | 48149 | 51 | 2 |
248942 | 248942 | 2020-06-17 | Fayette | Texas | 48149 | 52 | 2 |
245829 | 245829 | 2020-06-16 | Fayette | Texas | 48149 | 45 | 2 |
242717 | 242717 | 2020-06-15 | Fayette | Texas | 48149 | 44 | 2 |
239607 | 239607 | 2020-06-14 | Fayette | Texas | 48149 | 44 | 2 |
236499 | 236499 | 2020-06-13 | Fayette | Texas | 48149 | 43 | 2 |
233393 | 233393 | 2020-06-12 | Fayette | Texas | 48149 | 44 | 2 |
230289 | 230289 | 2020-06-11 | Fayette | Texas | 48149 | 43 | 2 |
227185 | 227185 | 2020-06-10 | Fayette | Texas | 48149 | 39 | 2 |
224085 | 224085 | 2020-06-09 | Fayette | Texas | 48149 | 38 | 2 |
220990 | 220990 | 2020-06-08 | Fayette | Texas | 48149 | 38 | 2 |
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);