ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where county = "James City" and deaths = 100 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177188 | 2177188 | 2022-02-02 | James City | Virginia | 51095 | 13855 | 100 |
2173935 | 2173935 | 2022-02-01 | James City | Virginia | 51095 | 13771 | 100 |
2170683 | 2170683 | 2022-01-31 | James City | Virginia | 51095 | 13712 | 100 |
2167430 | 2167430 | 2022-01-30 | James City | Virginia | 51095 | 13524 | 100 |
2164175 | 2164175 | 2022-01-29 | James City | Virginia | 51095 | 13524 | 100 |
2160920 | 2160920 | 2022-01-28 | James City | Virginia | 51095 | 13524 | 100 |
2157664 | 2157664 | 2022-01-27 | James City | Virginia | 51095 | 13406 | 100 |
2154411 | 2154411 | 2022-01-26 | James City | Virginia | 51095 | 13256 | 100 |
2151158 | 2151158 | 2022-01-25 | James City | Virginia | 51095 | 13128 | 100 |
2147906 | 2147906 | 2022-01-24 | James City | Virginia | 51095 | 13004 | 100 |
2144653 | 2144653 | 2022-01-23 | James City | Virginia | 51095 | 12699 | 100 |
2141398 | 2141398 | 2022-01-22 | James City | Virginia | 51095 | 12699 | 100 |
2138142 | 2138142 | 2022-01-21 | James City | Virginia | 51095 | 12699 | 100 |
2134888 | 2134888 | 2022-01-20 | James City | Virginia | 51095 | 12462 | 100 |
2131636 | 2131636 | 2022-01-19 | James City | Virginia | 51095 | 12298 | 100 |
2128382 | 2128382 | 2022-01-18 | James City | Virginia | 51095 | 12165 | 100 |
2125129 | 2125129 | 2022-01-17 | James City | Virginia | 51095 | 11998 | 100 |
2121877 | 2121877 | 2022-01-16 | James City | Virginia | 51095 | 11423 | 100 |
2118625 | 2118625 | 2022-01-15 | James City | Virginia | 51095 | 11423 | 100 |
2115373 | 2115373 | 2022-01-14 | James City | Virginia | 51095 | 11423 | 100 |
2112121 | 2112121 | 2022-01-13 | James City | Virginia | 51095 | 11227 | 100 |
2108869 | 2108869 | 2022-01-12 | James City | Virginia | 51095 | 10919 | 100 |
2105618 | 2105618 | 2022-01-11 | James City | Virginia | 51095 | 10739 | 100 |
2102367 | 2102367 | 2022-01-10 | James City | Virginia | 51095 | 10587 | 100 |
2099116 | 2099116 | 2022-01-09 | James City | Virginia | 51095 | 9558 | 100 |
2095865 | 2095865 | 2022-01-08 | James City | Virginia | 51095 | 9558 | 100 |
2092613 | 2092613 | 2022-01-07 | James City | Virginia | 51095 | 9558 | 100 |
2089361 | 2089361 | 2022-01-06 | James City | Virginia | 51095 | 9418 | 100 |
2086110 | 2086110 | 2022-01-05 | James City | Virginia | 51095 | 9392 | 100 |
2082858 | 2082858 | 2022-01-04 | James City | Virginia | 51095 | 9309 | 100 |
2079606 | 2079606 | 2022-01-03 | James City | Virginia | 51095 | 9101 | 100 |
2076354 | 2076354 | 2022-01-02 | James City | Virginia | 51095 | 8583 | 100 |
2073103 | 2073103 | 2022-01-01 | James City | Virginia | 51095 | 8583 | 100 |
2069852 | 2069852 | 2021-12-31 | James City | Virginia | 51095 | 8583 | 100 |
2066601 | 2066601 | 2021-12-30 | James City | Virginia | 51095 | 8380 | 100 |
2063351 | 2063351 | 2021-12-29 | James City | Virginia | 51095 | 8261 | 100 |
2060101 | 2060101 | 2021-12-28 | James City | Virginia | 51095 | 8138 | 100 |
2056852 | 2056852 | 2021-12-27 | James City | Virginia | 51095 | 8078 | 100 |
2053603 | 2053603 | 2021-12-26 | James City | Virginia | 51095 | 7966 | 100 |
2050353 | 2050353 | 2021-12-25 | James City | Virginia | 51095 | 7966 | 100 |
2047103 | 2047103 | 2021-12-24 | James City | Virginia | 51095 | 7966 | 100 |
2043853 | 2043853 | 2021-12-23 | James City | Virginia | 51095 | 7903 | 100 |
2040604 | 2040604 | 2021-12-22 | James City | Virginia | 51095 | 7847 | 100 |
2037354 | 2037354 | 2021-12-21 | James City | Virginia | 51095 | 7838 | 100 |
2034104 | 2034104 | 2021-12-20 | James City | Virginia | 51095 | 7824 | 100 |
2030854 | 2030854 | 2021-12-19 | James City | Virginia | 51095 | 7716 | 100 |
2027603 | 2027603 | 2021-12-18 | James City | Virginia | 51095 | 7716 | 100 |
2024352 | 2024352 | 2021-12-17 | James City | Virginia | 51095 | 7716 | 100 |
2021101 | 2021101 | 2021-12-16 | James City | Virginia | 51095 | 7696 | 100 |
2017850 | 2017850 | 2021-12-15 | James City | Virginia | 51095 | 7682 | 100 |
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);