Data source: Big Local News · About: big-local-datasette

5 rows where "updatedAt" is on date 2021-03-02

View and edit SQL

Suggested facets: createdAt (date)

updatedAt (date)

  • 2021-03-02 · 5
id ▼ contact createdAt description isOpen name updatedAt readme_markdown
UHJvamVjdDo1YzU3ZTY1NS03YzJmLTRlZTUtOGI0My05YzVmYzY5YmFkOTU= biglocalnews@stanford.edu 2020-04-10T22:15:39.540617+00:00 Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README. 1 Johns Hopkins COVID data - time series 2021-03-02T05:30:42.947000+00:00  
UHJvamVjdDphNjNlNjkwNy02ZTliLTQ4NDgtYTljYi1hOWI2ZTlmM2ZlYjc= biglocalnews@stanford.edu 2020-03-13T19:55:17.790560+00:00 Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/. 1 COVIDtracking data archive 2021-03-02T05:16:56.726000+00:00  
UHJvamVjdDphZTM5NjdjMi04YmVmLTQzNDMtYTllMi02OTE1ZGZhNTk4ZDE= biglocalnews@stanford.edu 2020-03-20T22:05:50.208150+00:00 Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details 1 COVID_USAFacts_county_cases 2021-03-02T16:06:00.605000+00:00  
UHJvamVjdDpiZGM5NmU1MS1kMzBhLTRlYTctODY4Yi04ZGI4N2RjMzQ1ODI= biglocalnews@stanford.edu 2020-03-29T22:52:52.513905+00:00 Big Local News is collecting and updating WARN (layoff/furlough) notices from state government sites and is processing the data to make it more useable. So far, we are collecting and updating daily or weekly data from 36 states. A federal law -- the WARN Act (Worker Adjustment and Retraining Notification Act) requires companies with more than 100 employees to give 60 days notice of any layoff, closure or furlough and 17 states have their own similar statutes. This data provides much more granularity into the types of jobs being lost and the companies that are furloughing workers, or that plan to close completely. A key note is that "unforeseen business circumstances" can mean that a company doesn't have to provide 60 days notice. For example, California has lifted that level of notice for its state version, or mini-WARN Act. Nonetheless, even though the advance time limit is flexible, companies still have to submit. Please cite the WARN data as collected by Big Local News. California data can be cited as collected and processed by Stanford journalism student Vanessa Ochavillo. This project includes a general README, a more specific README for California and a more specific file layout README that details the fields by state. Some states are missing but we are working to obtain the data or build scrapers. If you are interested in contributing, please let us know at biglocalnews@stanford.edu. 1 COVID_WARN_Notices 2021-03-02T00:02:02.661000+00:00  
UHJvamVjdDpkOWVkYTcyNi1iMDc4LTRmZjQtODU2My01ODRhNzIxMDdlOTc= biglocalnews@stanford.edu 2020-03-31T22:29:52.354165+00:00 Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use. 1 New York Times COVID data 2021-03-02T05:20:41.414000+00:00  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [projects] (
   [contact] TEXT,
   [createdAt] TEXT,
   [description] TEXT,
   [id] TEXT PRIMARY KEY,
   [isOpen] INTEGER,
   [name] TEXT,
   [updatedAt] TEXT
, [readme_markdown] TEXT);