ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 40143 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 280 ✖
- 1694 30
- 1022 14
- 0 13
- 1 9
- 37 8
- 761 8
- 2028 8
- 36 7
- 66 7
- 723 7
- 746 7
- 774 7
- 794 7
- 1014 7
- 1033 7
- 1044 7
- 1054 7
- 1061 7
- 1109 7
- 1112 7
- 1113 7
- 1118 7
- 1124 7
- 1126 7
- 1131 7
- 1135 7
- 1148 7
- 1157 7
- 1162 7
- 1180 7
- 1196 7
- 1228 7
- 1273 7
- 1312 7
- 1365 7
- 1406 7
- 1440 7
- 1482 7
- 1505 7
- 1640 7
- 1669 7
- 1788 7
- 1797 7
- 1806 7
- 1809 7
- 1816 7
- 1829 7
- 1854 7
- 1880 7
- 1899 7
- 1914 7
- 1948 7
- 1979 7
- 2072 7
- 2104 7
- 2120 7
- 2139 7
- 2148 7
- 2155 7
- 2162 7
- 2168 7
- 2178 7
- 72 6
- 3 5
- 62 5
- 1766 5
- 8 4
- 16 4
- 22 4
- 67 4
- 101 4
- 144 4
- 152 4
- 27 3
- 33 3
- 34 3
- 44 3
- 54 3
- 59 3
- 75 3
- 89 3
- 90 3
- 107 3
- 113 3
- 132 3
- 139 3
- 160 3
- 176 3
- 200 3
- 214 3
- 226 3
- 18 2
- 21 2
- 25 2
- 49 2
- 57 2
- 60 2
- 61 2
- 64 2
- 65 2
- 84 2
- 98 2
- 123 2
- 125 2
- 128 2
- 143 2
- 166 2
- 168 2
- 182 2
- 185 2
- 231 2
- 235 2
- 254 2
- 260 2
- 289 2
- 350 2
- 367 2
- 399 2
- 415 2
- 457 2
- 541 2
- 625 2
- 2183 2
- 5 1
- 14 1
- 19 1
- 26 1
- 28 1
- 32 1
- 39 1
- 40 1
- 41 1
- 47 1
- 51 1
- 69 1
- 70 1
- 71 1
- 76 1
- 78 1
- 79 1
- 81 1
- 83 1
- 85 1
- 86 1
- 93 1
- 94 1
- 103 1
- 105 1
- 106 1
- 108 1
- 110 1
- 114 1
- 116 1
- 120 1
- 122 1
- 126 1
- 127 1
- 129 1
- 134 1
- 135 1
- 136 1
- 137 1
- 140 1
- 147 1
- 149 1
- 151 1
- 153 1
- 155 1
- 156 1
- 159 1
- 162 1
- 167 1
- 169 1
- 171 1
- 172 1
- 175 1
- 178 1
- 180 1
- 183 1
- 186 1
- 190 1
- 193 1
- 195 1
- 197 1
- 201 1
- 204 1
- 206 1
- 211 1
- 218 1
- 219 1
- 221 1
- 225 1
- 228 1
- 233 1
- 238 1
- 240 1
- 243 1
- 246 1
- 248 1
- 257 1
- 258 1
- 264 1
- 265 1
- 268 1
- 269 1
- 270 1
- 279 1
- 282 1
- 284 1
- 286 1
- 290 1
- 292 1
- 295 1
- 303 1
- 310 1
- 312 1
- 317 1
- 319 1
- 328 1
- 331 1
- 338 1
- 343 1
- 351 1
- 361 1
- 373 1
- 375 1
- 376 1
- 379 1
- 395 1
- 411 1
- 416 1
- 429 1
- 437 1
- 444 1
- 450 1
- 455 1
- 475 1
- 479 1
- 486 1
- 491 1
- 496 1
- 497 1
- 502 1
- 509 1
- 518 1
- 526 1
- 531 1
- 546 1
- 557 1
- 564 1
- 573 1
- 582 1
- 587 1
- 589 1
- 593 1
- 600 1
- 606 1
- 610 1
- 618 1
- 629 1
- 637 1
- 644 1
- 645 1
- 648 1
- 650 1
- 651 1
- 654 1
- 661 1
- 667 1
- 668 1
- 671 1
- 672 1
- 674 1
- 676 1
- 681 1
- 687 1
- 688 1
- 696 1
- 704 1
- 710 1
state 1
- Oklahoma 799
fips 1
- 40143 · 799 ✖
county 1
- Tulsa 799
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
633 | 633 | 2020-03-06 | Tulsa | Oklahoma | 40143 | 1 | 0 |
722 | 722 | 2020-03-07 | Tulsa | Oklahoma | 40143 | 1 | 0 |
829 | 829 | 2020-03-08 | Tulsa | Oklahoma | 40143 | 1 | 0 |
957 | 957 | 2020-03-09 | Tulsa | Oklahoma | 40143 | 1 | 0 |
1108 | 1108 | 2020-03-10 | Tulsa | Oklahoma | 40143 | 2 | 0 |
1297 | 1297 | 2020-03-11 | Tulsa | Oklahoma | 40143 | 2 | 0 |
1540 | 1540 | 2020-03-12 | Tulsa | Oklahoma | 40143 | 2 | 0 |
1836 | 1836 | 2020-03-13 | Tulsa | Oklahoma | 40143 | 2 | 0 |
2197 | 2197 | 2020-03-14 | Tulsa | Oklahoma | 40143 | 2 | 0 |
2616 | 2616 | 2020-03-15 | Tulsa | Oklahoma | 40143 | 3 | 0 |
3080 | 3080 | 2020-03-16 | Tulsa | Oklahoma | 40143 | 3 | 0 |
3608 | 3608 | 2020-03-17 | Tulsa | Oklahoma | 40143 | 4 | 0 |
4223 | 4223 | 2020-03-18 | Tulsa | Oklahoma | 40143 | 4 | 0 |
4961 | 4961 | 2020-03-19 | Tulsa | Oklahoma | 40143 | 5 | 1 |
5828 | 5828 | 2020-03-20 | Tulsa | Oklahoma | 40143 | 5 | 1 |
6829 | 6829 | 2020-03-21 | Tulsa | Oklahoma | 40143 | 5 | 1 |
7944 | 7944 | 2020-03-22 | Tulsa | Oklahoma | 40143 | 6 | 1 |
9153 | 9153 | 2020-03-23 | Tulsa | Oklahoma | 40143 | 11 | 1 |
10470 | 10470 | 2020-03-24 | Tulsa | Oklahoma | 40143 | 12 | 1 |
11931 | 11931 | 2020-03-25 | Tulsa | Oklahoma | 40143 | 27 | 1 |
13547 | 13547 | 2020-03-26 | Tulsa | Oklahoma | 40143 | 41 | 1 |
15291 | 15291 | 2020-03-27 | Tulsa | Oklahoma | 40143 | 49 | 1 |
17138 | 17138 | 2020-03-28 | Tulsa | Oklahoma | 40143 | 57 | 3 |
19076 | 19076 | 2020-03-29 | Tulsa | Oklahoma | 40143 | 61 | 3 |
21126 | 21126 | 2020-03-30 | Tulsa | Oklahoma | 40143 | 65 | 3 |
23259 | 23259 | 2020-03-31 | Tulsa | Oklahoma | 40143 | 83 | 3 |
25456 | 25456 | 2020-04-01 | Tulsa | Oklahoma | 40143 | 115 | 3 |
27728 | 27728 | 2020-04-02 | Tulsa | Oklahoma | 40143 | 151 | 5 |
30060 | 30060 | 2020-04-03 | Tulsa | Oklahoma | 40143 | 175 | 8 |
32450 | 32450 | 2020-04-04 | Tulsa | Oklahoma | 40143 | 221 | 8 |
34884 | 34884 | 2020-04-05 | Tulsa | Oklahoma | 40143 | 240 | 8 |
37358 | 37358 | 2020-04-06 | Tulsa | Oklahoma | 40143 | 249 | 8 |
39879 | 39879 | 2020-04-07 | Tulsa | Oklahoma | 40143 | 273 | 14 |
42439 | 42439 | 2020-04-08 | Tulsa | Oklahoma | 40143 | 293 | 16 |
45025 | 45025 | 2020-04-09 | Tulsa | Oklahoma | 40143 | 308 | 16 |
47642 | 47642 | 2020-04-10 | Tulsa | Oklahoma | 40143 | 314 | 16 |
50298 | 50298 | 2020-04-11 | Tulsa | Oklahoma | 40143 | 323 | 16 |
52971 | 52971 | 2020-04-12 | Tulsa | Oklahoma | 40143 | 332 | 18 |
55656 | 55656 | 2020-04-13 | Tulsa | Oklahoma | 40143 | 337 | 18 |
58358 | 58358 | 2020-04-14 | Tulsa | Oklahoma | 40143 | 358 | 19 |
61073 | 61073 | 2020-04-15 | Tulsa | Oklahoma | 40143 | 362 | 21 |
63799 | 63799 | 2020-04-16 | Tulsa | Oklahoma | 40143 | 376 | 21 |
66544 | 66544 | 2020-04-17 | Tulsa | Oklahoma | 40143 | 390 | 22 |
69302 | 69302 | 2020-04-18 | Tulsa | Oklahoma | 40143 | 409 | 22 |
72069 | 72069 | 2020-04-19 | Tulsa | Oklahoma | 40143 | 411 | 22 |
74844 | 74844 | 2020-04-20 | Tulsa | Oklahoma | 40143 | 422 | 22 |
77626 | 77626 | 2020-04-21 | Tulsa | Oklahoma | 40143 | 432 | 25 |
80416 | 80416 | 2020-04-22 | Tulsa | Oklahoma | 40143 | 437 | 25 |
83215 | 83215 | 2020-04-23 | Tulsa | Oklahoma | 40143 | 454 | 26 |
86019 | 86019 | 2020-04-24 | Tulsa | Oklahoma | 40143 | 467 | 27 |
88833 | 88833 | 2020-04-25 | Tulsa | Oklahoma | 40143 | 479 | 27 |
91649 | 91649 | 2020-04-26 | Tulsa | Oklahoma | 40143 | 491 | 27 |
94476 | 94476 | 2020-04-27 | Tulsa | Oklahoma | 40143 | 490 | 28 |
97314 | 97314 | 2020-04-28 | Tulsa | Oklahoma | 40143 | 506 | 32 |
100163 | 100163 | 2020-04-29 | Tulsa | Oklahoma | 40143 | 522 | 33 |
103016 | 103016 | 2020-04-30 | Tulsa | Oklahoma | 40143 | 567 | 33 |
105879 | 105879 | 2020-05-01 | Tulsa | Oklahoma | 40143 | 584 | 33 |
108746 | 108746 | 2020-05-02 | Tulsa | Oklahoma | 40143 | 607 | 34 |
111620 | 111620 | 2020-05-03 | Tulsa | Oklahoma | 40143 | 628 | 34 |
114502 | 114502 | 2020-05-04 | Tulsa | Oklahoma | 40143 | 639 | 34 |
117383 | 117383 | 2020-05-05 | Tulsa | Oklahoma | 40143 | 645 | 36 |
120344 | 120344 | 2020-05-06 | Tulsa | Oklahoma | 40143 | 653 | 36 |
123321 | 123321 | 2020-05-07 | Tulsa | Oklahoma | 40143 | 676 | 36 |
126304 | 126304 | 2020-05-08 | Tulsa | Oklahoma | 40143 | 684 | 36 |
129293 | 129293 | 2020-05-09 | Tulsa | Oklahoma | 40143 | 695 | 36 |
132282 | 132282 | 2020-05-10 | Tulsa | Oklahoma | 40143 | 700 | 36 |
135273 | 135273 | 2020-05-11 | Tulsa | Oklahoma | 40143 | 708 | 36 |
138263 | 138263 | 2020-05-12 | Tulsa | Oklahoma | 40143 | 717 | 37 |
141259 | 141259 | 2020-05-13 | Tulsa | Oklahoma | 40143 | 734 | 37 |
144254 | 144254 | 2020-05-14 | Tulsa | Oklahoma | 40143 | 743 | 37 |
147255 | 147255 | 2020-05-15 | Tulsa | Oklahoma | 40143 | 752 | 37 |
150262 | 150262 | 2020-05-16 | Tulsa | Oklahoma | 40143 | 776 | 37 |
153273 | 153273 | 2020-05-17 | Tulsa | Oklahoma | 40143 | 781 | 37 |
156290 | 156290 | 2020-05-18 | Tulsa | Oklahoma | 40143 | 787 | 37 |
159311 | 159311 | 2020-05-19 | Tulsa | Oklahoma | 40143 | 802 | 37 |
162338 | 162338 | 2020-05-20 | Tulsa | Oklahoma | 40143 | 814 | 39 |
165367 | 165367 | 2020-05-21 | Tulsa | Oklahoma | 40143 | 852 | 40 |
168403 | 168403 | 2020-05-22 | Tulsa | Oklahoma | 40143 | 890 | 41 |
171442 | 171442 | 2020-05-23 | Tulsa | Oklahoma | 40143 | 903 | 44 |
174484 | 174484 | 2020-05-24 | Tulsa | Oklahoma | 40143 | 915 | 44 |
177528 | 177528 | 2020-05-25 | Tulsa | Oklahoma | 40143 | 926 | 44 |
180571 | 180571 | 2020-05-26 | Tulsa | Oklahoma | 40143 | 935 | 47 |
183620 | 183620 | 2020-05-27 | Tulsa | Oklahoma | 40143 | 958 | 49 |
186677 | 186677 | 2020-05-28 | Tulsa | Oklahoma | 40143 | 960 | 49 |
189738 | 189738 | 2020-05-29 | Tulsa | Oklahoma | 40143 | 983 | 51 |
192803 | 192803 | 2020-05-30 | Tulsa | Oklahoma | 40143 | 998 | 54 |
195872 | 195872 | 2020-05-31 | Tulsa | Oklahoma | 40143 | 1014 | 54 |
198945 | 198945 | 2020-06-01 | Tulsa | Oklahoma | 40143 | 1022 | 54 |
202020 | 202020 | 2020-06-02 | Tulsa | Oklahoma | 40143 | 1057 | 57 |
205097 | 205097 | 2020-06-03 | Tulsa | Oklahoma | 40143 | 1087 | 57 |
208178 | 208178 | 2020-06-04 | Tulsa | Oklahoma | 40143 | 1109 | 59 |
211260 | 211260 | 2020-06-05 | Tulsa | Oklahoma | 40143 | 1134 | 59 |
214346 | 214346 | 2020-06-06 | Tulsa | Oklahoma | 40143 | 1165 | 59 |
217436 | 217436 | 2020-06-07 | Tulsa | Oklahoma | 40143 | 1188 | 60 |
220528 | 220528 | 2020-06-08 | Tulsa | Oklahoma | 40143 | 1196 | 60 |
223623 | 223623 | 2020-06-09 | Tulsa | Oklahoma | 40143 | 1261 | 61 |
226723 | 226723 | 2020-06-10 | Tulsa | Oklahoma | 40143 | 1308 | 61 |
229827 | 229827 | 2020-06-11 | Tulsa | Oklahoma | 40143 | 1372 | 62 |
232932 | 232932 | 2020-06-12 | Tulsa | Oklahoma | 40143 | 1443 | 62 |
236037 | 236037 | 2020-06-13 | Tulsa | Oklahoma | 40143 | 1525 | 62 |
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);