ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Arapahoe" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635131 | 635131 | 2020-10-16 | Arapahoe | Colorado | 8005 | 11017 | 390 |
631885 | 631885 | 2020-10-15 | Arapahoe | Colorado | 8005 | 10916 | 390 |
628641 | 628641 | 2020-10-14 | Arapahoe | Colorado | 8005 | 10786 | 390 |
625398 | 625398 | 2020-10-13 | Arapahoe | Colorado | 8005 | 10706 | 390 |
622155 | 622155 | 2020-10-12 | Arapahoe | Colorado | 8005 | 10585 | 390 |
618912 | 618912 | 2020-10-11 | Arapahoe | Colorado | 8005 | 10441 | 387 |
615670 | 615670 | 2020-10-10 | Arapahoe | Colorado | 8005 | 10365 | 375 |
612429 | 612429 | 2020-10-09 | Arapahoe | Colorado | 8005 | 10250 | 375 |
609187 | 609187 | 2020-10-08 | Arapahoe | Colorado | 8005 | 10132 | 375 |
605944 | 605944 | 2020-10-07 | Arapahoe | Colorado | 8005 | 10057 | 373 |
602702 | 602702 | 2020-10-06 | Arapahoe | Colorado | 8005 | 9985 | 374 |
599459 | 599459 | 2020-10-05 | Arapahoe | Colorado | 8005 | 9935 | 374 |
596216 | 596216 | 2020-10-04 | Arapahoe | Colorado | 8005 | 9827 | 374 |
592974 | 592974 | 2020-10-03 | Arapahoe | Colorado | 8005 | 9775 | 374 |
589734 | 589734 | 2020-10-02 | Arapahoe | Colorado | 8005 | 9754 | 374 |
586493 | 586493 | 2020-10-01 | Arapahoe | Colorado | 8005 | 9664 | 373 |
583253 | 583253 | 2020-09-30 | Arapahoe | Colorado | 8005 | 9595 | 372 |
580014 | 580014 | 2020-09-29 | Arapahoe | Colorado | 8005 | 9533 | 372 |
576773 | 576773 | 2020-09-28 | Arapahoe | Colorado | 8005 | 9464 | 372 |
573530 | 573530 | 2020-09-27 | Arapahoe | Colorado | 8005 | 9380 | 372 |
570288 | 570288 | 2020-09-26 | Arapahoe | Colorado | 8005 | 9341 | 372 |
567046 | 567046 | 2020-09-25 | Arapahoe | Colorado | 8005 | 9305 | 371 |
563806 | 563806 | 2020-09-24 | Arapahoe | Colorado | 8005 | 9228 | 371 |
560567 | 560567 | 2020-09-23 | Arapahoe | Colorado | 8005 | 9179 | 371 |
557331 | 557331 | 2020-09-22 | Arapahoe | Colorado | 8005 | 9093 | 370 |
554094 | 554094 | 2020-09-21 | Arapahoe | Colorado | 8005 | 9067 | 370 |
550855 | 550855 | 2020-09-20 | Arapahoe | Colorado | 8005 | 8981 | 370 |
547616 | 547616 | 2020-09-19 | Arapahoe | Colorado | 8005 | 8958 | 370 |
544378 | 544378 | 2020-09-18 | Arapahoe | Colorado | 8005 | 8937 | 370 |
541142 | 541142 | 2020-09-17 | Arapahoe | Colorado | 8005 | 8878 | 370 |
537905 | 537905 | 2020-09-16 | Arapahoe | Colorado | 8005 | 8792 | 370 |
534669 | 534669 | 2020-09-15 | Arapahoe | Colorado | 8005 | 8748 | 370 |
531434 | 531434 | 2020-09-14 | Arapahoe | Colorado | 8005 | 8692 | 370 |
528197 | 528197 | 2020-09-13 | Arapahoe | Colorado | 8005 | 8656 | 370 |
524961 | 524961 | 2020-09-12 | Arapahoe | Colorado | 8005 | 8624 | 370 |
521725 | 521725 | 2020-09-11 | Arapahoe | Colorado | 8005 | 8575 | 370 |
518488 | 518488 | 2020-09-10 | Arapahoe | Colorado | 8005 | 8549 | 370 |
515253 | 515253 | 2020-09-09 | Arapahoe | Colorado | 8005 | 8496 | 370 |
512020 | 512020 | 2020-09-08 | Arapahoe | Colorado | 8005 | 8468 | 370 |
508787 | 508787 | 2020-09-07 | Arapahoe | Colorado | 8005 | 8450 | 370 |
505555 | 505555 | 2020-09-06 | Arapahoe | Colorado | 8005 | 8436 | 370 |
502321 | 502321 | 2020-09-05 | Arapahoe | Colorado | 8005 | 8419 | 369 |
499087 | 499087 | 2020-09-04 | Arapahoe | Colorado | 8005 | 8381 | 369 |
495854 | 495854 | 2020-09-03 | Arapahoe | Colorado | 8005 | 8346 | 370 |
492620 | 492620 | 2020-09-02 | Arapahoe | Colorado | 8005 | 8320 | 370 |
489387 | 489387 | 2020-09-01 | Arapahoe | Colorado | 8005 | 8277 | 369 |
486154 | 486154 | 2020-08-31 | Arapahoe | Colorado | 8005 | 8237 | 368 |
482919 | 482919 | 2020-08-30 | Arapahoe | Colorado | 8005 | 8195 | 367 |
479685 | 479685 | 2020-08-29 | Arapahoe | Colorado | 8005 | 8170 | 367 |
476452 | 476452 | 2020-08-28 | Arapahoe | Colorado | 8005 | 8170 | 367 |
473219 | 473219 | 2020-08-27 | Arapahoe | Colorado | 8005 | 8114 | 367 |
469987 | 469987 | 2020-08-26 | Arapahoe | Colorado | 8005 | 8071 | 367 |
466758 | 466758 | 2020-08-25 | Arapahoe | Colorado | 8005 | 8051 | 367 |
463529 | 463529 | 2020-08-24 | Arapahoe | Colorado | 8005 | 7990 | 366 |
460300 | 460300 | 2020-08-23 | Arapahoe | Colorado | 8005 | 7957 | 366 |
457073 | 457073 | 2020-08-22 | Arapahoe | Colorado | 8005 | 7791 | 364 |
453845 | 453845 | 2020-08-21 | Arapahoe | Colorado | 8005 | 7760 | 364 |
450617 | 450617 | 2020-08-20 | Arapahoe | Colorado | 8005 | 7706 | 364 |
447389 | 447389 | 2020-08-19 | Arapahoe | Colorado | 8005 | 7669 | 364 |
444162 | 444162 | 2020-08-18 | Arapahoe | Colorado | 8005 | 7646 | 364 |
440936 | 440936 | 2020-08-17 | Arapahoe | Colorado | 8005 | 7610 | 364 |
437710 | 437710 | 2020-08-16 | Arapahoe | Colorado | 8005 | 7594 | 364 |
434484 | 434484 | 2020-08-15 | Arapahoe | Colorado | 8005 | 7547 | 364 |
431259 | 431259 | 2020-08-14 | Arapahoe | Colorado | 8005 | 7497 | 363 |
428031 | 428031 | 2020-08-13 | Arapahoe | Colorado | 8005 | 7461 | 363 |
424807 | 424807 | 2020-08-12 | Arapahoe | Colorado | 8005 | 7405 | 363 |
421586 | 421586 | 2020-08-11 | Arapahoe | Colorado | 8005 | 7377 | 362 |
418365 | 418365 | 2020-08-10 | Arapahoe | Colorado | 8005 | 7340 | 364 |
415144 | 415144 | 2020-08-09 | Arapahoe | Colorado | 8005 | 7311 | 364 |
411924 | 411924 | 2020-08-08 | Arapahoe | Colorado | 8005 | 7286 | 364 |
408705 | 408705 | 2020-08-07 | Arapahoe | Colorado | 8005 | 7234 | 364 |
405485 | 405485 | 2020-08-06 | Arapahoe | Colorado | 8005 | 7194 | 363 |
402267 | 402267 | 2020-08-05 | Arapahoe | Colorado | 8005 | 7156 | 364 |
399051 | 399051 | 2020-08-04 | Arapahoe | Colorado | 8005 | 7093 | 364 |
395835 | 395835 | 2020-08-03 | Arapahoe | Colorado | 8005 | 7023 | 363 |
392619 | 392619 | 2020-08-02 | Arapahoe | Colorado | 8005 | 7004 | 363 |
389402 | 389402 | 2020-08-01 | Arapahoe | Colorado | 8005 | 6932 | 363 |
386185 | 386185 | 2020-07-31 | Arapahoe | Colorado | 8005 | 6877 | 362 |
382967 | 382967 | 2020-07-30 | Arapahoe | Colorado | 8005 | 6798 | 362 |
379750 | 379750 | 2020-07-29 | Arapahoe | Colorado | 8005 | 6749 | 362 |
376533 | 376533 | 2020-07-28 | Arapahoe | Colorado | 8005 | 6691 | 362 |
373319 | 373319 | 2020-07-27 | Arapahoe | Colorado | 8005 | 6570 | 360 |
370107 | 370107 | 2020-07-26 | Arapahoe | Colorado | 8005 | 6541 | 360 |
366897 | 366897 | 2020-07-25 | Arapahoe | Colorado | 8005 | 6470 | 360 |
363690 | 363690 | 2020-07-24 | Arapahoe | Colorado | 8005 | 6373 | 360 |
360483 | 360483 | 2020-07-23 | Arapahoe | Colorado | 8005 | 6276 | 360 |
357278 | 357278 | 2020-07-22 | Arapahoe | Colorado | 8005 | 6197 | 352 |
354075 | 354075 | 2020-07-21 | Arapahoe | Colorado | 8005 | 6140 | 352 |
350873 | 350873 | 2020-07-20 | Arapahoe | Colorado | 8005 | 6075 | 352 |
347672 | 347672 | 2020-07-19 | Arapahoe | Colorado | 8005 | 6032 | 351 |
344472 | 344472 | 2020-07-18 | Arapahoe | Colorado | 8005 | 5990 | 351 |
341273 | 341273 | 2020-07-17 | Arapahoe | Colorado | 8005 | 5934 | 351 |
338077 | 338077 | 2020-07-16 | Arapahoe | Colorado | 8005 | 5854 | 351 |
334882 | 334882 | 2020-07-15 | Arapahoe | Colorado | 8005 | 5789 | 352 |
331689 | 331689 | 2020-07-14 | Arapahoe | Colorado | 8005 | 5734 | 352 |
328503 | 328503 | 2020-07-13 | Arapahoe | Colorado | 8005 | 5682 | 349 |
325317 | 325317 | 2020-07-12 | Arapahoe | Colorado | 8005 | 5647 | 349 |
322136 | 322136 | 2020-07-11 | Arapahoe | Colorado | 8005 | 5627 | 349 |
318957 | 318957 | 2020-07-10 | Arapahoe | Colorado | 8005 | 5583 | 349 |
315784 | 315784 | 2020-07-09 | Arapahoe | Colorado | 8005 | 5510 | 349 |
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);