ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Beckham" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195262 | 1195262 | 2021-04-06 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1192014 | 1192014 | 2021-04-05 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1188765 | 1188765 | 2021-04-04 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1185518 | 1185518 | 2021-04-03 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1182271 | 1182271 | 2021-04-02 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1179024 | 1179024 | 2021-04-01 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1175777 | 1175777 | 2021-03-31 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1172530 | 1172530 | 2021-03-30 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1169283 | 1169283 | 2021-03-29 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1166035 | 1166035 | 2021-03-28 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1162787 | 1162787 | 2021-03-27 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1159538 | 1159538 | 2021-03-26 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1156291 | 1156291 | 2021-03-25 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1153044 | 1153044 | 2021-03-24 | Beckham | Oklahoma | 40009 | 2843 | 39 |
1149797 | 1149797 | 2021-03-23 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1146550 | 1146550 | 2021-03-22 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1143303 | 1143303 | 2021-03-21 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1140056 | 1140056 | 2021-03-20 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1136810 | 1136810 | 2021-03-19 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1133564 | 1133564 | 2021-03-18 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1130316 | 1130316 | 2021-03-17 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1127069 | 1127069 | 2021-03-16 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1123823 | 1123823 | 2021-03-15 | Beckham | Oklahoma | 40009 | 2819 | 39 |
1120577 | 1120577 | 2021-03-14 | Beckham | Oklahoma | 40009 | 2816 | 39 |
1117330 | 1117330 | 2021-03-13 | Beckham | Oklahoma | 40009 | 2812 | 39 |
1114083 | 1114083 | 2021-03-12 | Beckham | Oklahoma | 40009 | 2804 | 39 |
1110837 | 1110837 | 2021-03-11 | Beckham | Oklahoma | 40009 | 2803 | 39 |
1107591 | 1107591 | 2021-03-10 | Beckham | Oklahoma | 40009 | 2800 | 39 |
1104345 | 1104345 | 2021-03-09 | Beckham | Oklahoma | 40009 | 2801 | 39 |
1101099 | 1101099 | 2021-03-08 | Beckham | Oklahoma | 40009 | 2798 | 37 |
1097853 | 1097853 | 2021-03-07 | Beckham | Oklahoma | 40009 | 2799 | 37 |
1094605 | 1094605 | 2021-03-06 | Beckham | Oklahoma | 40009 | 2797 | 37 |
1091359 | 1091359 | 2021-03-05 | Beckham | Oklahoma | 40009 | 2793 | 37 |
1088113 | 1088113 | 2021-03-04 | Beckham | Oklahoma | 40009 | 2773 | 37 |
1084868 | 1084868 | 2021-03-03 | Beckham | Oklahoma | 40009 | 2759 | 37 |
1081622 | 1081622 | 2021-03-02 | Beckham | Oklahoma | 40009 | 2709 | 37 |
1078376 | 1078376 | 2021-03-01 | Beckham | Oklahoma | 40009 | 2708 | 37 |
1075131 | 1075131 | 2021-02-28 | Beckham | Oklahoma | 40009 | 2708 | 37 |
1071885 | 1071885 | 2021-02-27 | Beckham | Oklahoma | 40009 | 2682 | 37 |
1068639 | 1068639 | 2021-02-26 | Beckham | Oklahoma | 40009 | 2681 | 37 |
1065394 | 1065394 | 2021-02-25 | Beckham | Oklahoma | 40009 | 2679 | 36 |
1062150 | 1062150 | 2021-02-24 | Beckham | Oklahoma | 40009 | 2675 | 35 |
1058904 | 1058904 | 2021-02-23 | Beckham | Oklahoma | 40009 | 2673 | 35 |
1055658 | 1055658 | 2021-02-22 | Beckham | Oklahoma | 40009 | 2673 | 35 |
1052412 | 1052412 | 2021-02-21 | Beckham | Oklahoma | 40009 | 2672 | 35 |
1049165 | 1049165 | 2021-02-20 | Beckham | Oklahoma | 40009 | 2668 | 35 |
1045918 | 1045918 | 2021-02-19 | Beckham | Oklahoma | 40009 | 2664 | 35 |
1042673 | 1042673 | 2021-02-18 | Beckham | Oklahoma | 40009 | 2662 | 35 |
1039428 | 1039428 | 2021-02-17 | Beckham | Oklahoma | 40009 | 2662 | 35 |
1036183 | 1036183 | 2021-02-16 | Beckham | Oklahoma | 40009 | 2659 | 35 |
1032938 | 1032938 | 2021-02-15 | Beckham | Oklahoma | 40009 | 2659 | 35 |
1029692 | 1029692 | 2021-02-14 | Beckham | Oklahoma | 40009 | 2659 | 35 |
1026445 | 1026445 | 2021-02-13 | Beckham | Oklahoma | 40009 | 2649 | 35 |
1023200 | 1023200 | 2021-02-12 | Beckham | Oklahoma | 40009 | 2648 | 34 |
1019955 | 1019955 | 2021-02-11 | Beckham | Oklahoma | 40009 | 2647 | 34 |
1016710 | 1016710 | 2021-02-10 | Beckham | Oklahoma | 40009 | 2603 | 33 |
1013465 | 1013465 | 2021-02-09 | Beckham | Oklahoma | 40009 | 2589 | 33 |
1010220 | 1010220 | 2021-02-08 | Beckham | Oklahoma | 40009 | 2585 | 33 |
1006974 | 1006974 | 2021-02-07 | Beckham | Oklahoma | 40009 | 2584 | 33 |
1003728 | 1003728 | 2021-02-06 | Beckham | Oklahoma | 40009 | 2576 | 32 |
1000482 | 1000482 | 2021-02-05 | Beckham | Oklahoma | 40009 | 2568 | 31 |
997236 | 997236 | 2021-02-04 | Beckham | Oklahoma | 40009 | 2553 | 31 |
993990 | 993990 | 2021-02-03 | Beckham | Oklahoma | 40009 | 2512 | 31 |
990744 | 990744 | 2021-02-02 | Beckham | Oklahoma | 40009 | 2494 | 31 |
987498 | 987498 | 2021-02-01 | Beckham | Oklahoma | 40009 | 2485 | 31 |
984251 | 984251 | 2021-01-31 | Beckham | Oklahoma | 40009 | 2483 | 31 |
981004 | 981004 | 2021-01-30 | Beckham | Oklahoma | 40009 | 2473 | 30 |
977758 | 977758 | 2021-01-29 | Beckham | Oklahoma | 40009 | 2467 | 29 |
974513 | 974513 | 2021-01-28 | Beckham | Oklahoma | 40009 | 2459 | 28 |
971268 | 971268 | 2021-01-27 | Beckham | Oklahoma | 40009 | 2454 | 28 |
968023 | 968023 | 2021-01-26 | Beckham | Oklahoma | 40009 | 2420 | 28 |
964779 | 964779 | 2021-01-25 | Beckham | Oklahoma | 40009 | 2409 | 28 |
961534 | 961534 | 2021-01-24 | Beckham | Oklahoma | 40009 | 2407 | 28 |
958289 | 958289 | 2021-01-23 | Beckham | Oklahoma | 40009 | 2386 | 28 |
955043 | 955043 | 2021-01-22 | Beckham | Oklahoma | 40009 | 2358 | 27 |
951798 | 951798 | 2021-01-21 | Beckham | Oklahoma | 40009 | 2347 | 27 |
948553 | 948553 | 2021-01-20 | Beckham | Oklahoma | 40009 | 2333 | 27 |
945307 | 945307 | 2021-01-19 | Beckham | Oklahoma | 40009 | 2329 | 26 |
942060 | 942060 | 2021-01-18 | Beckham | Oklahoma | 40009 | 2323 | 26 |
938815 | 938815 | 2021-01-17 | Beckham | Oklahoma | 40009 | 2315 | 26 |
935570 | 935570 | 2021-01-16 | Beckham | Oklahoma | 40009 | 2265 | 26 |
932325 | 932325 | 2021-01-15 | Beckham | Oklahoma | 40009 | 2261 | 26 |
929080 | 929080 | 2021-01-14 | Beckham | Oklahoma | 40009 | 2249 | 25 |
925835 | 925835 | 2021-01-13 | Beckham | Oklahoma | 40009 | 2241 | 25 |
922589 | 922589 | 2021-01-12 | Beckham | Oklahoma | 40009 | 2216 | 24 |
919344 | 919344 | 2021-01-11 | Beckham | Oklahoma | 40009 | 2206 | 23 |
916099 | 916099 | 2021-01-10 | Beckham | Oklahoma | 40009 | 2168 | 23 |
912854 | 912854 | 2021-01-09 | Beckham | Oklahoma | 40009 | 2079 | 22 |
909609 | 909609 | 2021-01-08 | Beckham | Oklahoma | 40009 | 2062 | 22 |
906364 | 906364 | 2021-01-07 | Beckham | Oklahoma | 40009 | 2048 | 22 |
903118 | 903118 | 2021-01-06 | Beckham | Oklahoma | 40009 | 2047 | 22 |
899873 | 899873 | 2021-01-05 | Beckham | Oklahoma | 40009 | 2042 | 22 |
896628 | 896628 | 2021-01-04 | Beckham | Oklahoma | 40009 | 2031 | 22 |
893382 | 893382 | 2021-01-03 | Beckham | Oklahoma | 40009 | 2026 | 22 |
890136 | 890136 | 2021-01-02 | Beckham | Oklahoma | 40009 | 1977 | 22 |
886889 | 886889 | 2021-01-01 | Beckham | Oklahoma | 40009 | 1964 | 22 |
883644 | 883644 | 2020-12-31 | Beckham | Oklahoma | 40009 | 1964 | 22 |
880399 | 880399 | 2020-12-30 | Beckham | Oklahoma | 40009 | 1948 | 22 |
877154 | 877154 | 2020-12-29 | Beckham | Oklahoma | 40009 | 1934 | 21 |
873909 | 873909 | 2020-12-28 | Beckham | Oklahoma | 40009 | 1925 | 21 |
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);