ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Caddo" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
333560 | 333560 | 2020-07-14 | Caddo | Oklahoma | 40015 | 210 | 11 |
330368 | 330368 | 2020-07-13 | Caddo | Oklahoma | 40015 | 208 | 11 |
327181 | 327181 | 2020-07-12 | Caddo | Oklahoma | 40015 | 206 | 11 |
323996 | 323996 | 2020-07-11 | Caddo | Oklahoma | 40015 | 206 | 11 |
320816 | 320816 | 2020-07-10 | Caddo | Oklahoma | 40015 | 204 | 11 |
317639 | 317639 | 2020-07-09 | Caddo | Oklahoma | 40015 | 202 | 11 |
314466 | 314466 | 2020-07-08 | Caddo | Oklahoma | 40015 | 200 | 11 |
311294 | 311294 | 2020-07-07 | Caddo | Oklahoma | 40015 | 200 | 11 |
308125 | 308125 | 2020-07-06 | Caddo | Oklahoma | 40015 | 197 | 11 |
304958 | 304958 | 2020-07-05 | Caddo | Oklahoma | 40015 | 195 | 11 |
301795 | 301795 | 2020-07-04 | Caddo | Oklahoma | 40015 | 193 | 11 |
298632 | 298632 | 2020-07-03 | Caddo | Oklahoma | 40015 | 191 | 11 |
295473 | 295473 | 2020-07-02 | Caddo | Oklahoma | 40015 | 190 | 11 |
292317 | 292317 | 2020-07-01 | Caddo | Oklahoma | 40015 | 189 | 11 |
289165 | 289165 | 2020-06-30 | Caddo | Oklahoma | 40015 | 186 | 11 |
286015 | 286015 | 2020-06-29 | Caddo | Oklahoma | 40015 | 185 | 11 |
282870 | 282870 | 2020-06-28 | Caddo | Oklahoma | 40015 | 184 | 11 |
279724 | 279724 | 2020-06-27 | Caddo | Oklahoma | 40015 | 184 | 11 |
276576 | 276576 | 2020-06-26 | Caddo | Oklahoma | 40015 | 184 | 10 |
273429 | 273429 | 2020-06-25 | Caddo | Oklahoma | 40015 | 182 | 10 |
270290 | 270290 | 2020-06-24 | Caddo | Oklahoma | 40015 | 182 | 10 |
267156 | 267156 | 2020-06-23 | Caddo | Oklahoma | 40015 | 181 | 10 |
264028 | 264028 | 2020-06-22 | Caddo | Oklahoma | 40015 | 181 | 10 |
260900 | 260900 | 2020-06-21 | Caddo | Oklahoma | 40015 | 180 | 10 |
257774 | 257774 | 2020-06-20 | Caddo | Oklahoma | 40015 | 180 | 10 |
254648 | 254648 | 2020-06-19 | Caddo | Oklahoma | 40015 | 181 | 10 |
251533 | 251533 | 2020-06-18 | Caddo | Oklahoma | 40015 | 181 | 10 |
248418 | 248418 | 2020-06-17 | Caddo | Oklahoma | 40015 | 178 | 10 |
245305 | 245305 | 2020-06-16 | Caddo | Oklahoma | 40015 | 176 | 10 |
242193 | 242193 | 2020-06-15 | Caddo | Oklahoma | 40015 | 176 | 10 |
239084 | 239084 | 2020-06-14 | Caddo | Oklahoma | 40015 | 175 | 10 |
235976 | 235976 | 2020-06-13 | Caddo | Oklahoma | 40015 | 175 | 10 |
232871 | 232871 | 2020-06-12 | Caddo | Oklahoma | 40015 | 173 | 10 |
229766 | 229766 | 2020-06-11 | Caddo | Oklahoma | 40015 | 173 | 10 |
226662 | 226662 | 2020-06-10 | Caddo | Oklahoma | 40015 | 173 | 10 |
223562 | 223562 | 2020-06-09 | Caddo | Oklahoma | 40015 | 174 | 10 |
220467 | 220467 | 2020-06-08 | Caddo | Oklahoma | 40015 | 170 | 10 |
217375 | 217375 | 2020-06-07 | Caddo | Oklahoma | 40015 | 170 | 10 |
214285 | 214285 | 2020-06-06 | Caddo | Oklahoma | 40015 | 168 | 10 |
211199 | 211199 | 2020-06-05 | Caddo | Oklahoma | 40015 | 168 | 10 |
208117 | 208117 | 2020-06-04 | Caddo | Oklahoma | 40015 | 168 | 10 |
205036 | 205036 | 2020-06-03 | Caddo | Oklahoma | 40015 | 167 | 10 |
201959 | 201959 | 2020-06-02 | Caddo | Oklahoma | 40015 | 164 | 10 |
198884 | 198884 | 2020-06-01 | Caddo | Oklahoma | 40015 | 162 | 10 |
195811 | 195811 | 2020-05-31 | Caddo | Oklahoma | 40015 | 160 | 10 |
192742 | 192742 | 2020-05-30 | Caddo | Oklahoma | 40015 | 158 | 10 |
189677 | 189677 | 2020-05-29 | Caddo | Oklahoma | 40015 | 155 | 10 |
186617 | 186617 | 2020-05-28 | Caddo | Oklahoma | 40015 | 154 | 10 |
183560 | 183560 | 2020-05-27 | Caddo | Oklahoma | 40015 | 153 | 10 |
180511 | 180511 | 2020-05-26 | Caddo | Oklahoma | 40015 | 150 | 10 |
177468 | 177468 | 2020-05-25 | Caddo | Oklahoma | 40015 | 146 | 10 |
174424 | 174424 | 2020-05-24 | Caddo | Oklahoma | 40015 | 136 | 10 |
171382 | 171382 | 2020-05-23 | Caddo | Oklahoma | 40015 | 136 | 10 |
168343 | 168343 | 2020-05-22 | Caddo | Oklahoma | 40015 | 132 | 10 |
165307 | 165307 | 2020-05-21 | Caddo | Oklahoma | 40015 | 132 | 10 |
162278 | 162278 | 2020-05-20 | Caddo | Oklahoma | 40015 | 126 | 10 |
159251 | 159251 | 2020-05-19 | Caddo | Oklahoma | 40015 | 122 | 10 |
156231 | 156231 | 2020-05-18 | Caddo | Oklahoma | 40015 | 120 | 10 |
153214 | 153214 | 2020-05-17 | Caddo | Oklahoma | 40015 | 114 | 10 |
150203 | 150203 | 2020-05-16 | Caddo | Oklahoma | 40015 | 112 | 10 |
147196 | 147196 | 2020-05-15 | Caddo | Oklahoma | 40015 | 111 | 9 |
144195 | 144195 | 2020-05-14 | Caddo | Oklahoma | 40015 | 110 | 9 |
141200 | 141200 | 2020-05-13 | Caddo | Oklahoma | 40015 | 110 | 9 |
138204 | 138204 | 2020-05-12 | Caddo | Oklahoma | 40015 | 109 | 9 |
135214 | 135214 | 2020-05-11 | Caddo | Oklahoma | 40015 | 108 | 9 |
132223 | 132223 | 2020-05-10 | Caddo | Oklahoma | 40015 | 108 | 9 |
129234 | 129234 | 2020-05-09 | Caddo | Oklahoma | 40015 | 100 | 9 |
126245 | 126245 | 2020-05-08 | Caddo | Oklahoma | 40015 | 97 | 9 |
123262 | 123262 | 2020-05-07 | Caddo | Oklahoma | 40015 | 89 | 8 |
120285 | 120285 | 2020-05-06 | Caddo | Oklahoma | 40015 | 77 | 8 |
117324 | 117324 | 2020-05-05 | Caddo | Oklahoma | 40015 | 77 | 8 |
114443 | 114443 | 2020-05-04 | Caddo | Oklahoma | 40015 | 72 | 8 |
111561 | 111561 | 2020-05-03 | Caddo | Oklahoma | 40015 | 69 | 8 |
108687 | 108687 | 2020-05-02 | Caddo | Oklahoma | 40015 | 64 | 8 |
105820 | 105820 | 2020-05-01 | Caddo | Oklahoma | 40015 | 64 | 7 |
102957 | 102957 | 2020-04-30 | Caddo | Oklahoma | 40015 | 62 | 7 |
100104 | 100104 | 2020-04-29 | Caddo | Oklahoma | 40015 | 61 | 7 |
97255 | 97255 | 2020-04-28 | Caddo | Oklahoma | 40015 | 61 | 7 |
94417 | 94417 | 2020-04-27 | Caddo | Oklahoma | 40015 | 58 | 6 |
91591 | 91591 | 2020-04-26 | Caddo | Oklahoma | 40015 | 58 | 6 |
88775 | 88775 | 2020-04-25 | Caddo | Oklahoma | 40015 | 53 | 6 |
85961 | 85961 | 2020-04-24 | Caddo | Oklahoma | 40015 | 53 | 6 |
83157 | 83157 | 2020-04-23 | Caddo | Oklahoma | 40015 | 53 | 5 |
80358 | 80358 | 2020-04-22 | Caddo | Oklahoma | 40015 | 53 | 4 |
77568 | 77568 | 2020-04-21 | Caddo | Oklahoma | 40015 | 52 | 3 |
74787 | 74787 | 2020-04-20 | Caddo | Oklahoma | 40015 | 52 | 3 |
72012 | 72012 | 2020-04-19 | Caddo | Oklahoma | 40015 | 51 | 2 |
69245 | 69245 | 2020-04-18 | Caddo | Oklahoma | 40015 | 51 | 2 |
66488 | 66488 | 2020-04-17 | Caddo | Oklahoma | 40015 | 51 | 2 |
63745 | 63745 | 2020-04-16 | Caddo | Oklahoma | 40015 | 48 | 2 |
61019 | 61019 | 2020-04-15 | Caddo | Oklahoma | 40015 | 35 | 1 |
58304 | 58304 | 2020-04-14 | Caddo | Oklahoma | 40015 | 10 | 0 |
55603 | 55603 | 2020-04-13 | Caddo | Oklahoma | 40015 | 9 | 0 |
52918 | 52918 | 2020-04-12 | Caddo | Oklahoma | 40015 | 9 | 0 |
50245 | 50245 | 2020-04-11 | Caddo | Oklahoma | 40015 | 9 | 0 |
47589 | 47589 | 2020-04-10 | Caddo | Oklahoma | 40015 | 8 | 0 |
44974 | 44974 | 2020-04-09 | Caddo | Oklahoma | 40015 | 6 | 0 |
42388 | 42388 | 2020-04-08 | Caddo | Oklahoma | 40015 | 6 | 0 |
39828 | 39828 | 2020-04-07 | Caddo | Oklahoma | 40015 | 6 | 0 |
37309 | 37309 | 2020-04-06 | Caddo | Oklahoma | 40015 | 5 | 0 |
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);