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 |
---|---|---|---|---|---|---|---|
1055725 | 1055725 | 2021-02-22 | Tulsa | Oklahoma | 40143 | 70137 | 674 |
1052479 | 1052479 | 2021-02-21 | Tulsa | Oklahoma | 40143 | 70029 | 672 |
1049232 | 1049232 | 2021-02-20 | Tulsa | Oklahoma | 40143 | 69924 | 671 |
1045985 | 1045985 | 2021-02-19 | Tulsa | Oklahoma | 40143 | 69600 | 668 |
1042740 | 1042740 | 2021-02-18 | Tulsa | Oklahoma | 40143 | 69314 | 667 |
1039495 | 1039495 | 2021-02-17 | Tulsa | Oklahoma | 40143 | 69112 | 661 |
1036250 | 1036250 | 2021-02-16 | Tulsa | Oklahoma | 40143 | 68882 | 654 |
1033005 | 1033005 | 2021-02-15 | Tulsa | Oklahoma | 40143 | 68807 | 651 |
1029759 | 1029759 | 2021-02-14 | Tulsa | Oklahoma | 40143 | 68655 | 650 |
1026512 | 1026512 | 2021-02-13 | Tulsa | Oklahoma | 40143 | 68417 | 648 |
1023267 | 1023267 | 2021-02-12 | Tulsa | Oklahoma | 40143 | 68160 | 645 |
1020022 | 1020022 | 2021-02-11 | Tulsa | Oklahoma | 40143 | 67930 | 644 |
1016777 | 1016777 | 2021-02-10 | Tulsa | Oklahoma | 40143 | 67702 | 637 |
1013532 | 1013532 | 2021-02-09 | Tulsa | Oklahoma | 40143 | 67459 | 629 |
1010287 | 1010287 | 2021-02-08 | Tulsa | Oklahoma | 40143 | 67251 | 625 |
1007041 | 1007041 | 2021-02-07 | Tulsa | Oklahoma | 40143 | 67052 | 625 |
1003795 | 1003795 | 2021-02-06 | Tulsa | Oklahoma | 40143 | 66585 | 618 |
1000549 | 1000549 | 2021-02-05 | Tulsa | Oklahoma | 40143 | 66160 | 610 |
997303 | 997303 | 2021-02-04 | Tulsa | Oklahoma | 40143 | 65555 | 606 |
994057 | 994057 | 2021-02-03 | Tulsa | Oklahoma | 40143 | 65112 | 600 |
990811 | 990811 | 2021-02-02 | Tulsa | Oklahoma | 40143 | 64677 | 593 |
987565 | 987565 | 2021-02-01 | Tulsa | Oklahoma | 40143 | 64380 | 589 |
984318 | 984318 | 2021-01-31 | Tulsa | Oklahoma | 40143 | 64115 | 587 |
981071 | 981071 | 2021-01-30 | Tulsa | Oklahoma | 40143 | 63643 | 582 |
977825 | 977825 | 2021-01-29 | Tulsa | Oklahoma | 40143 | 63201 | 573 |
974580 | 974580 | 2021-01-28 | Tulsa | Oklahoma | 40143 | 62739 | 564 |
971335 | 971335 | 2021-01-27 | Tulsa | Oklahoma | 40143 | 62297 | 557 |
968090 | 968090 | 2021-01-26 | Tulsa | Oklahoma | 40143 | 61814 | 546 |
964846 | 964846 | 2021-01-25 | Tulsa | Oklahoma | 40143 | 61489 | 541 |
961601 | 961601 | 2021-01-24 | Tulsa | Oklahoma | 40143 | 61145 | 541 |
958356 | 958356 | 2021-01-23 | Tulsa | Oklahoma | 40143 | 60653 | 531 |
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 |
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);