ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
270 rows where county = "Grant" and deaths = 2 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- New Mexico 85
- Kansas 42
- Washington 35
- Arkansas 26
- South Dakota 24
- Nebraska 22
- Oklahoma 14
- Louisiana 10
- North Dakota 5
- Oregon 4
- Wisconsin 2
- Kentucky 1
fips 12
county 1
- Grant · 270 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
37947 | 37947 | 2020-04-06 | Grant | Washington | 53025 | 90 | 2 |
40482 | 40482 | 2020-04-07 | Grant | Washington | 53025 | 93 | 2 |
43051 | 43051 | 2020-04-08 | Grant | Washington | 53025 | 95 | 2 |
45647 | 45647 | 2020-04-09 | Grant | Washington | 53025 | 101 | 2 |
48274 | 48274 | 2020-04-10 | Grant | Washington | 53025 | 101 | 2 |
50932 | 50932 | 2020-04-11 | Grant | Washington | 53025 | 111 | 2 |
53607 | 53607 | 2020-04-12 | Grant | Washington | 53025 | 119 | 2 |
56297 | 56297 | 2020-04-13 | Grant | Washington | 53025 | 121 | 2 |
59003 | 59003 | 2020-04-14 | Grant | Washington | 53025 | 121 | 2 |
61722 | 61722 | 2020-04-15 | Grant | Washington | 53025 | 129 | 2 |
70060 | 70060 | 2020-04-18 | Grant | Wisconsin | 55043 | 15 | 2 |
72829 | 72829 | 2020-04-19 | Grant | Wisconsin | 55043 | 18 | 2 |
76605 | 76605 | 2020-04-21 | Grant | Kentucky | 21081 | 17 | 2 |
83888 | 83888 | 2020-04-23 | Grant | Washington | 53025 | 154 | 2 |
86695 | 86695 | 2020-04-24 | Grant | Washington | 53025 | 154 | 2 |
89510 | 89510 | 2020-04-25 | Grant | Washington | 53025 | 156 | 2 |
92327 | 92327 | 2020-04-26 | Grant | Washington | 53025 | 157 | 2 |
95156 | 95156 | 2020-04-27 | Grant | Washington | 53025 | 157 | 2 |
98001 | 98001 | 2020-04-28 | Grant | Washington | 53025 | 157 | 2 |
100851 | 100851 | 2020-04-29 | Grant | Washington | 53025 | 160 | 2 |
103706 | 103706 | 2020-04-30 | Grant | Washington | 53025 | 166 | 2 |
106570 | 106570 | 2020-05-01 | Grant | Washington | 53025 | 170 | 2 |
109439 | 109439 | 2020-05-02 | Grant | Washington | 53025 | 174 | 2 |
112313 | 112313 | 2020-05-03 | Grant | Washington | 53025 | 174 | 2 |
115196 | 115196 | 2020-05-04 | Grant | Washington | 53025 | 179 | 2 |
118155 | 118155 | 2020-05-05 | Grant | Washington | 53025 | 181 | 2 |
121119 | 121119 | 2020-05-06 | Grant | Washington | 53025 | 181 | 2 |
124099 | 124099 | 2020-05-07 | Grant | Washington | 53025 | 183 | 2 |
127084 | 127084 | 2020-05-08 | Grant | Washington | 53025 | 219 | 2 |
130074 | 130074 | 2020-05-09 | Grant | Washington | 53025 | 219 | 2 |
133064 | 133064 | 2020-05-10 | Grant | Washington | 53025 | 219 | 2 |
136054 | 136054 | 2020-05-11 | Grant | Washington | 53025 | 219 | 2 |
139045 | 139045 | 2020-05-12 | Grant | Washington | 53025 | 221 | 2 |
142041 | 142041 | 2020-05-13 | Grant | Washington | 53025 | 221 | 2 |
145038 | 145038 | 2020-05-14 | Grant | Washington | 53025 | 224 | 2 |
148041 | 148041 | 2020-05-15 | Grant | Washington | 53025 | 223 | 2 |
151050 | 151050 | 2020-05-16 | Grant | Washington | 53025 | 223 | 2 |
154061 | 154061 | 2020-05-17 | Grant | Washington | 53025 | 223 | 2 |
310321 | 310321 | 2020-07-07 | Grant | Louisiana | 22043 | 103 | 2 |
313284 | 313284 | 2020-07-08 | Grant | Kansas | 20067 | 57 | 2 |
313491 | 313491 | 2020-07-08 | Grant | Louisiana | 22043 | 104 | 2 |
316458 | 316458 | 2020-07-09 | Grant | Kansas | 20067 | 57 | 2 |
316665 | 316665 | 2020-07-09 | Grant | Louisiana | 22043 | 115 | 2 |
319631 | 319631 | 2020-07-10 | Grant | Kansas | 20067 | 61 | 2 |
319840 | 319840 | 2020-07-10 | Grant | Louisiana | 22043 | 122 | 2 |
322810 | 322810 | 2020-07-11 | Grant | Kansas | 20067 | 62 | 2 |
323019 | 323019 | 2020-07-11 | Grant | Louisiana | 22043 | 124 | 2 |
325992 | 325992 | 2020-07-12 | Grant | Kansas | 20067 | 63 | 2 |
326202 | 326202 | 2020-07-12 | Grant | Louisiana | 22043 | 128 | 2 |
329178 | 329178 | 2020-07-13 | Grant | Kansas | 20067 | 66 | 2 |
329388 | 329388 | 2020-07-13 | Grant | Louisiana | 22043 | 133 | 2 |
332365 | 332365 | 2020-07-14 | Grant | Kansas | 20067 | 67 | 2 |
332575 | 332575 | 2020-07-14 | Grant | Louisiana | 22043 | 136 | 2 |
335558 | 335558 | 2020-07-15 | Grant | Kansas | 20067 | 71 | 2 |
335768 | 335768 | 2020-07-15 | Grant | Louisiana | 22043 | 142 | 2 |
338754 | 338754 | 2020-07-16 | Grant | Kansas | 20067 | 71 | 2 |
338964 | 338964 | 2020-07-16 | Grant | Louisiana | 22043 | 145 | 2 |
341950 | 341950 | 2020-07-17 | Grant | Kansas | 20067 | 75 | 2 |
345150 | 345150 | 2020-07-18 | Grant | Kansas | 20067 | 76 | 2 |
348351 | 348351 | 2020-07-19 | Grant | Kansas | 20067 | 78 | 2 |
351551 | 351551 | 2020-07-20 | Grant | Kansas | 20067 | 78 | 2 |
354753 | 354753 | 2020-07-21 | Grant | Kansas | 20067 | 78 | 2 |
357955 | 357955 | 2020-07-22 | Grant | Kansas | 20067 | 78 | 2 |
361160 | 361160 | 2020-07-23 | Grant | Kansas | 20067 | 88 | 2 |
364367 | 364367 | 2020-07-24 | Grant | Kansas | 20067 | 88 | 2 |
367574 | 367574 | 2020-07-25 | Grant | Kansas | 20067 | 88 | 2 |
370784 | 370784 | 2020-07-26 | Grant | Kansas | 20067 | 88 | 2 |
373996 | 373996 | 2020-07-27 | Grant | Kansas | 20067 | 88 | 2 |
377211 | 377211 | 2020-07-28 | Grant | Kansas | 20067 | 88 | 2 |
378086 | 378086 | 2020-07-28 | Grant | New Mexico | 35017 | 65 | 2 |
380428 | 380428 | 2020-07-29 | Grant | Kansas | 20067 | 88 | 2 |
381304 | 381304 | 2020-07-29 | Grant | New Mexico | 35017 | 65 | 2 |
383645 | 383645 | 2020-07-30 | Grant | Kansas | 20067 | 92 | 2 |
384522 | 384522 | 2020-07-30 | Grant | New Mexico | 35017 | 66 | 2 |
386863 | 386863 | 2020-07-31 | Grant | Kansas | 20067 | 92 | 2 |
387739 | 387739 | 2020-07-31 | Grant | New Mexico | 35017 | 66 | 2 |
390080 | 390080 | 2020-08-01 | Grant | Kansas | 20067 | 94 | 2 |
390955 | 390955 | 2020-08-01 | Grant | New Mexico | 35017 | 67 | 2 |
393297 | 393297 | 2020-08-02 | Grant | Kansas | 20067 | 95 | 2 |
394172 | 394172 | 2020-08-02 | Grant | New Mexico | 35017 | 67 | 2 |
396513 | 396513 | 2020-08-03 | Grant | Kansas | 20067 | 97 | 2 |
397389 | 397389 | 2020-08-03 | Grant | New Mexico | 35017 | 68 | 2 |
399728 | 399728 | 2020-08-04 | Grant | Kansas | 20067 | 97 | 2 |
400604 | 400604 | 2020-08-04 | Grant | New Mexico | 35017 | 68 | 2 |
402945 | 402945 | 2020-08-05 | Grant | Kansas | 20067 | 101 | 2 |
403822 | 403822 | 2020-08-05 | Grant | New Mexico | 35017 | 70 | 2 |
406163 | 406163 | 2020-08-06 | Grant | Kansas | 20067 | 106 | 2 |
407041 | 407041 | 2020-08-06 | Grant | New Mexico | 35017 | 71 | 2 |
409382 | 409382 | 2020-08-07 | Grant | Kansas | 20067 | 110 | 2 |
410261 | 410261 | 2020-08-07 | Grant | New Mexico | 35017 | 71 | 2 |
412602 | 412602 | 2020-08-08 | Grant | Kansas | 20067 | 110 | 2 |
413481 | 413481 | 2020-08-08 | Grant | New Mexico | 35017 | 71 | 2 |
415822 | 415822 | 2020-08-09 | Grant | Kansas | 20067 | 114 | 2 |
416702 | 416702 | 2020-08-09 | Grant | New Mexico | 35017 | 71 | 2 |
419043 | 419043 | 2020-08-10 | Grant | Kansas | 20067 | 116 | 2 |
419922 | 419922 | 2020-08-10 | Grant | New Mexico | 35017 | 71 | 2 |
422266 | 422266 | 2020-08-11 | Grant | Kansas | 20067 | 116 | 2 |
423145 | 423145 | 2020-08-11 | Grant | New Mexico | 35017 | 71 | 2 |
425487 | 425487 | 2020-08-12 | Grant | Kansas | 20067 | 119 | 2 |
426368 | 426368 | 2020-08-12 | Grant | New Mexico | 35017 | 71 | 2 |
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);