ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,474 rows where county = "Dewey" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
276590 | 276590 | 2020-06-26 | Dewey | Oklahoma | 40043 | 5 | 0 |
276893 | 276893 | 2020-06-26 | Dewey | South Dakota | 46041 | 4 | 0 |
279738 | 279738 | 2020-06-27 | Dewey | Oklahoma | 40043 | 5 | 0 |
280041 | 280041 | 2020-06-27 | Dewey | South Dakota | 46041 | 4 | 0 |
282884 | 282884 | 2020-06-28 | Dewey | Oklahoma | 40043 | 5 | 0 |
283187 | 283187 | 2020-06-28 | Dewey | South Dakota | 46041 | 4 | 0 |
286029 | 286029 | 2020-06-29 | Dewey | Oklahoma | 40043 | 5 | 0 |
286332 | 286332 | 2020-06-29 | Dewey | South Dakota | 46041 | 4 | 0 |
289179 | 289179 | 2020-06-30 | Dewey | Oklahoma | 40043 | 5 | 0 |
289483 | 289483 | 2020-06-30 | Dewey | South Dakota | 46041 | 4 | 0 |
292331 | 292331 | 2020-07-01 | Dewey | Oklahoma | 40043 | 4 | 0 |
292635 | 292635 | 2020-07-01 | Dewey | South Dakota | 46041 | 5 | 0 |
295487 | 295487 | 2020-07-02 | Dewey | Oklahoma | 40043 | 4 | 0 |
295791 | 295791 | 2020-07-02 | Dewey | South Dakota | 46041 | 6 | 0 |
298646 | 298646 | 2020-07-03 | Dewey | Oklahoma | 40043 | 4 | 0 |
298951 | 298951 | 2020-07-03 | Dewey | South Dakota | 46041 | 8 | 0 |
301809 | 301809 | 2020-07-04 | Dewey | Oklahoma | 40043 | 4 | 0 |
302115 | 302115 | 2020-07-04 | Dewey | South Dakota | 46041 | 8 | 0 |
304972 | 304972 | 2020-07-05 | Dewey | Oklahoma | 40043 | 4 | 0 |
305278 | 305278 | 2020-07-05 | Dewey | South Dakota | 46041 | 8 | 0 |
308139 | 308139 | 2020-07-06 | Dewey | Oklahoma | 40043 | 4 | 0 |
308445 | 308445 | 2020-07-06 | Dewey | South Dakota | 46041 | 8 | 0 |
311308 | 311308 | 2020-07-07 | Dewey | Oklahoma | 40043 | 4 | 0 |
311614 | 311614 | 2020-07-07 | Dewey | South Dakota | 46041 | 9 | 0 |
314480 | 314480 | 2020-07-08 | Dewey | Oklahoma | 40043 | 4 | 0 |
314787 | 314787 | 2020-07-08 | Dewey | South Dakota | 46041 | 12 | 0 |
317653 | 317653 | 2020-07-09 | Dewey | Oklahoma | 40043 | 4 | 0 |
317960 | 317960 | 2020-07-09 | Dewey | South Dakota | 46041 | 27 | 0 |
320830 | 320830 | 2020-07-10 | Dewey | Oklahoma | 40043 | 4 | 0 |
321138 | 321138 | 2020-07-10 | Dewey | South Dakota | 46041 | 33 | 0 |
324010 | 324010 | 2020-07-11 | Dewey | Oklahoma | 40043 | 4 | 0 |
324318 | 324318 | 2020-07-11 | Dewey | South Dakota | 46041 | 33 | 0 |
327195 | 327195 | 2020-07-12 | Dewey | Oklahoma | 40043 | 4 | 0 |
327503 | 327503 | 2020-07-12 | Dewey | South Dakota | 46041 | 35 | 0 |
330382 | 330382 | 2020-07-13 | Dewey | Oklahoma | 40043 | 4 | 0 |
330689 | 330689 | 2020-07-13 | Dewey | South Dakota | 46041 | 37 | 0 |
333574 | 333574 | 2020-07-14 | Dewey | Oklahoma | 40043 | 4 | 0 |
333881 | 333881 | 2020-07-14 | Dewey | South Dakota | 46041 | 37 | 0 |
336768 | 336768 | 2020-07-15 | Dewey | Oklahoma | 40043 | 4 | 0 |
337075 | 337075 | 2020-07-15 | Dewey | South Dakota | 46041 | 38 | 0 |
339964 | 339964 | 2020-07-16 | Dewey | Oklahoma | 40043 | 4 | 0 |
340272 | 340272 | 2020-07-16 | Dewey | South Dakota | 46041 | 40 | 0 |
343162 | 343162 | 2020-07-17 | Dewey | Oklahoma | 40043 | 5 | 0 |
343470 | 343470 | 2020-07-17 | Dewey | South Dakota | 46041 | 42 | 0 |
346362 | 346362 | 2020-07-18 | Dewey | Oklahoma | 40043 | 7 | 0 |
346670 | 346670 | 2020-07-18 | Dewey | South Dakota | 46041 | 42 | 0 |
349562 | 349562 | 2020-07-19 | Dewey | Oklahoma | 40043 | 6 | 0 |
349870 | 349870 | 2020-07-19 | Dewey | South Dakota | 46041 | 45 | 0 |
352765 | 352765 | 2020-07-20 | Dewey | Oklahoma | 40043 | 6 | 0 |
353073 | 353073 | 2020-07-20 | Dewey | South Dakota | 46041 | 45 | 0 |
355968 | 355968 | 2020-07-21 | Dewey | Oklahoma | 40043 | 6 | 0 |
356276 | 356276 | 2020-07-21 | Dewey | South Dakota | 46041 | 45 | 0 |
359172 | 359172 | 2020-07-22 | Dewey | Oklahoma | 40043 | 4 | 0 |
359480 | 359480 | 2020-07-22 | Dewey | South Dakota | 46041 | 47 | 0 |
362378 | 362378 | 2020-07-23 | Dewey | Oklahoma | 40043 | 4 | 0 |
362686 | 362686 | 2020-07-23 | Dewey | South Dakota | 46041 | 49 | 0 |
365584 | 365584 | 2020-07-24 | Dewey | Oklahoma | 40043 | 4 | 0 |
365892 | 365892 | 2020-07-24 | Dewey | South Dakota | 46041 | 52 | 0 |
368793 | 368793 | 2020-07-25 | Dewey | Oklahoma | 40043 | 4 | 0 |
369101 | 369101 | 2020-07-25 | Dewey | South Dakota | 46041 | 53 | 0 |
372005 | 372005 | 2020-07-26 | Dewey | Oklahoma | 40043 | 4 | 0 |
372313 | 372313 | 2020-07-26 | Dewey | South Dakota | 46041 | 53 | 0 |
375217 | 375217 | 2020-07-27 | Dewey | Oklahoma | 40043 | 6 | 0 |
375526 | 375526 | 2020-07-27 | Dewey | South Dakota | 46041 | 53 | 0 |
378434 | 378434 | 2020-07-28 | Dewey | Oklahoma | 40043 | 6 | 0 |
378742 | 378742 | 2020-07-28 | Dewey | South Dakota | 46041 | 53 | 0 |
381651 | 381651 | 2020-07-29 | Dewey | Oklahoma | 40043 | 7 | 0 |
381959 | 381959 | 2020-07-29 | Dewey | South Dakota | 46041 | 54 | 0 |
384869 | 384869 | 2020-07-30 | Dewey | Oklahoma | 40043 | 7 | 0 |
385177 | 385177 | 2020-07-30 | Dewey | South Dakota | 46041 | 56 | 0 |
388086 | 388086 | 2020-07-31 | Dewey | Oklahoma | 40043 | 7 | 0 |
388394 | 388394 | 2020-07-31 | Dewey | South Dakota | 46041 | 58 | 0 |
391303 | 391303 | 2020-08-01 | Dewey | Oklahoma | 40043 | 7 | 0 |
391611 | 391611 | 2020-08-01 | Dewey | South Dakota | 46041 | 59 | 0 |
394519 | 394519 | 2020-08-02 | Dewey | Oklahoma | 40043 | 7 | 0 |
394827 | 394827 | 2020-08-02 | Dewey | South Dakota | 46041 | 59 | 0 |
397736 | 397736 | 2020-08-03 | Dewey | Oklahoma | 40043 | 8 | 0 |
398044 | 398044 | 2020-08-03 | Dewey | South Dakota | 46041 | 61 | 0 |
400951 | 400951 | 2020-08-04 | Dewey | Oklahoma | 40043 | 8 | 0 |
401259 | 401259 | 2020-08-04 | Dewey | South Dakota | 46041 | 63 | 0 |
404169 | 404169 | 2020-08-05 | Dewey | Oklahoma | 40043 | 8 | 0 |
404477 | 404477 | 2020-08-05 | Dewey | South Dakota | 46041 | 64 | 0 |
407388 | 407388 | 2020-08-06 | Dewey | Oklahoma | 40043 | 8 | 0 |
407697 | 407697 | 2020-08-06 | Dewey | South Dakota | 46041 | 65 | 0 |
410608 | 410608 | 2020-08-07 | Dewey | Oklahoma | 40043 | 9 | 0 |
410916 | 410916 | 2020-08-07 | Dewey | South Dakota | 46041 | 50 | 0 |
413828 | 413828 | 2020-08-08 | Dewey | Oklahoma | 40043 | 9 | 0 |
414136 | 414136 | 2020-08-08 | Dewey | South Dakota | 46041 | 49 | 0 |
417049 | 417049 | 2020-08-09 | Dewey | Oklahoma | 40043 | 10 | 0 |
417357 | 417357 | 2020-08-09 | Dewey | South Dakota | 46041 | 48 | 0 |
420269 | 420269 | 2020-08-10 | Dewey | Oklahoma | 40043 | 10 | 0 |
420578 | 420578 | 2020-08-10 | Dewey | South Dakota | 46041 | 48 | 0 |
423492 | 423492 | 2020-08-11 | Dewey | Oklahoma | 40043 | 10 | 0 |
423800 | 423800 | 2020-08-11 | Dewey | South Dakota | 46041 | 48 | 0 |
426715 | 426715 | 2020-08-12 | Dewey | Oklahoma | 40043 | 10 | 0 |
427023 | 427023 | 2020-08-12 | Dewey | South Dakota | 46041 | 49 | 0 |
429940 | 429940 | 2020-08-13 | Dewey | Oklahoma | 40043 | 11 | 0 |
430249 | 430249 | 2020-08-13 | Dewey | South Dakota | 46041 | 49 | 0 |
433166 | 433166 | 2020-08-14 | Dewey | Oklahoma | 40043 | 12 | 0 |
433474 | 433474 | 2020-08-14 | Dewey | South Dakota | 46041 | 57 | 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);