ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Tulsa" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955110 | 955110 | 2021-01-22 | Tulsa | Oklahoma | 40143 | 60142 | 526 |
951865 | 951865 | 2021-01-21 | Tulsa | Oklahoma | 40143 | 59629 | 518 |
948620 | 948620 | 2021-01-20 | Tulsa | Oklahoma | 40143 | 59160 | 509 |
945374 | 945374 | 2021-01-19 | Tulsa | Oklahoma | 40143 | 58851 | 502 |
942127 | 942127 | 2021-01-18 | Tulsa | Oklahoma | 40143 | 58471 | 497 |
938882 | 938882 | 2021-01-17 | Tulsa | Oklahoma | 40143 | 58126 | 496 |
935637 | 935637 | 2021-01-16 | Tulsa | Oklahoma | 40143 | 57544 | 491 |
932392 | 932392 | 2021-01-15 | Tulsa | Oklahoma | 40143 | 56914 | 486 |
929147 | 929147 | 2021-01-14 | Tulsa | Oklahoma | 40143 | 56281 | 479 |
925902 | 925902 | 2021-01-13 | Tulsa | Oklahoma | 40143 | 55721 | 475 |
922656 | 922656 | 2021-01-12 | Tulsa | Oklahoma | 40143 | 55098 | 457 |
919411 | 919411 | 2021-01-11 | Tulsa | Oklahoma | 40143 | 54764 | 457 |
916166 | 916166 | 2021-01-10 | Tulsa | Oklahoma | 40143 | 54116 | 455 |
912921 | 912921 | 2021-01-09 | Tulsa | Oklahoma | 40143 | 53356 | 450 |
909676 | 909676 | 2021-01-08 | Tulsa | Oklahoma | 40143 | 52587 | 444 |
906431 | 906431 | 2021-01-07 | Tulsa | Oklahoma | 40143 | 51921 | 437 |
903185 | 903185 | 2021-01-06 | Tulsa | Oklahoma | 40143 | 51319 | 429 |
899940 | 899940 | 2021-01-05 | Tulsa | Oklahoma | 40143 | 50910 | 416 |
896695 | 896695 | 2021-01-04 | Tulsa | Oklahoma | 40143 | 50619 | 415 |
893449 | 893449 | 2021-01-03 | Tulsa | Oklahoma | 40143 | 50050 | 415 |
890203 | 890203 | 2021-01-02 | Tulsa | Oklahoma | 40143 | 48826 | 411 |
886956 | 886956 | 2021-01-01 | Tulsa | Oklahoma | 40143 | 48124 | 399 |
883711 | 883711 | 2020-12-31 | Tulsa | Oklahoma | 40143 | 48124 | 399 |
880466 | 880466 | 2020-12-30 | Tulsa | Oklahoma | 40143 | 47575 | 395 |
877221 | 877221 | 2020-12-29 | Tulsa | Oklahoma | 40143 | 47164 | 379 |
873976 | 873976 | 2020-12-28 | Tulsa | Oklahoma | 40143 | 46999 | 376 |
870731 | 870731 | 2020-12-27 | Tulsa | Oklahoma | 40143 | 46367 | 375 |
867486 | 867486 | 2020-12-26 | Tulsa | Oklahoma | 40143 | 45873 | 373 |
864241 | 864241 | 2020-12-25 | Tulsa | Oklahoma | 40143 | 45349 | 367 |
860996 | 860996 | 2020-12-24 | Tulsa | Oklahoma | 40143 | 45349 | 367 |
857751 | 857751 | 2020-12-23 | Tulsa | Oklahoma | 40143 | 44818 | 361 |
854506 | 854506 | 2020-12-22 | Tulsa | Oklahoma | 40143 | 44433 | 351 |
851261 | 851261 | 2020-12-21 | Tulsa | Oklahoma | 40143 | 44100 | 350 |
848016 | 848016 | 2020-12-20 | Tulsa | Oklahoma | 40143 | 43673 | 350 |
844771 | 844771 | 2020-12-19 | Tulsa | Oklahoma | 40143 | 42564 | 343 |
841525 | 841525 | 2020-12-18 | Tulsa | Oklahoma | 40143 | 41816 | 338 |
838280 | 838280 | 2020-12-17 | Tulsa | Oklahoma | 40143 | 41196 | 331 |
835034 | 835034 | 2020-12-16 | Tulsa | Oklahoma | 40143 | 40757 | 328 |
831788 | 831788 | 2020-12-15 | Tulsa | Oklahoma | 40143 | 40229 | 319 |
828541 | 828541 | 2020-12-14 | Tulsa | Oklahoma | 40143 | 39898 | 317 |
825295 | 825295 | 2020-12-13 | Tulsa | Oklahoma | 40143 | 39625 | 312 |
822048 | 822048 | 2020-12-12 | Tulsa | Oklahoma | 40143 | 39129 | 310 |
818802 | 818802 | 2020-12-11 | Tulsa | Oklahoma | 40143 | 38522 | 303 |
815556 | 815556 | 2020-12-10 | Tulsa | Oklahoma | 40143 | 37922 | 295 |
812310 | 812310 | 2020-12-09 | Tulsa | Oklahoma | 40143 | 37459 | 292 |
809066 | 809066 | 2020-12-08 | Tulsa | Oklahoma | 40143 | 37149 | 290 |
805821 | 805821 | 2020-12-07 | Tulsa | Oklahoma | 40143 | 36702 | 289 |
802576 | 802576 | 2020-12-06 | Tulsa | Oklahoma | 40143 | 36375 | 289 |
799331 | 799331 | 2020-12-05 | Tulsa | Oklahoma | 40143 | 35857 | 286 |
796086 | 796086 | 2020-12-04 | Tulsa | Oklahoma | 40143 | 35243 | 284 |
792841 | 792841 | 2020-12-03 | Tulsa | Oklahoma | 40143 | 34519 | 282 |
789596 | 789596 | 2020-12-02 | Tulsa | Oklahoma | 40143 | 34288 | 279 |
786351 | 786351 | 2020-12-01 | Tulsa | Oklahoma | 40143 | 33863 | 270 |
783107 | 783107 | 2020-11-30 | Tulsa | Oklahoma | 40143 | 33569 | 269 |
779861 | 779861 | 2020-11-29 | Tulsa | Oklahoma | 40143 | 33207 | 268 |
776616 | 776616 | 2020-11-28 | Tulsa | Oklahoma | 40143 | 32961 | 265 |
773371 | 773371 | 2020-11-27 | Tulsa | Oklahoma | 40143 | 31760 | 264 |
770126 | 770126 | 2020-11-26 | Tulsa | Oklahoma | 40143 | 31333 | 260 |
766880 | 766880 | 2020-11-25 | Tulsa | Oklahoma | 40143 | 31333 | 260 |
763635 | 763635 | 2020-11-24 | Tulsa | Oklahoma | 40143 | 30917 | 258 |
760390 | 760390 | 2020-11-23 | Tulsa | Oklahoma | 40143 | 30500 | 257 |
757145 | 757145 | 2020-11-22 | Tulsa | Oklahoma | 40143 | 29991 | 254 |
753898 | 753898 | 2020-11-21 | Tulsa | Oklahoma | 40143 | 29516 | 254 |
750652 | 750652 | 2020-11-20 | Tulsa | Oklahoma | 40143 | 28966 | 248 |
747406 | 747406 | 2020-11-19 | Tulsa | Oklahoma | 40143 | 28506 | 246 |
744160 | 744160 | 2020-11-18 | Tulsa | Oklahoma | 40143 | 28127 | 243 |
740913 | 740913 | 2020-11-17 | Tulsa | Oklahoma | 40143 | 27729 | 240 |
737667 | 737667 | 2020-11-16 | Tulsa | Oklahoma | 40143 | 27501 | 238 |
734423 | 734423 | 2020-11-15 | Tulsa | Oklahoma | 40143 | 27046 | 235 |
731177 | 731177 | 2020-11-14 | Tulsa | Oklahoma | 40143 | 26430 | 235 |
727933 | 727933 | 2020-11-13 | Tulsa | Oklahoma | 40143 | 26064 | 233 |
724689 | 724689 | 2020-11-12 | Tulsa | Oklahoma | 40143 | 25745 | 231 |
721446 | 721446 | 2020-11-11 | Tulsa | Oklahoma | 40143 | 25370 | 231 |
718203 | 718203 | 2020-11-10 | Tulsa | Oklahoma | 40143 | 25024 | 228 |
714960 | 714960 | 2020-11-09 | Tulsa | Oklahoma | 40143 | 24663 | 226 |
711716 | 711716 | 2020-11-08 | Tulsa | Oklahoma | 40143 | 24361 | 226 |
708472 | 708472 | 2020-11-07 | Tulsa | Oklahoma | 40143 | 24361 | 226 |
705229 | 705229 | 2020-11-06 | Tulsa | Oklahoma | 40143 | 23983 | 225 |
701986 | 701986 | 2020-11-05 | Tulsa | Oklahoma | 40143 | 23656 | 221 |
698742 | 698742 | 2020-11-04 | Tulsa | Oklahoma | 40143 | 23351 | 219 |
695499 | 695499 | 2020-11-03 | Tulsa | Oklahoma | 40143 | 23153 | 218 |
692257 | 692257 | 2020-11-02 | Tulsa | Oklahoma | 40143 | 22919 | 214 |
689013 | 689013 | 2020-11-01 | Tulsa | Oklahoma | 40143 | 22742 | 214 |
685768 | 685768 | 2020-10-31 | Tulsa | Oklahoma | 40143 | 22535 | 214 |
682525 | 682525 | 2020-10-30 | Tulsa | Oklahoma | 40143 | 22312 | 211 |
679282 | 679282 | 2020-10-29 | Tulsa | Oklahoma | 40143 | 22096 | 206 |
676039 | 676039 | 2020-10-28 | Tulsa | Oklahoma | 40143 | 21922 | 204 |
672796 | 672796 | 2020-10-27 | Tulsa | Oklahoma | 40143 | 21829 | 201 |
669554 | 669554 | 2020-10-26 | Tulsa | Oklahoma | 40143 | 21692 | 200 |
666310 | 666310 | 2020-10-25 | Tulsa | Oklahoma | 40143 | 21584 | 200 |
663065 | 663065 | 2020-10-24 | Tulsa | Oklahoma | 40143 | 21413 | 200 |
659821 | 659821 | 2020-10-23 | Tulsa | Oklahoma | 40143 | 21239 | 197 |
656577 | 656577 | 2020-10-22 | Tulsa | Oklahoma | 40143 | 21032 | 195 |
653332 | 653332 | 2020-10-21 | Tulsa | Oklahoma | 40143 | 20805 | 193 |
650087 | 650087 | 2020-10-20 | Tulsa | Oklahoma | 40143 | 20639 | 190 |
646843 | 646843 | 2020-10-19 | Tulsa | Oklahoma | 40143 | 20448 | 186 |
643597 | 643597 | 2020-10-18 | Tulsa | Oklahoma | 40143 | 20322 | 185 |
640349 | 640349 | 2020-10-17 | Tulsa | Oklahoma | 40143 | 20251 | 185 |
637103 | 637103 | 2020-10-16 | Tulsa | Oklahoma | 40143 | 20102 | 183 |
633857 | 633857 | 2020-10-15 | Tulsa | Oklahoma | 40143 | 19888 | 182 |
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);