search

Dance-Data-Project / smith-capstone-23

MIT License
0 stars 1 forks source link

Create metadata table #3

Closed ajhoekst closed 1 year ago

ajhoekst commented 1 year ago

First complete #2

Iterate through all filings, compiling the metadata from #2 into a table/dataframe. Answer the questions below.

  1. How many filings do we have each year?
  2. How many companies (EINs) do we have each year?
  3. Which companies had more than one filing in a year?
  4. Are there years for which there is a "gap year" between filings for a company?
ajhoekst commented 1 year ago

@q-w-a Looks like you got a good portion of this done already!

Once you think this is done, try creating a pull request for the branch so we can merge it into main. This will help the team review your contribution.

q-w-a commented 1 year ago

For questions 1-3, are we thinking of the year as the year of the return timestamp or the year of the fiscal year start date?

ajhoekst commented 1 year ago

Great question! When we analyze fiscal year 2020 (FY20) for companies...we are referring to the filing with a tax period ending in 2020.