ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Ramsey" and state = "North Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282756 | 282756 | 2020-06-28 | Ramsey | North Dakota | 38071 | 10 | 1 |
285901 | 285901 | 2020-06-29 | Ramsey | North Dakota | 38071 | 10 | 1 |
289051 | 289051 | 2020-06-30 | Ramsey | North Dakota | 38071 | 10 | 1 |
292203 | 292203 | 2020-07-01 | Ramsey | North Dakota | 38071 | 10 | 1 |
295358 | 295358 | 2020-07-02 | Ramsey | North Dakota | 38071 | 10 | 1 |
298518 | 298518 | 2020-07-03 | Ramsey | North Dakota | 38071 | 11 | 1 |
301681 | 301681 | 2020-07-04 | Ramsey | North Dakota | 38071 | 11 | 1 |
304844 | 304844 | 2020-07-05 | Ramsey | North Dakota | 38071 | 12 | 1 |
308011 | 308011 | 2020-07-06 | Ramsey | North Dakota | 38071 | 12 | 1 |
311179 | 311179 | 2020-07-07 | Ramsey | North Dakota | 38071 | 12 | 1 |
314351 | 314351 | 2020-07-08 | Ramsey | North Dakota | 38071 | 18 | 1 |
317524 | 317524 | 2020-07-09 | Ramsey | North Dakota | 38071 | 18 | 1 |
320701 | 320701 | 2020-07-10 | Ramsey | North Dakota | 38071 | 19 | 1 |
323881 | 323881 | 2020-07-11 | Ramsey | North Dakota | 38071 | 19 | 1 |
327066 | 327066 | 2020-07-12 | Ramsey | North Dakota | 38071 | 20 | 1 |
330253 | 330253 | 2020-07-13 | Ramsey | North Dakota | 38071 | 22 | 1 |
333444 | 333444 | 2020-07-14 | Ramsey | North Dakota | 38071 | 22 | 1 |
336638 | 336638 | 2020-07-15 | Ramsey | North Dakota | 38071 | 23 | 1 |
339834 | 339834 | 2020-07-16 | Ramsey | North Dakota | 38071 | 24 | 1 |
343032 | 343032 | 2020-07-17 | Ramsey | North Dakota | 38071 | 24 | 1 |
346231 | 346231 | 2020-07-18 | Ramsey | North Dakota | 38071 | 25 | 1 |
349432 | 349432 | 2020-07-19 | Ramsey | North Dakota | 38071 | 25 | 1 |
352635 | 352635 | 2020-07-20 | Ramsey | North Dakota | 38071 | 25 | 1 |
355838 | 355838 | 2020-07-21 | Ramsey | North Dakota | 38071 | 26 | 1 |
359042 | 359042 | 2020-07-22 | Ramsey | North Dakota | 38071 | 26 | 1 |
362248 | 362248 | 2020-07-23 | Ramsey | North Dakota | 38071 | 28 | 1 |
365454 | 365454 | 2020-07-24 | Ramsey | North Dakota | 38071 | 28 | 1 |
368663 | 368663 | 2020-07-25 | Ramsey | North Dakota | 38071 | 28 | 1 |
371875 | 371875 | 2020-07-26 | Ramsey | North Dakota | 38071 | 29 | 1 |
375087 | 375087 | 2020-07-27 | Ramsey | North Dakota | 38071 | 30 | 1 |
378304 | 378304 | 2020-07-28 | Ramsey | North Dakota | 38071 | 31 | 1 |
381521 | 381521 | 2020-07-29 | Ramsey | North Dakota | 38071 | 34 | 1 |
384739 | 384739 | 2020-07-30 | Ramsey | North Dakota | 38071 | 35 | 2 |
387956 | 387956 | 2020-07-31 | Ramsey | North Dakota | 38071 | 37 | 2 |
391173 | 391173 | 2020-08-01 | Ramsey | North Dakota | 38071 | 40 | 2 |
394389 | 394389 | 2020-08-02 | Ramsey | North Dakota | 38071 | 43 | 2 |
397606 | 397606 | 2020-08-03 | Ramsey | North Dakota | 38071 | 47 | 2 |
400821 | 400821 | 2020-08-04 | Ramsey | North Dakota | 38071 | 60 | 2 |
404039 | 404039 | 2020-08-05 | Ramsey | North Dakota | 38071 | 65 | 2 |
407258 | 407258 | 2020-08-06 | Ramsey | North Dakota | 38071 | 65 | 2 |
410478 | 410478 | 2020-08-07 | Ramsey | North Dakota | 38071 | 66 | 2 |
413698 | 413698 | 2020-08-08 | Ramsey | North Dakota | 38071 | 69 | 2 |
416919 | 416919 | 2020-08-09 | Ramsey | North Dakota | 38071 | 69 | 2 |
420139 | 420139 | 2020-08-10 | Ramsey | North Dakota | 38071 | 70 | 2 |
423362 | 423362 | 2020-08-11 | Ramsey | North Dakota | 38071 | 75 | 2 |
426585 | 426585 | 2020-08-12 | Ramsey | North Dakota | 38071 | 75 | 2 |
429810 | 429810 | 2020-08-13 | Ramsey | North Dakota | 38071 | 80 | 2 |
433036 | 433036 | 2020-08-14 | Ramsey | North Dakota | 38071 | 83 | 2 |
436262 | 436262 | 2020-08-15 | Ramsey | North Dakota | 38071 | 85 | 2 |
439487 | 439487 | 2020-08-16 | Ramsey | North Dakota | 38071 | 87 | 2 |
442714 | 442714 | 2020-08-17 | Ramsey | North Dakota | 38071 | 89 | 2 |
445940 | 445940 | 2020-08-18 | Ramsey | North Dakota | 38071 | 89 | 2 |
449168 | 449168 | 2020-08-19 | Ramsey | North Dakota | 38071 | 89 | 2 |
452396 | 452396 | 2020-08-20 | Ramsey | North Dakota | 38071 | 95 | 2 |
455624 | 455624 | 2020-08-21 | Ramsey | North Dakota | 38071 | 98 | 2 |
458852 | 458852 | 2020-08-22 | Ramsey | North Dakota | 38071 | 98 | 2 |
462080 | 462080 | 2020-08-23 | Ramsey | North Dakota | 38071 | 99 | 2 |
465309 | 465309 | 2020-08-24 | Ramsey | North Dakota | 38071 | 107 | 2 |
468537 | 468537 | 2020-08-25 | Ramsey | North Dakota | 38071 | 108 | 2 |
471769 | 471769 | 2020-08-26 | Ramsey | North Dakota | 38071 | 114 | 2 |
475003 | 475003 | 2020-08-27 | Ramsey | North Dakota | 38071 | 115 | 2 |
478236 | 478236 | 2020-08-28 | Ramsey | North Dakota | 38071 | 115 | 2 |
481469 | 481469 | 2020-08-29 | Ramsey | North Dakota | 38071 | 118 | 2 |
484704 | 484704 | 2020-08-30 | Ramsey | North Dakota | 38071 | 120 | 2 |
487937 | 487937 | 2020-08-31 | Ramsey | North Dakota | 38071 | 121 | 2 |
491170 | 491170 | 2020-09-01 | Ramsey | North Dakota | 38071 | 122 | 2 |
494404 | 494404 | 2020-09-02 | Ramsey | North Dakota | 38071 | 122 | 2 |
497637 | 497637 | 2020-09-03 | Ramsey | North Dakota | 38071 | 134 | 2 |
500871 | 500871 | 2020-09-04 | Ramsey | North Dakota | 38071 | 138 | 2 |
504105 | 504105 | 2020-09-05 | Ramsey | North Dakota | 38071 | 150 | 2 |
507337 | 507337 | 2020-09-06 | Ramsey | North Dakota | 38071 | 152 | 2 |
510570 | 510570 | 2020-09-07 | Ramsey | North Dakota | 38071 | 158 | 2 |
513803 | 513803 | 2020-09-08 | Ramsey | North Dakota | 38071 | 158 | 2 |
517038 | 517038 | 2020-09-09 | Ramsey | North Dakota | 38071 | 155 | 2 |
520274 | 520274 | 2020-09-10 | Ramsey | North Dakota | 38071 | 158 | 2 |
523510 | 523510 | 2020-09-11 | Ramsey | North Dakota | 38071 | 162 | 2 |
526746 | 526746 | 2020-09-12 | Ramsey | North Dakota | 38071 | 169 | 2 |
529983 | 529983 | 2020-09-13 | Ramsey | North Dakota | 38071 | 175 | 2 |
533218 | 533218 | 2020-09-14 | Ramsey | North Dakota | 38071 | 176 | 2 |
536454 | 536454 | 2020-09-15 | Ramsey | North Dakota | 38071 | 172 | 2 |
539691 | 539691 | 2020-09-16 | Ramsey | North Dakota | 38071 | 173 | 2 |
542927 | 542927 | 2020-09-17 | Ramsey | North Dakota | 38071 | 177 | 2 |
546164 | 546164 | 2020-09-18 | Ramsey | North Dakota | 38071 | 182 | 2 |
549403 | 549403 | 2020-09-19 | Ramsey | North Dakota | 38071 | 185 | 2 |
552642 | 552642 | 2020-09-20 | Ramsey | North Dakota | 38071 | 189 | 2 |
555879 | 555879 | 2020-09-21 | Ramsey | North Dakota | 38071 | 190 | 2 |
559116 | 559116 | 2020-09-22 | Ramsey | North Dakota | 38071 | 191 | 2 |
562353 | 562353 | 2020-09-23 | Ramsey | North Dakota | 38071 | 192 | 2 |
565594 | 565594 | 2020-09-24 | Ramsey | North Dakota | 38071 | 199 | 2 |
568835 | 568835 | 2020-09-25 | Ramsey | North Dakota | 38071 | 207 | 2 |
572077 | 572077 | 2020-09-26 | Ramsey | North Dakota | 38071 | 219 | 2 |
575321 | 575321 | 2020-09-27 | Ramsey | North Dakota | 38071 | 239 | 2 |
578562 | 578562 | 2020-09-28 | Ramsey | North Dakota | 38071 | 240 | 2 |
581802 | 581802 | 2020-09-29 | Ramsey | North Dakota | 38071 | 246 | 2 |
585043 | 585043 | 2020-09-30 | Ramsey | North Dakota | 38071 | 249 | 2 |
588283 | 588283 | 2020-10-01 | Ramsey | North Dakota | 38071 | 255 | 2 |
591524 | 591524 | 2020-10-02 | Ramsey | North Dakota | 38071 | 261 | 2 |
594765 | 594765 | 2020-10-03 | Ramsey | North Dakota | 38071 | 267 | 2 |
598008 | 598008 | 2020-10-04 | Ramsey | North Dakota | 38071 | 276 | 2 |
601251 | 601251 | 2020-10-05 | Ramsey | North Dakota | 38071 | 284 | 2 |
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);