ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2021-11-18 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 |
---|---|---|---|---|---|---|---|
1929099 | 1929099 | 2021-11-18 | Adams | North Dakota | 38001 | 424 | 5 |
1929100 | 1929100 | 2021-11-18 | Barnes | North Dakota | 38003 | 1997 | 38 |
1929101 | 1929101 | 2021-11-18 | Benson | North Dakota | 38005 | 1371 | 20 |
1929102 | 1929102 | 2021-11-18 | Billings | North Dakota | 38007 | 103 | 1 |
1929103 | 1929103 | 2021-11-18 | Bottineau | North Dakota | 38009 | 1106 | 21 |
1929104 | 1929104 | 2021-11-18 | Bowman | North Dakota | 38011 | 639 | 8 |
1929105 | 1929105 | 2021-11-18 | Burke | North Dakota | 38013 | 343 | 3 |
1929106 | 1929106 | 2021-11-18 | Burleigh | North Dakota | 38015 | 23472 | 250 |
1929107 | 1929107 | 2021-11-18 | Cass | North Dakota | 38017 | 34535 | 255 |
1929108 | 1929108 | 2021-11-18 | Cavalier | North Dakota | 38019 | 544 | 5 |
1929109 | 1929109 | 2021-11-18 | Dickey | North Dakota | 38021 | 1091 | 36 |
1929110 | 1929110 | 2021-11-18 | Divide | North Dakota | 38023 | 301 | 3 |
1929111 | 1929111 | 2021-11-18 | Dunn | North Dakota | 38025 | 786 | 7 |
1929112 | 1929112 | 2021-11-18 | Eddy | North Dakota | 38027 | 550 | 6 |
1929113 | 1929113 | 2021-11-18 | Emmons | North Dakota | 38029 | 571 | 16 |
1929114 | 1929114 | 2021-11-18 | Foster | North Dakota | 38031 | 688 | 19 |
1929115 | 1929115 | 2021-11-18 | Golden Valley | North Dakota | 38033 | 373 | 4 |
1929116 | 1929116 | 2021-11-18 | Grand Forks | North Dakota | 38035 | 13682 | 94 |
1929117 | 1929117 | 2021-11-18 | Grant | North Dakota | 38037 | 345 | 8 |
1929118 | 1929118 | 2021-11-18 | Griggs | North Dakota | 38039 | 405 | 2 |
1929119 | 1929119 | 2021-11-18 | Hettinger | North Dakota | 38041 | 533 | 6 |
1929120 | 1929120 | 2021-11-18 | Kidder | North Dakota | 38043 | 376 | 12 |
1929121 | 1929121 | 2021-11-18 | LaMoure | North Dakota | 38045 | 711 | 17 |
1929122 | 1929122 | 2021-11-18 | Logan | North Dakota | 38047 | 334 | 11 |
1929123 | 1929123 | 2021-11-18 | McHenry | North Dakota | 38049 | 990 | 25 |
1929124 | 1929124 | 2021-11-18 | McIntosh | North Dakota | 38051 | 500 | 8 |
1929125 | 1929125 | 2021-11-18 | McKenzie | North Dakota | 38053 | 2434 | 21 |
1929126 | 1929126 | 2021-11-18 | McLean | North Dakota | 38055 | 1988 | 42 |
1929127 | 1929127 | 2021-11-18 | Mercer | North Dakota | 38057 | 1824 | 17 |
1929128 | 1929128 | 2021-11-18 | Morton | North Dakota | 38059 | 7881 | 123 |
1929129 | 1929129 | 2021-11-18 | Mountrail | North Dakota | 38061 | 1998 | 29 |
1929130 | 1929130 | 2021-11-18 | Nelson | North Dakota | 38063 | 560 | 16 |
1929131 | 1929131 | 2021-11-18 | Oliver | North Dakota | 38065 | 226 | 3 |
1929132 | 1929132 | 2021-11-18 | Pembina | North Dakota | 38067 | 1334 | 13 |
1929133 | 1929133 | 2021-11-18 | Pierce | North Dakota | 38069 | 812 | 27 |
1929134 | 1929134 | 2021-11-18 | Ramsey | North Dakota | 38071 | 2360 | 38 |
1929135 | 1929135 | 2021-11-18 | Ransom | North Dakota | 38073 | 955 | 20 |
1929136 | 1929136 | 2021-11-18 | Renville | North Dakota | 38075 | 423 | 14 |
1929137 | 1929137 | 2021-11-18 | Richland | North Dakota | 38077 | 2758 | 21 |
1929138 | 1929138 | 2021-11-18 | Rolette | North Dakota | 38079 | 3264 | 35 |
1929139 | 1929139 | 2021-11-18 | Sargent | North Dakota | 38081 | 670 | 8 |
1929140 | 1929140 | 2021-11-18 | Sheridan | North Dakota | 38083 | 205 | 4 |
1929141 | 1929141 | 2021-11-18 | Sioux | North Dakota | 38085 | 939 | 18 |
1929142 | 1929142 | 2021-11-18 | Slope | North Dakota | 38087 | 54 | 0 |
1929143 | 1929143 | 2021-11-18 | Stark | North Dakota | 38089 | 8503 | 70 |
1929144 | 1929144 | 2021-11-18 | Steele | North Dakota | 38091 | 271 | 2 |
1929145 | 1929145 | 2021-11-18 | Stutsman | North Dakota | 38093 | 4690 | 90 |
1929146 | 1929146 | 2021-11-18 | Towner | North Dakota | 38095 | 427 | 11 |
1929147 | 1929147 | 2021-11-18 | Traill | North Dakota | 38097 | 1514 | 21 |
1929148 | 1929148 | 2021-11-18 | Unknown | North Dakota | 37 | 37 | |
1929149 | 1929149 | 2021-11-18 | Walsh | North Dakota | 38099 | 2391 | 29 |
1929150 | 1929150 | 2021-11-18 | Ward | North Dakota | 38101 | 14071 | 223 |
1929151 | 1929151 | 2021-11-18 | Wells | North Dakota | 38103 | 683 | 9 |
1929152 | 1929152 | 2021-11-18 | Williams | North Dakota | 38105 | 7376 | 54 |
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);