Enhanced US-GAAP Financial Statement Data Set
Refined US-GAAP Data with Outlier Correction, Amendments, and Missing Figures
@kaggle.vadimvanak_step_2
Submissions
@kaggle.vadimvanak_step_2.submissions
- 4.92 MB
- 252998 rows
- 18 columns
adshAdsh | cikCik | sicSic | formForm | periodPeriod | acceptedAccepted | versionVersion | amendment_adshAmendment Adsh | is_amendedIs Amended | tickerTicker | start_repStart Rep | end_repEnd Rep | start_qStart Q | end_qEnd Q | start_rep_pyStart Rep Py | end_rep_pyEnd Rep Py | start_q_pyStart Q Py | end_q_pyEnd Q Py |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141057825000003 | 1750 | 3720 | 10-Q | Sat Nov 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jan 07 2025 17:45:44 GMT+0000 (Coordinated Universal Time) | 2024 | air | Sat Jun 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat Nov 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Sep 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat Nov 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Nov 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Nov 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | ||
| 141057824001617 | 1750 | 3720 | 10-Q | Sat Aug 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Sep 23 2024 17:45:00 GMT+0000 (Coordinated Universal Time) | 2024 | air | Sat Jun 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat Aug 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Aug 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||
| 110465924080890 | 1750 | 3720 | 10-K | Fri May 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Jul 18 2024 17:43:00 GMT+0000 (Coordinated Universal Time) | 2023 | air | Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri May 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed May 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||
| 110465924037408 | 1750 | 3720 | 10-Q | Thu Feb 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Mar 21 2024 17:26:00 GMT+0000 (Coordinated Universal Time) | 2023 | air | Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Feb 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Dec 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Feb 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | ||
| 110465923128321 | 1750 | 3720 | 10-Q | Thu Nov 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 21 2023 17:20:00 GMT+0000 (Coordinated Universal Time) | 2023 | air | Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Nov 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Nov 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||
| 110465923103944 | 1750 | 3720 | 10-Q | Thu Aug 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Sep 26 2023 17:14:00 GMT+0000 (Coordinated Universal Time) | 2023 | air | Thu Jun 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Aug 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Aug 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||
| 110465923082069 | 1750 | 3720 | 10-K | Wed May 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jul 18 2023 17:17:00 GMT+0000 (Coordinated Universal Time) | 2022 | air | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed May 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jun 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue May 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||||
| 110465923035153 | 1750 | 3720 | 10-Q | Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Mar 21 2023 17:17:00 GMT+0000 (Coordinated Universal Time) | 2022 | air | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Dec 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Feb 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jun 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Dec 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Feb 28 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||
| 110465922128706 | 1750 | 3720 | 10-Q | Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Dec 20 2022 17:23:00 GMT+0000 (Coordinated Universal Time) | 2022 | air | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jun 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Sep 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | ||
| 110465922102374 | 1750 | 3720 | 10-Q | Wed Aug 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Thu Sep 22 2022 17:11:00 GMT+0000 (Coordinated Universal Time) | 2021 | air | Wed Jun 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Aug 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jun 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Aug 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time) |
CREATE TABLE submissions (
"adsh" BIGINT,
"cik" BIGINT,
"sic" BIGINT,
"form" VARCHAR,
"period" TIMESTAMP,
"accepted" TIMESTAMP,
"version" BIGINT,
"amendment_adsh" BIGINT,
"is_amended" BOOLEAN,
"ticker" VARCHAR,
"start_rep" TIMESTAMP,
"end_rep" TIMESTAMP,
"start_q" TIMESTAMP,
"end_q" TIMESTAMP,
"start_rep_py" TIMESTAMP,
"end_rep_py" TIMESTAMP,
"start_q_py" TIMESTAMP,
"end_q_py" TIMESTAMP
);