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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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);