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-04-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 |
---|---|---|---|---|---|---|---|
1234090 | 1234090 | 2021-04-18 | Adams | North Dakota | 38001 | 269 | 3 |
1234091 | 1234091 | 2021-04-18 | Barnes | North Dakota | 38003 | 1363 | 31 |
1234092 | 1234092 | 2021-04-18 | Benson | North Dakota | 38005 | 1047 | 18 |
1234093 | 1234093 | 2021-04-18 | Billings | North Dakota | 38007 | 53 | 0 |
1234094 | 1234094 | 2021-04-18 | Bottineau | North Dakota | 38009 | 708 | 20 |
1234095 | 1234095 | 2021-04-18 | Bowman | North Dakota | 38011 | 399 | 5 |
1234096 | 1234096 | 2021-04-18 | Burke | North Dakota | 38013 | 233 | 1 |
1234097 | 1234097 | 2021-04-18 | Burleigh | North Dakota | 38015 | 15258 | 189 |
1234098 | 1234098 | 2021-04-18 | Cass | North Dakota | 38017 | 23794 | 200 |
1234099 | 1234099 | 2021-04-18 | Cavalier | North Dakota | 38019 | 427 | 5 |
1234100 | 1234100 | 2021-04-18 | Dickey | North Dakota | 38021 | 775 | 32 |
1234101 | 1234101 | 2021-04-18 | Divide | North Dakota | 38023 | 173 | 2 |
1234102 | 1234102 | 2021-04-18 | Dunn | North Dakota | 38025 | 374 | 7 |
1234103 | 1234103 | 2021-04-18 | Eddy | North Dakota | 38027 | 464 | 6 |
1234104 | 1234104 | 2021-04-18 | Emmons | North Dakota | 38029 | 410 | 13 |
1234105 | 1234105 | 2021-04-18 | Foster | North Dakota | 38031 | 576 | 19 |
1234106 | 1234106 | 2021-04-18 | Golden Valley | North Dakota | 38033 | 256 | 3 |
1234107 | 1234107 | 2021-04-18 | Grand Forks | North Dakota | 38035 | 10358 | 77 |
1234108 | 1234108 | 2021-04-18 | Grant | North Dakota | 38037 | 196 | 7 |
1234109 | 1234109 | 2021-04-18 | Griggs | North Dakota | 38039 | 312 | 2 |
1234110 | 1234110 | 2021-04-18 | Hettinger | North Dakota | 38041 | 324 | 4 |
1234111 | 1234111 | 2021-04-18 | Kidder | North Dakota | 38043 | 262 | 10 |
1234112 | 1234112 | 2021-04-18 | LaMoure | North Dakota | 38045 | 518 | 17 |
1234113 | 1234113 | 2021-04-18 | Logan | North Dakota | 38047 | 244 | 8 |
1234114 | 1234114 | 2021-04-18 | McHenry | North Dakota | 38049 | 631 | 22 |
1234115 | 1234115 | 2021-04-18 | McIntosh | North Dakota | 38051 | 330 | 7 |
1234116 | 1234116 | 2021-04-18 | McKenzie | North Dakota | 38053 | 1233 | 12 |
1234117 | 1234117 | 2021-04-18 | McLean | North Dakota | 38055 | 1253 | 30 |
1234118 | 1234118 | 2021-04-18 | Mercer | North Dakota | 38057 | 1105 | 10 |
1234119 | 1234119 | 2021-04-18 | Morton | North Dakota | 38059 | 5121 | 98 |
1234120 | 1234120 | 2021-04-18 | Mountrail | North Dakota | 38061 | 1302 | 17 |
1234121 | 1234121 | 2021-04-18 | Nelson | North Dakota | 38063 | 470 | 14 |
1234122 | 1234122 | 2021-04-18 | Oliver | North Dakota | 38065 | 155 | 3 |
1234123 | 1234123 | 2021-04-18 | Pembina | North Dakota | 38067 | 800 | 11 |
1234124 | 1234124 | 2021-04-18 | Pierce | North Dakota | 38069 | 533 | 25 |
1234125 | 1234125 | 2021-04-18 | Ramsey | North Dakota | 38071 | 1683 | 30 |
1234126 | 1234126 | 2021-04-18 | Ransom | North Dakota | 38073 | 660 | 17 |
1234127 | 1234127 | 2021-04-18 | Renville | North Dakota | 38075 | 318 | 14 |
1234128 | 1234128 | 2021-04-18 | Richland | North Dakota | 38077 | 1958 | 17 |
1234129 | 1234129 | 2021-04-18 | Rolette | North Dakota | 38079 | 2136 | 28 |
1234130 | 1234130 | 2021-04-18 | Sargent | North Dakota | 38081 | 472 | 6 |
1234131 | 1234131 | 2021-04-18 | Sheridan | North Dakota | 38083 | 115 | 2 |
1234132 | 1234132 | 2021-04-18 | Sioux | North Dakota | 38085 | 648 | 11 |
1234133 | 1234133 | 2021-04-18 | Slope | North Dakota | 38087 | 32 | 0 |
1234134 | 1234134 | 2021-04-18 | Stark | North Dakota | 38089 | 4631 | 51 |
1234135 | 1234135 | 2021-04-18 | Steele | North Dakota | 38091 | 180 | 2 |
1234136 | 1234136 | 2021-04-18 | Stutsman | North Dakota | 38093 | 3416 | 80 |
1234137 | 1234137 | 2021-04-18 | Towner | North Dakota | 38095 | 311 | 11 |
1234138 | 1234138 | 2021-04-18 | Traill | North Dakota | 38097 | 1032 | 18 |
1234139 | 1234139 | 2021-04-18 | Unknown | North Dakota | 31 | 31 | |
1234140 | 1234140 | 2021-04-18 | Walsh | North Dakota | 38099 | 1854 | 24 |
1234141 | 1234141 | 2021-04-18 | Ward | North Dakota | 38101 | 9483 | 194 |
1234142 | 1234142 | 2021-04-18 | Wells | North Dakota | 38103 | 441 | 8 |
1234143 | 1234143 | 2021-04-18 | Williams | North Dakota | 38105 | 4658 | 38 |
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);