ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Canadian" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 119 ✖
- 3 96
- 295 30
- 185 21
- 17 17
- 0 15
- 24 15
- 102 15
- 9 14
- 13 14
- 187 14
- 190 14
- 193 14
- 386 14
- 1 13
- 4 10
- 23 9
- 390 9
- 365 8
- 5 7
- 57 7
- 97 7
- 100 7
- 106 7
- 163 7
- 164 7
- 165 7
- 168 7
- 170 7
- 172 7
- 175 7
- 184 7
- 188 7
- 191 7
- 197 7
- 198 7
- 201 7
- 203 7
- 208 7
- 214 7
- 224 7
- 231 7
- 238 7
- 280 7
- 288 7
- 305 7
- 306 7
- 308 7
- 312 7
- 315 7
- 319 7
- 322 7
- 328 7
- 331 7
- 346 7
- 352 7
- 358 7
- 371 7
- 374 7
- 381 7
- 382 7
- 385 7
- 388 7
- 11 6
- 16 6
- 21 6
- 27 6
- 7 5
- 45 5
- 52 5
- 303 5
- 19 4
- 25 4
- 28 4
- 35 4
- 49 4
- 59 4
- 61 4
- 34 3
- 41 3
- 54 3
- 81 3
- 6 2
- 12 2
- 18 2
- 20 2
- 44 2
- 50 2
- 58 2
- 62 2
- 65 2
- 69 2
- 75 2
- 83 2
- 86 2
- 87 2
- 88 2
- 91 2
- 95 2
- 22 1
- 30 1
- 36 1
- 39 1
- 40 1
- 47 1
- 48 1
- 51 1
- 53 1
- 56 1
- 64 1
- 66 1
- 70 1
- 72 1
- 73 1
- 80 1
- 84 1
- 85 1
- 90 1
- 92 1
- 94 1
state 1
- Oklahoma 789
fips 1
- 40017 789
county 1
- Canadian · 789 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3074 | 3074 | 2020-03-16 | Canadian | Oklahoma | 40017 | 1 | 0 |
3601 | 3601 | 2020-03-17 | Canadian | Oklahoma | 40017 | 2 | 0 |
4216 | 4216 | 2020-03-18 | Canadian | Oklahoma | 40017 | 2 | 0 |
4950 | 4950 | 2020-03-19 | Canadian | Oklahoma | 40017 | 2 | 0 |
5816 | 5816 | 2020-03-20 | Canadian | Oklahoma | 40017 | 2 | 0 |
6817 | 6817 | 2020-03-21 | Canadian | Oklahoma | 40017 | 2 | 0 |
7930 | 7930 | 2020-03-22 | Canadian | Oklahoma | 40017 | 2 | 0 |
9138 | 9138 | 2020-03-23 | Canadian | Oklahoma | 40017 | 2 | 0 |
10454 | 10454 | 2020-03-24 | Canadian | Oklahoma | 40017 | 4 | 0 |
11909 | 11909 | 2020-03-25 | Canadian | Oklahoma | 40017 | 5 | 0 |
13519 | 13519 | 2020-03-26 | Canadian | Oklahoma | 40017 | 6 | 0 |
15259 | 15259 | 2020-03-27 | Canadian | Oklahoma | 40017 | 11 | 0 |
17104 | 17104 | 2020-03-28 | Canadian | Oklahoma | 40017 | 11 | 0 |
19038 | 19038 | 2020-03-29 | Canadian | Oklahoma | 40017 | 12 | 0 |
21086 | 21086 | 2020-03-30 | Canadian | Oklahoma | 40017 | 15 | 0 |
23219 | 23219 | 2020-03-31 | Canadian | Oklahoma | 40017 | 19 | 1 |
25415 | 25415 | 2020-04-01 | Canadian | Oklahoma | 40017 | 24 | 1 |
27685 | 27685 | 2020-04-02 | Canadian | Oklahoma | 40017 | 28 | 1 |
30014 | 30014 | 2020-04-03 | Canadian | Oklahoma | 40017 | 29 | 1 |
32403 | 32403 | 2020-04-04 | Canadian | Oklahoma | 40017 | 32 | 1 |
34837 | 34837 | 2020-04-05 | Canadian | Oklahoma | 40017 | 33 | 1 |
37310 | 37310 | 2020-04-06 | Canadian | Oklahoma | 40017 | 35 | 1 |
39829 | 39829 | 2020-04-07 | Canadian | Oklahoma | 40017 | 40 | 1 |
42389 | 42389 | 2020-04-08 | Canadian | Oklahoma | 40017 | 40 | 1 |
44975 | 44975 | 2020-04-09 | Canadian | Oklahoma | 40017 | 48 | 1 |
47590 | 47590 | 2020-04-10 | Canadian | Oklahoma | 40017 | 52 | 1 |
50246 | 50246 | 2020-04-11 | Canadian | Oklahoma | 40017 | 56 | 1 |
52919 | 52919 | 2020-04-12 | Canadian | Oklahoma | 40017 | 56 | 1 |
55604 | 55604 | 2020-04-13 | Canadian | Oklahoma | 40017 | 57 | 3 |
58305 | 58305 | 2020-04-14 | Canadian | Oklahoma | 40017 | 62 | 3 |
61020 | 61020 | 2020-04-15 | Canadian | Oklahoma | 40017 | 63 | 3 |
63746 | 63746 | 2020-04-16 | Canadian | Oklahoma | 40017 | 65 | 3 |
66489 | 66489 | 2020-04-17 | Canadian | Oklahoma | 40017 | 69 | 3 |
69246 | 69246 | 2020-04-18 | Canadian | Oklahoma | 40017 | 72 | 3 |
72013 | 72013 | 2020-04-19 | Canadian | Oklahoma | 40017 | 73 | 3 |
74788 | 74788 | 2020-04-20 | Canadian | Oklahoma | 40017 | 75 | 3 |
77569 | 77569 | 2020-04-21 | Canadian | Oklahoma | 40017 | 76 | 3 |
80359 | 80359 | 2020-04-22 | Canadian | Oklahoma | 40017 | 82 | 3 |
83158 | 83158 | 2020-04-23 | Canadian | Oklahoma | 40017 | 86 | 3 |
85962 | 85962 | 2020-04-24 | Canadian | Oklahoma | 40017 | 88 | 3 |
88776 | 88776 | 2020-04-25 | Canadian | Oklahoma | 40017 | 90 | 3 |
91592 | 91592 | 2020-04-26 | Canadian | Oklahoma | 40017 | 91 | 3 |
94418 | 94418 | 2020-04-27 | Canadian | Oklahoma | 40017 | 91 | 3 |
97256 | 97256 | 2020-04-28 | Canadian | Oklahoma | 40017 | 96 | 3 |
100105 | 100105 | 2020-04-29 | Canadian | Oklahoma | 40017 | 97 | 3 |
102958 | 102958 | 2020-04-30 | Canadian | Oklahoma | 40017 | 98 | 3 |
105821 | 105821 | 2020-05-01 | Canadian | Oklahoma | 40017 | 98 | 3 |
108688 | 108688 | 2020-05-02 | Canadian | Oklahoma | 40017 | 98 | 3 |
111562 | 111562 | 2020-05-03 | Canadian | Oklahoma | 40017 | 100 | 3 |
114444 | 114444 | 2020-05-04 | Canadian | Oklahoma | 40017 | 102 | 3 |
117325 | 117325 | 2020-05-05 | Canadian | Oklahoma | 40017 | 103 | 3 |
120286 | 120286 | 2020-05-06 | Canadian | Oklahoma | 40017 | 103 | 3 |
123263 | 123263 | 2020-05-07 | Canadian | Oklahoma | 40017 | 107 | 3 |
126246 | 126246 | 2020-05-08 | Canadian | Oklahoma | 40017 | 107 | 3 |
129235 | 129235 | 2020-05-09 | Canadian | Oklahoma | 40017 | 110 | 3 |
132224 | 132224 | 2020-05-10 | Canadian | Oklahoma | 40017 | 111 | 3 |
135215 | 135215 | 2020-05-11 | Canadian | Oklahoma | 40017 | 111 | 3 |
138205 | 138205 | 2020-05-12 | Canadian | Oklahoma | 40017 | 114 | 3 |
141201 | 141201 | 2020-05-13 | Canadian | Oklahoma | 40017 | 115 | 3 |
144196 | 144196 | 2020-05-14 | Canadian | Oklahoma | 40017 | 116 | 3 |
147197 | 147197 | 2020-05-15 | Canadian | Oklahoma | 40017 | 116 | 3 |
150204 | 150204 | 2020-05-16 | Canadian | Oklahoma | 40017 | 116 | 3 |
153215 | 153215 | 2020-05-17 | Canadian | Oklahoma | 40017 | 117 | 3 |
156232 | 156232 | 2020-05-18 | Canadian | Oklahoma | 40017 | 118 | 3 |
159252 | 159252 | 2020-05-19 | Canadian | Oklahoma | 40017 | 120 | 3 |
162279 | 162279 | 2020-05-20 | Canadian | Oklahoma | 40017 | 120 | 3 |
165308 | 165308 | 2020-05-21 | Canadian | Oklahoma | 40017 | 122 | 3 |
168344 | 168344 | 2020-05-22 | Canadian | Oklahoma | 40017 | 123 | 3 |
171383 | 171383 | 2020-05-23 | Canadian | Oklahoma | 40017 | 124 | 3 |
174425 | 174425 | 2020-05-24 | Canadian | Oklahoma | 40017 | 126 | 3 |
177469 | 177469 | 2020-05-25 | Canadian | Oklahoma | 40017 | 128 | 3 |
180512 | 180512 | 2020-05-26 | Canadian | Oklahoma | 40017 | 128 | 3 |
183561 | 183561 | 2020-05-27 | Canadian | Oklahoma | 40017 | 128 | 3 |
186618 | 186618 | 2020-05-28 | Canadian | Oklahoma | 40017 | 128 | 3 |
189678 | 189678 | 2020-05-29 | Canadian | Oklahoma | 40017 | 129 | 3 |
192743 | 192743 | 2020-05-30 | Canadian | Oklahoma | 40017 | 132 | 3 |
195812 | 195812 | 2020-05-31 | Canadian | Oklahoma | 40017 | 133 | 3 |
198885 | 198885 | 2020-06-01 | Canadian | Oklahoma | 40017 | 133 | 3 |
201960 | 201960 | 2020-06-02 | Canadian | Oklahoma | 40017 | 133 | 3 |
205037 | 205037 | 2020-06-03 | Canadian | Oklahoma | 40017 | 133 | 3 |
208118 | 208118 | 2020-06-04 | Canadian | Oklahoma | 40017 | 137 | 3 |
211200 | 211200 | 2020-06-05 | Canadian | Oklahoma | 40017 | 141 | 3 |
214286 | 214286 | 2020-06-06 | Canadian | Oklahoma | 40017 | 141 | 3 |
217376 | 217376 | 2020-06-07 | Canadian | Oklahoma | 40017 | 142 | 3 |
220468 | 220468 | 2020-06-08 | Canadian | Oklahoma | 40017 | 142 | 3 |
223563 | 223563 | 2020-06-09 | Canadian | Oklahoma | 40017 | 143 | 3 |
226663 | 226663 | 2020-06-10 | Canadian | Oklahoma | 40017 | 144 | 3 |
229767 | 229767 | 2020-06-11 | Canadian | Oklahoma | 40017 | 144 | 3 |
232872 | 232872 | 2020-06-12 | Canadian | Oklahoma | 40017 | 146 | 3 |
235977 | 235977 | 2020-06-13 | Canadian | Oklahoma | 40017 | 148 | 3 |
239085 | 239085 | 2020-06-14 | Canadian | Oklahoma | 40017 | 150 | 3 |
242194 | 242194 | 2020-06-15 | Canadian | Oklahoma | 40017 | 156 | 3 |
245306 | 245306 | 2020-06-16 | Canadian | Oklahoma | 40017 | 160 | 3 |
248419 | 248419 | 2020-06-17 | Canadian | Oklahoma | 40017 | 167 | 3 |
251534 | 251534 | 2020-06-18 | Canadian | Oklahoma | 40017 | 175 | 3 |
254649 | 254649 | 2020-06-19 | Canadian | Oklahoma | 40017 | 186 | 3 |
257775 | 257775 | 2020-06-20 | Canadian | Oklahoma | 40017 | 192 | 3 |
260901 | 260901 | 2020-06-21 | Canadian | Oklahoma | 40017 | 197 | 3 |
264029 | 264029 | 2020-06-22 | Canadian | Oklahoma | 40017 | 200 | 3 |
267157 | 267157 | 2020-06-23 | Canadian | Oklahoma | 40017 | 207 | 3 |
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);