ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 38029 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 |
---|---|---|---|---|---|---|---|
922455 | 922455 | 2021-01-12 | Emmons | North Dakota | 38029 | 400 | 10 |
919210 | 919210 | 2021-01-11 | Emmons | North Dakota | 38029 | 399 | 10 |
915965 | 915965 | 2021-01-10 | Emmons | North Dakota | 38029 | 399 | 10 |
912720 | 912720 | 2021-01-09 | Emmons | North Dakota | 38029 | 399 | 10 |
909475 | 909475 | 2021-01-08 | Emmons | North Dakota | 38029 | 395 | 10 |
906230 | 906230 | 2021-01-07 | Emmons | North Dakota | 38029 | 391 | 10 |
902984 | 902984 | 2021-01-06 | Emmons | North Dakota | 38029 | 388 | 10 |
899739 | 899739 | 2021-01-05 | Emmons | North Dakota | 38029 | 382 | 10 |
896494 | 896494 | 2021-01-04 | Emmons | North Dakota | 38029 | 380 | 10 |
893248 | 893248 | 2021-01-03 | Emmons | North Dakota | 38029 | 377 | 10 |
890002 | 890002 | 2021-01-02 | Emmons | North Dakota | 38029 | 376 | 10 |
886755 | 886755 | 2021-01-01 | Emmons | North Dakota | 38029 | 376 | 10 |
883510 | 883510 | 2020-12-31 | Emmons | North Dakota | 38029 | 372 | 10 |
880265 | 880265 | 2020-12-30 | Emmons | North Dakota | 38029 | 371 | 10 |
877020 | 877020 | 2020-12-29 | Emmons | North Dakota | 38029 | 369 | 10 |
873775 | 873775 | 2020-12-28 | Emmons | North Dakota | 38029 | 368 | 10 |
870530 | 870530 | 2020-12-27 | Emmons | North Dakota | 38029 | 368 | 10 |
867285 | 867285 | 2020-12-26 | Emmons | North Dakota | 38029 | 368 | 10 |
864040 | 864040 | 2020-12-25 | Emmons | North Dakota | 38029 | 367 | 10 |
860795 | 860795 | 2020-12-24 | Emmons | North Dakota | 38029 | 367 | 10 |
857550 | 857550 | 2020-12-23 | Emmons | North Dakota | 38029 | 367 | 10 |
854305 | 854305 | 2020-12-22 | Emmons | North Dakota | 38029 | 365 | 10 |
851060 | 851060 | 2020-12-21 | Emmons | North Dakota | 38029 | 365 | 10 |
847815 | 847815 | 2020-12-20 | Emmons | North Dakota | 38029 | 365 | 10 |
844570 | 844570 | 2020-12-19 | Emmons | North Dakota | 38029 | 365 | 10 |
841324 | 841324 | 2020-12-18 | Emmons | North Dakota | 38029 | 364 | 10 |
838079 | 838079 | 2020-12-17 | Emmons | North Dakota | 38029 | 364 | 10 |
834833 | 834833 | 2020-12-16 | Emmons | North Dakota | 38029 | 361 | 10 |
831587 | 831587 | 2020-12-15 | Emmons | North Dakota | 38029 | 360 | 10 |
828340 | 828340 | 2020-12-14 | Emmons | North Dakota | 38029 | 359 | 10 |
825094 | 825094 | 2020-12-13 | Emmons | North Dakota | 38029 | 359 | 10 |
821847 | 821847 | 2020-12-12 | Emmons | North Dakota | 38029 | 359 | 10 |
818601 | 818601 | 2020-12-11 | Emmons | North Dakota | 38029 | 356 | 10 |
815355 | 815355 | 2020-12-10 | Emmons | North Dakota | 38029 | 355 | 10 |
812110 | 812110 | 2020-12-09 | Emmons | North Dakota | 38029 | 354 | 10 |
808865 | 808865 | 2020-12-08 | Emmons | North Dakota | 38029 | 354 | 10 |
805620 | 805620 | 2020-12-07 | Emmons | North Dakota | 38029 | 354 | 10 |
802375 | 802375 | 2020-12-06 | Emmons | North Dakota | 38029 | 354 | 10 |
799130 | 799130 | 2020-12-05 | Emmons | North Dakota | 38029 | 354 | 10 |
795885 | 795885 | 2020-12-04 | Emmons | North Dakota | 38029 | 353 | 10 |
792640 | 792640 | 2020-12-03 | Emmons | North Dakota | 38029 | 352 | 9 |
789395 | 789395 | 2020-12-02 | Emmons | North Dakota | 38029 | 349 | 9 |
786150 | 786150 | 2020-12-01 | Emmons | North Dakota | 38029 | 349 | 9 |
782906 | 782906 | 2020-11-30 | Emmons | North Dakota | 38029 | 351 | 9 |
779660 | 779660 | 2020-11-29 | Emmons | North Dakota | 38029 | 351 | 9 |
776415 | 776415 | 2020-11-28 | Emmons | North Dakota | 38029 | 350 | 9 |
773170 | 773170 | 2020-11-27 | Emmons | North Dakota | 38029 | 349 | 9 |
769925 | 769925 | 2020-11-26 | Emmons | North Dakota | 38029 | 345 | 9 |
766679 | 766679 | 2020-11-25 | Emmons | North Dakota | 38029 | 344 | 9 |
763434 | 763434 | 2020-11-24 | Emmons | North Dakota | 38029 | 341 | 9 |
760189 | 760189 | 2020-11-23 | Emmons | North Dakota | 38029 | 339 | 9 |
756943 | 756943 | 2020-11-22 | Emmons | North Dakota | 38029 | 339 | 9 |
753696 | 753696 | 2020-11-21 | Emmons | North Dakota | 38029 | 327 | 9 |
750450 | 750450 | 2020-11-20 | Emmons | North Dakota | 38029 | 325 | 9 |
747204 | 747204 | 2020-11-19 | Emmons | North Dakota | 38029 | 324 | 9 |
743958 | 743958 | 2020-11-18 | Emmons | North Dakota | 38029 | 322 | 9 |
740711 | 740711 | 2020-11-17 | Emmons | North Dakota | 38029 | 322 | 9 |
737466 | 737466 | 2020-11-16 | Emmons | North Dakota | 38029 | 321 | 9 |
734222 | 734222 | 2020-11-15 | Emmons | North Dakota | 38029 | 321 | 9 |
730976 | 730976 | 2020-11-14 | Emmons | North Dakota | 38029 | 319 | 9 |
727732 | 727732 | 2020-11-13 | Emmons | North Dakota | 38029 | 317 | 9 |
724488 | 724488 | 2020-11-12 | Emmons | North Dakota | 38029 | 314 | 9 |
721245 | 721245 | 2020-11-11 | Emmons | North Dakota | 38029 | 310 | 9 |
718002 | 718002 | 2020-11-10 | Emmons | North Dakota | 38029 | 307 | 9 |
714759 | 714759 | 2020-11-09 | Emmons | North Dakota | 38029 | 307 | 9 |
711515 | 711515 | 2020-11-08 | Emmons | North Dakota | 38029 | 304 | 9 |
708271 | 708271 | 2020-11-07 | Emmons | North Dakota | 38029 | 304 | 9 |
705028 | 705028 | 2020-11-06 | Emmons | North Dakota | 38029 | 300 | 9 |
701785 | 701785 | 2020-11-05 | Emmons | North Dakota | 38029 | 297 | 9 |
698541 | 698541 | 2020-11-04 | Emmons | North Dakota | 38029 | 295 | 9 |
695298 | 695298 | 2020-11-03 | Emmons | North Dakota | 38029 | 294 | 9 |
692056 | 692056 | 2020-11-02 | Emmons | North Dakota | 38029 | 294 | 9 |
688812 | 688812 | 2020-11-01 | Emmons | North Dakota | 38029 | 292 | 9 |
685567 | 685567 | 2020-10-31 | Emmons | North Dakota | 38029 | 286 | 9 |
682324 | 682324 | 2020-10-30 | Emmons | North Dakota | 38029 | 285 | 9 |
679081 | 679081 | 2020-10-29 | Emmons | North Dakota | 38029 | 285 | 9 |
675838 | 675838 | 2020-10-28 | Emmons | North Dakota | 38029 | 281 | 8 |
672595 | 672595 | 2020-10-27 | Emmons | North Dakota | 38029 | 279 | 8 |
669353 | 669353 | 2020-10-26 | Emmons | North Dakota | 38029 | 277 | 8 |
666109 | 666109 | 2020-10-25 | Emmons | North Dakota | 38029 | 276 | 8 |
662864 | 662864 | 2020-10-24 | Emmons | North Dakota | 38029 | 275 | 8 |
659620 | 659620 | 2020-10-23 | Emmons | North Dakota | 38029 | 275 | 8 |
656376 | 656376 | 2020-10-22 | Emmons | North Dakota | 38029 | 272 | 8 |
653131 | 653131 | 2020-10-21 | Emmons | North Dakota | 38029 | 271 | 8 |
649886 | 649886 | 2020-10-20 | Emmons | North Dakota | 38029 | 270 | 7 |
646642 | 646642 | 2020-10-19 | Emmons | North Dakota | 38029 | 271 | 7 |
643396 | 643396 | 2020-10-18 | Emmons | North Dakota | 38029 | 264 | 7 |
640148 | 640148 | 2020-10-17 | Emmons | North Dakota | 38029 | 262 | 7 |
636902 | 636902 | 2020-10-16 | Emmons | North Dakota | 38029 | 259 | 7 |
633656 | 633656 | 2020-10-15 | Emmons | North Dakota | 38029 | 260 | 7 |
630411 | 630411 | 2020-10-14 | Emmons | North Dakota | 38029 | 257 | 7 |
627167 | 627167 | 2020-10-13 | Emmons | North Dakota | 38029 | 252 | 7 |
623925 | 623925 | 2020-10-12 | Emmons | North Dakota | 38029 | 249 | 7 |
620682 | 620682 | 2020-10-11 | Emmons | North Dakota | 38029 | 242 | 6 |
617440 | 617440 | 2020-10-10 | Emmons | North Dakota | 38029 | 236 | 5 |
614198 | 614198 | 2020-10-09 | Emmons | North Dakota | 38029 | 231 | 5 |
610957 | 610957 | 2020-10-08 | Emmons | North Dakota | 38029 | 231 | 5 |
607715 | 607715 | 2020-10-07 | Emmons | North Dakota | 38029 | 229 | 5 |
604472 | 604472 | 2020-10-06 | Emmons | North Dakota | 38029 | 229 | 2 |
601230 | 601230 | 2020-10-05 | Emmons | North Dakota | 38029 | 223 | 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);