ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 40143 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282932 | 282932 | 2020-06-28 | Tulsa | Oklahoma | 40143 | 3251 | 67 |
279786 | 279786 | 2020-06-27 | Tulsa | Oklahoma | 40143 | 3178 | 67 |
276638 | 276638 | 2020-06-26 | Tulsa | Oklahoma | 40143 | 3103 | 66 |
273491 | 273491 | 2020-06-25 | Tulsa | Oklahoma | 40143 | 2949 | 66 |
270352 | 270352 | 2020-06-24 | Tulsa | Oklahoma | 40143 | 2742 | 66 |
267218 | 267218 | 2020-06-23 | Tulsa | Oklahoma | 40143 | 2483 | 66 |
264090 | 264090 | 2020-06-22 | Tulsa | Oklahoma | 40143 | 2392 | 66 |
260962 | 260962 | 2020-06-21 | Tulsa | Oklahoma | 40143 | 2349 | 66 |
257835 | 257835 | 2020-06-20 | Tulsa | Oklahoma | 40143 | 2206 | 66 |
254709 | 254709 | 2020-06-19 | Tulsa | Oklahoma | 40143 | 2070 | 65 |
251594 | 251594 | 2020-06-18 | Tulsa | Oklahoma | 40143 | 1945 | 65 |
248479 | 248479 | 2020-06-17 | Tulsa | Oklahoma | 40143 | 1825 | 64 |
245366 | 245366 | 2020-06-16 | Tulsa | Oklahoma | 40143 | 1729 | 64 |
242254 | 242254 | 2020-06-15 | Tulsa | Oklahoma | 40143 | 1653 | 62 |
239145 | 239145 | 2020-06-14 | Tulsa | Oklahoma | 40143 | 1564 | 62 |
236037 | 236037 | 2020-06-13 | Tulsa | Oklahoma | 40143 | 1525 | 62 |
232932 | 232932 | 2020-06-12 | Tulsa | Oklahoma | 40143 | 1443 | 62 |
229827 | 229827 | 2020-06-11 | Tulsa | Oklahoma | 40143 | 1372 | 62 |
226723 | 226723 | 2020-06-10 | Tulsa | Oklahoma | 40143 | 1308 | 61 |
223623 | 223623 | 2020-06-09 | Tulsa | Oklahoma | 40143 | 1261 | 61 |
220528 | 220528 | 2020-06-08 | Tulsa | Oklahoma | 40143 | 1196 | 60 |
217436 | 217436 | 2020-06-07 | Tulsa | Oklahoma | 40143 | 1188 | 60 |
214346 | 214346 | 2020-06-06 | Tulsa | Oklahoma | 40143 | 1165 | 59 |
211260 | 211260 | 2020-06-05 | Tulsa | Oklahoma | 40143 | 1134 | 59 |
208178 | 208178 | 2020-06-04 | Tulsa | Oklahoma | 40143 | 1109 | 59 |
205097 | 205097 | 2020-06-03 | Tulsa | Oklahoma | 40143 | 1087 | 57 |
202020 | 202020 | 2020-06-02 | Tulsa | Oklahoma | 40143 | 1057 | 57 |
198945 | 198945 | 2020-06-01 | Tulsa | Oklahoma | 40143 | 1022 | 54 |
195872 | 195872 | 2020-05-31 | Tulsa | Oklahoma | 40143 | 1014 | 54 |
192803 | 192803 | 2020-05-30 | Tulsa | Oklahoma | 40143 | 998 | 54 |
189738 | 189738 | 2020-05-29 | Tulsa | Oklahoma | 40143 | 983 | 51 |
186677 | 186677 | 2020-05-28 | Tulsa | Oklahoma | 40143 | 960 | 49 |
183620 | 183620 | 2020-05-27 | Tulsa | Oklahoma | 40143 | 958 | 49 |
180571 | 180571 | 2020-05-26 | Tulsa | Oklahoma | 40143 | 935 | 47 |
177528 | 177528 | 2020-05-25 | Tulsa | Oklahoma | 40143 | 926 | 44 |
174484 | 174484 | 2020-05-24 | Tulsa | Oklahoma | 40143 | 915 | 44 |
171442 | 171442 | 2020-05-23 | Tulsa | Oklahoma | 40143 | 903 | 44 |
168403 | 168403 | 2020-05-22 | Tulsa | Oklahoma | 40143 | 890 | 41 |
165367 | 165367 | 2020-05-21 | Tulsa | Oklahoma | 40143 | 852 | 40 |
162338 | 162338 | 2020-05-20 | Tulsa | Oklahoma | 40143 | 814 | 39 |
159311 | 159311 | 2020-05-19 | Tulsa | Oklahoma | 40143 | 802 | 37 |
156290 | 156290 | 2020-05-18 | Tulsa | Oklahoma | 40143 | 787 | 37 |
153273 | 153273 | 2020-05-17 | Tulsa | Oklahoma | 40143 | 781 | 37 |
150262 | 150262 | 2020-05-16 | Tulsa | Oklahoma | 40143 | 776 | 37 |
147255 | 147255 | 2020-05-15 | Tulsa | Oklahoma | 40143 | 752 | 37 |
144254 | 144254 | 2020-05-14 | Tulsa | Oklahoma | 40143 | 743 | 37 |
141259 | 141259 | 2020-05-13 | Tulsa | Oklahoma | 40143 | 734 | 37 |
138263 | 138263 | 2020-05-12 | Tulsa | Oklahoma | 40143 | 717 | 37 |
135273 | 135273 | 2020-05-11 | Tulsa | Oklahoma | 40143 | 708 | 36 |
132282 | 132282 | 2020-05-10 | Tulsa | Oklahoma | 40143 | 700 | 36 |
129293 | 129293 | 2020-05-09 | Tulsa | Oklahoma | 40143 | 695 | 36 |
126304 | 126304 | 2020-05-08 | Tulsa | Oklahoma | 40143 | 684 | 36 |
123321 | 123321 | 2020-05-07 | Tulsa | Oklahoma | 40143 | 676 | 36 |
120344 | 120344 | 2020-05-06 | Tulsa | Oklahoma | 40143 | 653 | 36 |
117383 | 117383 | 2020-05-05 | Tulsa | Oklahoma | 40143 | 645 | 36 |
114502 | 114502 | 2020-05-04 | Tulsa | Oklahoma | 40143 | 639 | 34 |
111620 | 111620 | 2020-05-03 | Tulsa | Oklahoma | 40143 | 628 | 34 |
108746 | 108746 | 2020-05-02 | Tulsa | Oklahoma | 40143 | 607 | 34 |
105879 | 105879 | 2020-05-01 | Tulsa | Oklahoma | 40143 | 584 | 33 |
103016 | 103016 | 2020-04-30 | Tulsa | Oklahoma | 40143 | 567 | 33 |
100163 | 100163 | 2020-04-29 | Tulsa | Oklahoma | 40143 | 522 | 33 |
97314 | 97314 | 2020-04-28 | Tulsa | Oklahoma | 40143 | 506 | 32 |
94476 | 94476 | 2020-04-27 | Tulsa | Oklahoma | 40143 | 490 | 28 |
91649 | 91649 | 2020-04-26 | Tulsa | Oklahoma | 40143 | 491 | 27 |
88833 | 88833 | 2020-04-25 | Tulsa | Oklahoma | 40143 | 479 | 27 |
86019 | 86019 | 2020-04-24 | Tulsa | Oklahoma | 40143 | 467 | 27 |
83215 | 83215 | 2020-04-23 | Tulsa | Oklahoma | 40143 | 454 | 26 |
80416 | 80416 | 2020-04-22 | Tulsa | Oklahoma | 40143 | 437 | 25 |
77626 | 77626 | 2020-04-21 | Tulsa | Oklahoma | 40143 | 432 | 25 |
74844 | 74844 | 2020-04-20 | Tulsa | Oklahoma | 40143 | 422 | 22 |
72069 | 72069 | 2020-04-19 | Tulsa | Oklahoma | 40143 | 411 | 22 |
69302 | 69302 | 2020-04-18 | Tulsa | Oklahoma | 40143 | 409 | 22 |
66544 | 66544 | 2020-04-17 | Tulsa | Oklahoma | 40143 | 390 | 22 |
63799 | 63799 | 2020-04-16 | Tulsa | Oklahoma | 40143 | 376 | 21 |
61073 | 61073 | 2020-04-15 | Tulsa | Oklahoma | 40143 | 362 | 21 |
58358 | 58358 | 2020-04-14 | Tulsa | Oklahoma | 40143 | 358 | 19 |
55656 | 55656 | 2020-04-13 | Tulsa | Oklahoma | 40143 | 337 | 18 |
52971 | 52971 | 2020-04-12 | Tulsa | Oklahoma | 40143 | 332 | 18 |
50298 | 50298 | 2020-04-11 | Tulsa | Oklahoma | 40143 | 323 | 16 |
47642 | 47642 | 2020-04-10 | Tulsa | Oklahoma | 40143 | 314 | 16 |
45025 | 45025 | 2020-04-09 | Tulsa | Oklahoma | 40143 | 308 | 16 |
42439 | 42439 | 2020-04-08 | Tulsa | Oklahoma | 40143 | 293 | 16 |
39879 | 39879 | 2020-04-07 | Tulsa | Oklahoma | 40143 | 273 | 14 |
37358 | 37358 | 2020-04-06 | Tulsa | Oklahoma | 40143 | 249 | 8 |
34884 | 34884 | 2020-04-05 | Tulsa | Oklahoma | 40143 | 240 | 8 |
32450 | 32450 | 2020-04-04 | Tulsa | Oklahoma | 40143 | 221 | 8 |
30060 | 30060 | 2020-04-03 | Tulsa | Oklahoma | 40143 | 175 | 8 |
27728 | 27728 | 2020-04-02 | Tulsa | Oklahoma | 40143 | 151 | 5 |
25456 | 25456 | 2020-04-01 | Tulsa | Oklahoma | 40143 | 115 | 3 |
23259 | 23259 | 2020-03-31 | Tulsa | Oklahoma | 40143 | 83 | 3 |
21126 | 21126 | 2020-03-30 | Tulsa | Oklahoma | 40143 | 65 | 3 |
19076 | 19076 | 2020-03-29 | Tulsa | Oklahoma | 40143 | 61 | 3 |
17138 | 17138 | 2020-03-28 | Tulsa | Oklahoma | 40143 | 57 | 3 |
15291 | 15291 | 2020-03-27 | Tulsa | Oklahoma | 40143 | 49 | 1 |
13547 | 13547 | 2020-03-26 | Tulsa | Oklahoma | 40143 | 41 | 1 |
11931 | 11931 | 2020-03-25 | Tulsa | Oklahoma | 40143 | 27 | 1 |
10470 | 10470 | 2020-03-24 | Tulsa | Oklahoma | 40143 | 12 | 1 |
9153 | 9153 | 2020-03-23 | Tulsa | Oklahoma | 40143 | 11 | 1 |
7944 | 7944 | 2020-03-22 | Tulsa | Oklahoma | 40143 | 6 | 1 |
6829 | 6829 | 2020-03-21 | Tulsa | Oklahoma | 40143 | 5 | 1 |
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);