ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8123 and state = "Colorado" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
259129 | 259129 | 2020-06-21 | Weld | Colorado | 8123 | 2721 | 136 |
262256 | 262256 | 2020-06-22 | Weld | Colorado | 8123 | 2724 | 136 |
265384 | 265384 | 2020-06-23 | Weld | Colorado | 8123 | 2730 | 136 |
268514 | 268514 | 2020-06-24 | Weld | Colorado | 8123 | 2746 | 136 |
271650 | 271650 | 2020-06-25 | Weld | Colorado | 8123 | 2757 | 136 |
274790 | 274790 | 2020-06-26 | Weld | Colorado | 8123 | 2773 | 136 |
277938 | 277938 | 2020-06-27 | Weld | Colorado | 8123 | 2783 | 136 |
281085 | 281085 | 2020-06-28 | Weld | Colorado | 8123 | 2788 | 137 |
284231 | 284231 | 2020-06-29 | Weld | Colorado | 8123 | 2798 | 137 |
287377 | 287377 | 2020-06-30 | Weld | Colorado | 8123 | 2802 | 137 |
290528 | 290528 | 2020-07-01 | Weld | Colorado | 8123 | 2823 | 137 |
293682 | 293682 | 2020-07-02 | Weld | Colorado | 8123 | 2839 | 137 |
296838 | 296838 | 2020-07-03 | Weld | Colorado | 8123 | 2854 | 137 |
300000 | 300000 | 2020-07-04 | Weld | Colorado | 8123 | 2862 | 137 |
303164 | 303164 | 2020-07-05 | Weld | Colorado | 8123 | 2871 | 137 |
306328 | 306328 | 2020-07-06 | Weld | Colorado | 8123 | 2886 | 137 |
309496 | 309496 | 2020-07-07 | Weld | Colorado | 8123 | 2903 | 138 |
312666 | 312666 | 2020-07-08 | Weld | Colorado | 8123 | 2930 | 138 |
315841 | 315841 | 2020-07-09 | Weld | Colorado | 8123 | 2961 | 138 |
319014 | 319014 | 2020-07-10 | Weld | Colorado | 8123 | 2987 | 138 |
322193 | 322193 | 2020-07-11 | Weld | Colorado | 8123 | 2988 | 138 |
325374 | 325374 | 2020-07-12 | Weld | Colorado | 8123 | 2999 | 138 |
328560 | 328560 | 2020-07-13 | Weld | Colorado | 8123 | 3041 | 138 |
331747 | 331747 | 2020-07-14 | Weld | Colorado | 8123 | 3070 | 138 |
334940 | 334940 | 2020-07-15 | Weld | Colorado | 8123 | 3105 | 138 |
338135 | 338135 | 2020-07-16 | Weld | Colorado | 8123 | 3155 | 139 |
341332 | 341332 | 2020-07-17 | Weld | Colorado | 8123 | 3184 | 139 |
344531 | 344531 | 2020-07-18 | Weld | Colorado | 8123 | 3189 | 139 |
347731 | 347731 | 2020-07-19 | Weld | Colorado | 8123 | 3210 | 139 |
350932 | 350932 | 2020-07-20 | Weld | Colorado | 8123 | 3257 | 139 |
354134 | 354134 | 2020-07-21 | Weld | Colorado | 8123 | 3281 | 139 |
357337 | 357337 | 2020-07-22 | Weld | Colorado | 8123 | 3308 | 139 |
360542 | 360542 | 2020-07-23 | Weld | Colorado | 8123 | 3345 | 139 |
363749 | 363749 | 2020-07-24 | Weld | Colorado | 8123 | 3353 | 139 |
366956 | 366956 | 2020-07-25 | Weld | Colorado | 8123 | 3386 | 139 |
370166 | 370166 | 2020-07-26 | Weld | Colorado | 8123 | 3408 | 139 |
373378 | 373378 | 2020-07-27 | Weld | Colorado | 8123 | 3448 | 139 |
376592 | 376592 | 2020-07-28 | Weld | Colorado | 8123 | 3462 | 139 |
379809 | 379809 | 2020-07-29 | Weld | Colorado | 8123 | 3478 | 141 |
383026 | 383026 | 2020-07-30 | Weld | Colorado | 8123 | 3491 | 141 |
386244 | 386244 | 2020-07-31 | Weld | Colorado | 8123 | 3523 | 141 |
389461 | 389461 | 2020-08-01 | Weld | Colorado | 8123 | 3525 | 141 |
392678 | 392678 | 2020-08-02 | Weld | Colorado | 8123 | 3546 | 141 |
395894 | 395894 | 2020-08-03 | Weld | Colorado | 8123 | 3578 | 141 |
399110 | 399110 | 2020-08-04 | Weld | Colorado | 8123 | 3597 | 142 |
402326 | 402326 | 2020-08-05 | Weld | Colorado | 8123 | 3627 | 142 |
405544 | 405544 | 2020-08-06 | Weld | Colorado | 8123 | 3635 | 142 |
408764 | 408764 | 2020-08-07 | Weld | Colorado | 8123 | 3680 | 142 |
411983 | 411983 | 2020-08-08 | Weld | Colorado | 8123 | 3696 | 143 |
415203 | 415203 | 2020-08-09 | Weld | Colorado | 8123 | 3709 | 143 |
418424 | 418424 | 2020-08-10 | Weld | Colorado | 8123 | 3743 | 145 |
421645 | 421645 | 2020-08-11 | Weld | Colorado | 8123 | 3743 | 145 |
424866 | 424866 | 2020-08-12 | Weld | Colorado | 8123 | 3763 | 145 |
428090 | 428090 | 2020-08-13 | Weld | Colorado | 8123 | 3787 | 145 |
431318 | 431318 | 2020-08-14 | Weld | Colorado | 8123 | 3800 | 145 |
434543 | 434543 | 2020-08-15 | Weld | Colorado | 8123 | 3801 | 145 |
437769 | 437769 | 2020-08-16 | Weld | Colorado | 8123 | 3825 | 145 |
440995 | 440995 | 2020-08-17 | Weld | Colorado | 8123 | 3844 | 145 |
444221 | 444221 | 2020-08-18 | Weld | Colorado | 8123 | 3861 | 145 |
447448 | 447448 | 2020-08-19 | Weld | Colorado | 8123 | 3865 | 145 |
450676 | 450676 | 2020-08-20 | Weld | Colorado | 8123 | 3887 | 145 |
453904 | 453904 | 2020-08-21 | Weld | Colorado | 8123 | 3896 | 145 |
457132 | 457132 | 2020-08-22 | Weld | Colorado | 8123 | 3919 | 146 |
460359 | 460359 | 2020-08-23 | Weld | Colorado | 8123 | 3938 | 146 |
463588 | 463588 | 2020-08-24 | Weld | Colorado | 8123 | 3956 | 146 |
466817 | 466817 | 2020-08-25 | Weld | Colorado | 8123 | 3965 | 146 |
470046 | 470046 | 2020-08-26 | Weld | Colorado | 8123 | 3979 | 146 |
473278 | 473278 | 2020-08-27 | Weld | Colorado | 8123 | 4001 | 146 |
476511 | 476511 | 2020-08-28 | Weld | Colorado | 8123 | 4029 | 146 |
479744 | 479744 | 2020-08-29 | Weld | Colorado | 8123 | 4040 | 146 |
482978 | 482978 | 2020-08-30 | Weld | Colorado | 8123 | 4051 | 146 |
486213 | 486213 | 2020-08-31 | Weld | Colorado | 8123 | 4060 | 146 |
489446 | 489446 | 2020-09-01 | Weld | Colorado | 8123 | 4085 | 146 |
492679 | 492679 | 2020-09-02 | Weld | Colorado | 8123 | 4098 | 146 |
495913 | 495913 | 2020-09-03 | Weld | Colorado | 8123 | 4113 | 146 |
499146 | 499146 | 2020-09-04 | Weld | Colorado | 8123 | 4136 | 147 |
502380 | 502380 | 2020-09-05 | Weld | Colorado | 8123 | 4157 | 148 |
505614 | 505614 | 2020-09-06 | Weld | Colorado | 8123 | 4178 | 148 |
508846 | 508846 | 2020-09-07 | Weld | Colorado | 8123 | 4198 | 148 |
512079 | 512079 | 2020-09-08 | Weld | Colorado | 8123 | 4219 | 148 |
515312 | 515312 | 2020-09-09 | Weld | Colorado | 8123 | 4233 | 149 |
518547 | 518547 | 2020-09-10 | Weld | Colorado | 8123 | 4245 | 149 |
521784 | 521784 | 2020-09-11 | Weld | Colorado | 8123 | 4257 | 149 |
525020 | 525020 | 2020-09-12 | Weld | Colorado | 8123 | 4285 | 149 |
528256 | 528256 | 2020-09-13 | Weld | Colorado | 8123 | 4304 | 149 |
531493 | 531493 | 2020-09-14 | Weld | Colorado | 8123 | 4326 | 149 |
534728 | 534728 | 2020-09-15 | Weld | Colorado | 8123 | 4356 | 149 |
537964 | 537964 | 2020-09-16 | Weld | Colorado | 8123 | 4401 | 149 |
541201 | 541201 | 2020-09-17 | Weld | Colorado | 8123 | 4428 | 149 |
544437 | 544437 | 2020-09-18 | Weld | Colorado | 8123 | 4451 | 149 |
547675 | 547675 | 2020-09-19 | Weld | Colorado | 8123 | 4492 | 149 |
550914 | 550914 | 2020-09-20 | Weld | Colorado | 8123 | 4507 | 149 |
554153 | 554153 | 2020-09-21 | Weld | Colorado | 8123 | 4540 | 149 |
557390 | 557390 | 2020-09-22 | Weld | Colorado | 8123 | 4576 | 149 |
560626 | 560626 | 2020-09-23 | Weld | Colorado | 8123 | 4597 | 149 |
563866 | 563866 | 2020-09-24 | Weld | Colorado | 8123 | 4624 | 149 |
567106 | 567106 | 2020-09-25 | Weld | Colorado | 8123 | 4655 | 149 |
570348 | 570348 | 2020-09-26 | Weld | Colorado | 8123 | 4682 | 149 |
573590 | 573590 | 2020-09-27 | Weld | Colorado | 8123 | 4712 | 149 |
576833 | 576833 | 2020-09-28 | Weld | Colorado | 8123 | 4741 | 150 |
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);