ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 32023 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282497 | 282497 | 2020-06-28 | Nye | Nevada | 32023 | 94 | 3 |
285642 | 285642 | 2020-06-29 | Nye | Nevada | 32023 | 108 | 3 |
288792 | 288792 | 2020-06-30 | Nye | Nevada | 32023 | 114 | 3 |
291944 | 291944 | 2020-07-01 | Nye | Nevada | 32023 | 118 | 3 |
295099 | 295099 | 2020-07-02 | Nye | Nevada | 32023 | 121 | 3 |
298259 | 298259 | 2020-07-03 | Nye | Nevada | 32023 | 126 | 3 |
301422 | 301422 | 2020-07-04 | Nye | Nevada | 32023 | 126 | 3 |
304585 | 304585 | 2020-07-05 | Nye | Nevada | 32023 | 126 | 3 |
307752 | 307752 | 2020-07-06 | Nye | Nevada | 32023 | 136 | 3 |
310920 | 310920 | 2020-07-07 | Nye | Nevada | 32023 | 169 | 3 |
314091 | 314091 | 2020-07-08 | Nye | Nevada | 32023 | 171 | 3 |
317265 | 317265 | 2020-07-09 | Nye | Nevada | 32023 | 186 | 3 |
320441 | 320441 | 2020-07-10 | Nye | Nevada | 32023 | 187 | 3 |
323621 | 323621 | 2020-07-11 | Nye | Nevada | 32023 | 187 | 3 |
326805 | 326805 | 2020-07-12 | Nye | Nevada | 32023 | 187 | 3 |
329992 | 329992 | 2020-07-13 | Nye | Nevada | 32023 | 193 | 3 |
333183 | 333183 | 2020-07-14 | Nye | Nevada | 32023 | 194 | 3 |
336377 | 336377 | 2020-07-15 | Nye | Nevada | 32023 | 198 | 3 |
339573 | 339573 | 2020-07-16 | Nye | Nevada | 32023 | 222 | 4 |
342771 | 342771 | 2020-07-17 | Nye | Nevada | 32023 | 223 | 4 |
345970 | 345970 | 2020-07-18 | Nye | Nevada | 32023 | 223 | 4 |
349171 | 349171 | 2020-07-19 | Nye | Nevada | 32023 | 236 | 4 |
352374 | 352374 | 2020-07-20 | Nye | Nevada | 32023 | 251 | 6 |
355577 | 355577 | 2020-07-21 | Nye | Nevada | 32023 | 256 | 6 |
358781 | 358781 | 2020-07-22 | Nye | Nevada | 32023 | 275 | 6 |
361987 | 361987 | 2020-07-23 | Nye | Nevada | 32023 | 292 | 7 |
365193 | 365193 | 2020-07-24 | Nye | Nevada | 32023 | 292 | 7 |
368402 | 368402 | 2020-07-25 | Nye | Nevada | 32023 | 292 | 7 |
371614 | 371614 | 2020-07-26 | Nye | Nevada | 32023 | 298 | 7 |
374826 | 374826 | 2020-07-27 | Nye | Nevada | 32023 | 311 | 7 |
378041 | 378041 | 2020-07-28 | Nye | Nevada | 32023 | 315 | 7 |
381259 | 381259 | 2020-07-29 | Nye | Nevada | 32023 | 317 | 7 |
384476 | 384476 | 2020-07-30 | Nye | Nevada | 32023 | 349 | 9 |
387693 | 387693 | 2020-07-31 | Nye | Nevada | 32023 | 348 | 9 |
390910 | 390910 | 2020-08-01 | Nye | Nevada | 32023 | 348 | 9 |
394127 | 394127 | 2020-08-02 | Nye | Nevada | 32023 | 351 | 9 |
397343 | 397343 | 2020-08-03 | Nye | Nevada | 32023 | 363 | 9 |
400558 | 400558 | 2020-08-04 | Nye | Nevada | 32023 | 369 | 9 |
403776 | 403776 | 2020-08-05 | Nye | Nevada | 32023 | 369 | 9 |
406995 | 406995 | 2020-08-06 | Nye | Nevada | 32023 | 381 | 9 |
410215 | 410215 | 2020-08-07 | Nye | Nevada | 32023 | 407 | 9 |
413435 | 413435 | 2020-08-08 | Nye | Nevada | 32023 | 407 | 9 |
416656 | 416656 | 2020-08-09 | Nye | Nevada | 32023 | 408 | 9 |
419877 | 419877 | 2020-08-10 | Nye | Nevada | 32023 | 415 | 9 |
423100 | 423100 | 2020-08-11 | Nye | Nevada | 32023 | 415 | 9 |
426322 | 426322 | 2020-08-12 | Nye | Nevada | 32023 | 423 | 9 |
429547 | 429547 | 2020-08-13 | Nye | Nevada | 32023 | 423 | 12 |
432774 | 432774 | 2020-08-14 | Nye | Nevada | 32023 | 428 | 12 |
436000 | 436000 | 2020-08-15 | Nye | Nevada | 32023 | 428 | 12 |
439225 | 439225 | 2020-08-16 | Nye | Nevada | 32023 | 439 | 12 |
442452 | 442452 | 2020-08-17 | Nye | Nevada | 32023 | 448 | 12 |
445678 | 445678 | 2020-08-18 | Nye | Nevada | 32023 | 448 | 13 |
448905 | 448905 | 2020-08-19 | Nye | Nevada | 32023 | 449 | 13 |
452133 | 452133 | 2020-08-20 | Nye | Nevada | 32023 | 449 | 13 |
455361 | 455361 | 2020-08-21 | Nye | Nevada | 32023 | 460 | 14 |
458589 | 458589 | 2020-08-22 | Nye | Nevada | 32023 | 460 | 14 |
461816 | 461816 | 2020-08-23 | Nye | Nevada | 32023 | 460 | 14 |
465047 | 465047 | 2020-08-24 | Nye | Nevada | 32023 | 464 | 14 |
468275 | 468275 | 2020-08-25 | Nye | Nevada | 32023 | 470 | 14 |
471507 | 471507 | 2020-08-26 | Nye | Nevada | 32023 | 472 | 14 |
474740 | 474740 | 2020-08-27 | Nye | Nevada | 32023 | 474 | 14 |
477973 | 477973 | 2020-08-28 | Nye | Nevada | 32023 | 475 | 14 |
481205 | 481205 | 2020-08-29 | Nye | Nevada | 32023 | 475 | 14 |
484440 | 484440 | 2020-08-30 | Nye | Nevada | 32023 | 475 | 14 |
487674 | 487674 | 2020-08-31 | Nye | Nevada | 32023 | 477 | 14 |
490907 | 490907 | 2020-09-01 | Nye | Nevada | 32023 | 477 | 14 |
494141 | 494141 | 2020-09-02 | Nye | Nevada | 32023 | 480 | 14 |
497374 | 497374 | 2020-09-03 | Nye | Nevada | 32023 | 485 | 14 |
500608 | 500608 | 2020-09-04 | Nye | Nevada | 32023 | 486 | 15 |
503842 | 503842 | 2020-09-05 | Nye | Nevada | 32023 | 486 | 15 |
507074 | 507074 | 2020-09-06 | Nye | Nevada | 32023 | 486 | 15 |
510307 | 510307 | 2020-09-07 | Nye | Nevada | 32023 | 490 | 14 |
513540 | 513540 | 2020-09-08 | Nye | Nevada | 32023 | 490 | 14 |
516774 | 516774 | 2020-09-09 | Nye | Nevada | 32023 | 491 | 14 |
520009 | 520009 | 2020-09-10 | Nye | Nevada | 32023 | 493 | 14 |
523246 | 523246 | 2020-09-11 | Nye | Nevada | 32023 | 496 | 14 |
526482 | 526482 | 2020-09-12 | Nye | Nevada | 32023 | 496 | 14 |
529718 | 529718 | 2020-09-13 | Nye | Nevada | 32023 | 496 | 14 |
532954 | 532954 | 2020-09-14 | Nye | Nevada | 32023 | 498 | 14 |
536189 | 536189 | 2020-09-15 | Nye | Nevada | 32023 | 498 | 15 |
539427 | 539427 | 2020-09-16 | Nye | Nevada | 32023 | 498 | 15 |
542663 | 542663 | 2020-09-17 | Nye | Nevada | 32023 | 499 | 15 |
545900 | 545900 | 2020-09-18 | Nye | Nevada | 32023 | 501 | 15 |
549138 | 549138 | 2020-09-19 | Nye | Nevada | 32023 | 501 | 15 |
552377 | 552377 | 2020-09-20 | Nye | Nevada | 32023 | 501 | 15 |
555615 | 555615 | 2020-09-21 | Nye | Nevada | 32023 | 505 | 15 |
558852 | 558852 | 2020-09-22 | Nye | Nevada | 32023 | 507 | 15 |
562089 | 562089 | 2020-09-23 | Nye | Nevada | 32023 | 507 | 15 |
565330 | 565330 | 2020-09-24 | Nye | Nevada | 32023 | 509 | 15 |
568571 | 568571 | 2020-09-25 | Nye | Nevada | 32023 | 510 | 15 |
571813 | 571813 | 2020-09-26 | Nye | Nevada | 32023 | 510 | 15 |
575056 | 575056 | 2020-09-27 | Nye | Nevada | 32023 | 510 | 15 |
578297 | 578297 | 2020-09-28 | Nye | Nevada | 32023 | 517 | 15 |
581538 | 581538 | 2020-09-29 | Nye | Nevada | 32023 | 519 | 15 |
584779 | 584779 | 2020-09-30 | Nye | Nevada | 32023 | 522 | 15 |
588019 | 588019 | 2020-10-01 | Nye | Nevada | 32023 | 524 | 15 |
591260 | 591260 | 2020-10-02 | Nye | Nevada | 32023 | 528 | 15 |
594501 | 594501 | 2020-10-03 | Nye | Nevada | 32023 | 528 | 15 |
597743 | 597743 | 2020-10-04 | Nye | Nevada | 32023 | 528 | 15 |
600987 | 600987 | 2020-10-05 | Nye | Nevada | 32023 | 532 | 15 |
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);