ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 40027 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2611 | 2611 | 2020-03-15 | Cleveland | Oklahoma | 40027 | 1 | 0 |
3075 | 3075 | 2020-03-16 | Cleveland | Oklahoma | 40027 | 1 | 0 |
3602 | 3602 | 2020-03-17 | Cleveland | Oklahoma | 40027 | 1 | 0 |
4217 | 4217 | 2020-03-18 | Cleveland | Oklahoma | 40027 | 4 | 0 |
4951 | 4951 | 2020-03-19 | Cleveland | Oklahoma | 40027 | 9 | 0 |
5817 | 5817 | 2020-03-20 | Cleveland | Oklahoma | 40027 | 11 | 0 |
6818 | 6818 | 2020-03-21 | Cleveland | Oklahoma | 40027 | 12 | 0 |
7931 | 7931 | 2020-03-22 | Cleveland | Oklahoma | 40027 | 13 | 0 |
9139 | 9139 | 2020-03-23 | Cleveland | Oklahoma | 40027 | 16 | 0 |
10455 | 10455 | 2020-03-24 | Cleveland | Oklahoma | 40027 | 22 | 1 |
11911 | 11911 | 2020-03-25 | Cleveland | Oklahoma | 40027 | 27 | 1 |
13521 | 13521 | 2020-03-26 | Cleveland | Oklahoma | 40027 | 39 | 3 |
15263 | 15263 | 2020-03-27 | Cleveland | Oklahoma | 40027 | 39 | 3 |
17108 | 17108 | 2020-03-28 | Cleveland | Oklahoma | 40027 | 46 | 5 |
19042 | 19042 | 2020-03-29 | Cleveland | Oklahoma | 40027 | 51 | 5 |
21090 | 21090 | 2020-03-30 | Cleveland | Oklahoma | 40027 | 60 | 6 |
23223 | 23223 | 2020-03-31 | Cleveland | Oklahoma | 40027 | 65 | 6 |
25419 | 25419 | 2020-04-01 | Cleveland | Oklahoma | 40027 | 87 | 6 |
27689 | 27689 | 2020-04-02 | Cleveland | Oklahoma | 40027 | 121 | 6 |
30018 | 30018 | 2020-04-03 | Cleveland | Oklahoma | 40027 | 130 | 7 |
32407 | 32407 | 2020-04-04 | Cleveland | Oklahoma | 40027 | 169 | 8 |
34841 | 34841 | 2020-04-05 | Cleveland | Oklahoma | 40027 | 171 | 11 |
37314 | 37314 | 2020-04-06 | Cleveland | Oklahoma | 40027 | 180 | 11 |
39833 | 39833 | 2020-04-07 | Cleveland | Oklahoma | 40027 | 203 | 12 |
42393 | 42393 | 2020-04-08 | Cleveland | Oklahoma | 40027 | 212 | 14 |
44979 | 44979 | 2020-04-09 | Cleveland | Oklahoma | 40027 | 231 | 14 |
47594 | 47594 | 2020-04-10 | Cleveland | Oklahoma | 40027 | 236 | 14 |
50250 | 50250 | 2020-04-11 | Cleveland | Oklahoma | 40027 | 247 | 17 |
52923 | 52923 | 2020-04-12 | Cleveland | Oklahoma | 40027 | 264 | 17 |
55608 | 55608 | 2020-04-13 | Cleveland | Oklahoma | 40027 | 267 | 17 |
58309 | 58309 | 2020-04-14 | Cleveland | Oklahoma | 40027 | 277 | 17 |
61024 | 61024 | 2020-04-15 | Cleveland | Oklahoma | 40027 | 294 | 18 |
63750 | 63750 | 2020-04-16 | Cleveland | Oklahoma | 40027 | 301 | 21 |
66493 | 66493 | 2020-04-17 | Cleveland | Oklahoma | 40027 | 306 | 21 |
69250 | 69250 | 2020-04-18 | Cleveland | Oklahoma | 40027 | 308 | 21 |
72017 | 72017 | 2020-04-19 | Cleveland | Oklahoma | 40027 | 312 | 21 |
74792 | 74792 | 2020-04-20 | Cleveland | Oklahoma | 40027 | 323 | 23 |
77574 | 77574 | 2020-04-21 | Cleveland | Oklahoma | 40027 | 345 | 23 |
80364 | 80364 | 2020-04-22 | Cleveland | Oklahoma | 40027 | 372 | 24 |
83163 | 83163 | 2020-04-23 | Cleveland | Oklahoma | 40027 | 388 | 26 |
85967 | 85967 | 2020-04-24 | Cleveland | Oklahoma | 40027 | 393 | 27 |
88781 | 88781 | 2020-04-25 | Cleveland | Oklahoma | 40027 | 400 | 27 |
91597 | 91597 | 2020-04-26 | Cleveland | Oklahoma | 40027 | 403 | 27 |
94423 | 94423 | 2020-04-27 | Cleveland | Oklahoma | 40027 | 404 | 27 |
97261 | 97261 | 2020-04-28 | Cleveland | Oklahoma | 40027 | 410 | 28 |
100110 | 100110 | 2020-04-29 | Cleveland | Oklahoma | 40027 | 417 | 28 |
102963 | 102963 | 2020-04-30 | Cleveland | Oklahoma | 40027 | 419 | 28 |
105826 | 105826 | 2020-05-01 | Cleveland | Oklahoma | 40027 | 426 | 29 |
108693 | 108693 | 2020-05-02 | Cleveland | Oklahoma | 40027 | 430 | 29 |
111567 | 111567 | 2020-05-03 | Cleveland | Oklahoma | 40027 | 432 | 29 |
114449 | 114449 | 2020-05-04 | Cleveland | Oklahoma | 40027 | 436 | 29 |
117330 | 117330 | 2020-05-05 | Cleveland | Oklahoma | 40027 | 439 | 30 |
120291 | 120291 | 2020-05-06 | Cleveland | Oklahoma | 40027 | 447 | 31 |
123268 | 123268 | 2020-05-07 | Cleveland | Oklahoma | 40027 | 448 | 32 |
126251 | 126251 | 2020-05-08 | Cleveland | Oklahoma | 40027 | 453 | 32 |
129240 | 129240 | 2020-05-09 | Cleveland | Oklahoma | 40027 | 455 | 32 |
132229 | 132229 | 2020-05-10 | Cleveland | Oklahoma | 40027 | 456 | 32 |
135220 | 135220 | 2020-05-11 | Cleveland | Oklahoma | 40027 | 456 | 32 |
138210 | 138210 | 2020-05-12 | Cleveland | Oklahoma | 40027 | 457 | 33 |
141206 | 141206 | 2020-05-13 | Cleveland | Oklahoma | 40027 | 458 | 33 |
144201 | 144201 | 2020-05-14 | Cleveland | Oklahoma | 40027 | 458 | 35 |
147202 | 147202 | 2020-05-15 | Cleveland | Oklahoma | 40027 | 459 | 35 |
150209 | 150209 | 2020-05-16 | Cleveland | Oklahoma | 40027 | 466 | 36 |
153220 | 153220 | 2020-05-17 | Cleveland | Oklahoma | 40027 | 468 | 36 |
156237 | 156237 | 2020-05-18 | Cleveland | Oklahoma | 40027 | 468 | 36 |
159257 | 159257 | 2020-05-19 | Cleveland | Oklahoma | 40027 | 470 | 36 |
162284 | 162284 | 2020-05-20 | Cleveland | Oklahoma | 40027 | 472 | 37 |
165313 | 165313 | 2020-05-21 | Cleveland | Oklahoma | 40027 | 482 | 37 |
168349 | 168349 | 2020-05-22 | Cleveland | Oklahoma | 40027 | 481 | 37 |
171388 | 171388 | 2020-05-23 | Cleveland | Oklahoma | 40027 | 487 | 37 |
174430 | 174430 | 2020-05-24 | Cleveland | Oklahoma | 40027 | 489 | 37 |
177474 | 177474 | 2020-05-25 | Cleveland | Oklahoma | 40027 | 490 | 37 |
180517 | 180517 | 2020-05-26 | Cleveland | Oklahoma | 40027 | 493 | 37 |
183566 | 183566 | 2020-05-27 | Cleveland | Oklahoma | 40027 | 494 | 37 |
186623 | 186623 | 2020-05-28 | Cleveland | Oklahoma | 40027 | 496 | 37 |
189683 | 189683 | 2020-05-29 | Cleveland | Oklahoma | 40027 | 498 | 37 |
192748 | 192748 | 2020-05-30 | Cleveland | Oklahoma | 40027 | 500 | 37 |
195817 | 195817 | 2020-05-31 | Cleveland | Oklahoma | 40027 | 501 | 37 |
198890 | 198890 | 2020-06-01 | Cleveland | Oklahoma | 40027 | 503 | 37 |
201965 | 201965 | 2020-06-02 | Cleveland | Oklahoma | 40027 | 506 | 37 |
205042 | 205042 | 2020-06-03 | Cleveland | Oklahoma | 40027 | 511 | 37 |
208123 | 208123 | 2020-06-04 | Cleveland | Oklahoma | 40027 | 514 | 37 |
211205 | 211205 | 2020-06-05 | Cleveland | Oklahoma | 40027 | 520 | 37 |
214291 | 214291 | 2020-06-06 | Cleveland | Oklahoma | 40027 | 519 | 37 |
217381 | 217381 | 2020-06-07 | Cleveland | Oklahoma | 40027 | 520 | 37 |
220473 | 220473 | 2020-06-08 | Cleveland | Oklahoma | 40027 | 524 | 37 |
223568 | 223568 | 2020-06-09 | Cleveland | Oklahoma | 40027 | 529 | 39 |
226668 | 226668 | 2020-06-10 | Cleveland | Oklahoma | 40027 | 529 | 40 |
229772 | 229772 | 2020-06-11 | Cleveland | Oklahoma | 40027 | 533 | 40 |
232877 | 232877 | 2020-06-12 | Cleveland | Oklahoma | 40027 | 539 | 40 |
235982 | 235982 | 2020-06-13 | Cleveland | Oklahoma | 40027 | 544 | 40 |
239090 | 239090 | 2020-06-14 | Cleveland | Oklahoma | 40027 | 546 | 40 |
242199 | 242199 | 2020-06-15 | Cleveland | Oklahoma | 40027 | 552 | 40 |
245311 | 245311 | 2020-06-16 | Cleveland | Oklahoma | 40027 | 564 | 40 |
248424 | 248424 | 2020-06-17 | Cleveland | Oklahoma | 40027 | 576 | 40 |
251539 | 251539 | 2020-06-18 | Cleveland | Oklahoma | 40027 | 605 | 40 |
254654 | 254654 | 2020-06-19 | Cleveland | Oklahoma | 40027 | 620 | 40 |
257780 | 257780 | 2020-06-20 | Cleveland | Oklahoma | 40027 | 640 | 40 |
260906 | 260906 | 2020-06-21 | Cleveland | Oklahoma | 40027 | 677 | 40 |
264034 | 264034 | 2020-06-22 | Cleveland | Oklahoma | 40027 | 684 | 40 |
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);