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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
534559 | 534559 | 2020-09-15 | Grant | Arkansas | 5053 | 227 | 2 |
537795 | 537795 | 2020-09-16 | Grant | Arkansas | 5053 | 226 | 2 |
541032 | 541032 | 2020-09-17 | Grant | Arkansas | 5053 | 241 | 2 |
544268 | 544268 | 2020-09-18 | Grant | Arkansas | 5053 | 243 | 2 |
547506 | 547506 | 2020-09-19 | Grant | Arkansas | 5053 | 245 | 2 |
550745 | 550745 | 2020-09-20 | Grant | Arkansas | 5053 | 247 | 2 |
553984 | 553984 | 2020-09-21 | Grant | Arkansas | 5053 | 249 | 2 |
557221 | 557221 | 2020-09-22 | Grant | Arkansas | 5053 | 250 | 2 |
560457 | 560457 | 2020-09-23 | Grant | Arkansas | 5053 | 252 | 2 |
563696 | 563696 | 2020-09-24 | Grant | Arkansas | 5053 | 255 | 2 |
566936 | 566936 | 2020-09-25 | Grant | Arkansas | 5053 | 256 | 2 |
570178 | 570178 | 2020-09-26 | Grant | Arkansas | 5053 | 263 | 2 |
573420 | 573420 | 2020-09-27 | Grant | Arkansas | 5053 | 266 | 2 |
576663 | 576663 | 2020-09-28 | Grant | Arkansas | 5053 | 269 | 2 |
579904 | 579904 | 2020-09-29 | Grant | Arkansas | 5053 | 271 | 2 |
583143 | 583143 | 2020-09-30 | Grant | Arkansas | 5053 | 272 | 2 |
586383 | 586383 | 2020-10-01 | Grant | Arkansas | 5053 | 274 | 2 |
589624 | 589624 | 2020-10-02 | Grant | Arkansas | 5053 | 275 | 2 |
592864 | 592864 | 2020-10-03 | Grant | Arkansas | 5053 | 276 | 2 |
596106 | 596106 | 2020-10-04 | Grant | Arkansas | 5053 | 277 | 2 |
599349 | 599349 | 2020-10-05 | Grant | Arkansas | 5053 | 278 | 2 |
602592 | 602592 | 2020-10-06 | Grant | Arkansas | 5053 | 282 | 2 |
605834 | 605834 | 2020-10-07 | Grant | Arkansas | 5053 | 284 | 2 |
609077 | 609077 | 2020-10-08 | Grant | Arkansas | 5053 | 292 | 2 |
612319 | 612319 | 2020-10-09 | Grant | Arkansas | 5053 | 297 | 2 |
615560 | 615560 | 2020-10-10 | Grant | Arkansas | 5053 | 303 | 2 |
313284 | 313284 | 2020-07-08 | Grant | Kansas | 20067 | 57 | 2 |
316458 | 316458 | 2020-07-09 | Grant | Kansas | 20067 | 57 | 2 |
319631 | 319631 | 2020-07-10 | Grant | Kansas | 20067 | 61 | 2 |
322810 | 322810 | 2020-07-11 | Grant | Kansas | 20067 | 62 | 2 |
325992 | 325992 | 2020-07-12 | Grant | Kansas | 20067 | 63 | 2 |
329178 | 329178 | 2020-07-13 | Grant | Kansas | 20067 | 66 | 2 |
332365 | 332365 | 2020-07-14 | Grant | Kansas | 20067 | 67 | 2 |
335558 | 335558 | 2020-07-15 | Grant | Kansas | 20067 | 71 | 2 |
338754 | 338754 | 2020-07-16 | Grant | Kansas | 20067 | 71 | 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 |
380428 | 380428 | 2020-07-29 | Grant | Kansas | 20067 | 88 | 2 |
383645 | 383645 | 2020-07-30 | Grant | Kansas | 20067 | 92 | 2 |
386863 | 386863 | 2020-07-31 | Grant | Kansas | 20067 | 92 | 2 |
390080 | 390080 | 2020-08-01 | Grant | Kansas | 20067 | 94 | 2 |
393297 | 393297 | 2020-08-02 | Grant | Kansas | 20067 | 95 | 2 |
396513 | 396513 | 2020-08-03 | Grant | Kansas | 20067 | 97 | 2 |
399728 | 399728 | 2020-08-04 | Grant | Kansas | 20067 | 97 | 2 |
402945 | 402945 | 2020-08-05 | Grant | Kansas | 20067 | 101 | 2 |
406163 | 406163 | 2020-08-06 | Grant | Kansas | 20067 | 106 | 2 |
409382 | 409382 | 2020-08-07 | Grant | Kansas | 20067 | 110 | 2 |
412602 | 412602 | 2020-08-08 | Grant | Kansas | 20067 | 110 | 2 |
415822 | 415822 | 2020-08-09 | Grant | Kansas | 20067 | 114 | 2 |
419043 | 419043 | 2020-08-10 | Grant | Kansas | 20067 | 116 | 2 |
422266 | 422266 | 2020-08-11 | Grant | Kansas | 20067 | 116 | 2 |
425487 | 425487 | 2020-08-12 | Grant | Kansas | 20067 | 119 | 2 |
428711 | 428711 | 2020-08-13 | Grant | Kansas | 20067 | 120 | 2 |
431939 | 431939 | 2020-08-14 | Grant | Kansas | 20067 | 120 | 2 |
435164 | 435164 | 2020-08-15 | Grant | Kansas | 20067 | 130 | 2 |
438389 | 438389 | 2020-08-16 | Grant | Kansas | 20067 | 130 | 2 |
441616 | 441616 | 2020-08-17 | Grant | Kansas | 20067 | 132 | 2 |
444842 | 444842 | 2020-08-18 | Grant | Kansas | 20067 | 134 | 2 |
76605 | 76605 | 2020-04-21 | Grant | Kentucky | 21081 | 17 | 2 |
310321 | 310321 | 2020-07-07 | Grant | Louisiana | 22043 | 103 | 2 |
313491 | 313491 | 2020-07-08 | Grant | Louisiana | 22043 | 104 | 2 |
316665 | 316665 | 2020-07-09 | Grant | Louisiana | 22043 | 115 | 2 |
319840 | 319840 | 2020-07-10 | Grant | Louisiana | 22043 | 122 | 2 |
323019 | 323019 | 2020-07-11 | Grant | Louisiana | 22043 | 124 | 2 |
326202 | 326202 | 2020-07-12 | Grant | Louisiana | 22043 | 128 | 2 |
329388 | 329388 | 2020-07-13 | Grant | Louisiana | 22043 | 133 | 2 |
332575 | 332575 | 2020-07-14 | Grant | Louisiana | 22043 | 136 | 2 |
335768 | 335768 | 2020-07-15 | Grant | Louisiana | 22043 | 142 | 2 |
338964 | 338964 | 2020-07-16 | Grant | Louisiana | 22043 | 145 | 2 |
785839 | 785839 | 2020-12-01 | Grant | Nebraska | 31075 | 19 | 2 |
789084 | 789084 | 2020-12-02 | Grant | Nebraska | 31075 | 20 | 2 |
792329 | 792329 | 2020-12-03 | Grant | Nebraska | 31075 | 20 | 2 |
795574 | 795574 | 2020-12-04 | Grant | Nebraska | 31075 | 20 | 2 |
798819 | 798819 | 2020-12-05 | Grant | Nebraska | 31075 | 21 | 2 |
802064 | 802064 | 2020-12-06 | Grant | Nebraska | 31075 | 21 | 2 |
805309 | 805309 | 2020-12-07 | Grant | Nebraska | 31075 | 21 | 2 |
808554 | 808554 | 2020-12-08 | Grant | Nebraska | 31075 | 21 | 2 |
811799 | 811799 | 2020-12-09 | Grant | Nebraska | 31075 | 21 | 2 |
815044 | 815044 | 2020-12-10 | Grant | Nebraska | 31075 | 21 | 2 |
818290 | 818290 | 2020-12-11 | Grant | Nebraska | 31075 | 21 | 2 |
821536 | 821536 | 2020-12-12 | Grant | Nebraska | 31075 | 21 | 2 |
824782 | 824782 | 2020-12-13 | Grant | Nebraska | 31075 | 21 | 2 |
828029 | 828029 | 2020-12-14 | Grant | Nebraska | 31075 | 21 | 2 |
831275 | 831275 | 2020-12-15 | Grant | Nebraska | 31075 | 23 | 2 |
834522 | 834522 | 2020-12-16 | Grant | Nebraska | 31075 | 23 | 2 |
837768 | 837768 | 2020-12-17 | Grant | Nebraska | 31075 | 23 | 2 |
841013 | 841013 | 2020-12-18 | Grant | Nebraska | 31075 | 23 | 2 |
844258 | 844258 | 2020-12-19 | Grant | Nebraska | 31075 | 23 | 2 |
847504 | 847504 | 2020-12-20 | Grant | Nebraska | 31075 | 23 | 2 |
850749 | 850749 | 2020-12-21 | Grant | Nebraska | 31075 | 23 | 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);