ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 38049 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 |
---|---|---|---|---|---|---|---|
1091234 | 1091234 | 2021-03-05 | McHenry | North Dakota | 38049 | 605 | 21 |
1087989 | 1087989 | 2021-03-04 | McHenry | North Dakota | 38049 | 601 | 21 |
1084744 | 1084744 | 2021-03-03 | McHenry | North Dakota | 38049 | 600 | 21 |
1081498 | 1081498 | 2021-03-02 | McHenry | North Dakota | 38049 | 598 | 21 |
1078252 | 1078252 | 2021-03-01 | McHenry | North Dakota | 38049 | 595 | 21 |
1075007 | 1075007 | 2021-02-28 | McHenry | North Dakota | 38049 | 594 | 21 |
1071761 | 1071761 | 2021-02-27 | McHenry | North Dakota | 38049 | 591 | 21 |
1068515 | 1068515 | 2021-02-26 | McHenry | North Dakota | 38049 | 588 | 21 |
1065270 | 1065270 | 2021-02-25 | McHenry | North Dakota | 38049 | 586 | 21 |
1062026 | 1062026 | 2021-02-24 | McHenry | North Dakota | 38049 | 586 | 21 |
1058780 | 1058780 | 2021-02-23 | McHenry | North Dakota | 38049 | 584 | 21 |
1055534 | 1055534 | 2021-02-22 | McHenry | North Dakota | 38049 | 582 | 21 |
1052288 | 1052288 | 2021-02-21 | McHenry | North Dakota | 38049 | 581 | 21 |
1049041 | 1049041 | 2021-02-20 | McHenry | North Dakota | 38049 | 580 | 21 |
1045794 | 1045794 | 2021-02-19 | McHenry | North Dakota | 38049 | 578 | 21 |
1042549 | 1042549 | 2021-02-18 | McHenry | North Dakota | 38049 | 575 | 21 |
1039304 | 1039304 | 2021-02-17 | McHenry | North Dakota | 38049 | 574 | 21 |
1036059 | 1036059 | 2021-02-16 | McHenry | North Dakota | 38049 | 572 | 21 |
1032814 | 1032814 | 2021-02-15 | McHenry | North Dakota | 38049 | 569 | 21 |
1029568 | 1029568 | 2021-02-14 | McHenry | North Dakota | 38049 | 567 | 21 |
1026321 | 1026321 | 2021-02-13 | McHenry | North Dakota | 38049 | 567 | 21 |
1023076 | 1023076 | 2021-02-12 | McHenry | North Dakota | 38049 | 567 | 21 |
1019831 | 1019831 | 2021-02-11 | McHenry | North Dakota | 38049 | 567 | 21 |
1016586 | 1016586 | 2021-02-10 | McHenry | North Dakota | 38049 | 564 | 21 |
1013341 | 1013341 | 2021-02-09 | McHenry | North Dakota | 38049 | 563 | 21 |
1010096 | 1010096 | 2021-02-08 | McHenry | North Dakota | 38049 | 563 | 21 |
1006850 | 1006850 | 2021-02-07 | McHenry | North Dakota | 38049 | 563 | 21 |
1003604 | 1003604 | 2021-02-06 | McHenry | North Dakota | 38049 | 563 | 21 |
1000358 | 1000358 | 2021-02-05 | McHenry | North Dakota | 38049 | 563 | 21 |
997112 | 997112 | 2021-02-04 | McHenry | North Dakota | 38049 | 561 | 21 |
993866 | 993866 | 2021-02-03 | McHenry | North Dakota | 38049 | 560 | 21 |
990620 | 990620 | 2021-02-02 | McHenry | North Dakota | 38049 | 557 | 21 |
987374 | 987374 | 2021-02-01 | McHenry | North Dakota | 38049 | 556 | 21 |
984127 | 984127 | 2021-01-31 | McHenry | North Dakota | 38049 | 555 | 21 |
980880 | 980880 | 2021-01-30 | McHenry | North Dakota | 38049 | 555 | 21 |
977634 | 977634 | 2021-01-29 | McHenry | North Dakota | 38049 | 554 | 21 |
974389 | 974389 | 2021-01-28 | McHenry | North Dakota | 38049 | 551 | 21 |
971144 | 971144 | 2021-01-27 | McHenry | North Dakota | 38049 | 551 | 21 |
967899 | 967899 | 2021-01-26 | McHenry | North Dakota | 38049 | 550 | 21 |
964655 | 964655 | 2021-01-25 | McHenry | North Dakota | 38049 | 550 | 21 |
961410 | 961410 | 2021-01-24 | McHenry | North Dakota | 38049 | 549 | 21 |
958165 | 958165 | 2021-01-23 | McHenry | North Dakota | 38049 | 549 | 21 |
954919 | 954919 | 2021-01-22 | McHenry | North Dakota | 38049 | 549 | 21 |
951674 | 951674 | 2021-01-21 | McHenry | North Dakota | 38049 | 549 | 21 |
948429 | 948429 | 2021-01-20 | McHenry | North Dakota | 38049 | 549 | 20 |
945183 | 945183 | 2021-01-19 | McHenry | North Dakota | 38049 | 548 | 20 |
941936 | 941936 | 2021-01-18 | McHenry | North Dakota | 38049 | 549 | 20 |
938691 | 938691 | 2021-01-17 | McHenry | North Dakota | 38049 | 549 | 20 |
935446 | 935446 | 2021-01-16 | McHenry | North Dakota | 38049 | 549 | 20 |
932201 | 932201 | 2021-01-15 | McHenry | North Dakota | 38049 | 547 | 20 |
928956 | 928956 | 2021-01-14 | McHenry | North Dakota | 38049 | 546 | 19 |
925711 | 925711 | 2021-01-13 | McHenry | North Dakota | 38049 | 546 | 19 |
922465 | 922465 | 2021-01-12 | McHenry | North Dakota | 38049 | 545 | 19 |
919220 | 919220 | 2021-01-11 | McHenry | North Dakota | 38049 | 546 | 19 |
915975 | 915975 | 2021-01-10 | McHenry | North Dakota | 38049 | 546 | 19 |
912730 | 912730 | 2021-01-09 | McHenry | North Dakota | 38049 | 546 | 19 |
909485 | 909485 | 2021-01-08 | McHenry | North Dakota | 38049 | 544 | 19 |
906240 | 906240 | 2021-01-07 | McHenry | North Dakota | 38049 | 544 | 19 |
902994 | 902994 | 2021-01-06 | McHenry | North Dakota | 38049 | 538 | 19 |
899749 | 899749 | 2021-01-05 | McHenry | North Dakota | 38049 | 535 | 19 |
896504 | 896504 | 2021-01-04 | McHenry | North Dakota | 38049 | 536 | 19 |
893258 | 893258 | 2021-01-03 | McHenry | North Dakota | 38049 | 535 | 19 |
890012 | 890012 | 2021-01-02 | McHenry | North Dakota | 38049 | 534 | 19 |
886765 | 886765 | 2021-01-01 | McHenry | North Dakota | 38049 | 534 | 19 |
883520 | 883520 | 2020-12-31 | McHenry | North Dakota | 38049 | 534 | 19 |
880275 | 880275 | 2020-12-30 | McHenry | North Dakota | 38049 | 533 | 19 |
877030 | 877030 | 2020-12-29 | McHenry | North Dakota | 38049 | 533 | 19 |
873785 | 873785 | 2020-12-28 | McHenry | North Dakota | 38049 | 532 | 19 |
870540 | 870540 | 2020-12-27 | McHenry | North Dakota | 38049 | 530 | 19 |
867295 | 867295 | 2020-12-26 | McHenry | North Dakota | 38049 | 529 | 19 |
864050 | 864050 | 2020-12-25 | McHenry | North Dakota | 38049 | 529 | 19 |
860805 | 860805 | 2020-12-24 | McHenry | North Dakota | 38049 | 527 | 19 |
857560 | 857560 | 2020-12-23 | McHenry | North Dakota | 38049 | 526 | 19 |
854315 | 854315 | 2020-12-22 | McHenry | North Dakota | 38049 | 525 | 19 |
851070 | 851070 | 2020-12-21 | McHenry | North Dakota | 38049 | 521 | 19 |
847825 | 847825 | 2020-12-20 | McHenry | North Dakota | 38049 | 520 | 19 |
844580 | 844580 | 2020-12-19 | McHenry | North Dakota | 38049 | 517 | 19 |
841334 | 841334 | 2020-12-18 | McHenry | North Dakota | 38049 | 515 | 19 |
838089 | 838089 | 2020-12-17 | McHenry | North Dakota | 38049 | 514 | 18 |
834843 | 834843 | 2020-12-16 | McHenry | North Dakota | 38049 | 513 | 18 |
831597 | 831597 | 2020-12-15 | McHenry | North Dakota | 38049 | 510 | 18 |
828350 | 828350 | 2020-12-14 | McHenry | North Dakota | 38049 | 509 | 18 |
825104 | 825104 | 2020-12-13 | McHenry | North Dakota | 38049 | 509 | 18 |
821857 | 821857 | 2020-12-12 | McHenry | North Dakota | 38049 | 508 | 18 |
818611 | 818611 | 2020-12-11 | McHenry | North Dakota | 38049 | 504 | 18 |
815365 | 815365 | 2020-12-10 | McHenry | North Dakota | 38049 | 504 | 17 |
812120 | 812120 | 2020-12-09 | McHenry | North Dakota | 38049 | 501 | 17 |
808875 | 808875 | 2020-12-08 | McHenry | North Dakota | 38049 | 482 | 17 |
805630 | 805630 | 2020-12-07 | McHenry | North Dakota | 38049 | 482 | 17 |
802385 | 802385 | 2020-12-06 | McHenry | North Dakota | 38049 | 480 | 17 |
799140 | 799140 | 2020-12-05 | McHenry | North Dakota | 38049 | 478 | 17 |
795895 | 795895 | 2020-12-04 | McHenry | North Dakota | 38049 | 474 | 17 |
792650 | 792650 | 2020-12-03 | McHenry | North Dakota | 38049 | 470 | 17 |
789405 | 789405 | 2020-12-02 | McHenry | North Dakota | 38049 | 462 | 17 |
786160 | 786160 | 2020-12-01 | McHenry | North Dakota | 38049 | 457 | 17 |
782916 | 782916 | 2020-11-30 | McHenry | North Dakota | 38049 | 457 | 17 |
779670 | 779670 | 2020-11-29 | McHenry | North Dakota | 38049 | 456 | 17 |
776425 | 776425 | 2020-11-28 | McHenry | North Dakota | 38049 | 448 | 17 |
773180 | 773180 | 2020-11-27 | McHenry | North Dakota | 38049 | 442 | 17 |
769935 | 769935 | 2020-11-26 | McHenry | North Dakota | 38049 | 437 | 17 |
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);