ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
707 rows where county = "LaMoure" and state = "North Dakota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
214159 | 214159 | 2020-06-06 | LaMoure | North Dakota | 38045 | 1 | 0 |
217249 | 217249 | 2020-06-07 | LaMoure | North Dakota | 38045 | 1 | 0 |
220341 | 220341 | 2020-06-08 | LaMoure | North Dakota | 38045 | 1 | 0 |
223436 | 223436 | 2020-06-09 | LaMoure | North Dakota | 38045 | 1 | 0 |
226536 | 226536 | 2020-06-10 | LaMoure | North Dakota | 38045 | 6 | 0 |
229640 | 229640 | 2020-06-11 | LaMoure | North Dakota | 38045 | 6 | 0 |
232745 | 232745 | 2020-06-12 | LaMoure | North Dakota | 38045 | 8 | 0 |
235850 | 235850 | 2020-06-13 | LaMoure | North Dakota | 38045 | 9 | 0 |
238958 | 238958 | 2020-06-14 | LaMoure | North Dakota | 38045 | 10 | 0 |
242067 | 242067 | 2020-06-15 | LaMoure | North Dakota | 38045 | 10 | 0 |
245179 | 245179 | 2020-06-16 | LaMoure | North Dakota | 38045 | 10 | 0 |
248292 | 248292 | 2020-06-17 | LaMoure | North Dakota | 38045 | 10 | 0 |
251407 | 251407 | 2020-06-18 | LaMoure | North Dakota | 38045 | 10 | 0 |
254522 | 254522 | 2020-06-19 | LaMoure | North Dakota | 38045 | 10 | 0 |
257647 | 257647 | 2020-06-20 | LaMoure | North Dakota | 38045 | 10 | 0 |
260774 | 260774 | 2020-06-21 | LaMoure | North Dakota | 38045 | 11 | 0 |
263902 | 263902 | 2020-06-22 | LaMoure | North Dakota | 38045 | 11 | 0 |
267030 | 267030 | 2020-06-23 | LaMoure | North Dakota | 38045 | 11 | 0 |
270164 | 270164 | 2020-06-24 | LaMoure | North Dakota | 38045 | 11 | 0 |
273303 | 273303 | 2020-06-25 | LaMoure | North Dakota | 38045 | 11 | 0 |
276450 | 276450 | 2020-06-26 | LaMoure | North Dakota | 38045 | 11 | 0 |
279598 | 279598 | 2020-06-27 | LaMoure | North Dakota | 38045 | 13 | 0 |
282744 | 282744 | 2020-06-28 | LaMoure | North Dakota | 38045 | 13 | 0 |
285889 | 285889 | 2020-06-29 | LaMoure | North Dakota | 38045 | 13 | 0 |
289039 | 289039 | 2020-06-30 | LaMoure | North Dakota | 38045 | 13 | 0 |
292191 | 292191 | 2020-07-01 | LaMoure | North Dakota | 38045 | 13 | 0 |
295346 | 295346 | 2020-07-02 | LaMoure | North Dakota | 38045 | 13 | 0 |
298506 | 298506 | 2020-07-03 | LaMoure | North Dakota | 38045 | 13 | 0 |
301669 | 301669 | 2020-07-04 | LaMoure | North Dakota | 38045 | 13 | 0 |
304832 | 304832 | 2020-07-05 | LaMoure | North Dakota | 38045 | 13 | 0 |
307999 | 307999 | 2020-07-06 | LaMoure | North Dakota | 38045 | 13 | 0 |
311167 | 311167 | 2020-07-07 | LaMoure | North Dakota | 38045 | 13 | 0 |
314338 | 314338 | 2020-07-08 | LaMoure | North Dakota | 38045 | 13 | 0 |
317512 | 317512 | 2020-07-09 | LaMoure | North Dakota | 38045 | 13 | 0 |
320689 | 320689 | 2020-07-10 | LaMoure | North Dakota | 38045 | 13 | 0 |
323869 | 323869 | 2020-07-11 | LaMoure | North Dakota | 38045 | 13 | 0 |
327053 | 327053 | 2020-07-12 | LaMoure | North Dakota | 38045 | 13 | 0 |
330240 | 330240 | 2020-07-13 | LaMoure | North Dakota | 38045 | 14 | 0 |
333431 | 333431 | 2020-07-14 | LaMoure | North Dakota | 38045 | 14 | 0 |
336625 | 336625 | 2020-07-15 | LaMoure | North Dakota | 38045 | 14 | 0 |
339821 | 339821 | 2020-07-16 | LaMoure | North Dakota | 38045 | 14 | 0 |
343019 | 343019 | 2020-07-17 | LaMoure | North Dakota | 38045 | 14 | 0 |
346218 | 346218 | 2020-07-18 | LaMoure | North Dakota | 38045 | 14 | 0 |
349419 | 349419 | 2020-07-19 | LaMoure | North Dakota | 38045 | 14 | 0 |
352622 | 352622 | 2020-07-20 | LaMoure | North Dakota | 38045 | 14 | 0 |
355825 | 355825 | 2020-07-21 | LaMoure | North Dakota | 38045 | 14 | 0 |
359029 | 359029 | 2020-07-22 | LaMoure | North Dakota | 38045 | 14 | 0 |
362235 | 362235 | 2020-07-23 | LaMoure | North Dakota | 38045 | 14 | 0 |
365441 | 365441 | 2020-07-24 | LaMoure | North Dakota | 38045 | 14 | 0 |
368650 | 368650 | 2020-07-25 | LaMoure | North Dakota | 38045 | 14 | 0 |
371862 | 371862 | 2020-07-26 | LaMoure | North Dakota | 38045 | 14 | 0 |
375074 | 375074 | 2020-07-27 | LaMoure | North Dakota | 38045 | 14 | 0 |
378291 | 378291 | 2020-07-28 | LaMoure | North Dakota | 38045 | 14 | 0 |
381508 | 381508 | 2020-07-29 | LaMoure | North Dakota | 38045 | 14 | 0 |
384726 | 384726 | 2020-07-30 | LaMoure | North Dakota | 38045 | 14 | 0 |
387943 | 387943 | 2020-07-31 | LaMoure | North Dakota | 38045 | 14 | 0 |
391160 | 391160 | 2020-08-01 | LaMoure | North Dakota | 38045 | 14 | 0 |
394376 | 394376 | 2020-08-02 | LaMoure | North Dakota | 38045 | 14 | 0 |
397593 | 397593 | 2020-08-03 | LaMoure | North Dakota | 38045 | 14 | 0 |
400808 | 400808 | 2020-08-04 | LaMoure | North Dakota | 38045 | 15 | 0 |
404026 | 404026 | 2020-08-05 | LaMoure | North Dakota | 38045 | 15 | 0 |
407245 | 407245 | 2020-08-06 | LaMoure | North Dakota | 38045 | 16 | 0 |
410465 | 410465 | 2020-08-07 | LaMoure | North Dakota | 38045 | 16 | 0 |
413685 | 413685 | 2020-08-08 | LaMoure | North Dakota | 38045 | 16 | 0 |
416906 | 416906 | 2020-08-09 | LaMoure | North Dakota | 38045 | 16 | 0 |
420126 | 420126 | 2020-08-10 | LaMoure | North Dakota | 38045 | 16 | 0 |
423349 | 423349 | 2020-08-11 | LaMoure | North Dakota | 38045 | 16 | 0 |
426572 | 426572 | 2020-08-12 | LaMoure | North Dakota | 38045 | 16 | 0 |
429797 | 429797 | 2020-08-13 | LaMoure | North Dakota | 38045 | 16 | 0 |
433023 | 433023 | 2020-08-14 | LaMoure | North Dakota | 38045 | 16 | 0 |
436249 | 436249 | 2020-08-15 | LaMoure | North Dakota | 38045 | 16 | 0 |
439474 | 439474 | 2020-08-16 | LaMoure | North Dakota | 38045 | 16 | 0 |
442701 | 442701 | 2020-08-17 | LaMoure | North Dakota | 38045 | 16 | 0 |
445927 | 445927 | 2020-08-18 | LaMoure | North Dakota | 38045 | 16 | 0 |
449155 | 449155 | 2020-08-19 | LaMoure | North Dakota | 38045 | 16 | 0 |
452383 | 452383 | 2020-08-20 | LaMoure | North Dakota | 38045 | 16 | 0 |
455611 | 455611 | 2020-08-21 | LaMoure | North Dakota | 38045 | 17 | 0 |
458839 | 458839 | 2020-08-22 | LaMoure | North Dakota | 38045 | 18 | 0 |
462067 | 462067 | 2020-08-23 | LaMoure | North Dakota | 38045 | 18 | 0 |
465296 | 465296 | 2020-08-24 | LaMoure | North Dakota | 38045 | 18 | 0 |
468524 | 468524 | 2020-08-25 | LaMoure | North Dakota | 38045 | 18 | 0 |
471756 | 471756 | 2020-08-26 | LaMoure | North Dakota | 38045 | 18 | 0 |
474990 | 474990 | 2020-08-27 | LaMoure | North Dakota | 38045 | 19 | 0 |
478223 | 478223 | 2020-08-28 | LaMoure | North Dakota | 38045 | 20 | 0 |
481456 | 481456 | 2020-08-29 | LaMoure | North Dakota | 38045 | 20 | 0 |
484691 | 484691 | 2020-08-30 | LaMoure | North Dakota | 38045 | 20 | 0 |
487924 | 487924 | 2020-08-31 | LaMoure | North Dakota | 38045 | 20 | 0 |
491157 | 491157 | 2020-09-01 | LaMoure | North Dakota | 38045 | 20 | 0 |
494391 | 494391 | 2020-09-02 | LaMoure | North Dakota | 38045 | 20 | 0 |
497624 | 497624 | 2020-09-03 | LaMoure | North Dakota | 38045 | 21 | 0 |
500858 | 500858 | 2020-09-04 | LaMoure | North Dakota | 38045 | 23 | 0 |
504092 | 504092 | 2020-09-05 | LaMoure | North Dakota | 38045 | 24 | 0 |
507324 | 507324 | 2020-09-06 | LaMoure | North Dakota | 38045 | 27 | 0 |
510557 | 510557 | 2020-09-07 | LaMoure | North Dakota | 38045 | 28 | 0 |
513790 | 513790 | 2020-09-08 | LaMoure | North Dakota | 38045 | 28 | 0 |
517025 | 517025 | 2020-09-09 | LaMoure | North Dakota | 38045 | 28 | 0 |
520261 | 520261 | 2020-09-10 | LaMoure | North Dakota | 38045 | 30 | 0 |
523497 | 523497 | 2020-09-11 | LaMoure | North Dakota | 38045 | 30 | 0 |
526733 | 526733 | 2020-09-12 | LaMoure | North Dakota | 38045 | 34 | 0 |
529970 | 529970 | 2020-09-13 | LaMoure | North Dakota | 38045 | 37 | 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);