ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Ransom" and state = "North Dakota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
91485 | 91485 | 2020-04-26 | Ransom | North Dakota | 38073 | 1 | 0 |
94311 | 94311 | 2020-04-27 | Ransom | North Dakota | 38073 | 1 | 0 |
97148 | 97148 | 2020-04-28 | Ransom | North Dakota | 38073 | 1 | 0 |
99997 | 99997 | 2020-04-29 | Ransom | North Dakota | 38073 | 1 | 0 |
102850 | 102850 | 2020-04-30 | Ransom | North Dakota | 38073 | 1 | 0 |
105712 | 105712 | 2020-05-01 | Ransom | North Dakota | 38073 | 1 | 0 |
108579 | 108579 | 2020-05-02 | Ransom | North Dakota | 38073 | 1 | 0 |
111453 | 111453 | 2020-05-03 | Ransom | North Dakota | 38073 | 1 | 0 |
114334 | 114334 | 2020-05-04 | Ransom | North Dakota | 38073 | 1 | 0 |
117215 | 117215 | 2020-05-05 | Ransom | North Dakota | 38073 | 1 | 0 |
120176 | 120176 | 2020-05-06 | Ransom | North Dakota | 38073 | 2 | 0 |
123152 | 123152 | 2020-05-07 | Ransom | North Dakota | 38073 | 2 | 0 |
126135 | 126135 | 2020-05-08 | Ransom | North Dakota | 38073 | 2 | 0 |
129124 | 129124 | 2020-05-09 | Ransom | North Dakota | 38073 | 3 | 0 |
132113 | 132113 | 2020-05-10 | Ransom | North Dakota | 38073 | 3 | 0 |
135104 | 135104 | 2020-05-11 | Ransom | North Dakota | 38073 | 3 | 0 |
138094 | 138094 | 2020-05-12 | Ransom | North Dakota | 38073 | 3 | 0 |
141090 | 141090 | 2020-05-13 | Ransom | North Dakota | 38073 | 3 | 0 |
144085 | 144085 | 2020-05-14 | Ransom | North Dakota | 38073 | 3 | 0 |
147086 | 147086 | 2020-05-15 | Ransom | North Dakota | 38073 | 3 | 0 |
150093 | 150093 | 2020-05-16 | Ransom | North Dakota | 38073 | 3 | 0 |
153103 | 153103 | 2020-05-17 | Ransom | North Dakota | 38073 | 4 | 0 |
156120 | 156120 | 2020-05-18 | Ransom | North Dakota | 38073 | 5 | 0 |
159140 | 159140 | 2020-05-19 | Ransom | North Dakota | 38073 | 7 | 0 |
162167 | 162167 | 2020-05-20 | Ransom | North Dakota | 38073 | 7 | 0 |
165196 | 165196 | 2020-05-21 | Ransom | North Dakota | 38073 | 7 | 0 |
168232 | 168232 | 2020-05-22 | Ransom | North Dakota | 38073 | 7 | 0 |
171271 | 171271 | 2020-05-23 | Ransom | North Dakota | 38073 | 8 | 0 |
174313 | 174313 | 2020-05-24 | Ransom | North Dakota | 38073 | 8 | 0 |
177357 | 177357 | 2020-05-25 | Ransom | North Dakota | 38073 | 9 | 0 |
180400 | 180400 | 2020-05-26 | Ransom | North Dakota | 38073 | 8 | 0 |
183448 | 183448 | 2020-05-27 | Ransom | North Dakota | 38073 | 8 | 0 |
186505 | 186505 | 2020-05-28 | Ransom | North Dakota | 38073 | 8 | 0 |
189565 | 189565 | 2020-05-29 | Ransom | North Dakota | 38073 | 8 | 0 |
192629 | 192629 | 2020-05-30 | Ransom | North Dakota | 38073 | 8 | 0 |
195699 | 195699 | 2020-05-31 | Ransom | North Dakota | 38073 | 8 | 0 |
198772 | 198772 | 2020-06-01 | Ransom | North Dakota | 38073 | 9 | 0 |
201847 | 201847 | 2020-06-02 | Ransom | North Dakota | 38073 | 9 | 0 |
204924 | 204924 | 2020-06-03 | Ransom | North Dakota | 38073 | 11 | 0 |
208005 | 208005 | 2020-06-04 | Ransom | North Dakota | 38073 | 11 | 0 |
211087 | 211087 | 2020-06-05 | Ransom | North Dakota | 38073 | 11 | 0 |
214172 | 214172 | 2020-06-06 | Ransom | North Dakota | 38073 | 11 | 0 |
217262 | 217262 | 2020-06-07 | Ransom | North Dakota | 38073 | 11 | 0 |
220354 | 220354 | 2020-06-08 | Ransom | North Dakota | 38073 | 11 | 0 |
223449 | 223449 | 2020-06-09 | Ransom | North Dakota | 38073 | 11 | 0 |
226549 | 226549 | 2020-06-10 | Ransom | North Dakota | 38073 | 11 | 0 |
229653 | 229653 | 2020-06-11 | Ransom | North Dakota | 38073 | 12 | 0 |
232758 | 232758 | 2020-06-12 | Ransom | North Dakota | 38073 | 12 | 0 |
235863 | 235863 | 2020-06-13 | Ransom | North Dakota | 38073 | 12 | 0 |
238971 | 238971 | 2020-06-14 | Ransom | North Dakota | 38073 | 12 | 0 |
242080 | 242080 | 2020-06-15 | Ransom | North Dakota | 38073 | 12 | 0 |
245192 | 245192 | 2020-06-16 | Ransom | North Dakota | 38073 | 13 | 0 |
248305 | 248305 | 2020-06-17 | Ransom | North Dakota | 38073 | 13 | 0 |
251420 | 251420 | 2020-06-18 | Ransom | North Dakota | 38073 | 13 | 0 |
254535 | 254535 | 2020-06-19 | Ransom | North Dakota | 38073 | 13 | 0 |
257660 | 257660 | 2020-06-20 | Ransom | North Dakota | 38073 | 13 | 0 |
260787 | 260787 | 2020-06-21 | Ransom | North Dakota | 38073 | 15 | 0 |
263915 | 263915 | 2020-06-22 | Ransom | North Dakota | 38073 | 15 | 0 |
267043 | 267043 | 2020-06-23 | Ransom | North Dakota | 38073 | 15 | 0 |
270177 | 270177 | 2020-06-24 | Ransom | North Dakota | 38073 | 16 | 0 |
273316 | 273316 | 2020-06-25 | Ransom | North Dakota | 38073 | 16 | 0 |
276463 | 276463 | 2020-06-26 | Ransom | North Dakota | 38073 | 16 | 0 |
279611 | 279611 | 2020-06-27 | Ransom | North Dakota | 38073 | 17 | 0 |
282757 | 282757 | 2020-06-28 | Ransom | North Dakota | 38073 | 17 | 0 |
285902 | 285902 | 2020-06-29 | Ransom | North Dakota | 38073 | 17 | 0 |
289052 | 289052 | 2020-06-30 | Ransom | North Dakota | 38073 | 17 | 0 |
292204 | 292204 | 2020-07-01 | Ransom | North Dakota | 38073 | 17 | 0 |
295359 | 295359 | 2020-07-02 | Ransom | North Dakota | 38073 | 17 | 0 |
298519 | 298519 | 2020-07-03 | Ransom | North Dakota | 38073 | 17 | 0 |
301682 | 301682 | 2020-07-04 | Ransom | North Dakota | 38073 | 18 | 0 |
304845 | 304845 | 2020-07-05 | Ransom | North Dakota | 38073 | 18 | 0 |
308012 | 308012 | 2020-07-06 | Ransom | North Dakota | 38073 | 19 | 0 |
311180 | 311180 | 2020-07-07 | Ransom | North Dakota | 38073 | 19 | 0 |
314352 | 314352 | 2020-07-08 | Ransom | North Dakota | 38073 | 19 | 0 |
317525 | 317525 | 2020-07-09 | Ransom | North Dakota | 38073 | 21 | 0 |
320702 | 320702 | 2020-07-10 | Ransom | North Dakota | 38073 | 21 | 0 |
323882 | 323882 | 2020-07-11 | Ransom | North Dakota | 38073 | 21 | 0 |
327067 | 327067 | 2020-07-12 | Ransom | North Dakota | 38073 | 21 | 0 |
330254 | 330254 | 2020-07-13 | Ransom | North Dakota | 38073 | 21 | 0 |
333445 | 333445 | 2020-07-14 | Ransom | North Dakota | 38073 | 21 | 0 |
336639 | 336639 | 2020-07-15 | Ransom | North Dakota | 38073 | 21 | 0 |
339835 | 339835 | 2020-07-16 | Ransom | North Dakota | 38073 | 21 | 0 |
343033 | 343033 | 2020-07-17 | Ransom | North Dakota | 38073 | 22 | 0 |
346232 | 346232 | 2020-07-18 | Ransom | North Dakota | 38073 | 23 | 0 |
349433 | 349433 | 2020-07-19 | Ransom | North Dakota | 38073 | 23 | 0 |
352636 | 352636 | 2020-07-20 | Ransom | North Dakota | 38073 | 23 | 0 |
355839 | 355839 | 2020-07-21 | Ransom | North Dakota | 38073 | 23 | 0 |
359043 | 359043 | 2020-07-22 | Ransom | North Dakota | 38073 | 24 | 0 |
362249 | 362249 | 2020-07-23 | Ransom | North Dakota | 38073 | 25 | 0 |
365455 | 365455 | 2020-07-24 | Ransom | North Dakota | 38073 | 25 | 0 |
368664 | 368664 | 2020-07-25 | Ransom | North Dakota | 38073 | 25 | 0 |
371876 | 371876 | 2020-07-26 | Ransom | North Dakota | 38073 | 25 | 0 |
375088 | 375088 | 2020-07-27 | Ransom | North Dakota | 38073 | 25 | 0 |
378305 | 378305 | 2020-07-28 | Ransom | North Dakota | 38073 | 25 | 0 |
381522 | 381522 | 2020-07-29 | Ransom | North Dakota | 38073 | 25 | 0 |
384740 | 384740 | 2020-07-30 | Ransom | North Dakota | 38073 | 26 | 0 |
387957 | 387957 | 2020-07-31 | Ransom | North Dakota | 38073 | 26 | 0 |
391174 | 391174 | 2020-08-01 | Ransom | North Dakota | 38073 | 26 | 0 |
394390 | 394390 | 2020-08-02 | Ransom | North Dakota | 38073 | 26 | 0 |
397607 | 397607 | 2020-08-03 | Ransom | North Dakota | 38073 | 26 | 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);