ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Foster", fips = 38031 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
11845 | 11845 | 2020-03-25 | Foster | North Dakota | 38031 | 1 | 0 |
13449 | 13449 | 2020-03-26 | Foster | North Dakota | 38031 | 1 | 0 |
15186 | 15186 | 2020-03-27 | Foster | North Dakota | 38031 | 1 | 0 |
17022 | 17022 | 2020-03-28 | Foster | North Dakota | 38031 | 1 | 0 |
18956 | 18956 | 2020-03-29 | Foster | North Dakota | 38031 | 1 | 0 |
20997 | 20997 | 2020-03-30 | Foster | North Dakota | 38031 | 1 | 0 |
23126 | 23126 | 2020-03-31 | Foster | North Dakota | 38031 | 1 | 0 |
25321 | 25321 | 2020-04-01 | Foster | North Dakota | 38031 | 1 | 0 |
27587 | 27587 | 2020-04-02 | Foster | North Dakota | 38031 | 1 | 0 |
29915 | 29915 | 2020-04-03 | Foster | North Dakota | 38031 | 1 | 0 |
32303 | 32303 | 2020-04-04 | Foster | North Dakota | 38031 | 1 | 0 |
34736 | 34736 | 2020-04-05 | Foster | North Dakota | 38031 | 1 | 0 |
37205 | 37205 | 2020-04-06 | Foster | North Dakota | 38031 | 1 | 0 |
39722 | 39722 | 2020-04-07 | Foster | North Dakota | 38031 | 1 | 0 |
42279 | 42279 | 2020-04-08 | Foster | North Dakota | 38031 | 1 | 0 |
44863 | 44863 | 2020-04-09 | Foster | North Dakota | 38031 | 1 | 0 |
47476 | 47476 | 2020-04-10 | Foster | North Dakota | 38031 | 1 | 0 |
50131 | 50131 | 2020-04-11 | Foster | North Dakota | 38031 | 1 | 0 |
52804 | 52804 | 2020-04-12 | Foster | North Dakota | 38031 | 1 | 0 |
55488 | 55488 | 2020-04-13 | Foster | North Dakota | 38031 | 1 | 0 |
58189 | 58189 | 2020-04-14 | Foster | North Dakota | 38031 | 1 | 0 |
60903 | 60903 | 2020-04-15 | Foster | North Dakota | 38031 | 1 | 0 |
63629 | 63629 | 2020-04-16 | Foster | North Dakota | 38031 | 1 | 0 |
66372 | 66372 | 2020-04-17 | Foster | North Dakota | 38031 | 1 | 0 |
69129 | 69129 | 2020-04-18 | Foster | North Dakota | 38031 | 1 | 0 |
71895 | 71895 | 2020-04-19 | Foster | North Dakota | 38031 | 1 | 0 |
74670 | 74670 | 2020-04-20 | Foster | North Dakota | 38031 | 1 | 0 |
77451 | 77451 | 2020-04-21 | Foster | North Dakota | 38031 | 1 | 0 |
80240 | 80240 | 2020-04-22 | Foster | North Dakota | 38031 | 1 | 0 |
83039 | 83039 | 2020-04-23 | Foster | North Dakota | 38031 | 1 | 0 |
85843 | 85843 | 2020-04-24 | Foster | North Dakota | 38031 | 1 | 0 |
88656 | 88656 | 2020-04-25 | Foster | North Dakota | 38031 | 1 | 0 |
91471 | 91471 | 2020-04-26 | Foster | North Dakota | 38031 | 1 | 0 |
94297 | 94297 | 2020-04-27 | Foster | North Dakota | 38031 | 1 | 0 |
97134 | 97134 | 2020-04-28 | Foster | North Dakota | 38031 | 1 | 0 |
99983 | 99983 | 2020-04-29 | Foster | North Dakota | 38031 | 1 | 0 |
102836 | 102836 | 2020-04-30 | Foster | North Dakota | 38031 | 1 | 0 |
105698 | 105698 | 2020-05-01 | Foster | North Dakota | 38031 | 1 | 0 |
108565 | 108565 | 2020-05-02 | Foster | North Dakota | 38031 | 1 | 0 |
111439 | 111439 | 2020-05-03 | Foster | North Dakota | 38031 | 1 | 0 |
114320 | 114320 | 2020-05-04 | Foster | North Dakota | 38031 | 1 | 0 |
117200 | 117200 | 2020-05-05 | Foster | North Dakota | 38031 | 1 | 0 |
120161 | 120161 | 2020-05-06 | Foster | North Dakota | 38031 | 1 | 0 |
123137 | 123137 | 2020-05-07 | Foster | North Dakota | 38031 | 1 | 0 |
126120 | 126120 | 2020-05-08 | Foster | North Dakota | 38031 | 1 | 0 |
129109 | 129109 | 2020-05-09 | Foster | North Dakota | 38031 | 1 | 0 |
132098 | 132098 | 2020-05-10 | Foster | North Dakota | 38031 | 1 | 0 |
135089 | 135089 | 2020-05-11 | Foster | North Dakota | 38031 | 1 | 0 |
138079 | 138079 | 2020-05-12 | Foster | North Dakota | 38031 | 1 | 0 |
141075 | 141075 | 2020-05-13 | Foster | North Dakota | 38031 | 1 | 0 |
144070 | 144070 | 2020-05-14 | Foster | North Dakota | 38031 | 1 | 0 |
147071 | 147071 | 2020-05-15 | Foster | North Dakota | 38031 | 1 | 0 |
150078 | 150078 | 2020-05-16 | Foster | North Dakota | 38031 | 1 | 0 |
153088 | 153088 | 2020-05-17 | Foster | North Dakota | 38031 | 1 | 0 |
156105 | 156105 | 2020-05-18 | Foster | North Dakota | 38031 | 1 | 0 |
159125 | 159125 | 2020-05-19 | Foster | North Dakota | 38031 | 1 | 0 |
162152 | 162152 | 2020-05-20 | Foster | North Dakota | 38031 | 1 | 0 |
165181 | 165181 | 2020-05-21 | Foster | North Dakota | 38031 | 1 | 0 |
168216 | 168216 | 2020-05-22 | Foster | North Dakota | 38031 | 1 | 0 |
171255 | 171255 | 2020-05-23 | Foster | North Dakota | 38031 | 1 | 0 |
174297 | 174297 | 2020-05-24 | Foster | North Dakota | 38031 | 1 | 0 |
177341 | 177341 | 2020-05-25 | Foster | North Dakota | 38031 | 1 | 0 |
180384 | 180384 | 2020-05-26 | Foster | North Dakota | 38031 | 1 | 0 |
183432 | 183432 | 2020-05-27 | Foster | North Dakota | 38031 | 1 | 0 |
186489 | 186489 | 2020-05-28 | Foster | North Dakota | 38031 | 1 | 0 |
189549 | 189549 | 2020-05-29 | Foster | North Dakota | 38031 | 1 | 0 |
192613 | 192613 | 2020-05-30 | Foster | North Dakota | 38031 | 1 | 0 |
195683 | 195683 | 2020-05-31 | Foster | North Dakota | 38031 | 1 | 0 |
198756 | 198756 | 2020-06-01 | Foster | North Dakota | 38031 | 1 | 0 |
201831 | 201831 | 2020-06-02 | Foster | North Dakota | 38031 | 1 | 0 |
204908 | 204908 | 2020-06-03 | Foster | North Dakota | 38031 | 1 | 0 |
207989 | 207989 | 2020-06-04 | Foster | North Dakota | 38031 | 1 | 0 |
211071 | 211071 | 2020-06-05 | Foster | North Dakota | 38031 | 1 | 0 |
214155 | 214155 | 2020-06-06 | Foster | North Dakota | 38031 | 1 | 0 |
217245 | 217245 | 2020-06-07 | Foster | North Dakota | 38031 | 1 | 0 |
220337 | 220337 | 2020-06-08 | Foster | North Dakota | 38031 | 1 | 0 |
223431 | 223431 | 2020-06-09 | Foster | North Dakota | 38031 | 1 | 0 |
226531 | 226531 | 2020-06-10 | Foster | North Dakota | 38031 | 1 | 0 |
229635 | 229635 | 2020-06-11 | Foster | North Dakota | 38031 | 1 | 0 |
232740 | 232740 | 2020-06-12 | Foster | North Dakota | 38031 | 1 | 0 |
235845 | 235845 | 2020-06-13 | Foster | North Dakota | 38031 | 1 | 0 |
238953 | 238953 | 2020-06-14 | Foster | North Dakota | 38031 | 1 | 0 |
242062 | 242062 | 2020-06-15 | Foster | North Dakota | 38031 | 1 | 0 |
245174 | 245174 | 2020-06-16 | Foster | North Dakota | 38031 | 1 | 0 |
248287 | 248287 | 2020-06-17 | Foster | North Dakota | 38031 | 1 | 0 |
251402 | 251402 | 2020-06-18 | Foster | North Dakota | 38031 | 1 | 0 |
254517 | 254517 | 2020-06-19 | Foster | North Dakota | 38031 | 1 | 0 |
257642 | 257642 | 2020-06-20 | Foster | North Dakota | 38031 | 1 | 0 |
260769 | 260769 | 2020-06-21 | Foster | North Dakota | 38031 | 1 | 0 |
263897 | 263897 | 2020-06-22 | Foster | North Dakota | 38031 | 1 | 0 |
267025 | 267025 | 2020-06-23 | Foster | North Dakota | 38031 | 2 | 0 |
270159 | 270159 | 2020-06-24 | Foster | North Dakota | 38031 | 2 | 0 |
273298 | 273298 | 2020-06-25 | Foster | North Dakota | 38031 | 2 | 0 |
276444 | 276444 | 2020-06-26 | Foster | North Dakota | 38031 | 2 | 0 |
279592 | 279592 | 2020-06-27 | Foster | North Dakota | 38031 | 2 | 0 |
282738 | 282738 | 2020-06-28 | Foster | North Dakota | 38031 | 2 | 0 |
285883 | 285883 | 2020-06-29 | Foster | North Dakota | 38031 | 2 | 0 |
289033 | 289033 | 2020-06-30 | Foster | North Dakota | 38031 | 2 | 0 |
292185 | 292185 | 2020-07-01 | Foster | North Dakota | 38031 | 2 | 0 |
295340 | 295340 | 2020-07-02 | Foster | North Dakota | 38031 | 2 | 0 |
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);