ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 48139 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537106 | 537106 | 2020-09-15 | Ellis | Texas | 48139 | 4119 | 62 |
533870 | 533870 | 2020-09-14 | Ellis | Texas | 48139 | 3998 | 62 |
530635 | 530635 | 2020-09-13 | Ellis | Texas | 48139 | 3998 | 62 |
527398 | 527398 | 2020-09-12 | Ellis | Texas | 48139 | 3998 | 62 |
524162 | 524162 | 2020-09-11 | Ellis | Texas | 48139 | 3988 | 62 |
520926 | 520926 | 2020-09-10 | Ellis | Texas | 48139 | 3951 | 61 |
517690 | 517690 | 2020-09-09 | Ellis | Texas | 48139 | 3951 | 61 |
514455 | 514455 | 2020-09-08 | Ellis | Texas | 48139 | 3888 | 60 |
511222 | 511222 | 2020-09-07 | Ellis | Texas | 48139 | 3888 | 60 |
507989 | 507989 | 2020-09-06 | Ellis | Texas | 48139 | 3888 | 60 |
504757 | 504757 | 2020-09-05 | Ellis | Texas | 48139 | 3888 | 60 |
501523 | 501523 | 2020-09-04 | Ellis | Texas | 48139 | 3856 | 60 |
498289 | 498289 | 2020-09-03 | Ellis | Texas | 48139 | 3843 | 58 |
495056 | 495056 | 2020-09-02 | Ellis | Texas | 48139 | 3828 | 58 |
491822 | 491822 | 2020-09-01 | Ellis | Texas | 48139 | 3801 | 56 |
488589 | 488589 | 2020-08-31 | Ellis | Texas | 48139 | 3758 | 56 |
485356 | 485356 | 2020-08-30 | Ellis | Texas | 48139 | 3758 | 56 |
482121 | 482121 | 2020-08-29 | Ellis | Texas | 48139 | 3758 | 56 |
478887 | 478887 | 2020-08-28 | Ellis | Texas | 48139 | 3740 | 55 |
475654 | 475654 | 2020-08-27 | Ellis | Texas | 48139 | 3700 | 55 |
472421 | 472421 | 2020-08-26 | Ellis | Texas | 48139 | 3670 | 55 |
469189 | 469189 | 2020-08-25 | Ellis | Texas | 48139 | 3562 | 55 |
465960 | 465960 | 2020-08-24 | Ellis | Texas | 48139 | 3486 | 55 |
462731 | 462731 | 2020-08-23 | Ellis | Texas | 48139 | 3486 | 54 |
459502 | 459502 | 2020-08-22 | Ellis | Texas | 48139 | 3486 | 54 |
456275 | 456275 | 2020-08-21 | Ellis | Texas | 48139 | 3486 | 54 |
453047 | 453047 | 2020-08-20 | Ellis | Texas | 48139 | 3445 | 54 |
449819 | 449819 | 2020-08-19 | Ellis | Texas | 48139 | 3427 | 53 |
446591 | 446591 | 2020-08-18 | Ellis | Texas | 48139 | 3433 | 51 |
443364 | 443364 | 2020-08-17 | Ellis | Texas | 48139 | 3255 | 51 |
440138 | 440138 | 2020-08-16 | Ellis | Texas | 48139 | 3255 | 51 |
436912 | 436912 | 2020-08-15 | Ellis | Texas | 48139 | 3255 | 50 |
433686 | 433686 | 2020-08-14 | Ellis | Texas | 48139 | 3238 | 48 |
430461 | 430461 | 2020-08-13 | Ellis | Texas | 48139 | 3244 | 48 |
427234 | 427234 | 2020-08-12 | Ellis | Texas | 48139 | 3218 | 48 |
424010 | 424010 | 2020-08-11 | Ellis | Texas | 48139 | 3120 | 43 |
420789 | 420789 | 2020-08-10 | Ellis | Texas | 48139 | 2855 | 42 |
417568 | 417568 | 2020-08-09 | Ellis | Texas | 48139 | 2855 | 41 |
414347 | 414347 | 2020-08-08 | Ellis | Texas | 48139 | 2855 | 41 |
411127 | 411127 | 2020-08-07 | Ellis | Texas | 48139 | 2808 | 40 |
407908 | 407908 | 2020-08-06 | Ellis | Texas | 48139 | 2739 | 38 |
404688 | 404688 | 2020-08-05 | Ellis | Texas | 48139 | 2691 | 37 |
401470 | 401470 | 2020-08-04 | Ellis | Texas | 48139 | 2545 | 35 |
398254 | 398254 | 2020-08-03 | Ellis | Texas | 48139 | 2472 | 34 |
395038 | 395038 | 2020-08-02 | Ellis | Texas | 48139 | 2472 | 34 |
391822 | 391822 | 2020-08-01 | Ellis | Texas | 48139 | 2472 | 34 |
388605 | 388605 | 2020-07-31 | Ellis | Texas | 48139 | 2452 | 33 |
385388 | 385388 | 2020-07-30 | Ellis | Texas | 48139 | 2407 | 33 |
382170 | 382170 | 2020-07-29 | Ellis | Texas | 48139 | 2387 | 33 |
378953 | 378953 | 2020-07-28 | Ellis | Texas | 48139 | 2332 | 33 |
375737 | 375737 | 2020-07-27 | Ellis | Texas | 48139 | 2268 | 32 |
372524 | 372524 | 2020-07-26 | Ellis | Texas | 48139 | 2268 | 21 |
369312 | 369312 | 2020-07-25 | Ellis | Texas | 48139 | 2268 | 21 |
366103 | 366103 | 2020-07-24 | Ellis | Texas | 48139 | 2216 | 21 |
362897 | 362897 | 2020-07-23 | Ellis | Texas | 48139 | 2183 | 21 |
359690 | 359690 | 2020-07-22 | Ellis | Texas | 48139 | 2129 | 21 |
356485 | 356485 | 2020-07-21 | Ellis | Texas | 48139 | 2090 | 21 |
353282 | 353282 | 2020-07-20 | Ellis | Texas | 48139 | 1972 | 21 |
350080 | 350080 | 2020-07-19 | Ellis | Texas | 48139 | 1972 | 21 |
346880 | 346880 | 2020-07-18 | Ellis | Texas | 48139 | 1972 | 21 |
343680 | 343680 | 2020-07-17 | Ellis | Texas | 48139 | 1957 | 21 |
340481 | 340481 | 2020-07-16 | Ellis | Texas | 48139 | 1837 | 21 |
337285 | 337285 | 2020-07-15 | Ellis | Texas | 48139 | 1811 | 21 |
334090 | 334090 | 2020-07-14 | Ellis | Texas | 48139 | 1729 | 21 |
330899 | 330899 | 2020-07-13 | Ellis | Texas | 48139 | 1510 | 20 |
327713 | 327713 | 2020-07-12 | Ellis | Texas | 48139 | 1510 | 20 |
324528 | 324528 | 2020-07-11 | Ellis | Texas | 48139 | 1510 | 20 |
321347 | 321347 | 2020-07-10 | Ellis | Texas | 48139 | 1485 | 20 |
318169 | 318169 | 2020-07-09 | Ellis | Texas | 48139 | 1424 | 20 |
314996 | 314996 | 2020-07-08 | Ellis | Texas | 48139 | 1351 | 19 |
311822 | 311822 | 2020-07-07 | Ellis | Texas | 48139 | 1182 | 19 |
308653 | 308653 | 2020-07-06 | Ellis | Texas | 48139 | 1046 | 19 |
305485 | 305485 | 2020-07-05 | Ellis | Texas | 48139 | 1046 | 19 |
302321 | 302321 | 2020-07-04 | Ellis | Texas | 48139 | 1046 | 19 |
299157 | 299157 | 2020-07-03 | Ellis | Texas | 48139 | 978 | 19 |
295997 | 295997 | 2020-07-02 | Ellis | Texas | 48139 | 901 | 19 |
292842 | 292842 | 2020-07-01 | Ellis | Texas | 48139 | 862 | 19 |
289689 | 289689 | 2020-06-30 | Ellis | Texas | 48139 | 820 | 19 |
286539 | 286539 | 2020-06-29 | Ellis | Texas | 48139 | 711 | 19 |
283393 | 283393 | 2020-06-28 | Ellis | Texas | 48139 | 711 | 19 |
280247 | 280247 | 2020-06-27 | Ellis | Texas | 48139 | 711 | 19 |
277099 | 277099 | 2020-06-26 | Ellis | Texas | 48139 | 684 | 19 |
273952 | 273952 | 2020-06-25 | Ellis | Texas | 48139 | 684 | 19 |
270812 | 270812 | 2020-06-24 | Ellis | Texas | 48139 | 684 | 19 |
267678 | 267678 | 2020-06-23 | Ellis | Texas | 48139 | 539 | 19 |
264550 | 264550 | 2020-06-22 | Ellis | Texas | 48139 | 510 | 19 |
261422 | 261422 | 2020-06-21 | Ellis | Texas | 48139 | 510 | 19 |
258295 | 258295 | 2020-06-20 | Ellis | Texas | 48139 | 510 | 19 |
255168 | 255168 | 2020-06-19 | Ellis | Texas | 48139 | 510 | 19 |
252053 | 252053 | 2020-06-18 | Ellis | Texas | 48139 | 490 | 19 |
248938 | 248938 | 2020-06-17 | Ellis | Texas | 48139 | 470 | 19 |
245825 | 245825 | 2020-06-16 | Ellis | Texas | 48139 | 458 | 19 |
242713 | 242713 | 2020-06-15 | Ellis | Texas | 48139 | 448 | 19 |
239603 | 239603 | 2020-06-14 | Ellis | Texas | 48139 | 448 | 19 |
236495 | 236495 | 2020-06-13 | Ellis | Texas | 48139 | 448 | 19 |
233389 | 233389 | 2020-06-12 | Ellis | Texas | 48139 | 437 | 18 |
230285 | 230285 | 2020-06-11 | Ellis | Texas | 48139 | 429 | 18 |
227181 | 227181 | 2020-06-10 | Ellis | Texas | 48139 | 418 | 18 |
224081 | 224081 | 2020-06-09 | Ellis | Texas | 48139 | 399 | 16 |
220986 | 220986 | 2020-06-08 | Ellis | Texas | 48139 | 364 | 16 |
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);