ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where county = "Grant" and deaths = 3 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 15
- Kentucky 35
- Kansas 29
- Nebraska 25
- Washington 22
- Indiana 14
- Louisiana 12
- Oklahoma 11
- Minnesota 8
- New Mexico 8
- North Dakota 8
- Wisconsin 7
- South Dakota 5
- Arkansas 2
- Oregon 2
- West Virginia 1
fips 15
county 1
- Grant · 189 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
618802 | 618802 | 2020-10-11 | Grant | Arkansas | 5053 | 305 | 3 |
622045 | 622045 | 2020-10-12 | Grant | Arkansas | 5053 | 307 | 3 |
33779 | 33779 | 2020-04-05 | Grant | Indiana | 18053 | 19 | 3 |
36232 | 36232 | 2020-04-06 | Grant | Indiana | 18053 | 21 | 3 |
38730 | 38730 | 2020-04-07 | Grant | Indiana | 18053 | 21 | 3 |
41276 | 41276 | 2020-04-08 | Grant | Indiana | 18053 | 23 | 3 |
43852 | 43852 | 2020-04-09 | Grant | Indiana | 18053 | 27 | 3 |
46456 | 46456 | 2020-04-10 | Grant | Indiana | 18053 | 33 | 3 |
49090 | 49090 | 2020-04-11 | Grant | Indiana | 18053 | 36 | 3 |
51753 | 51753 | 2020-04-12 | Grant | Indiana | 18053 | 37 | 3 |
54434 | 54434 | 2020-04-13 | Grant | Indiana | 18053 | 38 | 3 |
57127 | 57127 | 2020-04-14 | Grant | Indiana | 18053 | 41 | 3 |
59835 | 59835 | 2020-04-15 | Grant | Indiana | 18053 | 42 | 3 |
62556 | 62556 | 2020-04-16 | Grant | Indiana | 18053 | 46 | 3 |
65290 | 65290 | 2020-04-17 | Grant | Indiana | 18053 | 48 | 3 |
68039 | 68039 | 2020-04-18 | Grant | Indiana | 18053 | 56 | 3 |
448069 | 448069 | 2020-08-19 | Grant | Kansas | 20067 | 135 | 3 |
451297 | 451297 | 2020-08-20 | Grant | Kansas | 20067 | 136 | 3 |
454525 | 454525 | 2020-08-21 | Grant | Kansas | 20067 | 138 | 3 |
457753 | 457753 | 2020-08-22 | Grant | Kansas | 20067 | 139 | 3 |
460980 | 460980 | 2020-08-23 | Grant | Kansas | 20067 | 139 | 3 |
464209 | 464209 | 2020-08-24 | Grant | Kansas | 20067 | 143 | 3 |
467438 | 467438 | 2020-08-25 | Grant | Kansas | 20067 | 143 | 3 |
470667 | 470667 | 2020-08-26 | Grant | Kansas | 20067 | 149 | 3 |
473899 | 473899 | 2020-08-27 | Grant | Kansas | 20067 | 149 | 3 |
477132 | 477132 | 2020-08-28 | Grant | Kansas | 20067 | 149 | 3 |
480365 | 480365 | 2020-08-29 | Grant | Kansas | 20067 | 159 | 3 |
483599 | 483599 | 2020-08-30 | Grant | Kansas | 20067 | 159 | 3 |
486834 | 486834 | 2020-08-31 | Grant | Kansas | 20067 | 160 | 3 |
490067 | 490067 | 2020-09-01 | Grant | Kansas | 20067 | 160 | 3 |
493300 | 493300 | 2020-09-02 | Grant | Kansas | 20067 | 163 | 3 |
496534 | 496534 | 2020-09-03 | Grant | Kansas | 20067 | 166 | 3 |
499767 | 499767 | 2020-09-04 | Grant | Kansas | 20067 | 166 | 3 |
503001 | 503001 | 2020-09-05 | Grant | Kansas | 20067 | 167 | 3 |
506235 | 506235 | 2020-09-06 | Grant | Kansas | 20067 | 167 | 3 |
509467 | 509467 | 2020-09-07 | Grant | Kansas | 20067 | 168 | 3 |
512700 | 512700 | 2020-09-08 | Grant | Kansas | 20067 | 180 | 3 |
515933 | 515933 | 2020-09-09 | Grant | Kansas | 20067 | 182 | 3 |
519168 | 519168 | 2020-09-10 | Grant | Kansas | 20067 | 185 | 3 |
522405 | 522405 | 2020-09-11 | Grant | Kansas | 20067 | 187 | 3 |
525641 | 525641 | 2020-09-12 | Grant | Kansas | 20067 | 188 | 3 |
528877 | 528877 | 2020-09-13 | Grant | Kansas | 20067 | 189 | 3 |
532114 | 532114 | 2020-09-14 | Grant | Kansas | 20067 | 189 | 3 |
535349 | 535349 | 2020-09-15 | Grant | Kansas | 20067 | 202 | 3 |
538585 | 538585 | 2020-09-16 | Grant | Kansas | 20067 | 209 | 3 |
79390 | 79390 | 2020-04-22 | Grant | Kentucky | 21081 | 19 | 3 |
82187 | 82187 | 2020-04-23 | Grant | Kentucky | 21081 | 18 | 3 |
84990 | 84990 | 2020-04-24 | Grant | Kentucky | 21081 | 18 | 3 |
87799 | 87799 | 2020-04-25 | Grant | Kentucky | 21081 | 18 | 3 |
90615 | 90615 | 2020-04-26 | Grant | Kentucky | 21081 | 18 | 3 |
93436 | 93436 | 2020-04-27 | Grant | Kentucky | 21081 | 18 | 3 |
96269 | 96269 | 2020-04-28 | Grant | Kentucky | 21081 | 20 | 3 |
99115 | 99115 | 2020-04-29 | Grant | Kentucky | 21081 | 20 | 3 |
101967 | 101967 | 2020-04-30 | Grant | Kentucky | 21081 | 21 | 3 |
104828 | 104828 | 2020-05-01 | Grant | Kentucky | 21081 | 21 | 3 |
107693 | 107693 | 2020-05-02 | Grant | Kentucky | 21081 | 24 | 3 |
110564 | 110564 | 2020-05-03 | Grant | Kentucky | 21081 | 25 | 3 |
113441 | 113441 | 2020-05-04 | Grant | Kentucky | 21081 | 25 | 3 |
116323 | 116323 | 2020-05-05 | Grant | Kentucky | 21081 | 26 | 3 |
119284 | 119284 | 2020-05-06 | Grant | Kentucky | 21081 | 27 | 3 |
122254 | 122254 | 2020-05-07 | Grant | Kentucky | 21081 | 27 | 3 |
125236 | 125236 | 2020-05-08 | Grant | Kentucky | 21081 | 29 | 3 |
128224 | 128224 | 2020-05-09 | Grant | Kentucky | 21081 | 30 | 3 |
131214 | 131214 | 2020-05-10 | Grant | Kentucky | 21081 | 30 | 3 |
134205 | 134205 | 2020-05-11 | Grant | Kentucky | 21081 | 31 | 3 |
137195 | 137195 | 2020-05-12 | Grant | Kentucky | 21081 | 31 | 3 |
140188 | 140188 | 2020-05-13 | Grant | Kentucky | 21081 | 31 | 3 |
143184 | 143184 | 2020-05-14 | Grant | Kentucky | 21081 | 31 | 3 |
146184 | 146184 | 2020-05-15 | Grant | Kentucky | 21081 | 32 | 3 |
149188 | 149188 | 2020-05-16 | Grant | Kentucky | 21081 | 32 | 3 |
152199 | 152199 | 2020-05-17 | Grant | Kentucky | 21081 | 32 | 3 |
155213 | 155213 | 2020-05-18 | Grant | Kentucky | 21081 | 35 | 3 |
158230 | 158230 | 2020-05-19 | Grant | Kentucky | 21081 | 35 | 3 |
161256 | 161256 | 2020-05-20 | Grant | Kentucky | 21081 | 36 | 3 |
164285 | 164285 | 2020-05-21 | Grant | Kentucky | 21081 | 36 | 3 |
167321 | 167321 | 2020-05-22 | Grant | Kentucky | 21081 | 36 | 3 |
170359 | 170359 | 2020-05-23 | Grant | Kentucky | 21081 | 37 | 3 |
173400 | 173400 | 2020-05-24 | Grant | Kentucky | 21081 | 37 | 3 |
176444 | 176444 | 2020-05-25 | Grant | Kentucky | 21081 | 37 | 3 |
179488 | 179488 | 2020-05-26 | Grant | Kentucky | 21081 | 39 | 3 |
342160 | 342160 | 2020-07-17 | Grant | Louisiana | 22043 | 150 | 3 |
345360 | 345360 | 2020-07-18 | Grant | Louisiana | 22043 | 150 | 3 |
348561 | 348561 | 2020-07-19 | Grant | Louisiana | 22043 | 154 | 3 |
351761 | 351761 | 2020-07-20 | Grant | Louisiana | 22043 | 173 | 3 |
354963 | 354963 | 2020-07-21 | Grant | Louisiana | 22043 | 179 | 3 |
358166 | 358166 | 2020-07-22 | Grant | Louisiana | 22043 | 184 | 3 |
361371 | 361371 | 2020-07-23 | Grant | Louisiana | 22043 | 188 | 3 |
364578 | 364578 | 2020-07-24 | Grant | Louisiana | 22043 | 209 | 3 |
367785 | 367785 | 2020-07-25 | Grant | Louisiana | 22043 | 209 | 3 |
370995 | 370995 | 2020-07-26 | Grant | Louisiana | 22043 | 232 | 3 |
374207 | 374207 | 2020-07-27 | Grant | Louisiana | 22043 | 244 | 3 |
377422 | 377422 | 2020-07-28 | Grant | Louisiana | 22043 | 255 | 3 |
406583 | 406583 | 2020-08-06 | Grant | Minnesota | 27051 | 52 | 3 |
409803 | 409803 | 2020-08-07 | Grant | Minnesota | 27051 | 53 | 3 |
413023 | 413023 | 2020-08-08 | Grant | Minnesota | 27051 | 53 | 3 |
416243 | 416243 | 2020-08-09 | Grant | Minnesota | 27051 | 55 | 3 |
419464 | 419464 | 2020-08-10 | Grant | Minnesota | 27051 | 56 | 3 |
422686 | 422686 | 2020-08-11 | Grant | Minnesota | 27051 | 56 | 3 |
425908 | 425908 | 2020-08-12 | Grant | Minnesota | 27051 | 56 | 3 |
429132 | 429132 | 2020-08-13 | Grant | Minnesota | 27051 | 56 | 3 |
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);