ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Latimer" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195296 | 1195296 | 2021-04-06 | Latimer | Oklahoma | 40077 | 828 | 10 |
1192048 | 1192048 | 2021-04-05 | Latimer | Oklahoma | 40077 | 828 | 10 |
1188799 | 1188799 | 2021-04-04 | Latimer | Oklahoma | 40077 | 828 | 10 |
1185552 | 1185552 | 2021-04-03 | Latimer | Oklahoma | 40077 | 828 | 10 |
1182305 | 1182305 | 2021-04-02 | Latimer | Oklahoma | 40077 | 828 | 10 |
1179058 | 1179058 | 2021-04-01 | Latimer | Oklahoma | 40077 | 828 | 10 |
1175811 | 1175811 | 2021-03-31 | Latimer | Oklahoma | 40077 | 828 | 10 |
1172564 | 1172564 | 2021-03-30 | Latimer | Oklahoma | 40077 | 828 | 10 |
1169317 | 1169317 | 2021-03-29 | Latimer | Oklahoma | 40077 | 828 | 10 |
1166069 | 1166069 | 2021-03-28 | Latimer | Oklahoma | 40077 | 828 | 10 |
1162821 | 1162821 | 2021-03-27 | Latimer | Oklahoma | 40077 | 828 | 10 |
1159572 | 1159572 | 2021-03-26 | Latimer | Oklahoma | 40077 | 828 | 10 |
1156325 | 1156325 | 2021-03-25 | Latimer | Oklahoma | 40077 | 828 | 10 |
1153078 | 1153078 | 2021-03-24 | Latimer | Oklahoma | 40077 | 828 | 10 |
1149831 | 1149831 | 2021-03-23 | Latimer | Oklahoma | 40077 | 827 | 9 |
1146584 | 1146584 | 2021-03-22 | Latimer | Oklahoma | 40077 | 827 | 9 |
1143337 | 1143337 | 2021-03-21 | Latimer | Oklahoma | 40077 | 827 | 9 |
1140090 | 1140090 | 2021-03-20 | Latimer | Oklahoma | 40077 | 827 | 9 |
1136844 | 1136844 | 2021-03-19 | Latimer | Oklahoma | 40077 | 827 | 9 |
1133598 | 1133598 | 2021-03-18 | Latimer | Oklahoma | 40077 | 827 | 9 |
1130350 | 1130350 | 2021-03-17 | Latimer | Oklahoma | 40077 | 827 | 9 |
1127103 | 1127103 | 2021-03-16 | Latimer | Oklahoma | 40077 | 827 | 9 |
1123857 | 1123857 | 2021-03-15 | Latimer | Oklahoma | 40077 | 827 | 9 |
1120611 | 1120611 | 2021-03-14 | Latimer | Oklahoma | 40077 | 827 | 9 |
1117364 | 1117364 | 2021-03-13 | Latimer | Oklahoma | 40077 | 826 | 9 |
1114117 | 1114117 | 2021-03-12 | Latimer | Oklahoma | 40077 | 826 | 9 |
1110871 | 1110871 | 2021-03-11 | Latimer | Oklahoma | 40077 | 826 | 9 |
1107625 | 1107625 | 2021-03-10 | Latimer | Oklahoma | 40077 | 823 | 9 |
1104379 | 1104379 | 2021-03-09 | Latimer | Oklahoma | 40077 | 820 | 9 |
1101133 | 1101133 | 2021-03-08 | Latimer | Oklahoma | 40077 | 820 | 9 |
1097887 | 1097887 | 2021-03-07 | Latimer | Oklahoma | 40077 | 818 | 9 |
1094639 | 1094639 | 2021-03-06 | Latimer | Oklahoma | 40077 | 815 | 9 |
1091393 | 1091393 | 2021-03-05 | Latimer | Oklahoma | 40077 | 812 | 9 |
1088147 | 1088147 | 2021-03-04 | Latimer | Oklahoma | 40077 | 812 | 9 |
1084902 | 1084902 | 2021-03-03 | Latimer | Oklahoma | 40077 | 804 | 9 |
1081656 | 1081656 | 2021-03-02 | Latimer | Oklahoma | 40077 | 802 | 9 |
1078410 | 1078410 | 2021-03-01 | Latimer | Oklahoma | 40077 | 801 | 9 |
1075165 | 1075165 | 2021-02-28 | Latimer | Oklahoma | 40077 | 801 | 9 |
1071919 | 1071919 | 2021-02-27 | Latimer | Oklahoma | 40077 | 800 | 9 |
1068673 | 1068673 | 2021-02-26 | Latimer | Oklahoma | 40077 | 799 | 9 |
1065428 | 1065428 | 2021-02-25 | Latimer | Oklahoma | 40077 | 798 | 9 |
1062184 | 1062184 | 2021-02-24 | Latimer | Oklahoma | 40077 | 794 | 8 |
1058938 | 1058938 | 2021-02-23 | Latimer | Oklahoma | 40077 | 793 | 8 |
1055692 | 1055692 | 2021-02-22 | Latimer | Oklahoma | 40077 | 793 | 8 |
1052446 | 1052446 | 2021-02-21 | Latimer | Oklahoma | 40077 | 788 | 8 |
1049199 | 1049199 | 2021-02-20 | Latimer | Oklahoma | 40077 | 786 | 8 |
1045952 | 1045952 | 2021-02-19 | Latimer | Oklahoma | 40077 | 786 | 8 |
1042707 | 1042707 | 2021-02-18 | Latimer | Oklahoma | 40077 | 785 | 8 |
1039462 | 1039462 | 2021-02-17 | Latimer | Oklahoma | 40077 | 784 | 8 |
1036217 | 1036217 | 2021-02-16 | Latimer | Oklahoma | 40077 | 784 | 8 |
1032972 | 1032972 | 2021-02-15 | Latimer | Oklahoma | 40077 | 784 | 8 |
1029726 | 1029726 | 2021-02-14 | Latimer | Oklahoma | 40077 | 783 | 8 |
1026479 | 1026479 | 2021-02-13 | Latimer | Oklahoma | 40077 | 779 | 8 |
1023234 | 1023234 | 2021-02-12 | Latimer | Oklahoma | 40077 | 779 | 8 |
1019989 | 1019989 | 2021-02-11 | Latimer | Oklahoma | 40077 | 777 | 8 |
1016744 | 1016744 | 2021-02-10 | Latimer | Oklahoma | 40077 | 773 | 8 |
1013499 | 1013499 | 2021-02-09 | Latimer | Oklahoma | 40077 | 768 | 8 |
1010254 | 1010254 | 2021-02-08 | Latimer | Oklahoma | 40077 | 765 | 8 |
1007008 | 1007008 | 2021-02-07 | Latimer | Oklahoma | 40077 | 765 | 8 |
1003762 | 1003762 | 2021-02-06 | Latimer | Oklahoma | 40077 | 764 | 8 |
1000516 | 1000516 | 2021-02-05 | Latimer | Oklahoma | 40077 | 760 | 8 |
997270 | 997270 | 2021-02-04 | Latimer | Oklahoma | 40077 | 758 | 8 |
994024 | 994024 | 2021-02-03 | Latimer | Oklahoma | 40077 | 755 | 8 |
990778 | 990778 | 2021-02-02 | Latimer | Oklahoma | 40077 | 745 | 8 |
987532 | 987532 | 2021-02-01 | Latimer | Oklahoma | 40077 | 745 | 8 |
984285 | 984285 | 2021-01-31 | Latimer | Oklahoma | 40077 | 743 | 8 |
981038 | 981038 | 2021-01-30 | Latimer | Oklahoma | 40077 | 742 | 8 |
977792 | 977792 | 2021-01-29 | Latimer | Oklahoma | 40077 | 728 | 8 |
974547 | 974547 | 2021-01-28 | Latimer | Oklahoma | 40077 | 724 | 7 |
971302 | 971302 | 2021-01-27 | Latimer | Oklahoma | 40077 | 721 | 7 |
968057 | 968057 | 2021-01-26 | Latimer | Oklahoma | 40077 | 714 | 7 |
964813 | 964813 | 2021-01-25 | Latimer | Oklahoma | 40077 | 714 | 7 |
961568 | 961568 | 2021-01-24 | Latimer | Oklahoma | 40077 | 703 | 7 |
958323 | 958323 | 2021-01-23 | Latimer | Oklahoma | 40077 | 700 | 7 |
955077 | 955077 | 2021-01-22 | Latimer | Oklahoma | 40077 | 692 | 7 |
951832 | 951832 | 2021-01-21 | Latimer | Oklahoma | 40077 | 685 | 7 |
948587 | 948587 | 2021-01-20 | Latimer | Oklahoma | 40077 | 674 | 7 |
945341 | 945341 | 2021-01-19 | Latimer | Oklahoma | 40077 | 668 | 7 |
942094 | 942094 | 2021-01-18 | Latimer | Oklahoma | 40077 | 666 | 7 |
938849 | 938849 | 2021-01-17 | Latimer | Oklahoma | 40077 | 663 | 7 |
935604 | 935604 | 2021-01-16 | Latimer | Oklahoma | 40077 | 659 | 7 |
932359 | 932359 | 2021-01-15 | Latimer | Oklahoma | 40077 | 650 | 7 |
929114 | 929114 | 2021-01-14 | Latimer | Oklahoma | 40077 | 644 | 7 |
925869 | 925869 | 2021-01-13 | Latimer | Oklahoma | 40077 | 637 | 7 |
922623 | 922623 | 2021-01-12 | Latimer | Oklahoma | 40077 | 629 | 7 |
919378 | 919378 | 2021-01-11 | Latimer | Oklahoma | 40077 | 627 | 7 |
916133 | 916133 | 2021-01-10 | Latimer | Oklahoma | 40077 | 625 | 7 |
912888 | 912888 | 2021-01-09 | Latimer | Oklahoma | 40077 | 616 | 7 |
909643 | 909643 | 2021-01-08 | Latimer | Oklahoma | 40077 | 607 | 7 |
906398 | 906398 | 2021-01-07 | Latimer | Oklahoma | 40077 | 597 | 6 |
903152 | 903152 | 2021-01-06 | Latimer | Oklahoma | 40077 | 589 | 6 |
899907 | 899907 | 2021-01-05 | Latimer | Oklahoma | 40077 | 571 | 5 |
896662 | 896662 | 2021-01-04 | Latimer | Oklahoma | 40077 | 571 | 5 |
893416 | 893416 | 2021-01-03 | Latimer | Oklahoma | 40077 | 567 | 5 |
890170 | 890170 | 2021-01-02 | Latimer | Oklahoma | 40077 | 547 | 5 |
886923 | 886923 | 2021-01-01 | Latimer | Oklahoma | 40077 | 532 | 5 |
883678 | 883678 | 2020-12-31 | Latimer | Oklahoma | 40077 | 532 | 5 |
880433 | 880433 | 2020-12-30 | Latimer | Oklahoma | 40077 | 515 | 5 |
877188 | 877188 | 2020-12-29 | Latimer | Oklahoma | 40077 | 505 | 5 |
873943 | 873943 | 2020-12-28 | Latimer | Oklahoma | 40077 | 502 | 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);