ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Comanche", fips = 40031 and state = "Oklahoma" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13522 | 13522 | 2020-03-26 | Comanche | Oklahoma | 40031 | 3 | 0 |
15264 | 15264 | 2020-03-27 | Comanche | Oklahoma | 40031 | 6 | 0 |
17109 | 17109 | 2020-03-28 | Comanche | Oklahoma | 40031 | 6 | 0 |
19043 | 19043 | 2020-03-29 | Comanche | Oklahoma | 40031 | 11 | 0 |
21091 | 21091 | 2020-03-30 | Comanche | Oklahoma | 40031 | 12 | 0 |
23224 | 23224 | 2020-03-31 | Comanche | Oklahoma | 40031 | 15 | 0 |
25420 | 25420 | 2020-04-01 | Comanche | Oklahoma | 40031 | 21 | 0 |
27690 | 27690 | 2020-04-02 | Comanche | Oklahoma | 40031 | 27 | 0 |
30019 | 30019 | 2020-04-03 | Comanche | Oklahoma | 40031 | 33 | 0 |
32408 | 32408 | 2020-04-04 | Comanche | Oklahoma | 40031 | 37 | 0 |
34842 | 34842 | 2020-04-05 | Comanche | Oklahoma | 40031 | 39 | 0 |
37315 | 37315 | 2020-04-06 | Comanche | Oklahoma | 40031 | 41 | 0 |
39834 | 39834 | 2020-04-07 | Comanche | Oklahoma | 40031 | 42 | 0 |
42394 | 42394 | 2020-04-08 | Comanche | Oklahoma | 40031 | 44 | 0 |
44980 | 44980 | 2020-04-09 | Comanche | Oklahoma | 40031 | 47 | 0 |
47595 | 47595 | 2020-04-10 | Comanche | Oklahoma | 40031 | 47 | 0 |
50251 | 50251 | 2020-04-11 | Comanche | Oklahoma | 40031 | 49 | 0 |
52924 | 52924 | 2020-04-12 | Comanche | Oklahoma | 40031 | 49 | 0 |
55609 | 55609 | 2020-04-13 | Comanche | Oklahoma | 40031 | 51 | 0 |
58310 | 58310 | 2020-04-14 | Comanche | Oklahoma | 40031 | 52 | 0 |
61025 | 61025 | 2020-04-15 | Comanche | Oklahoma | 40031 | 52 | 0 |
63751 | 63751 | 2020-04-16 | Comanche | Oklahoma | 40031 | 57 | 0 |
66494 | 66494 | 2020-04-17 | Comanche | Oklahoma | 40031 | 65 | 0 |
69251 | 69251 | 2020-04-18 | Comanche | Oklahoma | 40031 | 65 | 0 |
72018 | 72018 | 2020-04-19 | Comanche | Oklahoma | 40031 | 67 | 0 |
74793 | 74793 | 2020-04-20 | Comanche | Oklahoma | 40031 | 71 | 0 |
77575 | 77575 | 2020-04-21 | Comanche | Oklahoma | 40031 | 72 | 1 |
80365 | 80365 | 2020-04-22 | Comanche | Oklahoma | 40031 | 71 | 1 |
83164 | 83164 | 2020-04-23 | Comanche | Oklahoma | 40031 | 75 | 1 |
85968 | 85968 | 2020-04-24 | Comanche | Oklahoma | 40031 | 76 | 1 |
88782 | 88782 | 2020-04-25 | Comanche | Oklahoma | 40031 | 76 | 1 |
91598 | 91598 | 2020-04-26 | Comanche | Oklahoma | 40031 | 79 | 1 |
94424 | 94424 | 2020-04-27 | Comanche | Oklahoma | 40031 | 79 | 1 |
97262 | 97262 | 2020-04-28 | Comanche | Oklahoma | 40031 | 79 | 1 |
100111 | 100111 | 2020-04-29 | Comanche | Oklahoma | 40031 | 79 | 1 |
102964 | 102964 | 2020-04-30 | Comanche | Oklahoma | 40031 | 80 | 1 |
105827 | 105827 | 2020-05-01 | Comanche | Oklahoma | 40031 | 81 | 2 |
108694 | 108694 | 2020-05-02 | Comanche | Oklahoma | 40031 | 84 | 2 |
111568 | 111568 | 2020-05-03 | Comanche | Oklahoma | 40031 | 98 | 2 |
114450 | 114450 | 2020-05-04 | Comanche | Oklahoma | 40031 | 102 | 2 |
117331 | 117331 | 2020-05-05 | Comanche | Oklahoma | 40031 | 104 | 2 |
120292 | 120292 | 2020-05-06 | Comanche | Oklahoma | 40031 | 113 | 2 |
123269 | 123269 | 2020-05-07 | Comanche | Oklahoma | 40031 | 115 | 2 |
126252 | 126252 | 2020-05-08 | Comanche | Oklahoma | 40031 | 116 | 2 |
129241 | 129241 | 2020-05-09 | Comanche | Oklahoma | 40031 | 124 | 2 |
132230 | 132230 | 2020-05-10 | Comanche | Oklahoma | 40031 | 124 | 2 |
135221 | 135221 | 2020-05-11 | Comanche | Oklahoma | 40031 | 124 | 2 |
138211 | 138211 | 2020-05-12 | Comanche | Oklahoma | 40031 | 151 | 2 |
141207 | 141207 | 2020-05-13 | Comanche | Oklahoma | 40031 | 184 | 2 |
144202 | 144202 | 2020-05-14 | Comanche | Oklahoma | 40031 | 197 | 3 |
147203 | 147203 | 2020-05-15 | Comanche | Oklahoma | 40031 | 205 | 3 |
150210 | 150210 | 2020-05-16 | Comanche | Oklahoma | 40031 | 215 | 3 |
153221 | 153221 | 2020-05-17 | Comanche | Oklahoma | 40031 | 224 | 3 |
156238 | 156238 | 2020-05-18 | Comanche | Oklahoma | 40031 | 225 | 3 |
159259 | 159259 | 2020-05-19 | Comanche | Oklahoma | 40031 | 229 | 3 |
162286 | 162286 | 2020-05-20 | Comanche | Oklahoma | 40031 | 229 | 3 |
165315 | 165315 | 2020-05-21 | Comanche | Oklahoma | 40031 | 235 | 3 |
168351 | 168351 | 2020-05-22 | Comanche | Oklahoma | 40031 | 236 | 3 |
171390 | 171390 | 2020-05-23 | Comanche | Oklahoma | 40031 | 270 | 3 |
174432 | 174432 | 2020-05-24 | Comanche | Oklahoma | 40031 | 270 | 3 |
177476 | 177476 | 2020-05-25 | Comanche | Oklahoma | 40031 | 268 | 3 |
180519 | 180519 | 2020-05-26 | Comanche | Oklahoma | 40031 | 270 | 3 |
183568 | 183568 | 2020-05-27 | Comanche | Oklahoma | 40031 | 274 | 3 |
186625 | 186625 | 2020-05-28 | Comanche | Oklahoma | 40031 | 278 | 3 |
189685 | 189685 | 2020-05-29 | Comanche | Oklahoma | 40031 | 279 | 3 |
192750 | 192750 | 2020-05-30 | Comanche | Oklahoma | 40031 | 279 | 3 |
195819 | 195819 | 2020-05-31 | Comanche | Oklahoma | 40031 | 281 | 3 |
198892 | 198892 | 2020-06-01 | Comanche | Oklahoma | 40031 | 283 | 3 |
201967 | 201967 | 2020-06-02 | Comanche | Oklahoma | 40031 | 285 | 3 |
205044 | 205044 | 2020-06-03 | Comanche | Oklahoma | 40031 | 290 | 3 |
208125 | 208125 | 2020-06-04 | Comanche | Oklahoma | 40031 | 293 | 3 |
211207 | 211207 | 2020-06-05 | Comanche | Oklahoma | 40031 | 306 | 3 |
214293 | 214293 | 2020-06-06 | Comanche | Oklahoma | 40031 | 309 | 3 |
217383 | 217383 | 2020-06-07 | Comanche | Oklahoma | 40031 | 310 | 3 |
220475 | 220475 | 2020-06-08 | Comanche | Oklahoma | 40031 | 310 | 3 |
223570 | 223570 | 2020-06-09 | Comanche | Oklahoma | 40031 | 311 | 3 |
226670 | 226670 | 2020-06-10 | Comanche | Oklahoma | 40031 | 312 | 3 |
229774 | 229774 | 2020-06-11 | Comanche | Oklahoma | 40031 | 317 | 3 |
232879 | 232879 | 2020-06-12 | Comanche | Oklahoma | 40031 | 319 | 4 |
235984 | 235984 | 2020-06-13 | Comanche | Oklahoma | 40031 | 333 | 4 |
239092 | 239092 | 2020-06-14 | Comanche | Oklahoma | 40031 | 337 | 4 |
242201 | 242201 | 2020-06-15 | Comanche | Oklahoma | 40031 | 341 | 4 |
245313 | 245313 | 2020-06-16 | Comanche | Oklahoma | 40031 | 339 | 4 |
248426 | 248426 | 2020-06-17 | Comanche | Oklahoma | 40031 | 342 | 4 |
251541 | 251541 | 2020-06-18 | Comanche | Oklahoma | 40031 | 360 | 5 |
254656 | 254656 | 2020-06-19 | Comanche | Oklahoma | 40031 | 361 | 5 |
257782 | 257782 | 2020-06-20 | Comanche | Oklahoma | 40031 | 364 | 5 |
260908 | 260908 | 2020-06-21 | Comanche | Oklahoma | 40031 | 365 | 5 |
264036 | 264036 | 2020-06-22 | Comanche | Oklahoma | 40031 | 377 | 5 |
267164 | 267164 | 2020-06-23 | Comanche | Oklahoma | 40031 | 377 | 5 |
270298 | 270298 | 2020-06-24 | Comanche | Oklahoma | 40031 | 381 | 5 |
273437 | 273437 | 2020-06-25 | Comanche | Oklahoma | 40031 | 383 | 5 |
276584 | 276584 | 2020-06-26 | Comanche | Oklahoma | 40031 | 386 | 5 |
279732 | 279732 | 2020-06-27 | Comanche | Oklahoma | 40031 | 391 | 5 |
282878 | 282878 | 2020-06-28 | Comanche | Oklahoma | 40031 | 392 | 5 |
286023 | 286023 | 2020-06-29 | Comanche | Oklahoma | 40031 | 399 | 5 |
289173 | 289173 | 2020-06-30 | Comanche | Oklahoma | 40031 | 406 | 5 |
292325 | 292325 | 2020-07-01 | Comanche | Oklahoma | 40031 | 408 | 5 |
295481 | 295481 | 2020-07-02 | Comanche | Oklahoma | 40031 | 418 | 7 |
298640 | 298640 | 2020-07-03 | Comanche | Oklahoma | 40031 | 427 | 7 |
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);