ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
711 rows where fips = 48235 and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
202518 | 202518 | 2020-06-02 | Irion | Texas | 48235 | 1 | 0 |
205597 | 205597 | 2020-06-03 | Irion | Texas | 48235 | 1 | 0 |
208679 | 208679 | 2020-06-04 | Irion | Texas | 48235 | 1 | 0 |
211763 | 211763 | 2020-06-05 | Irion | Texas | 48235 | 1 | 0 |
214850 | 214850 | 2020-06-06 | Irion | Texas | 48235 | 1 | 0 |
217940 | 217940 | 2020-06-07 | Irion | Texas | 48235 | 1 | 0 |
221032 | 221032 | 2020-06-08 | Irion | Texas | 48235 | 1 | 0 |
224127 | 224127 | 2020-06-09 | Irion | Texas | 48235 | 1 | 0 |
227227 | 227227 | 2020-06-10 | Irion | Texas | 48235 | 1 | 0 |
230331 | 230331 | 2020-06-11 | Irion | Texas | 48235 | 1 | 0 |
233435 | 233435 | 2020-06-12 | Irion | Texas | 48235 | 1 | 0 |
236541 | 236541 | 2020-06-13 | Irion | Texas | 48235 | 1 | 0 |
239649 | 239649 | 2020-06-14 | Irion | Texas | 48235 | 1 | 0 |
242759 | 242759 | 2020-06-15 | Irion | Texas | 48235 | 1 | 0 |
245871 | 245871 | 2020-06-16 | Irion | Texas | 48235 | 1 | 0 |
248984 | 248984 | 2020-06-17 | Irion | Texas | 48235 | 1 | 0 |
252099 | 252099 | 2020-06-18 | Irion | Texas | 48235 | 1 | 0 |
255214 | 255214 | 2020-06-19 | Irion | Texas | 48235 | 1 | 0 |
258341 | 258341 | 2020-06-20 | Irion | Texas | 48235 | 1 | 0 |
261468 | 261468 | 2020-06-21 | Irion | Texas | 48235 | 1 | 0 |
264596 | 264596 | 2020-06-22 | Irion | Texas | 48235 | 1 | 0 |
267724 | 267724 | 2020-06-23 | Irion | Texas | 48235 | 1 | 0 |
270858 | 270858 | 2020-06-24 | Irion | Texas | 48235 | 1 | 0 |
273998 | 273998 | 2020-06-25 | Irion | Texas | 48235 | 1 | 0 |
277145 | 277145 | 2020-06-26 | Irion | Texas | 48235 | 1 | 0 |
280293 | 280293 | 2020-06-27 | Irion | Texas | 48235 | 2 | 0 |
283439 | 283439 | 2020-06-28 | Irion | Texas | 48235 | 2 | 0 |
286585 | 286585 | 2020-06-29 | Irion | Texas | 48235 | 2 | 0 |
289735 | 289735 | 2020-06-30 | Irion | Texas | 48235 | 2 | 0 |
292888 | 292888 | 2020-07-01 | Irion | Texas | 48235 | 2 | 0 |
296043 | 296043 | 2020-07-02 | Irion | Texas | 48235 | 2 | 0 |
299203 | 299203 | 2020-07-03 | Irion | Texas | 48235 | 2 | 0 |
302367 | 302367 | 2020-07-04 | Irion | Texas | 48235 | 2 | 0 |
305531 | 305531 | 2020-07-05 | Irion | Texas | 48235 | 2 | 0 |
308699 | 308699 | 2020-07-06 | Irion | Texas | 48235 | 2 | 0 |
311868 | 311868 | 2020-07-07 | Irion | Texas | 48235 | 2 | 0 |
315042 | 315042 | 2020-07-08 | Irion | Texas | 48235 | 2 | 0 |
318215 | 318215 | 2020-07-09 | Irion | Texas | 48235 | 3 | 0 |
321394 | 321394 | 2020-07-10 | Irion | Texas | 48235 | 3 | 0 |
324575 | 324575 | 2020-07-11 | Irion | Texas | 48235 | 3 | 0 |
327760 | 327760 | 2020-07-12 | Irion | Texas | 48235 | 3 | 0 |
330946 | 330946 | 2020-07-13 | Irion | Texas | 48235 | 3 | 0 |
334137 | 334137 | 2020-07-14 | Irion | Texas | 48235 | 3 | 0 |
337332 | 337332 | 2020-07-15 | Irion | Texas | 48235 | 3 | 0 |
340528 | 340528 | 2020-07-16 | Irion | Texas | 48235 | 4 | 0 |
343727 | 343727 | 2020-07-17 | Irion | Texas | 48235 | 4 | 0 |
346927 | 346927 | 2020-07-18 | Irion | Texas | 48235 | 4 | 0 |
350127 | 350127 | 2020-07-19 | Irion | Texas | 48235 | 4 | 0 |
353329 | 353329 | 2020-07-20 | Irion | Texas | 48235 | 4 | 0 |
356532 | 356532 | 2020-07-21 | Irion | Texas | 48235 | 4 | 0 |
359737 | 359737 | 2020-07-22 | Irion | Texas | 48235 | 4 | 0 |
362944 | 362944 | 2020-07-23 | Irion | Texas | 48235 | 5 | 0 |
366150 | 366150 | 2020-07-24 | Irion | Texas | 48235 | 6 | 0 |
369359 | 369359 | 2020-07-25 | Irion | Texas | 48235 | 7 | 0 |
372571 | 372571 | 2020-07-26 | Irion | Texas | 48235 | 7 | 0 |
375784 | 375784 | 2020-07-27 | Irion | Texas | 48235 | 6 | 0 |
379000 | 379000 | 2020-07-28 | Irion | Texas | 48235 | 7 | 0 |
382217 | 382217 | 2020-07-29 | Irion | Texas | 48235 | 7 | 0 |
385435 | 385435 | 2020-07-30 | Irion | Texas | 48235 | 8 | 0 |
388652 | 388652 | 2020-07-31 | Irion | Texas | 48235 | 8 | 0 |
391869 | 391869 | 2020-08-01 | Irion | Texas | 48235 | 9 | 0 |
395085 | 395085 | 2020-08-02 | Irion | Texas | 48235 | 9 | 0 |
398301 | 398301 | 2020-08-03 | Irion | Texas | 48235 | 9 | 0 |
401517 | 401517 | 2020-08-04 | Irion | Texas | 48235 | 9 | 0 |
404735 | 404735 | 2020-08-05 | Irion | Texas | 48235 | 9 | 0 |
407955 | 407955 | 2020-08-06 | Irion | Texas | 48235 | 9 | 0 |
411174 | 411174 | 2020-08-07 | Irion | Texas | 48235 | 9 | 0 |
414394 | 414394 | 2020-08-08 | Irion | Texas | 48235 | 9 | 0 |
417615 | 417615 | 2020-08-09 | Irion | Texas | 48235 | 9 | 0 |
420836 | 420836 | 2020-08-10 | Irion | Texas | 48235 | 9 | 0 |
424057 | 424057 | 2020-08-11 | Irion | Texas | 48235 | 9 | 0 |
427281 | 427281 | 2020-08-12 | Irion | Texas | 48235 | 9 | 0 |
430508 | 430508 | 2020-08-13 | Irion | Texas | 48235 | 9 | 0 |
433733 | 433733 | 2020-08-14 | Irion | Texas | 48235 | 9 | 0 |
436959 | 436959 | 2020-08-15 | Irion | Texas | 48235 | 9 | 0 |
440185 | 440185 | 2020-08-16 | Irion | Texas | 48235 | 9 | 0 |
443411 | 443411 | 2020-08-17 | Irion | Texas | 48235 | 9 | 0 |
446638 | 446638 | 2020-08-18 | Irion | Texas | 48235 | 9 | 0 |
449866 | 449866 | 2020-08-19 | Irion | Texas | 48235 | 9 | 0 |
453094 | 453094 | 2020-08-20 | Irion | Texas | 48235 | 9 | 0 |
456322 | 456322 | 2020-08-21 | Irion | Texas | 48235 | 9 | 0 |
459549 | 459549 | 2020-08-22 | Irion | Texas | 48235 | 9 | 0 |
462778 | 462778 | 2020-08-23 | Irion | Texas | 48235 | 9 | 0 |
466007 | 466007 | 2020-08-24 | Irion | Texas | 48235 | 9 | 0 |
469236 | 469236 | 2020-08-25 | Irion | Texas | 48235 | 9 | 0 |
472468 | 472468 | 2020-08-26 | Irion | Texas | 48235 | 9 | 0 |
475701 | 475701 | 2020-08-27 | Irion | Texas | 48235 | 10 | 0 |
478934 | 478934 | 2020-08-28 | Irion | Texas | 48235 | 10 | 0 |
482168 | 482168 | 2020-08-29 | Irion | Texas | 48235 | 10 | 0 |
485403 | 485403 | 2020-08-30 | Irion | Texas | 48235 | 10 | 0 |
488636 | 488636 | 2020-08-31 | Irion | Texas | 48235 | 10 | 0 |
491869 | 491869 | 2020-09-01 | Irion | Texas | 48235 | 10 | 0 |
495103 | 495103 | 2020-09-02 | Irion | Texas | 48235 | 10 | 0 |
498336 | 498336 | 2020-09-03 | Irion | Texas | 48235 | 10 | 0 |
501570 | 501570 | 2020-09-04 | Irion | Texas | 48235 | 10 | 0 |
504804 | 504804 | 2020-09-05 | Irion | Texas | 48235 | 10 | 0 |
508036 | 508036 | 2020-09-06 | Irion | Texas | 48235 | 10 | 0 |
511269 | 511269 | 2020-09-07 | Irion | Texas | 48235 | 10 | 0 |
514502 | 514502 | 2020-09-08 | Irion | Texas | 48235 | 10 | 0 |
517737 | 517737 | 2020-09-09 | Irion | Texas | 48235 | 10 | 0 |
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);