ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Bryan" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955045 | 955045 | 2021-01-22 | Bryan | Oklahoma | 40013 | 5011 | 44 |
951800 | 951800 | 2021-01-21 | Bryan | Oklahoma | 40013 | 4945 | 44 |
948555 | 948555 | 2021-01-20 | Bryan | Oklahoma | 40013 | 4907 | 44 |
945309 | 945309 | 2021-01-19 | Bryan | Oklahoma | 40013 | 4858 | 44 |
942062 | 942062 | 2021-01-18 | Bryan | Oklahoma | 40013 | 4847 | 44 |
938817 | 938817 | 2021-01-17 | Bryan | Oklahoma | 40013 | 4837 | 44 |
935572 | 935572 | 2021-01-16 | Bryan | Oklahoma | 40013 | 4803 | 44 |
932327 | 932327 | 2021-01-15 | Bryan | Oklahoma | 40013 | 4758 | 44 |
929082 | 929082 | 2021-01-14 | Bryan | Oklahoma | 40013 | 4705 | 44 |
925837 | 925837 | 2021-01-13 | Bryan | Oklahoma | 40013 | 4642 | 41 |
922591 | 922591 | 2021-01-12 | Bryan | Oklahoma | 40013 | 4578 | 40 |
919346 | 919346 | 2021-01-11 | Bryan | Oklahoma | 40013 | 4564 | 40 |
916101 | 916101 | 2021-01-10 | Bryan | Oklahoma | 40013 | 4541 | 40 |
912856 | 912856 | 2021-01-09 | Bryan | Oklahoma | 40013 | 4487 | 39 |
909611 | 909611 | 2021-01-08 | Bryan | Oklahoma | 40013 | 4420 | 39 |
906366 | 906366 | 2021-01-07 | Bryan | Oklahoma | 40013 | 4367 | 39 |
903120 | 903120 | 2021-01-06 | Bryan | Oklahoma | 40013 | 4293 | 39 |
899875 | 899875 | 2021-01-05 | Bryan | Oklahoma | 40013 | 4184 | 33 |
896630 | 896630 | 2021-01-04 | Bryan | Oklahoma | 40013 | 4161 | 33 |
893384 | 893384 | 2021-01-03 | Bryan | Oklahoma | 40013 | 4153 | 33 |
890138 | 890138 | 2021-01-02 | Bryan | Oklahoma | 40013 | 4055 | 33 |
886891 | 886891 | 2021-01-01 | Bryan | Oklahoma | 40013 | 3980 | 32 |
883646 | 883646 | 2020-12-31 | Bryan | Oklahoma | 40013 | 3980 | 32 |
880401 | 880401 | 2020-12-30 | Bryan | Oklahoma | 40013 | 3904 | 32 |
877156 | 877156 | 2020-12-29 | Bryan | Oklahoma | 40013 | 3823 | 32 |
873911 | 873911 | 2020-12-28 | Bryan | Oklahoma | 40013 | 3816 | 32 |
870666 | 870666 | 2020-12-27 | Bryan | Oklahoma | 40013 | 3779 | 32 |
867421 | 867421 | 2020-12-26 | Bryan | Oklahoma | 40013 | 3751 | 32 |
864176 | 864176 | 2020-12-25 | Bryan | Oklahoma | 40013 | 3702 | 32 |
860931 | 860931 | 2020-12-24 | Bryan | Oklahoma | 40013 | 3702 | 32 |
857686 | 857686 | 2020-12-23 | Bryan | Oklahoma | 40013 | 3660 | 30 |
854441 | 854441 | 2020-12-22 | Bryan | Oklahoma | 40013 | 3582 | 28 |
851196 | 851196 | 2020-12-21 | Bryan | Oklahoma | 40013 | 3576 | 27 |
847951 | 847951 | 2020-12-20 | Bryan | Oklahoma | 40013 | 3539 | 27 |
844706 | 844706 | 2020-12-19 | Bryan | Oklahoma | 40013 | 3503 | 27 |
841460 | 841460 | 2020-12-18 | Bryan | Oklahoma | 40013 | 3442 | 26 |
838215 | 838215 | 2020-12-17 | Bryan | Oklahoma | 40013 | 3383 | 26 |
834969 | 834969 | 2020-12-16 | Bryan | Oklahoma | 40013 | 3338 | 26 |
831723 | 831723 | 2020-12-15 | Bryan | Oklahoma | 40013 | 3275 | 26 |
828476 | 828476 | 2020-12-14 | Bryan | Oklahoma | 40013 | 3265 | 26 |
825230 | 825230 | 2020-12-13 | Bryan | Oklahoma | 40013 | 3255 | 25 |
821983 | 821983 | 2020-12-12 | Bryan | Oklahoma | 40013 | 3214 | 25 |
818737 | 818737 | 2020-12-11 | Bryan | Oklahoma | 40013 | 3159 | 25 |
815491 | 815491 | 2020-12-10 | Bryan | Oklahoma | 40013 | 3120 | 25 |
812245 | 812245 | 2020-12-09 | Bryan | Oklahoma | 40013 | 3087 | 25 |
809001 | 809001 | 2020-12-08 | Bryan | Oklahoma | 40013 | 3037 | 25 |
805756 | 805756 | 2020-12-07 | Bryan | Oklahoma | 40013 | 3031 | 25 |
802511 | 802511 | 2020-12-06 | Bryan | Oklahoma | 40013 | 3025 | 25 |
799266 | 799266 | 2020-12-05 | Bryan | Oklahoma | 40013 | 2991 | 24 |
796021 | 796021 | 2020-12-04 | Bryan | Oklahoma | 40013 | 2952 | 24 |
792776 | 792776 | 2020-12-03 | Bryan | Oklahoma | 40013 | 2909 | 23 |
789531 | 789531 | 2020-12-02 | Bryan | Oklahoma | 40013 | 2880 | 23 |
786286 | 786286 | 2020-12-01 | Bryan | Oklahoma | 40013 | 2824 | 19 |
783042 | 783042 | 2020-11-30 | Bryan | Oklahoma | 40013 | 2817 | 18 |
779796 | 779796 | 2020-11-29 | Bryan | Oklahoma | 40013 | 2812 | 18 |
776551 | 776551 | 2020-11-28 | Bryan | Oklahoma | 40013 | 2794 | 18 |
773306 | 773306 | 2020-11-27 | Bryan | Oklahoma | 40013 | 2749 | 18 |
770061 | 770061 | 2020-11-26 | Bryan | Oklahoma | 40013 | 2710 | 18 |
766815 | 766815 | 2020-11-25 | Bryan | Oklahoma | 40013 | 2710 | 18 |
763570 | 763570 | 2020-11-24 | Bryan | Oklahoma | 40013 | 2634 | 18 |
760325 | 760325 | 2020-11-23 | Bryan | Oklahoma | 40013 | 2629 | 18 |
757080 | 757080 | 2020-11-22 | Bryan | Oklahoma | 40013 | 2620 | 18 |
753833 | 753833 | 2020-11-21 | Bryan | Oklahoma | 40013 | 2563 | 18 |
750587 | 750587 | 2020-11-20 | Bryan | Oklahoma | 40013 | 2508 | 18 |
747341 | 747341 | 2020-11-19 | Bryan | Oklahoma | 40013 | 2468 | 18 |
744095 | 744095 | 2020-11-18 | Bryan | Oklahoma | 40013 | 2425 | 17 |
740848 | 740848 | 2020-11-17 | Bryan | Oklahoma | 40013 | 2367 | 17 |
737602 | 737602 | 2020-11-16 | Bryan | Oklahoma | 40013 | 2356 | 17 |
734358 | 734358 | 2020-11-15 | Bryan | Oklahoma | 40013 | 2328 | 17 |
731112 | 731112 | 2020-11-14 | Bryan | Oklahoma | 40013 | 2262 | 17 |
727868 | 727868 | 2020-11-13 | Bryan | Oklahoma | 40013 | 2191 | 17 |
724624 | 724624 | 2020-11-12 | Bryan | Oklahoma | 40013 | 2167 | 17 |
721381 | 721381 | 2020-11-11 | Bryan | Oklahoma | 40013 | 2092 | 17 |
718138 | 718138 | 2020-11-10 | Bryan | Oklahoma | 40013 | 2018 | 16 |
714895 | 714895 | 2020-11-09 | Bryan | Oklahoma | 40013 | 1981 | 16 |
711651 | 711651 | 2020-11-08 | Bryan | Oklahoma | 40013 | 1971 | 16 |
708407 | 708407 | 2020-11-07 | Bryan | Oklahoma | 40013 | 1971 | 16 |
705164 | 705164 | 2020-11-06 | Bryan | Oklahoma | 40013 | 1837 | 16 |
701921 | 701921 | 2020-11-05 | Bryan | Oklahoma | 40013 | 1801 | 16 |
698677 | 698677 | 2020-11-04 | Bryan | Oklahoma | 40013 | 1773 | 16 |
695434 | 695434 | 2020-11-03 | Bryan | Oklahoma | 40013 | 1743 | 14 |
692192 | 692192 | 2020-11-02 | Bryan | Oklahoma | 40013 | 1684 | 14 |
688948 | 688948 | 2020-11-01 | Bryan | Oklahoma | 40013 | 1655 | 14 |
685703 | 685703 | 2020-10-31 | Bryan | Oklahoma | 40013 | 1630 | 14 |
682460 | 682460 | 2020-10-30 | Bryan | Oklahoma | 40013 | 1610 | 14 |
679217 | 679217 | 2020-10-29 | Bryan | Oklahoma | 40013 | 1584 | 13 |
675974 | 675974 | 2020-10-28 | Bryan | Oklahoma | 40013 | 1574 | 13 |
672731 | 672731 | 2020-10-27 | Bryan | Oklahoma | 40013 | 1556 | 13 |
669489 | 669489 | 2020-10-26 | Bryan | Oklahoma | 40013 | 1528 | 11 |
666245 | 666245 | 2020-10-25 | Bryan | Oklahoma | 40013 | 1501 | 11 |
663000 | 663000 | 2020-10-24 | Bryan | Oklahoma | 40013 | 1492 | 11 |
659756 | 659756 | 2020-10-23 | Bryan | Oklahoma | 40013 | 1467 | 11 |
656512 | 656512 | 2020-10-22 | Bryan | Oklahoma | 40013 | 1438 | 11 |
653267 | 653267 | 2020-10-21 | Bryan | Oklahoma | 40013 | 1415 | 11 |
650022 | 650022 | 2020-10-20 | Bryan | Oklahoma | 40013 | 1397 | 11 |
646778 | 646778 | 2020-10-19 | Bryan | Oklahoma | 40013 | 1383 | 11 |
643532 | 643532 | 2020-10-18 | Bryan | Oklahoma | 40013 | 1360 | 11 |
640284 | 640284 | 2020-10-17 | Bryan | Oklahoma | 40013 | 1338 | 11 |
637038 | 637038 | 2020-10-16 | Bryan | Oklahoma | 40013 | 1303 | 5 |
633792 | 633792 | 2020-10-15 | Bryan | Oklahoma | 40013 | 1286 | 5 |
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);