ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 38003 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 |
---|---|---|---|---|---|---|---|
17017 | 17017 | 2020-03-28 | Barnes | North Dakota | 38003 | 2 | 0 |
18951 | 18951 | 2020-03-29 | Barnes | North Dakota | 38003 | 2 | 0 |
20992 | 20992 | 2020-03-30 | Barnes | North Dakota | 38003 | 2 | 0 |
23121 | 23121 | 2020-03-31 | Barnes | North Dakota | 38003 | 2 | 0 |
25315 | 25315 | 2020-04-01 | Barnes | North Dakota | 38003 | 2 | 0 |
27581 | 27581 | 2020-04-02 | Barnes | North Dakota | 38003 | 2 | 0 |
29908 | 29908 | 2020-04-03 | Barnes | North Dakota | 38003 | 2 | 0 |
32296 | 32296 | 2020-04-04 | Barnes | North Dakota | 38003 | 2 | 0 |
34728 | 34728 | 2020-04-05 | Barnes | North Dakota | 38003 | 2 | 0 |
37197 | 37197 | 2020-04-06 | Barnes | North Dakota | 38003 | 2 | 0 |
39713 | 39713 | 2020-04-07 | Barnes | North Dakota | 38003 | 2 | 0 |
42270 | 42270 | 2020-04-08 | Barnes | North Dakota | 38003 | 2 | 0 |
44854 | 44854 | 2020-04-09 | Barnes | North Dakota | 38003 | 2 | 0 |
47467 | 47467 | 2020-04-10 | Barnes | North Dakota | 38003 | 2 | 0 |
50122 | 50122 | 2020-04-11 | Barnes | North Dakota | 38003 | 2 | 0 |
52795 | 52795 | 2020-04-12 | Barnes | North Dakota | 38003 | 2 | 0 |
55479 | 55479 | 2020-04-13 | Barnes | North Dakota | 38003 | 2 | 0 |
58180 | 58180 | 2020-04-14 | Barnes | North Dakota | 38003 | 2 | 0 |
60894 | 60894 | 2020-04-15 | Barnes | North Dakota | 38003 | 2 | 0 |
63620 | 63620 | 2020-04-16 | Barnes | North Dakota | 38003 | 2 | 0 |
66363 | 66363 | 2020-04-17 | Barnes | North Dakota | 38003 | 2 | 0 |
69120 | 69120 | 2020-04-18 | Barnes | North Dakota | 38003 | 3 | 0 |
71886 | 71886 | 2020-04-19 | Barnes | North Dakota | 38003 | 3 | 0 |
74661 | 74661 | 2020-04-20 | Barnes | North Dakota | 38003 | 3 | 0 |
77442 | 77442 | 2020-04-21 | Barnes | North Dakota | 38003 | 3 | 0 |
80231 | 80231 | 2020-04-22 | Barnes | North Dakota | 38003 | 3 | 0 |
83030 | 83030 | 2020-04-23 | Barnes | North Dakota | 38003 | 3 | 0 |
85834 | 85834 | 2020-04-24 | Barnes | North Dakota | 38003 | 3 | 0 |
88647 | 88647 | 2020-04-25 | Barnes | North Dakota | 38003 | 4 | 0 |
91462 | 91462 | 2020-04-26 | Barnes | North Dakota | 38003 | 4 | 0 |
94288 | 94288 | 2020-04-27 | Barnes | North Dakota | 38003 | 4 | 0 |
97125 | 97125 | 2020-04-28 | Barnes | North Dakota | 38003 | 4 | 0 |
99974 | 99974 | 2020-04-29 | Barnes | North Dakota | 38003 | 4 | 0 |
102827 | 102827 | 2020-04-30 | Barnes | North Dakota | 38003 | 4 | 0 |
105689 | 105689 | 2020-05-01 | Barnes | North Dakota | 38003 | 4 | 0 |
108556 | 108556 | 2020-05-02 | Barnes | North Dakota | 38003 | 4 | 0 |
111430 | 111430 | 2020-05-03 | Barnes | North Dakota | 38003 | 4 | 0 |
114311 | 114311 | 2020-05-04 | Barnes | North Dakota | 38003 | 4 | 0 |
117191 | 117191 | 2020-05-05 | Barnes | North Dakota | 38003 | 4 | 0 |
120152 | 120152 | 2020-05-06 | Barnes | North Dakota | 38003 | 4 | 0 |
123127 | 123127 | 2020-05-07 | Barnes | North Dakota | 38003 | 4 | 0 |
126110 | 126110 | 2020-05-08 | Barnes | North Dakota | 38003 | 4 | 0 |
129099 | 129099 | 2020-05-09 | Barnes | North Dakota | 38003 | 4 | 0 |
132088 | 132088 | 2020-05-10 | Barnes | North Dakota | 38003 | 4 | 0 |
135079 | 135079 | 2020-05-11 | Barnes | North Dakota | 38003 | 4 | 0 |
138069 | 138069 | 2020-05-12 | Barnes | North Dakota | 38003 | 4 | 0 |
141065 | 141065 | 2020-05-13 | Barnes | North Dakota | 38003 | 4 | 0 |
144060 | 144060 | 2020-05-14 | Barnes | North Dakota | 38003 | 4 | 0 |
147061 | 147061 | 2020-05-15 | Barnes | North Dakota | 38003 | 4 | 0 |
150068 | 150068 | 2020-05-16 | Barnes | North Dakota | 38003 | 4 | 0 |
153078 | 153078 | 2020-05-17 | Barnes | North Dakota | 38003 | 4 | 0 |
156095 | 156095 | 2020-05-18 | Barnes | North Dakota | 38003 | 4 | 0 |
159114 | 159114 | 2020-05-19 | Barnes | North Dakota | 38003 | 4 | 0 |
162141 | 162141 | 2020-05-20 | Barnes | North Dakota | 38003 | 4 | 0 |
165170 | 165170 | 2020-05-21 | Barnes | North Dakota | 38003 | 4 | 0 |
168205 | 168205 | 2020-05-22 | Barnes | North Dakota | 38003 | 4 | 0 |
171244 | 171244 | 2020-05-23 | Barnes | North Dakota | 38003 | 4 | 0 |
174286 | 174286 | 2020-05-24 | Barnes | North Dakota | 38003 | 4 | 0 |
177330 | 177330 | 2020-05-25 | Barnes | North Dakota | 38003 | 4 | 0 |
180373 | 180373 | 2020-05-26 | Barnes | North Dakota | 38003 | 4 | 0 |
183421 | 183421 | 2020-05-27 | Barnes | North Dakota | 38003 | 4 | 0 |
186478 | 186478 | 2020-05-28 | Barnes | North Dakota | 38003 | 4 | 0 |
189538 | 189538 | 2020-05-29 | Barnes | North Dakota | 38003 | 4 | 0 |
192602 | 192602 | 2020-05-30 | Barnes | North Dakota | 38003 | 4 | 0 |
195672 | 195672 | 2020-05-31 | Barnes | North Dakota | 38003 | 4 | 0 |
198745 | 198745 | 2020-06-01 | Barnes | North Dakota | 38003 | 5 | 0 |
201819 | 201819 | 2020-06-02 | Barnes | North Dakota | 38003 | 5 | 0 |
204896 | 204896 | 2020-06-03 | Barnes | North Dakota | 38003 | 5 | 0 |
207977 | 207977 | 2020-06-04 | Barnes | North Dakota | 38003 | 6 | 0 |
211059 | 211059 | 2020-06-05 | Barnes | North Dakota | 38003 | 6 | 0 |
214143 | 214143 | 2020-06-06 | Barnes | North Dakota | 38003 | 9 | 0 |
217233 | 217233 | 2020-06-07 | Barnes | North Dakota | 38003 | 9 | 0 |
220325 | 220325 | 2020-06-08 | Barnes | North Dakota | 38003 | 9 | 0 |
223419 | 223419 | 2020-06-09 | Barnes | North Dakota | 38003 | 9 | 0 |
226519 | 226519 | 2020-06-10 | Barnes | North Dakota | 38003 | 9 | 0 |
229623 | 229623 | 2020-06-11 | Barnes | North Dakota | 38003 | 9 | 0 |
232728 | 232728 | 2020-06-12 | Barnes | North Dakota | 38003 | 9 | 0 |
235833 | 235833 | 2020-06-13 | Barnes | North Dakota | 38003 | 9 | 0 |
238941 | 238941 | 2020-06-14 | Barnes | North Dakota | 38003 | 9 | 0 |
242050 | 242050 | 2020-06-15 | Barnes | North Dakota | 38003 | 9 | 0 |
245162 | 245162 | 2020-06-16 | Barnes | North Dakota | 38003 | 9 | 0 |
248275 | 248275 | 2020-06-17 | Barnes | North Dakota | 38003 | 11 | 0 |
251390 | 251390 | 2020-06-18 | Barnes | North Dakota | 38003 | 16 | 0 |
254505 | 254505 | 2020-06-19 | Barnes | North Dakota | 38003 | 16 | 0 |
257628 | 257628 | 2020-06-20 | Barnes | North Dakota | 38003 | 16 | 0 |
260755 | 260755 | 2020-06-21 | Barnes | North Dakota | 38003 | 18 | 0 |
263883 | 263883 | 2020-06-22 | Barnes | North Dakota | 38003 | 18 | 0 |
267011 | 267011 | 2020-06-23 | Barnes | North Dakota | 38003 | 18 | 0 |
270145 | 270145 | 2020-06-24 | Barnes | North Dakota | 38003 | 18 | 0 |
273284 | 273284 | 2020-06-25 | Barnes | North Dakota | 38003 | 18 | 0 |
276430 | 276430 | 2020-06-26 | Barnes | North Dakota | 38003 | 18 | 0 |
279578 | 279578 | 2020-06-27 | Barnes | North Dakota | 38003 | 19 | 0 |
282724 | 282724 | 2020-06-28 | Barnes | North Dakota | 38003 | 19 | 0 |
285869 | 285869 | 2020-06-29 | Barnes | North Dakota | 38003 | 19 | 0 |
289019 | 289019 | 2020-06-30 | Barnes | North Dakota | 38003 | 19 | 0 |
292171 | 292171 | 2020-07-01 | Barnes | North Dakota | 38003 | 19 | 0 |
295326 | 295326 | 2020-07-02 | Barnes | North Dakota | 38003 | 19 | 0 |
298486 | 298486 | 2020-07-03 | Barnes | North Dakota | 38003 | 20 | 0 |
301649 | 301649 | 2020-07-04 | Barnes | North Dakota | 38003 | 20 | 0 |
304812 | 304812 | 2020-07-05 | Barnes | North Dakota | 38003 | 21 | 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);