ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Burleigh" and deaths = 196 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1565229 | 1565229 | 2021-07-29 | Burleigh | North Dakota | 38015 | 16145 | 196 |
1561981 | 1561981 | 2021-07-28 | Burleigh | North Dakota | 38015 | 16138 | 196 |
1558733 | 1558733 | 2021-07-27 | Burleigh | North Dakota | 38015 | 16124 | 196 |
1555486 | 1555486 | 2021-07-26 | Burleigh | North Dakota | 38015 | 16116 | 196 |
1552239 | 1552239 | 2021-07-25 | Burleigh | North Dakota | 38015 | 16111 | 196 |
1548992 | 1548992 | 2021-07-24 | Burleigh | North Dakota | 38015 | 16107 | 196 |
1545745 | 1545745 | 2021-07-23 | Burleigh | North Dakota | 38015 | 16095 | 196 |
1542498 | 1542498 | 2021-07-22 | Burleigh | North Dakota | 38015 | 16088 | 196 |
1539250 | 1539250 | 2021-07-21 | Burleigh | North Dakota | 38015 | 16087 | 196 |
1536003 | 1536003 | 2021-07-20 | Burleigh | North Dakota | 38015 | 16079 | 196 |
1532755 | 1532755 | 2021-07-19 | Burleigh | North Dakota | 38015 | 16063 | 196 |
1529508 | 1529508 | 2021-07-18 | Burleigh | North Dakota | 38015 | 16059 | 196 |
1526261 | 1526261 | 2021-07-17 | Burleigh | North Dakota | 38015 | 16058 | 196 |
1523014 | 1523014 | 2021-07-16 | Burleigh | North Dakota | 38015 | 16056 | 196 |
1519766 | 1519766 | 2021-07-15 | Burleigh | North Dakota | 38015 | 16054 | 196 |
1516518 | 1516518 | 2021-07-14 | Burleigh | North Dakota | 38015 | 16049 | 196 |
1513271 | 1513271 | 2021-07-13 | Burleigh | North Dakota | 38015 | 16045 | 196 |
1510025 | 1510025 | 2021-07-12 | Burleigh | North Dakota | 38015 | 16045 | 196 |
1506778 | 1506778 | 2021-07-11 | Burleigh | North Dakota | 38015 | 16045 | 196 |
1503532 | 1503532 | 2021-07-10 | Burleigh | North Dakota | 38015 | 16044 | 196 |
1500286 | 1500286 | 2021-07-09 | Burleigh | North Dakota | 38015 | 16042 | 196 |
1497040 | 1497040 | 2021-07-08 | Burleigh | North Dakota | 38015 | 16042 | 196 |
1493793 | 1493793 | 2021-07-07 | Burleigh | North Dakota | 38015 | 16042 | 196 |
1490546 | 1490546 | 2021-07-06 | Burleigh | North Dakota | 38015 | 16040 | 196 |
1487299 | 1487299 | 2021-07-05 | Burleigh | North Dakota | 38015 | 16040 | 196 |
1484053 | 1484053 | 2021-07-04 | Burleigh | North Dakota | 38015 | 16039 | 196 |
1480807 | 1480807 | 2021-07-03 | Burleigh | North Dakota | 38015 | 16039 | 196 |
1477560 | 1477560 | 2021-07-02 | Burleigh | North Dakota | 38015 | 16037 | 196 |
1474314 | 1474314 | 2021-07-01 | Burleigh | North Dakota | 38015 | 16037 | 196 |
1471068 | 1471068 | 2021-06-30 | Burleigh | North Dakota | 38015 | 16037 | 196 |
1467823 | 1467823 | 2021-06-29 | Burleigh | North Dakota | 38015 | 16032 | 196 |
1464578 | 1464578 | 2021-06-28 | Burleigh | North Dakota | 38015 | 16029 | 196 |
1461333 | 1461333 | 2021-06-27 | Burleigh | North Dakota | 38015 | 16029 | 196 |
1458088 | 1458088 | 2021-06-26 | Burleigh | North Dakota | 38015 | 16028 | 196 |
1454843 | 1454843 | 2021-06-25 | Burleigh | North Dakota | 38015 | 16028 | 196 |
1451598 | 1451598 | 2021-06-24 | Burleigh | North Dakota | 38015 | 16026 | 196 |
1448352 | 1448352 | 2021-06-23 | Burleigh | North Dakota | 38015 | 16024 | 196 |
1445107 | 1445107 | 2021-06-22 | Burleigh | North Dakota | 38015 | 16021 | 196 |
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);