ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 38069 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
5784 | 5784 | 2020-03-20 | Pierce | North Dakota | 38069 | 1 | 0 |
6781 | 6781 | 2020-03-21 | Pierce | North Dakota | 38069 | 1 | 0 |
7887 | 7887 | 2020-03-22 | Pierce | North Dakota | 38069 | 2 | 0 |
9089 | 9089 | 2020-03-23 | Pierce | North Dakota | 38069 | 2 | 0 |
10401 | 10401 | 2020-03-24 | Pierce | North Dakota | 38069 | 2 | 0 |
11847 | 11847 | 2020-03-25 | Pierce | North Dakota | 38069 | 2 | 0 |
13453 | 13453 | 2020-03-26 | Pierce | North Dakota | 38069 | 2 | 0 |
15190 | 15190 | 2020-03-27 | Pierce | North Dakota | 38069 | 2 | 0 |
17028 | 17028 | 2020-03-28 | Pierce | North Dakota | 38069 | 2 | 0 |
18962 | 18962 | 2020-03-29 | Pierce | North Dakota | 38069 | 2 | 0 |
21005 | 21005 | 2020-03-30 | Pierce | North Dakota | 38069 | 2 | 0 |
23136 | 23136 | 2020-03-31 | Pierce | North Dakota | 38069 | 2 | 0 |
25331 | 25331 | 2020-04-01 | Pierce | North Dakota | 38069 | 2 | 0 |
27597 | 27597 | 2020-04-02 | Pierce | North Dakota | 38069 | 2 | 0 |
29925 | 29925 | 2020-04-03 | Pierce | North Dakota | 38069 | 2 | 0 |
32313 | 32313 | 2020-04-04 | Pierce | North Dakota | 38069 | 2 | 0 |
34746 | 34746 | 2020-04-05 | Pierce | North Dakota | 38069 | 2 | 0 |
37215 | 37215 | 2020-04-06 | Pierce | North Dakota | 38069 | 2 | 0 |
39732 | 39732 | 2020-04-07 | Pierce | North Dakota | 38069 | 2 | 0 |
42289 | 42289 | 2020-04-08 | Pierce | North Dakota | 38069 | 2 | 0 |
44873 | 44873 | 2020-04-09 | Pierce | North Dakota | 38069 | 2 | 0 |
47486 | 47486 | 2020-04-10 | Pierce | North Dakota | 38069 | 2 | 0 |
50141 | 50141 | 2020-04-11 | Pierce | North Dakota | 38069 | 2 | 0 |
52814 | 52814 | 2020-04-12 | Pierce | North Dakota | 38069 | 2 | 0 |
55498 | 55498 | 2020-04-13 | Pierce | North Dakota | 38069 | 2 | 0 |
58199 | 58199 | 2020-04-14 | Pierce | North Dakota | 38069 | 2 | 0 |
60913 | 60913 | 2020-04-15 | Pierce | North Dakota | 38069 | 2 | 0 |
63639 | 63639 | 2020-04-16 | Pierce | North Dakota | 38069 | 2 | 0 |
66382 | 66382 | 2020-04-17 | Pierce | North Dakota | 38069 | 2 | 0 |
69139 | 69139 | 2020-04-18 | Pierce | North Dakota | 38069 | 2 | 0 |
71906 | 71906 | 2020-04-19 | Pierce | North Dakota | 38069 | 2 | 0 |
74681 | 74681 | 2020-04-20 | Pierce | North Dakota | 38069 | 2 | 0 |
77462 | 77462 | 2020-04-21 | Pierce | North Dakota | 38069 | 2 | 0 |
80251 | 80251 | 2020-04-22 | Pierce | North Dakota | 38069 | 2 | 0 |
83050 | 83050 | 2020-04-23 | Pierce | North Dakota | 38069 | 2 | 0 |
85854 | 85854 | 2020-04-24 | Pierce | North Dakota | 38069 | 2 | 0 |
88668 | 88668 | 2020-04-25 | Pierce | North Dakota | 38069 | 2 | 0 |
91483 | 91483 | 2020-04-26 | Pierce | North Dakota | 38069 | 2 | 0 |
94309 | 94309 | 2020-04-27 | Pierce | North Dakota | 38069 | 2 | 0 |
97146 | 97146 | 2020-04-28 | Pierce | North Dakota | 38069 | 2 | 0 |
99995 | 99995 | 2020-04-29 | Pierce | North Dakota | 38069 | 2 | 0 |
102848 | 102848 | 2020-04-30 | Pierce | North Dakota | 38069 | 2 | 0 |
105710 | 105710 | 2020-05-01 | Pierce | North Dakota | 38069 | 2 | 0 |
108577 | 108577 | 2020-05-02 | Pierce | North Dakota | 38069 | 2 | 0 |
111451 | 111451 | 2020-05-03 | Pierce | North Dakota | 38069 | 2 | 0 |
114332 | 114332 | 2020-05-04 | Pierce | North Dakota | 38069 | 2 | 0 |
117213 | 117213 | 2020-05-05 | Pierce | North Dakota | 38069 | 2 | 0 |
120174 | 120174 | 2020-05-06 | Pierce | North Dakota | 38069 | 2 | 0 |
123150 | 123150 | 2020-05-07 | Pierce | North Dakota | 38069 | 3 | 0 |
126133 | 126133 | 2020-05-08 | Pierce | North Dakota | 38069 | 3 | 0 |
129122 | 129122 | 2020-05-09 | Pierce | North Dakota | 38069 | 3 | 0 |
132111 | 132111 | 2020-05-10 | Pierce | North Dakota | 38069 | 3 | 0 |
135102 | 135102 | 2020-05-11 | Pierce | North Dakota | 38069 | 3 | 0 |
138092 | 138092 | 2020-05-12 | Pierce | North Dakota | 38069 | 3 | 0 |
141088 | 141088 | 2020-05-13 | Pierce | North Dakota | 38069 | 3 | 0 |
144083 | 144083 | 2020-05-14 | Pierce | North Dakota | 38069 | 3 | 0 |
147084 | 147084 | 2020-05-15 | Pierce | North Dakota | 38069 | 3 | 0 |
150091 | 150091 | 2020-05-16 | Pierce | North Dakota | 38069 | 3 | 0 |
153101 | 153101 | 2020-05-17 | Pierce | North Dakota | 38069 | 3 | 0 |
156118 | 156118 | 2020-05-18 | Pierce | North Dakota | 38069 | 3 | 0 |
159138 | 159138 | 2020-05-19 | Pierce | North Dakota | 38069 | 3 | 0 |
162165 | 162165 | 2020-05-20 | Pierce | North Dakota | 38069 | 3 | 0 |
165194 | 165194 | 2020-05-21 | Pierce | North Dakota | 38069 | 4 | 0 |
168230 | 168230 | 2020-05-22 | Pierce | North Dakota | 38069 | 4 | 0 |
171269 | 171269 | 2020-05-23 | Pierce | North Dakota | 38069 | 4 | 0 |
174311 | 174311 | 2020-05-24 | Pierce | North Dakota | 38069 | 4 | 0 |
177355 | 177355 | 2020-05-25 | Pierce | North Dakota | 38069 | 4 | 0 |
180398 | 180398 | 2020-05-26 | Pierce | North Dakota | 38069 | 3 | 0 |
183446 | 183446 | 2020-05-27 | Pierce | North Dakota | 38069 | 3 | 0 |
186503 | 186503 | 2020-05-28 | Pierce | North Dakota | 38069 | 3 | 0 |
189563 | 189563 | 2020-05-29 | Pierce | North Dakota | 38069 | 3 | 0 |
192627 | 192627 | 2020-05-30 | Pierce | North Dakota | 38069 | 3 | 0 |
195697 | 195697 | 2020-05-31 | Pierce | North Dakota | 38069 | 3 | 0 |
198770 | 198770 | 2020-06-01 | Pierce | North Dakota | 38069 | 3 | 0 |
201845 | 201845 | 2020-06-02 | Pierce | North Dakota | 38069 | 3 | 0 |
204922 | 204922 | 2020-06-03 | Pierce | North Dakota | 38069 | 3 | 0 |
208003 | 208003 | 2020-06-04 | Pierce | North Dakota | 38069 | 3 | 0 |
211085 | 211085 | 2020-06-05 | Pierce | North Dakota | 38069 | 3 | 0 |
214170 | 214170 | 2020-06-06 | Pierce | North Dakota | 38069 | 3 | 0 |
217260 | 217260 | 2020-06-07 | Pierce | North Dakota | 38069 | 3 | 0 |
220352 | 220352 | 2020-06-08 | Pierce | North Dakota | 38069 | 3 | 0 |
223447 | 223447 | 2020-06-09 | Pierce | North Dakota | 38069 | 3 | 0 |
226547 | 226547 | 2020-06-10 | Pierce | North Dakota | 38069 | 3 | 0 |
229651 | 229651 | 2020-06-11 | Pierce | North Dakota | 38069 | 3 | 0 |
232756 | 232756 | 2020-06-12 | Pierce | North Dakota | 38069 | 3 | 0 |
235861 | 235861 | 2020-06-13 | Pierce | North Dakota | 38069 | 3 | 0 |
238969 | 238969 | 2020-06-14 | Pierce | North Dakota | 38069 | 3 | 0 |
242078 | 242078 | 2020-06-15 | Pierce | North Dakota | 38069 | 3 | 0 |
245190 | 245190 | 2020-06-16 | Pierce | North Dakota | 38069 | 3 | 0 |
248303 | 248303 | 2020-06-17 | Pierce | North Dakota | 38069 | 3 | 0 |
251418 | 251418 | 2020-06-18 | Pierce | North Dakota | 38069 | 3 | 0 |
254533 | 254533 | 2020-06-19 | Pierce | North Dakota | 38069 | 4 | 0 |
257658 | 257658 | 2020-06-20 | Pierce | North Dakota | 38069 | 4 | 0 |
260785 | 260785 | 2020-06-21 | Pierce | North Dakota | 38069 | 4 | 0 |
263913 | 263913 | 2020-06-22 | Pierce | North Dakota | 38069 | 4 | 0 |
267041 | 267041 | 2020-06-23 | Pierce | North Dakota | 38069 | 4 | 0 |
270175 | 270175 | 2020-06-24 | Pierce | North Dakota | 38069 | 4 | 0 |
273314 | 273314 | 2020-06-25 | Pierce | North Dakota | 38069 | 4 | 0 |
276461 | 276461 | 2020-06-26 | Pierce | North Dakota | 38069 | 4 | 0 |
279609 | 279609 | 2020-06-27 | Pierce | North Dakota | 38069 | 4 | 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);