ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "McHenry" and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536443 | 536443 | 2020-09-15 | McHenry | North Dakota | 38049 | 55 | 1 |
533207 | 533207 | 2020-09-14 | McHenry | North Dakota | 38049 | 55 | 1 |
529972 | 529972 | 2020-09-13 | McHenry | North Dakota | 38049 | 55 | 1 |
526735 | 526735 | 2020-09-12 | McHenry | North Dakota | 38049 | 53 | 1 |
523499 | 523499 | 2020-09-11 | McHenry | North Dakota | 38049 | 52 | 1 |
520263 | 520263 | 2020-09-10 | McHenry | North Dakota | 38049 | 52 | 1 |
517027 | 517027 | 2020-09-09 | McHenry | North Dakota | 38049 | 51 | 1 |
513792 | 513792 | 2020-09-08 | McHenry | North Dakota | 38049 | 51 | 1 |
510559 | 510559 | 2020-09-07 | McHenry | North Dakota | 38049 | 49 | 1 |
507326 | 507326 | 2020-09-06 | McHenry | North Dakota | 38049 | 48 | 1 |
504094 | 504094 | 2020-09-05 | McHenry | North Dakota | 38049 | 45 | 1 |
500860 | 500860 | 2020-09-04 | McHenry | North Dakota | 38049 | 44 | 1 |
497626 | 497626 | 2020-09-03 | McHenry | North Dakota | 38049 | 44 | 1 |
494393 | 494393 | 2020-09-02 | McHenry | North Dakota | 38049 | 44 | 1 |
491159 | 491159 | 2020-09-01 | McHenry | North Dakota | 38049 | 41 | 1 |
487926 | 487926 | 2020-08-31 | McHenry | North Dakota | 38049 | 38 | 1 |
484693 | 484693 | 2020-08-30 | McHenry | North Dakota | 38049 | 38 | 1 |
481458 | 481458 | 2020-08-29 | McHenry | North Dakota | 38049 | 36 | 1 |
478225 | 478225 | 2020-08-28 | McHenry | North Dakota | 38049 | 34 | 1 |
474992 | 474992 | 2020-08-27 | McHenry | North Dakota | 38049 | 33 | 1 |
471758 | 471758 | 2020-08-26 | McHenry | North Dakota | 38049 | 29 | 1 |
468526 | 468526 | 2020-08-25 | McHenry | North Dakota | 38049 | 28 | 1 |
465298 | 465298 | 2020-08-24 | McHenry | North Dakota | 38049 | 28 | 1 |
462069 | 462069 | 2020-08-23 | McHenry | North Dakota | 38049 | 27 | 1 |
458841 | 458841 | 2020-08-22 | McHenry | North Dakota | 38049 | 27 | 1 |
455613 | 455613 | 2020-08-21 | McHenry | North Dakota | 38049 | 25 | 1 |
452385 | 452385 | 2020-08-20 | McHenry | North Dakota | 38049 | 25 | 1 |
449157 | 449157 | 2020-08-19 | McHenry | North Dakota | 38049 | 25 | 1 |
445929 | 445929 | 2020-08-18 | McHenry | North Dakota | 38049 | 24 | 1 |
442703 | 442703 | 2020-08-17 | McHenry | North Dakota | 38049 | 24 | 1 |
439476 | 439476 | 2020-08-16 | McHenry | North Dakota | 38049 | 24 | 1 |
436251 | 436251 | 2020-08-15 | McHenry | North Dakota | 38049 | 21 | 1 |
433025 | 433025 | 2020-08-14 | McHenry | North Dakota | 38049 | 21 | 1 |
429799 | 429799 | 2020-08-13 | McHenry | North Dakota | 38049 | 19 | 1 |
426574 | 426574 | 2020-08-12 | McHenry | North Dakota | 38049 | 17 | 1 |
423351 | 423351 | 2020-08-11 | McHenry | North Dakota | 38049 | 17 | 1 |
420128 | 420128 | 2020-08-10 | McHenry | North Dakota | 38049 | 17 | 1 |
416908 | 416908 | 2020-08-09 | McHenry | North Dakota | 38049 | 16 | 1 |
413687 | 413687 | 2020-08-08 | McHenry | North Dakota | 38049 | 16 | 1 |
410467 | 410467 | 2020-08-07 | McHenry | North Dakota | 38049 | 16 | 1 |
407247 | 407247 | 2020-08-06 | McHenry | North Dakota | 38049 | 16 | 1 |
404028 | 404028 | 2020-08-05 | McHenry | North Dakota | 38049 | 15 | 1 |
400810 | 400810 | 2020-08-04 | McHenry | North Dakota | 38049 | 15 | 1 |
397595 | 397595 | 2020-08-03 | McHenry | North Dakota | 38049 | 15 | 1 |
394378 | 394378 | 2020-08-02 | McHenry | North Dakota | 38049 | 14 | 1 |
391162 | 391162 | 2020-08-01 | McHenry | North Dakota | 38049 | 14 | 1 |
387945 | 387945 | 2020-07-31 | McHenry | North Dakota | 38049 | 14 | 1 |
384728 | 384728 | 2020-07-30 | McHenry | North Dakota | 38049 | 14 | 1 |
381510 | 381510 | 2020-07-29 | McHenry | North Dakota | 38049 | 14 | 1 |
378293 | 378293 | 2020-07-28 | McHenry | North Dakota | 38049 | 12 | 1 |
375076 | 375076 | 2020-07-27 | McHenry | North Dakota | 38049 | 12 | 1 |
371864 | 371864 | 2020-07-26 | McHenry | North Dakota | 38049 | 12 | 1 |
368652 | 368652 | 2020-07-25 | McHenry | North Dakota | 38049 | 12 | 1 |
365443 | 365443 | 2020-07-24 | McHenry | North Dakota | 38049 | 12 | 1 |
362237 | 362237 | 2020-07-23 | McHenry | North Dakota | 38049 | 12 | 1 |
359031 | 359031 | 2020-07-22 | McHenry | North Dakota | 38049 | 11 | 1 |
355827 | 355827 | 2020-07-21 | McHenry | North Dakota | 38049 | 11 | 1 |
352624 | 352624 | 2020-07-20 | McHenry | North Dakota | 38049 | 11 | 1 |
349421 | 349421 | 2020-07-19 | McHenry | North Dakota | 38049 | 11 | 1 |
346220 | 346220 | 2020-07-18 | McHenry | North Dakota | 38049 | 11 | 1 |
343021 | 343021 | 2020-07-17 | McHenry | North Dakota | 38049 | 10 | 1 |
339823 | 339823 | 2020-07-16 | McHenry | North Dakota | 38049 | 10 | 1 |
336627 | 336627 | 2020-07-15 | McHenry | North Dakota | 38049 | 9 | 1 |
333433 | 333433 | 2020-07-14 | McHenry | North Dakota | 38049 | 9 | 1 |
330242 | 330242 | 2020-07-13 | McHenry | North Dakota | 38049 | 9 | 1 |
327055 | 327055 | 2020-07-12 | McHenry | North Dakota | 38049 | 9 | 1 |
323870 | 323870 | 2020-07-11 | McHenry | North Dakota | 38049 | 9 | 1 |
320690 | 320690 | 2020-07-10 | McHenry | North Dakota | 38049 | 6 | 1 |
317513 | 317513 | 2020-07-09 | McHenry | North Dakota | 38049 | 6 | 1 |
314340 | 314340 | 2020-07-08 | McHenry | North Dakota | 38049 | 6 | 1 |
311168 | 311168 | 2020-07-07 | McHenry | North Dakota | 38049 | 5 | 1 |
308000 | 308000 | 2020-07-06 | McHenry | North Dakota | 38049 | 5 | 1 |
304833 | 304833 | 2020-07-05 | McHenry | North Dakota | 38049 | 5 | 1 |
301670 | 301670 | 2020-07-04 | McHenry | North Dakota | 38049 | 5 | 1 |
298507 | 298507 | 2020-07-03 | McHenry | North Dakota | 38049 | 4 | 1 |
295347 | 295347 | 2020-07-02 | McHenry | North Dakota | 38049 | 4 | 1 |
292192 | 292192 | 2020-07-01 | McHenry | North Dakota | 38049 | 3 | 1 |
289040 | 289040 | 2020-06-30 | McHenry | North Dakota | 38049 | 3 | 1 |
285890 | 285890 | 2020-06-29 | McHenry | North Dakota | 38049 | 3 | 1 |
282745 | 282745 | 2020-06-28 | McHenry | North Dakota | 38049 | 3 | 1 |
279599 | 279599 | 2020-06-27 | McHenry | North Dakota | 38049 | 3 | 1 |
276451 | 276451 | 2020-06-26 | McHenry | North Dakota | 38049 | 3 | 1 |
273304 | 273304 | 2020-06-25 | McHenry | North Dakota | 38049 | 3 | 1 |
270165 | 270165 | 2020-06-24 | McHenry | North Dakota | 38049 | 3 | 1 |
267031 | 267031 | 2020-06-23 | McHenry | North Dakota | 38049 | 3 | 1 |
263903 | 263903 | 2020-06-22 | McHenry | North Dakota | 38049 | 3 | 1 |
260775 | 260775 | 2020-06-21 | McHenry | North Dakota | 38049 | 3 | 1 |
257648 | 257648 | 2020-06-20 | McHenry | North Dakota | 38049 | 3 | 1 |
254523 | 254523 | 2020-06-19 | McHenry | North Dakota | 38049 | 3 | 1 |
251408 | 251408 | 2020-06-18 | McHenry | North Dakota | 38049 | 2 | 1 |
248293 | 248293 | 2020-06-17 | McHenry | North Dakota | 38049 | 2 | 1 |
245180 | 245180 | 2020-06-16 | McHenry | North Dakota | 38049 | 2 | 1 |
242068 | 242068 | 2020-06-15 | McHenry | North Dakota | 38049 | 2 | 1 |
238959 | 238959 | 2020-06-14 | McHenry | North Dakota | 38049 | 2 | 1 |
235851 | 235851 | 2020-06-13 | McHenry | North Dakota | 38049 | 2 | 1 |
232746 | 232746 | 2020-06-12 | McHenry | North Dakota | 38049 | 2 | 1 |
229641 | 229641 | 2020-06-11 | McHenry | North Dakota | 38049 | 2 | 1 |
226537 | 226537 | 2020-06-10 | McHenry | North Dakota | 38049 | 2 | 1 |
223437 | 223437 | 2020-06-09 | McHenry | North Dakota | 38049 | 2 | 1 |
220342 | 220342 | 2020-06-08 | McHenry | North Dakota | 38049 | 2 | 1 |
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);