ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Polk" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537220 | 537220 | 2020-09-15 | Polk | Texas | 48373 | 909 | 21 |
533984 | 533984 | 2020-09-14 | Polk | Texas | 48373 | 909 | 21 |
530749 | 530749 | 2020-09-13 | Polk | Texas | 48373 | 909 | 21 |
527512 | 527512 | 2020-09-12 | Polk | Texas | 48373 | 909 | 21 |
524276 | 524276 | 2020-09-11 | Polk | Texas | 48373 | 909 | 21 |
521040 | 521040 | 2020-09-10 | Polk | Texas | 48373 | 909 | 20 |
517804 | 517804 | 2020-09-09 | Polk | Texas | 48373 | 884 | 20 |
514569 | 514569 | 2020-09-08 | Polk | Texas | 48373 | 884 | 20 |
511336 | 511336 | 2020-09-07 | Polk | Texas | 48373 | 855 | 19 |
508103 | 508103 | 2020-09-06 | Polk | Texas | 48373 | 855 | 19 |
504871 | 504871 | 2020-09-05 | Polk | Texas | 48373 | 855 | 19 |
501637 | 501637 | 2020-09-04 | Polk | Texas | 48373 | 855 | 18 |
498403 | 498403 | 2020-09-03 | Polk | Texas | 48373 | 851 | 18 |
495170 | 495170 | 2020-09-02 | Polk | Texas | 48373 | 851 | 18 |
491936 | 491936 | 2020-09-01 | Polk | Texas | 48373 | 851 | 18 |
488703 | 488703 | 2020-08-31 | Polk | Texas | 48373 | 851 | 18 |
485470 | 485470 | 2020-08-30 | Polk | Texas | 48373 | 850 | 18 |
482235 | 482235 | 2020-08-29 | Polk | Texas | 48373 | 849 | 17 |
479001 | 479001 | 2020-08-28 | Polk | Texas | 48373 | 849 | 16 |
475768 | 475768 | 2020-08-27 | Polk | Texas | 48373 | 843 | 16 |
472535 | 472535 | 2020-08-26 | Polk | Texas | 48373 | 843 | 16 |
469303 | 469303 | 2020-08-25 | Polk | Texas | 48373 | 843 | 16 |
466074 | 466074 | 2020-08-24 | Polk | Texas | 48373 | 843 | 15 |
462845 | 462845 | 2020-08-23 | Polk | Texas | 48373 | 835 | 15 |
459616 | 459616 | 2020-08-22 | Polk | Texas | 48373 | 835 | 15 |
456389 | 456389 | 2020-08-21 | Polk | Texas | 48373 | 835 | 15 |
453161 | 453161 | 2020-08-20 | Polk | Texas | 48373 | 835 | 15 |
449933 | 449933 | 2020-08-19 | Polk | Texas | 48373 | 835 | 14 |
446705 | 446705 | 2020-08-18 | Polk | Texas | 48373 | 830 | 14 |
443478 | 443478 | 2020-08-17 | Polk | Texas | 48373 | 830 | 14 |
440252 | 440252 | 2020-08-16 | Polk | Texas | 48373 | 823 | 14 |
437026 | 437026 | 2020-08-15 | Polk | Texas | 48373 | 823 | 14 |
433800 | 433800 | 2020-08-14 | Polk | Texas | 48373 | 823 | 14 |
430575 | 430575 | 2020-08-13 | Polk | Texas | 48373 | 823 | 14 |
427348 | 427348 | 2020-08-12 | Polk | Texas | 48373 | 805 | 13 |
424124 | 424124 | 2020-08-11 | Polk | Texas | 48373 | 805 | 12 |
420903 | 420903 | 2020-08-10 | Polk | Texas | 48373 | 783 | 12 |
417682 | 417682 | 2020-08-09 | Polk | Texas | 48373 | 748 | 12 |
414461 | 414461 | 2020-08-08 | Polk | Texas | 48373 | 748 | 12 |
411241 | 411241 | 2020-08-07 | Polk | Texas | 48373 | 748 | 11 |
408022 | 408022 | 2020-08-06 | Polk | Texas | 48373 | 700 | 11 |
404802 | 404802 | 2020-08-05 | Polk | Texas | 48373 | 693 | 11 |
401584 | 401584 | 2020-08-04 | Polk | Texas | 48373 | 693 | 11 |
398368 | 398368 | 2020-08-03 | Polk | Texas | 48373 | 659 | 9 |
395152 | 395152 | 2020-08-02 | Polk | Texas | 48373 | 659 | 9 |
391936 | 391936 | 2020-08-01 | Polk | Texas | 48373 | 659 | 9 |
388719 | 388719 | 2020-07-31 | Polk | Texas | 48373 | 659 | 9 |
385502 | 385502 | 2020-07-30 | Polk | Texas | 48373 | 656 | 8 |
382284 | 382284 | 2020-07-29 | Polk | Texas | 48373 | 656 | 6 |
379067 | 379067 | 2020-07-28 | Polk | Texas | 48373 | 648 | 6 |
375851 | 375851 | 2020-07-27 | Polk | Texas | 48373 | 628 | 5 |
372638 | 372638 | 2020-07-26 | Polk | Texas | 48373 | 601 | 1 |
369426 | 369426 | 2020-07-25 | Polk | Texas | 48373 | 601 | 1 |
366217 | 366217 | 2020-07-24 | Polk | Texas | 48373 | 601 | 1 |
363011 | 363011 | 2020-07-23 | Polk | Texas | 48373 | 592 | 1 |
359804 | 359804 | 2020-07-22 | Polk | Texas | 48373 | 533 | 1 |
356599 | 356599 | 2020-07-21 | Polk | Texas | 48373 | 516 | 1 |
353396 | 353396 | 2020-07-20 | Polk | Texas | 48373 | 414 | 1 |
350194 | 350194 | 2020-07-19 | Polk | Texas | 48373 | 414 | 1 |
346994 | 346994 | 2020-07-18 | Polk | Texas | 48373 | 414 | 1 |
343794 | 343794 | 2020-07-17 | Polk | Texas | 48373 | 414 | 1 |
340595 | 340595 | 2020-07-16 | Polk | Texas | 48373 | 414 | 1 |
337399 | 337399 | 2020-07-15 | Polk | Texas | 48373 | 401 | 0 |
334204 | 334204 | 2020-07-14 | Polk | Texas | 48373 | 380 | 0 |
331011 | 331011 | 2020-07-13 | Polk | Texas | 48373 | 321 | 0 |
327825 | 327825 | 2020-07-12 | Polk | Texas | 48373 | 321 | 0 |
324640 | 324640 | 2020-07-11 | Polk | Texas | 48373 | 321 | 0 |
321459 | 321459 | 2020-07-10 | Polk | Texas | 48373 | 321 | 0 |
318280 | 318280 | 2020-07-09 | Polk | Texas | 48373 | 288 | 0 |
315107 | 315107 | 2020-07-08 | Polk | Texas | 48373 | 268 | 0 |
311933 | 311933 | 2020-07-07 | Polk | Texas | 48373 | 205 | 0 |
308764 | 308764 | 2020-07-06 | Polk | Texas | 48373 | 170 | 0 |
305596 | 305596 | 2020-07-05 | Polk | Texas | 48373 | 170 | 0 |
302432 | 302432 | 2020-07-04 | Polk | Texas | 48373 | 170 | 0 |
299268 | 299268 | 2020-07-03 | Polk | Texas | 48373 | 170 | 0 |
296107 | 296107 | 2020-07-02 | Polk | Texas | 48373 | 170 | 0 |
292952 | 292952 | 2020-07-01 | Polk | Texas | 48373 | 155 | 0 |
289799 | 289799 | 2020-06-30 | Polk | Texas | 48373 | 113 | 0 |
286649 | 286649 | 2020-06-29 | Polk | Texas | 48373 | 106 | 0 |
283503 | 283503 | 2020-06-28 | Polk | Texas | 48373 | 106 | 0 |
280357 | 280357 | 2020-06-27 | Polk | Texas | 48373 | 106 | 0 |
277209 | 277209 | 2020-06-26 | Polk | Texas | 48373 | 106 | 0 |
274061 | 274061 | 2020-06-25 | Polk | Texas | 48373 | 95 | 0 |
270921 | 270921 | 2020-06-24 | Polk | Texas | 48373 | 88 | 0 |
267787 | 267787 | 2020-06-23 | Polk | Texas | 48373 | 85 | 0 |
264659 | 264659 | 2020-06-22 | Polk | Texas | 48373 | 75 | 0 |
261530 | 261530 | 2020-06-21 | Polk | Texas | 48373 | 75 | 0 |
258403 | 258403 | 2020-06-20 | Polk | Texas | 48373 | 75 | 0 |
255276 | 255276 | 2020-06-19 | Polk | Texas | 48373 | 73 | 0 |
252161 | 252161 | 2020-06-18 | Polk | Texas | 48373 | 73 | 0 |
249046 | 249046 | 2020-06-17 | Polk | Texas | 48373 | 72 | 0 |
245933 | 245933 | 2020-06-16 | Polk | Texas | 48373 | 71 | 0 |
242821 | 242821 | 2020-06-15 | Polk | Texas | 48373 | 65 | 0 |
239711 | 239711 | 2020-06-14 | Polk | Texas | 48373 | 65 | 0 |
236603 | 236603 | 2020-06-13 | Polk | Texas | 48373 | 65 | 0 |
233497 | 233497 | 2020-06-12 | Polk | Texas | 48373 | 65 | 0 |
230393 | 230393 | 2020-06-11 | Polk | Texas | 48373 | 62 | 0 |
227289 | 227289 | 2020-06-10 | Polk | Texas | 48373 | 62 | 0 |
224189 | 224189 | 2020-06-09 | Polk | Texas | 48373 | 61 | 0 |
221094 | 221094 | 2020-06-08 | Polk | Texas | 48373 | 61 | 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);