ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Choctaw" and fips = 40023 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15262 | 15262 | 2020-03-27 | Choctaw | Oklahoma | 40023 | 1 | 0 |
17107 | 17107 | 2020-03-28 | Choctaw | Oklahoma | 40023 | 1 | 0 |
19041 | 19041 | 2020-03-29 | Choctaw | Oklahoma | 40023 | 1 | 0 |
21089 | 21089 | 2020-03-30 | Choctaw | Oklahoma | 40023 | 1 | 0 |
23222 | 23222 | 2020-03-31 | Choctaw | Oklahoma | 40023 | 1 | 0 |
25418 | 25418 | 2020-04-01 | Choctaw | Oklahoma | 40023 | 1 | 0 |
27688 | 27688 | 2020-04-02 | Choctaw | Oklahoma | 40023 | 1 | 0 |
30017 | 30017 | 2020-04-03 | Choctaw | Oklahoma | 40023 | 1 | 0 |
32406 | 32406 | 2020-04-04 | Choctaw | Oklahoma | 40023 | 2 | 0 |
34840 | 34840 | 2020-04-05 | Choctaw | Oklahoma | 40023 | 2 | 0 |
37313 | 37313 | 2020-04-06 | Choctaw | Oklahoma | 40023 | 2 | 0 |
39832 | 39832 | 2020-04-07 | Choctaw | Oklahoma | 40023 | 2 | 0 |
42392 | 42392 | 2020-04-08 | Choctaw | Oklahoma | 40023 | 2 | 0 |
44978 | 44978 | 2020-04-09 | Choctaw | Oklahoma | 40023 | 2 | 0 |
47593 | 47593 | 2020-04-10 | Choctaw | Oklahoma | 40023 | 2 | 0 |
50249 | 50249 | 2020-04-11 | Choctaw | Oklahoma | 40023 | 2 | 0 |
52922 | 52922 | 2020-04-12 | Choctaw | Oklahoma | 40023 | 2 | 0 |
55607 | 55607 | 2020-04-13 | Choctaw | Oklahoma | 40023 | 2 | 0 |
58308 | 58308 | 2020-04-14 | Choctaw | Oklahoma | 40023 | 3 | 0 |
61023 | 61023 | 2020-04-15 | Choctaw | Oklahoma | 40023 | 3 | 0 |
63749 | 63749 | 2020-04-16 | Choctaw | Oklahoma | 40023 | 3 | 0 |
66492 | 66492 | 2020-04-17 | Choctaw | Oklahoma | 40023 | 3 | 0 |
69249 | 69249 | 2020-04-18 | Choctaw | Oklahoma | 40023 | 3 | 0 |
72016 | 72016 | 2020-04-19 | Choctaw | Oklahoma | 40023 | 3 | 0 |
74791 | 74791 | 2020-04-20 | Choctaw | Oklahoma | 40023 | 3 | 0 |
77572 | 77572 | 2020-04-21 | Choctaw | Oklahoma | 40023 | 3 | 0 |
80362 | 80362 | 2020-04-22 | Choctaw | Oklahoma | 40023 | 3 | 0 |
83161 | 83161 | 2020-04-23 | Choctaw | Oklahoma | 40023 | 3 | 0 |
85965 | 85965 | 2020-04-24 | Choctaw | Oklahoma | 40023 | 3 | 0 |
88779 | 88779 | 2020-04-25 | Choctaw | Oklahoma | 40023 | 3 | 0 |
91595 | 91595 | 2020-04-26 | Choctaw | Oklahoma | 40023 | 3 | 0 |
94421 | 94421 | 2020-04-27 | Choctaw | Oklahoma | 40023 | 3 | 0 |
97259 | 97259 | 2020-04-28 | Choctaw | Oklahoma | 40023 | 3 | 0 |
100108 | 100108 | 2020-04-29 | Choctaw | Oklahoma | 40023 | 3 | 0 |
102961 | 102961 | 2020-04-30 | Choctaw | Oklahoma | 40023 | 3 | 0 |
105824 | 105824 | 2020-05-01 | Choctaw | Oklahoma | 40023 | 3 | 0 |
108691 | 108691 | 2020-05-02 | Choctaw | Oklahoma | 40023 | 3 | 0 |
111565 | 111565 | 2020-05-03 | Choctaw | Oklahoma | 40023 | 3 | 0 |
114447 | 114447 | 2020-05-04 | Choctaw | Oklahoma | 40023 | 3 | 0 |
117328 | 117328 | 2020-05-05 | Choctaw | Oklahoma | 40023 | 3 | 0 |
120289 | 120289 | 2020-05-06 | Choctaw | Oklahoma | 40023 | 3 | 0 |
123266 | 123266 | 2020-05-07 | Choctaw | Oklahoma | 40023 | 3 | 0 |
126249 | 126249 | 2020-05-08 | Choctaw | Oklahoma | 40023 | 3 | 0 |
129238 | 129238 | 2020-05-09 | Choctaw | Oklahoma | 40023 | 3 | 0 |
132227 | 132227 | 2020-05-10 | Choctaw | Oklahoma | 40023 | 3 | 0 |
135218 | 135218 | 2020-05-11 | Choctaw | Oklahoma | 40023 | 3 | 0 |
138208 | 138208 | 2020-05-12 | Choctaw | Oklahoma | 40023 | 3 | 0 |
141204 | 141204 | 2020-05-13 | Choctaw | Oklahoma | 40023 | 3 | 0 |
144199 | 144199 | 2020-05-14 | Choctaw | Oklahoma | 40023 | 3 | 0 |
147200 | 147200 | 2020-05-15 | Choctaw | Oklahoma | 40023 | 3 | 0 |
150207 | 150207 | 2020-05-16 | Choctaw | Oklahoma | 40023 | 3 | 0 |
153218 | 153218 | 2020-05-17 | Choctaw | Oklahoma | 40023 | 4 | 0 |
156235 | 156235 | 2020-05-18 | Choctaw | Oklahoma | 40023 | 5 | 0 |
159255 | 159255 | 2020-05-19 | Choctaw | Oklahoma | 40023 | 6 | 0 |
162282 | 162282 | 2020-05-20 | Choctaw | Oklahoma | 40023 | 12 | 0 |
165311 | 165311 | 2020-05-21 | Choctaw | Oklahoma | 40023 | 12 | 0 |
168347 | 168347 | 2020-05-22 | Choctaw | Oklahoma | 40023 | 14 | 0 |
171386 | 171386 | 2020-05-23 | Choctaw | Oklahoma | 40023 | 14 | 0 |
174428 | 174428 | 2020-05-24 | Choctaw | Oklahoma | 40023 | 18 | 0 |
177472 | 177472 | 2020-05-25 | Choctaw | Oklahoma | 40023 | 21 | 0 |
180515 | 180515 | 2020-05-26 | Choctaw | Oklahoma | 40023 | 25 | 0 |
183564 | 183564 | 2020-05-27 | Choctaw | Oklahoma | 40023 | 27 | 0 |
186621 | 186621 | 2020-05-28 | Choctaw | Oklahoma | 40023 | 30 | 1 |
189681 | 189681 | 2020-05-29 | Choctaw | Oklahoma | 40023 | 32 | 1 |
192746 | 192746 | 2020-05-30 | Choctaw | Oklahoma | 40023 | 39 | 1 |
195815 | 195815 | 2020-05-31 | Choctaw | Oklahoma | 40023 | 48 | 1 |
198888 | 198888 | 2020-06-01 | Choctaw | Oklahoma | 40023 | 73 | 1 |
201963 | 201963 | 2020-06-02 | Choctaw | Oklahoma | 40023 | 76 | 1 |
205040 | 205040 | 2020-06-03 | Choctaw | Oklahoma | 40023 | 87 | 1 |
208121 | 208121 | 2020-06-04 | Choctaw | Oklahoma | 40023 | 90 | 1 |
211203 | 211203 | 2020-06-05 | Choctaw | Oklahoma | 40023 | 97 | 1 |
214289 | 214289 | 2020-06-06 | Choctaw | Oklahoma | 40023 | 98 | 1 |
217379 | 217379 | 2020-06-07 | Choctaw | Oklahoma | 40023 | 98 | 1 |
220471 | 220471 | 2020-06-08 | Choctaw | Oklahoma | 40023 | 100 | 1 |
223566 | 223566 | 2020-06-09 | Choctaw | Oklahoma | 40023 | 100 | 1 |
226666 | 226666 | 2020-06-10 | Choctaw | Oklahoma | 40023 | 101 | 1 |
229770 | 229770 | 2020-06-11 | Choctaw | Oklahoma | 40023 | 101 | 1 |
232875 | 232875 | 2020-06-12 | Choctaw | Oklahoma | 40023 | 102 | 1 |
235980 | 235980 | 2020-06-13 | Choctaw | Oklahoma | 40023 | 102 | 1 |
239088 | 239088 | 2020-06-14 | Choctaw | Oklahoma | 40023 | 102 | 1 |
242197 | 242197 | 2020-06-15 | Choctaw | Oklahoma | 40023 | 102 | 1 |
245309 | 245309 | 2020-06-16 | Choctaw | Oklahoma | 40023 | 105 | 1 |
248422 | 248422 | 2020-06-17 | Choctaw | Oklahoma | 40023 | 106 | 1 |
251537 | 251537 | 2020-06-18 | Choctaw | Oklahoma | 40023 | 107 | 1 |
254652 | 254652 | 2020-06-19 | Choctaw | Oklahoma | 40023 | 107 | 1 |
257778 | 257778 | 2020-06-20 | Choctaw | Oklahoma | 40023 | 107 | 1 |
260904 | 260904 | 2020-06-21 | Choctaw | Oklahoma | 40023 | 107 | 1 |
264032 | 264032 | 2020-06-22 | Choctaw | Oklahoma | 40023 | 108 | 1 |
267160 | 267160 | 2020-06-23 | Choctaw | Oklahoma | 40023 | 108 | 1 |
270294 | 270294 | 2020-06-24 | Choctaw | Oklahoma | 40023 | 108 | 1 |
273433 | 273433 | 2020-06-25 | Choctaw | Oklahoma | 40023 | 108 | 1 |
276580 | 276580 | 2020-06-26 | Choctaw | Oklahoma | 40023 | 108 | 1 |
279728 | 279728 | 2020-06-27 | Choctaw | Oklahoma | 40023 | 110 | 1 |
282874 | 282874 | 2020-06-28 | Choctaw | Oklahoma | 40023 | 110 | 1 |
286019 | 286019 | 2020-06-29 | Choctaw | Oklahoma | 40023 | 110 | 1 |
289169 | 289169 | 2020-06-30 | Choctaw | Oklahoma | 40023 | 112 | 1 |
292321 | 292321 | 2020-07-01 | Choctaw | Oklahoma | 40023 | 112 | 1 |
295477 | 295477 | 2020-07-02 | Choctaw | Oklahoma | 40023 | 114 | 1 |
298636 | 298636 | 2020-07-03 | Choctaw | Oklahoma | 40023 | 114 | 1 |
301799 | 301799 | 2020-07-04 | Choctaw | Oklahoma | 40023 | 118 | 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);