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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|
2501741 | 2501741 | 2022-05-13 | Canadian | Oklahoma | 40017 | 39889 | 390 |
2498483 | 2498483 | 2022-05-12 | Canadian | Oklahoma | 40017 | 39889 | 390 |
2495225 | 2495225 | 2022-05-11 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2491967 | 2491967 | 2022-05-10 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2488709 | 2488709 | 2022-05-09 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2485452 | 2485452 | 2022-05-08 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2482194 | 2482194 | 2022-05-07 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2478936 | 2478936 | 2022-05-06 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2475678 | 2475678 | 2022-05-05 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2472421 | 2472421 | 2022-05-04 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2469165 | 2469165 | 2022-05-03 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2465909 | 2465909 | 2022-05-02 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2462654 | 2462654 | 2022-05-01 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2459398 | 2459398 | 2022-04-30 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2456142 | 2456142 | 2022-04-29 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2452886 | 2452886 | 2022-04-28 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2449630 | 2449630 | 2022-04-27 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2446373 | 2446373 | 2022-04-26 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2443118 | 2443118 | 2022-04-25 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2439862 | 2439862 | 2022-04-24 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2436606 | 2436606 | 2022-04-23 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2433350 | 2433350 | 2022-04-22 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2430094 | 2430094 | 2022-04-21 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2426838 | 2426838 | 2022-04-20 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2423582 | 2423582 | 2022-04-19 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2420325 | 2420325 | 2022-04-18 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2417070 | 2417070 | 2022-04-17 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2413814 | 2413814 | 2022-04-16 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2410558 | 2410558 | 2022-04-15 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2407302 | 2407302 | 2022-04-14 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2404046 | 2404046 | 2022-04-13 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2400791 | 2400791 | 2022-04-12 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2397536 | 2397536 | 2022-04-11 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2394281 | 2394281 | 2022-04-10 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2391025 | 2391025 | 2022-04-09 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2387769 | 2387769 | 2022-04-08 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2384514 | 2384514 | 2022-04-07 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2381259 | 2381259 | 2022-04-06 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2378004 | 2378004 | 2022-04-05 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2374750 | 2374750 | 2022-04-04 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2371498 | 2371498 | 2022-04-03 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2368245 | 2368245 | 2022-04-02 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2364992 | 2364992 | 2022-04-01 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2361739 | 2361739 | 2022-03-31 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2358485 | 2358485 | 2022-03-30 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2355231 | 2355231 | 2022-03-29 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2351978 | 2351978 | 2022-03-28 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2348726 | 2348726 | 2022-03-27 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2345473 | 2345473 | 2022-03-26 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2342220 | 2342220 | 2022-03-25 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2338967 | 2338967 | 2022-03-24 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2335713 | 2335713 | 2022-03-23 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2332459 | 2332459 | 2022-03-22 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2329206 | 2329206 | 2022-03-21 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2325954 | 2325954 | 2022-03-20 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2322701 | 2322701 | 2022-03-19 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2319447 | 2319447 | 2022-03-18 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2316193 | 2316193 | 2022-03-17 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2312940 | 2312940 | 2022-03-16 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2309687 | 2309687 | 2022-03-15 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2306434 | 2306434 | 2022-03-14 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2303183 | 2303183 | 2022-03-13 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2299931 | 2299931 | 2022-03-12 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2296679 | 2296679 | 2022-03-11 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2293427 | 2293427 | 2022-03-10 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2290175 | 2290175 | 2022-03-09 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2286923 | 2286923 | 2022-03-08 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2283671 | 2283671 | 2022-03-07 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2280419 | 2280419 | 2022-03-06 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2277166 | 2277166 | 2022-03-05 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2273913 | 2273913 | 2022-03-04 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2270660 | 2270660 | 2022-03-03 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2267408 | 2267408 | 2022-03-02 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2264155 | 2264155 | 2022-03-01 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2260905 | 2260905 | 2022-02-28 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2257654 | 2257654 | 2022-02-27 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2254403 | 2254403 | 2022-02-26 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2251152 | 2251152 | 2022-02-25 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2247901 | 2247901 | 2022-02-24 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2244650 | 2244650 | 2022-02-23 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2241399 | 2241399 | 2022-02-22 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2238148 | 2238148 | 2022-02-21 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2234897 | 2234897 | 2022-02-20 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2231646 | 2231646 | 2022-02-19 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2228395 | 2228395 | 2022-02-18 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2225144 | 2225144 | 2022-02-17 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2221893 | 2221893 | 2022-02-16 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2218642 | 2218642 | 2022-02-15 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2215391 | 2215391 | 2022-02-14 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2212140 | 2212140 | 2022-02-13 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2208887 | 2208887 | 2022-02-12 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2205634 | 2205634 | 2022-02-11 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2202381 | 2202381 | 2022-02-10 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2199127 | 2199127 | 2022-02-09 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2195873 | 2195873 | 2022-02-08 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2192619 | 2192619 | 2022-02-07 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2189365 | 2189365 | 2022-02-06 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2186112 | 2186112 | 2022-02-05 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2182860 | 2182860 | 2022-02-04 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2179608 | 2179608 | 2022-02-03 | Canadian | Oklahoma | 40017 | 37338 | 331 |
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);