Skip to content

Instantly share code, notes, and snippets.

@bnchdrff

bnchdrff/py13_990.sql

Last active August 18, 2016 16:42
Show Gist options
  • Save bnchdrff/14413f0bf8253729bd646373d91519a0 to your computer and use it in GitHub Desktop.
Save bnchdrff/14413f0bf8253729bd646373d91519a0 to your computer and use it in GitHub Desktop.
Download ZIP
irs 990 schemas
Raw
py13_990.sql
CREATE TABLE py13_990 (
"EIN" VARCHAR(9) NOT NULL,
tax_pd INTEGER NOT NULL,
subseccd VARCHAR(2) NOT NULL,
s501c3or4947a1cd BOOLEAN NOT NULL,
schdbind BOOLEAN NOT NULL,
politicalactvtscd BOOLEAN NOT NULL,
lbbyingactvtscd BOOLEAN NOT NULL,
subjto6033cd BOOLEAN NOT NULL,
dnradvisedfundscd BOOLEAN NOT NULL,
prptyintrcvdcd BOOLEAN NOT NULL,
maintwrkofartcd BOOLEAN NOT NULL,
crcounselingqstncd BOOLEAN NOT NULL,
hldassetsintermpermcd BOOLEAN NOT NULL,
rptlndbldgeqptcd BOOLEAN NOT NULL,
rptinvstothsecd BOOLEAN NOT NULL,
rptinvstprgrelcd BOOLEAN NOT NULL,
rptothasstcd BOOLEAN NOT NULL,
rptothliabcd BOOLEAN NOT NULL,
sepcnsldtfinstmtcd BOOLEAN NOT NULL,
sepindaudfinstmtcd BOOLEAN NOT NULL,
inclinfinstmtcd BOOLEAN NOT NULL,
operateschools170cd BOOLEAN NOT NULL,
frgnofficecd BOOLEAN NOT NULL,
frgnrevexpnscd BOOLEAN NOT NULL,
frgngrntscd BOOLEAN NOT NULL,
frgnaggragrntscd BOOLEAN NOT NULL,
rptprofndrsngfeescd BOOLEAN NOT NULL,
rptincfnndrsngcd BOOLEAN NOT NULL,
rptincgamingcd BOOLEAN NOT NULL,
operatehosptlcd BOOLEAN NOT NULL,
hospaudfinstmtcd BOOLEAN NOT NULL,
rptgrntstogovtcd BOOLEAN NOT NULL,
rptgrntstoindvcd BOOLEAN NOT NULL,
rptyestocompnstncd BOOLEAN NOT NULL,
txexmptbndcd BOOLEAN NOT NULL,
invstproceedscd BOOLEAN NOT NULL,
maintescrwaccntcd BOOLEAN NOT NULL,
actonbehalfcd BOOLEAN NOT NULL,
engageexcessbnftcd BOOLEAN NOT NULL,
awarexcessbnftcd BOOLEAN NOT NULL,
loantofficercd BOOLEAN NOT NULL,
grantoofficercd BOOLEAN NOT NULL,
dirbusnreltdcd BOOLEAN NOT NULL,
fmlybusnreltdcd BOOLEAN NOT NULL,
servasofficercd BOOLEAN NOT NULL,
recvnoncashcd BOOLEAN NOT NULL,
recvartcd BOOLEAN NOT NULL,
ceaseoperationscd BOOLEAN NOT NULL,
sellorexchcd BOOLEAN NOT NULL,
ownsepentcd BOOLEAN NOT NULL,
reltdorgcd BOOLEAN NOT NULL,
intincntrlcd BOOLEAN NOT NULL,
orgtrnsfrcd BOOLEAN NOT NULL,
conduct5percentcd BOOLEAN NOT NULL,
compltschocd BOOLEAN NOT NULL,
f1096cnt INTEGER NOT NULL,
fw2gcnt INTEGER NOT NULL,
wthldngrulescd BOOLEAN NOT NULL,
noemplyeesw3cnt INTEGER NOT NULL,
filerqrdrtnscd BOOLEAN NOT NULL,
unrelbusinccd BOOLEAN NOT NULL,
filedf990tcd BOOLEAN NOT NULL,
frgnacctcd BOOLEAN NOT NULL,
prohibtdtxshltrcd BOOLEAN NOT NULL,
prtynotifyorgcd BOOLEAN NOT NULL,
filedf8886tcd BOOLEAN NOT NULL,
solicitcntrbcd BOOLEAN NOT NULL,
exprstmntcd BOOLEAN NOT NULL,
providegoodscd BOOLEAN NOT NULL,
notfydnrvalcd BOOLEAN NOT NULL,
filedf8282cd BOOLEAN NOT NULL,
f8282cnt INTEGER NOT NULL,
fndsrcvdcd BOOLEAN NOT NULL,
premiumspaidcd BOOLEAN NOT NULL,
filedf8899cd BOOLEAN NOT NULL,
filedf1098ccd BOOLEAN NOT NULL,
excbushldngscd BOOLEAN NOT NULL,
s4966distribcd BOOLEAN NOT NULL,
distribtodonorcd BOOLEAN NOT NULL,
initiationfees INTEGER NOT NULL,
grsrcptspublicuse INTEGER NOT NULL,
grsincmembers INTEGER NOT NULL,
grsincother INTEGER NOT NULL,
filedlieuf1041cd BOOLEAN NOT NULL,
txexmptint INTEGER NOT NULL,
qualhlthplncd BOOLEAN NOT NULL,
qualhlthreqmntn INTEGER NOT NULL,
qualhlthonhnd INTEGER NOT NULL,
rcvdpdtngcd BOOLEAN NOT NULL,
filedf720cd BOOLEAN NOT NULL,
totreprtabled INTEGER NOT NULL,
totcomprelatede INTEGER NOT NULL,
totestcompf INTEGER NOT NULL,
noindiv100kcnt INTEGER NOT NULL,
nocontractor100kcnt INTEGER NOT NULL,
totcntrbgfts BIGINT NOT NULL,
prgmservcode2acd INTEGER NOT NULL,
totrev2acola BIGINT NOT NULL,
prgmservcode2bcd INTEGER NOT NULL,
totrev2bcola BIGINT NOT NULL,
prgmservcode2ccd INTEGER NOT NULL,
totrev2ccola BIGINT NOT NULL,
prgmservcode2dcd INTEGER NOT NULL,
totrev2dcola INTEGER NOT NULL,
prgmservcode2ecd INTEGER NOT NULL,
totrev2ecola BIGINT NOT NULL,
totrev2fcola INTEGER NOT NULL,
totprgmrevnue BIGINT NOT NULL,
invstmntinc INTEGER NOT NULL,
txexmptbndsproceeds INTEGER NOT NULL,
royaltsinc INTEGER NOT NULL,
grsrntsreal INTEGER NOT NULL,
grsrntsprsnl INTEGER NOT NULL,
rntlexpnsreal INTEGER NOT NULL,
rntlexpnsprsnl INTEGER NOT NULL,
rntlincreal INTEGER NOT NULL,
rntlincprsnl BIGINT NOT NULL,
netrntlinc INTEGER NOT NULL,
grsalesecur BIGINT NOT NULL,
grsalesothr BIGINT NOT NULL,
cstbasisecur BIGINT NOT NULL,
cstbasisothr BIGINT NOT NULL,
gnlsecur INTEGER NOT NULL,
gnlsothr INTEGER NOT NULL,
netgnls INTEGER NOT NULL,
grsincfndrsng INTEGER NOT NULL,
lessdirfndrsng INTEGER NOT NULL,
netincfndrsng INTEGER NOT NULL,
grsincgaming INTEGER NOT NULL,
lessdirgaming INTEGER NOT NULL,
netincgaming INTEGER NOT NULL,
grsalesinvent INTEGER NOT NULL,
lesscstofgoods INTEGER NOT NULL,
netincsales INTEGER NOT NULL,
miscrev11acd INTEGER NOT NULL,
miscrevtota INTEGER NOT NULL,
miscrev11bcd INTEGER NOT NULL,
miscrevtot11b BIGINT NOT NULL,
miscrev11ccd INTEGER NOT NULL,
miscrevtot11c INTEGER NOT NULL,
miscrevtot11d INTEGER NOT NULL,
miscrevtot11e INTEGER NOT NULL,
totrevenue BIGINT NOT NULL,
grntstogovt INTEGER NOT NULL,
grnsttoindiv INTEGER NOT NULL,
grntstofrgngovt INTEGER NOT NULL,
benifitsmembrs BIGINT NOT NULL,
compnsatncurrofcr INTEGER NOT NULL,
compnsatnandothr INTEGER NOT NULL,
othrsalwages BIGINT NOT NULL,
pensionplancontrb INTEGER NOT NULL,
othremplyeebenef INTEGER NOT NULL,
payrolltx INTEGER NOT NULL,
feesforsrvcmgmt INTEGER NOT NULL,
legalfees INTEGER NOT NULL,
accntingfees INTEGER NOT NULL,
feesforsrvclobby INTEGER NOT NULL,
profndraising INTEGER NOT NULL,
feesforsrvcinvstmgmt INTEGER NOT NULL,
feesforsrvcothr INTEGER NOT NULL,
advrtpromo INTEGER NOT NULL,
officexpns INTEGER NOT NULL,
infotech BIGINT NOT NULL,
royaltsexpns INTEGER NOT NULL,
occupancy INTEGER NOT NULL,
travel INTEGER NOT NULL,
travelofpublicoffcl INTEGER NOT NULL,
converconventmtng INTEGER NOT NULL,
interestamt INTEGER NOT NULL,
pymtoaffiliates INTEGER NOT NULL,
deprcatndepletn INTEGER NOT NULL,
insurance INTEGER NOT NULL,
othrexpnsa BIGINT NOT NULL,
othrexpnsb BIGINT NOT NULL,
othrexpnsc BIGINT NOT NULL,
othrexpnsd INTEGER NOT NULL,
othrexpnse INTEGER NOT NULL,
othrexpnsf INTEGER NOT NULL,
totfuncexpns BIGINT NOT NULL,
nonintcashend INTEGER NOT NULL,
svngstempinvend BIGINT NOT NULL,
pldgegrntrcvblend BIGINT NOT NULL,
accntsrcvblend BIGINT NOT NULL,
currfrmrcvblend INTEGER NOT NULL,
rcvbldisqualend INTEGER NOT NULL,
notesloansrcvblend BIGINT NOT NULL,
invntriesalesend INTEGER NOT NULL,
prepaidexpnsend INTEGER NOT NULL,
lndbldgsequipend BIGINT NOT NULL,
invstmntsend BIGINT NOT NULL,
invstmntsothrend BIGINT NOT NULL,
invstmntsprgmend BIGINT NOT NULL,
intangibleassetsend INTEGER NOT NULL,
othrassetsend BIGINT NOT NULL,
totassetsend BIGINT NOT NULL,
accntspayableend BIGINT NOT NULL,
grntspayableend INTEGER NOT NULL,
deferedrevnuend BIGINT NOT NULL,
txexmptbndsend BIGINT NOT NULL,
escrwaccntliabend INTEGER NOT NULL,
paybletoffcrsend INTEGER NOT NULL,
secrdmrtgsend BIGINT NOT NULL,
unsecurednotesend BIGINT NOT NULL,
othrliabend BIGINT NOT NULL,
totliabend BIGINT NOT NULL,
unrstrctnetasstsend BIGINT NOT NULL,
temprstrctnetasstsend BIGINT NOT NULL,
permrstrctnetasstsend BIGINT NOT NULL,
capitalstktrstend BIGINT NOT NULL,
paidinsurplusend BIGINT NOT NULL,
retainedearnend BIGINT NOT NULL,
totnetassetend BIGINT NOT NULL,
totnetliabastend BIGINT NOT NULL,
nonpfrea VARCHAR(2) NOT NULL,
totnooforgscnt INTEGER NOT NULL,
totsupport BIGINT NOT NULL,
gftgrntsrcvd170 BIGINT NOT NULL,
txrevnuelevied170 INTEGER NOT NULL,
srvcsval170 INTEGER NOT NULL,
pubsuppsubtot170 BIGINT NOT NULL,
exceeds2pct170 BIGINT NOT NULL,
pubsupplesspct170 BIGINT NOT NULL,
samepubsuppsubtot170 BIGINT NOT NULL,
grsinc170 INTEGER NOT NULL,
netincunreltd170 INTEGER NOT NULL,
othrinc170 INTEGER NOT NULL,
totsupp170 BIGINT NOT NULL,
grsrcptsrelated170 BIGINT NOT NULL,
totgftgrntrcvd509 BIGINT NOT NULL,
grsrcptsadmissn509 BIGINT NOT NULL,
grsrcptsactivities509 INTEGER NOT NULL,
txrevnuelevied509 INTEGER NOT NULL,
srvcsval509 INTEGER NOT NULL,
pubsuppsubtot509 BIGINT NOT NULL,
rcvdfrmdisqualsub509 INTEGER NOT NULL,
exceeds1pct509 BIGINT NOT NULL,
subtotpub509 BIGINT NOT NULL,
pubsupplesub509 BIGINT NOT NULL,
samepubsuppsubtot509 BIGINT NOT NULL,
grsinc509 INTEGER NOT NULL,
unreltxincls511tx509 INTEGER NOT NULL,
subtotsuppinc509 INTEGER NOT NULL,
netincunrelatd509 INTEGER NOT NULL,
othrinc509 INTEGER NOT NULL,
totsupp509 BIGINT NOT NULL
);
Raw
py14_990.sql
CREATE TABLE py14_990 (
"EIN" VARCHAR(9) NOT NULL,
tax_prd INTEGER NOT NULL,
subseccd VARCHAR(2) NOT NULL,
s501c3or4947a1cd BOOLEAN NOT NULL,
schdbind BOOLEAN NOT NULL,
politicalactvtscd BOOLEAN NOT NULL,
lbbyingactvtscd BOOLEAN NOT NULL,
subjto6033cd BOOLEAN NOT NULL,
dnradvisedfundscd BOOLEAN NOT NULL,
prptyintrcvdcd BOOLEAN NOT NULL,
maintwrkofartcd BOOLEAN NOT NULL,
crcounselingqstncd BOOLEAN NOT NULL,
hldassetsintermpermcd BOOLEAN NOT NULL,
rptlndbldgeqptcd BOOLEAN NOT NULL,
rptinvstothsecd BOOLEAN NOT NULL,
rptinvstprgrelcd BOOLEAN NOT NULL,
rptothasstcd BOOLEAN NOT NULL,
rptothliabcd BOOLEAN NOT NULL,
sepcnsldtfinstmtcd BOOLEAN NOT NULL,
sepindaudfinstmtcd BOOLEAN NOT NULL,
inclinfinstmtcd BOOLEAN NOT NULL,
operateschools170cd BOOLEAN NOT NULL,
frgnofficecd BOOLEAN NOT NULL,
frgnrevexpnscd BOOLEAN NOT NULL,
frgngrntscd BOOLEAN NOT NULL,
frgnaggragrntscd BOOLEAN NOT NULL,
rptprofndrsngfeescd BOOLEAN NOT NULL,
rptincfnndrsngcd BOOLEAN NOT NULL,
rptincgamingcd BOOLEAN NOT NULL,
operatehosptlcd BOOLEAN NOT NULL,
hospaudfinstmtcd BOOLEAN NOT NULL,
rptgrntstogovtcd BOOLEAN NOT NULL,
rptgrntstoindvcd BOOLEAN NOT NULL,
rptyestocompnstncd BOOLEAN NOT NULL,
txexmptbndcd BOOLEAN NOT NULL,
invstproceedscd BOOLEAN NOT NULL,
maintescrwaccntcd BOOLEAN NOT NULL,
actonbehalfcd BOOLEAN NOT NULL,
engageexcessbnftcd BOOLEAN NOT NULL,
awarexcessbnftcd BOOLEAN NOT NULL,
loantofficercd BOOLEAN NOT NULL,
grantoofficercd BOOLEAN NOT NULL,
dirbusnreltdcd BOOLEAN NOT NULL,
fmlybusnreltdcd BOOLEAN NOT NULL,
servasofficercd BOOLEAN NOT NULL,
recvnoncashcd BOOLEAN NOT NULL,
recvartcd BOOLEAN NOT NULL,
ceaseoperationscd BOOLEAN NOT NULL,
sellorexchcd BOOLEAN NOT NULL,
ownsepentcd BOOLEAN NOT NULL,
reltdorgcd BOOLEAN NOT NULL,
intincntrlcd BOOLEAN NOT NULL,
orgtrnsfrcd BOOLEAN NOT NULL,
conduct5percentcd BOOLEAN NOT NULL,
compltschocd BOOLEAN NOT NULL,
f1096cnt INTEGER NOT NULL,
fw2gcnt INTEGER NOT NULL,
wthldngrulescd BOOLEAN NOT NULL,
noemplyeesw3cnt INTEGER NOT NULL,
filerqrdrtnscd BOOLEAN NOT NULL,
unrelbusinccd BOOLEAN NOT NULL,
filedf990tcd BOOLEAN NOT NULL,
frgnacctcd BOOLEAN NOT NULL,
prohibtdtxshltrcd BOOLEAN NOT NULL,
prtynotifyorgcd BOOLEAN NOT NULL,
filedf8886tcd BOOLEAN NOT NULL,
solicitcntrbcd BOOLEAN NOT NULL,
exprstmntcd BOOLEAN NOT NULL,
providegoodscd BOOLEAN NOT NULL,
notfydnrvalcd BOOLEAN NOT NULL,
filedf8282cd BOOLEAN NOT NULL,
f8282cnt INTEGER NOT NULL,
fndsrcvdcd BOOLEAN NOT NULL,
premiumspaidcd BOOLEAN NOT NULL,
filedf8899cd BOOLEAN NOT NULL,
filedf1098ccd BOOLEAN NOT NULL,
excbushldngscd BOOLEAN NOT NULL,
s4966distribcd BOOLEAN NOT NULL,
distribtodonorcd BOOLEAN NOT NULL,
initiationfees INTEGER NOT NULL,
grsrcptspublicuse INTEGER NOT NULL,
grsincmembers BIGINT NOT NULL,
grsincother INTEGER NOT NULL,
filedlieuf1041cd BOOLEAN NOT NULL,
txexmptint INTEGER NOT NULL,
qualhlthplncd BOOLEAN NOT NULL,
qualhlthreqmntn INTEGER NOT NULL,
qualhlthonhnd INTEGER NOT NULL,
rcvdpdtngcd BOOLEAN NOT NULL,
filedf720cd BOOLEAN NOT NULL,
totreprtabled INTEGER NOT NULL,
totcomprelatede INTEGER NOT NULL,
totestcompf INTEGER NOT NULL,
noindiv100kcnt INTEGER NOT NULL,
nocontractor100kcnt INTEGER NOT NULL,
totcntrbgfts BIGINT NOT NULL,
prgmservcode2acd INTEGER NOT NULL,
totrev2acola BIGINT NOT NULL,
prgmservcode2bcd INTEGER NOT NULL,
totrev2bcola BIGINT NOT NULL,
prgmservcode2ccd INTEGER NOT NULL,
totrev2ccola BIGINT NOT NULL,
prgmservcode2dcd INTEGER NOT NULL,
totrev2dcola INTEGER NOT NULL,
prgmservcode2ecd INTEGER NOT NULL,
totrev2ecola INTEGER NOT NULL,
totrev2fcola INTEGER NOT NULL,
totprgmrevnue BIGINT NOT NULL,
invstmntinc INTEGER NOT NULL,
txexmptbndsproceeds INTEGER NOT NULL,
royaltsinc INTEGER NOT NULL,
grsrntsreal INTEGER NOT NULL,
grsrntsprsnl INTEGER NOT NULL,
rntlexpnsreal INTEGER NOT NULL,
rntlexpnsprsnl INTEGER NOT NULL,
rntlincreal INTEGER NOT NULL,
rntlincprsnl INTEGER NOT NULL,
netrntlinc INTEGER NOT NULL,
grsalesecur BIGINT NOT NULL,
grsalesothr BIGINT NOT NULL,
cstbasisecur BIGINT NOT NULL,
cstbasisothr BIGINT NOT NULL,
gnlsecur BIGINT NOT NULL,
gnlsothr INTEGER NOT NULL,
netgnls BIGINT NOT NULL,
grsincfndrsng INTEGER NOT NULL,
lessdirfndrsng INTEGER NOT NULL,
netincfndrsng INTEGER NOT NULL,
grsincgaming INTEGER NOT NULL,
lessdirgaming INTEGER NOT NULL,
netincgaming INTEGER NOT NULL,
grsalesinvent INTEGER NOT NULL,
lesscstofgoods INTEGER NOT NULL,
netincsales INTEGER NOT NULL,
miscrev11acd INTEGER NOT NULL,
miscrevtota INTEGER NOT NULL,
miscrev11bcd INTEGER NOT NULL,
miscrevtot11b INTEGER NOT NULL,
miscrev11ccd INTEGER NOT NULL,
miscrevtot11c INTEGER NOT NULL,
miscrevtot11d INTEGER NOT NULL,
miscrevtot11e INTEGER NOT NULL,
totrevenue BIGINT NOT NULL,
grntstogovt INTEGER NOT NULL,
grnsttoindiv INTEGER NOT NULL,
grntstofrgngovt BIGINT NOT NULL,
benifitsmembrs BIGINT NOT NULL,
compnsatncurrofcr INTEGER NOT NULL,
compnsatnandothr INTEGER NOT NULL,
othrsalwages BIGINT NOT NULL,
pensionplancontrb INTEGER NOT NULL,
othremplyeebenef INTEGER NOT NULL,
payrolltx INTEGER NOT NULL,
feesforsrvcmgmt INTEGER NOT NULL,
legalfees INTEGER NOT NULL,
accntingfees INTEGER NOT NULL,
feesforsrvclobby INTEGER NOT NULL,
profndraising INTEGER NOT NULL,
feesforsrvcinvstmgmt INTEGER NOT NULL,
feesforsrvcothr BIGINT NOT NULL,
advrtpromo INTEGER NOT NULL,
officexpns INTEGER NOT NULL,
infotech BIGINT NOT NULL,
royaltsexpns INTEGER NOT NULL,
occupancy INTEGER NOT NULL,
travel INTEGER NOT NULL,
travelofpublicoffcl INTEGER NOT NULL,
converconventmtng INTEGER NOT NULL,
interestamt INTEGER NOT NULL,
pymtoaffiliates INTEGER NOT NULL,
deprcatndepletn INTEGER NOT NULL,
insurance INTEGER NOT NULL,
othrexpnsa BIGINT NOT NULL,
othrexpnsb BIGINT NOT NULL,
othrexpnsc BIGINT NOT NULL,
othrexpnsd INTEGER NOT NULL,
othrexpnse INTEGER NOT NULL,
othrexpnsf INTEGER NOT NULL,
totfuncexpns BIGINT NOT NULL,
nonintcashend INTEGER NOT NULL,
svngstempinvend BIGINT NOT NULL,
pldgegrntrcvblend BIGINT NOT NULL,
accntsrcvblend BIGINT NOT NULL,
currfrmrcvblend INTEGER NOT NULL,
rcvbldisqualend INTEGER NOT NULL,
notesloansrcvblend BIGINT NOT NULL,
invntriesalesend INTEGER NOT NULL,
prepaidexpnsend INTEGER NOT NULL,
lndbldgsequipend BIGINT NOT NULL,
invstmntsend BIGINT NOT NULL,
invstmntsothrend BIGINT NOT NULL,
invstmntsprgmend BIGINT NOT NULL,
intangibleassetsend INTEGER NOT NULL,
othrassetsend BIGINT NOT NULL,
totassetsend BIGINT NOT NULL,
accntspayableend BIGINT NOT NULL,
grntspayableend BIGINT NOT NULL,
deferedrevnuend BIGINT NOT NULL,
txexmptbndsend BIGINT NOT NULL,
escrwaccntliabend INTEGER NOT NULL,
paybletoffcrsend INTEGER NOT NULL,
secrdmrtgsend BIGINT NOT NULL,
unsecurednotesend BIGINT NOT NULL,
othrliabend BIGINT NOT NULL,
totliabend BIGINT NOT NULL,
unrstrctnetasstsend BIGINT NOT NULL,
temprstrctnetasstsend BIGINT NOT NULL,
permrstrctnetasstsend BIGINT NOT NULL,
capitalstktrstend BIGINT NOT NULL,
paidinsurplusend BIGINT NOT NULL,
retainedearnend BIGINT NOT NULL,
totnetassetend BIGINT NOT NULL,
totnetliabastend BIGINT NOT NULL,
nonpfrea VARCHAR(2) NOT NULL,
totnooforgscnt INTEGER NOT NULL,
totsupport BIGINT NOT NULL,
gftgrntsrcvd170 BIGINT NOT NULL,
txrevnuelevied170 INTEGER NOT NULL,
srvcsval170 INTEGER NOT NULL,
pubsuppsubtot170 BIGINT NOT NULL,
exceeds2pct170 INTEGER NOT NULL,
pubsupplesspct170 BIGINT NOT NULL,
samepubsuppsubtot170 BIGINT NOT NULL,
grsinc170 INTEGER NOT NULL,
netincunreltd170 INTEGER NOT NULL,
othrinc170 INTEGER NOT NULL,
totsupp170 BIGINT NOT NULL,
grsrcptsrelated170 BIGINT NOT NULL,
totgftgrntrcvd509 BIGINT NOT NULL,
grsrcptsadmissn509 BIGINT NOT NULL,
grsrcptsactivities509 INTEGER NOT NULL,
txrevnuelevied509 INTEGER NOT NULL,
srvcsval509 INTEGER NOT NULL,
pubsuppsubtot509 BIGINT NOT NULL,
rcvdfrmdisqualsub509 INTEGER NOT NULL,
exceeds1pct509 BIGINT NOT NULL,
subtotpub509 BIGINT NOT NULL,
pubsupplesub509 BIGINT NOT NULL,
samepubsuppsubtot509 BIGINT NOT NULL,
grsinc509 INTEGER NOT NULL,
unreltxincls511tx509 INTEGER NOT NULL,
subtotsuppinc509 INTEGER NOT NULL,
netincunrelatd509 INTEGER NOT NULL,
othrinc509 INTEGER NOT NULL,
totsupp509 BIGINT
);
Raw
py15_990.sql
CREATE TABLE "15eofinextract990.dat" (
elf VARCHAR(1) NOT NULL,
"EIN" VARCHAR(9) NOT NULL,
tax_prd INTEGER NOT NULL,
subseccd VARCHAR(2) NOT NULL,
"s50Yc3or4947aYcd" BOOLEAN NOT NULL,
schdbind BOOLEAN NOT NULL,
politicalactvtscd BOOLEAN NOT NULL,
lbbyingactvtscd BOOLEAN NOT NULL,
subjto6033cd BOOLEAN NOT NULL,
dnradvisedfundscd BOOLEAN NOT NULL,
prptyintrcvdcd BOOLEAN NOT NULL,
maintwrkofartcd BOOLEAN NOT NULL,
crcounselingqstncd BOOLEAN NOT NULL,
hldassetsintermpermcd BOOLEAN NOT NULL,
rptlndbldgeqptcd BOOLEAN NOT NULL,
rptinvstothsecd BOOLEAN NOT NULL,
rptinvstprgrelcd BOOLEAN NOT NULL,
rptothasstcd BOOLEAN NOT NULL,
rptothliabcd BOOLEAN NOT NULL,
sepcnsldtfinstmtcd BOOLEAN NOT NULL,
sepindaudfinstmtcd BOOLEAN NOT NULL,
inclinfinstmtcd BOOLEAN NOT NULL,
"operateschoolsY70cd" BOOLEAN NOT NULL,
frgnofficecd BOOLEAN NOT NULL,
frgnrevexpnscd BOOLEAN NOT NULL,
frgngrntscd BOOLEAN NOT NULL,
frgnaggragrntscd BOOLEAN NOT NULL,
rptprofndrsngfeescd BOOLEAN NOT NULL,
rptincfnndrsngcd BOOLEAN NOT NULL,
rptincgamingcd BOOLEAN NOT NULL,
operatehosptlcd BOOLEAN NOT NULL,
hospaudfinstmtcd BOOLEAN NOT NULL,
rptgrntstogovtcd BOOLEAN NOT NULL,
rptgrntstoindvcd BOOLEAN NOT NULL,
rptyestocompnstncd BOOLEAN NOT NULL,
txexmptbndcd BOOLEAN NOT NULL,
invstproceedscd BOOLEAN NOT NULL,
maintescrwaccntcd BOOLEAN NOT NULL,
actonbehalfcd BOOLEAN NOT NULL,
engageexcessbnftcd BOOLEAN NOT NULL,
awarexcessbnftcd BOOLEAN NOT NULL,
loantofficercd BOOLEAN NOT NULL,
grantoofficercd BOOLEAN NOT NULL,
dirbusnreltdcd BOOLEAN NOT NULL,
fmlybusnreltdcd BOOLEAN NOT NULL,
servasofficercd BOOLEAN NOT NULL,
recvnoncashcd BOOLEAN NOT NULL,
recvartcd BOOLEAN NOT NULL,
ceaseoperationscd BOOLEAN NOT NULL,
sellorexchcd BOOLEAN NOT NULL,
ownsepentcd BOOLEAN NOT NULL,
reltdorgcd BOOLEAN NOT NULL,
intincntrlcd BOOLEAN NOT NULL,
orgtrnsfrcd BOOLEAN NOT NULL,
conduct5percentcd BOOLEAN NOT NULL,
compltschocd BOOLEAN NOT NULL,
f1096cnt INTEGER NOT NULL,
fw2gcnt INTEGER NOT NULL,
wthldngrulescd BOOLEAN NOT NULL,
noemplyeesw3cnt INTEGER NOT NULL,
filerqrdrtnscd BOOLEAN NOT NULL,
unrelbusinccd BOOLEAN NOT NULL,
filedf990tcd BOOLEAN NOT NULL,
frgnacctcd BOOLEAN NOT NULL,
prohibtdtxshltrcd BOOLEAN NOT NULL,
prtynotifyorgcd BOOLEAN NOT NULL,
filedf8886tcd BOOLEAN NOT NULL,
solicitcntrbcd BOOLEAN NOT NULL,
exprstmntcd BOOLEAN NOT NULL,
providegoodscd BOOLEAN NOT NULL,
notfydnrvalcd BOOLEAN NOT NULL,
"filedf8N8Ncd" BOOLEAN NOT NULL,
f8282cnt INTEGER NOT NULL,
fndsrcvdcd BOOLEAN NOT NULL,
premiumspaidcd BOOLEAN NOT NULL,
filedf8899cd BOOLEAN NOT NULL,
"filedfY098ccd" BOOLEAN NOT NULL,
excbushldngscd BOOLEAN NOT NULL,
s4966distribcd BOOLEAN NOT NULL,
distribtodonorcd BOOLEAN NOT NULL,
initiationfees INTEGER NOT NULL,
grsrcptspublicuse INTEGER NOT NULL,
grsincmembers INTEGER NOT NULL,
grsincother INTEGER NOT NULL,
"filedlieufY04Ycd" BOOLEAN NOT NULL,
txexmptint INTEGER NOT NULL,
qualhlthplncd BOOLEAN NOT NULL,
qualhlthreqmntn INTEGER NOT NULL,
qualhlthonhnd INTEGER NOT NULL,
rcvdpdtngcd BOOLEAN NOT NULL,
"filedf7N0cd" BOOLEAN NOT NULL,
totreprtabled INTEGER NOT NULL,
totcomprelatede INTEGER NOT NULL,
totestcompf INTEGER NOT NULL,
noindiv100kcnt INTEGER NOT NULL,
nocontractor100kcnt INTEGER NOT NULL,
totcntrbgfts BIGINT NOT NULL,
prgmservcode2acd INTEGER NOT NULL,
totrev2acola BIGINT NOT NULL,
prgmservcode2bcd INTEGER NOT NULL,
totrev2bcola BIGINT NOT NULL,
prgmservcode2ccd INTEGER NOT NULL,
totrev2ccola BIGINT NOT NULL,
prgmservcode2dcd INTEGER NOT NULL,
totrev2dcola INTEGER NOT NULL,
prgmservcode2ecd INTEGER NOT NULL,
totrev2ecola INTEGER NOT NULL,
totrev2fcola BIGINT NOT NULL,
totprgmrevnue BIGINT NOT NULL,
invstmntinc INTEGER NOT NULL,
txexmptbndsproceeds INTEGER NOT NULL,
royaltsinc INTEGER NOT NULL,
grsrntsreal INTEGER NOT NULL,
grsrntsprsnl INTEGER NOT NULL,
rntlexpnsreal INTEGER NOT NULL,
rntlexpnsprsnl INTEGER NOT NULL,
rntlincreal INTEGER NOT NULL,
rntlincprsnl INTEGER NOT NULL,
netrntlinc INTEGER NOT NULL,
grsalesecur BIGINT NOT NULL,
grsalesothr BIGINT NOT NULL,
cstbasisecur BIGINT NOT NULL,
cstbasisothr BIGINT NOT NULL,
gnlsecur BIGINT NOT NULL,
gnlsothr INTEGER NOT NULL,
netgnls BIGINT NOT NULL,
grsincfndrsng INTEGER NOT NULL,
lessdirfndrsng INTEGER NOT NULL,
netincfndrsng INTEGER NOT NULL,
grsincgaming INTEGER NOT NULL,
lessdirgaming INTEGER NOT NULL,
netincgaming INTEGER NOT NULL,
grsalesinvent INTEGER NOT NULL,
lesscstofgoods INTEGER NOT NULL,
netincsales INTEGER NOT NULL,
miscrev11acd INTEGER NOT NULL,
miscrevtota INTEGER NOT NULL,
miscrev11bcd INTEGER NOT NULL,
miscrevtot11b INTEGER NOT NULL,
miscrev11ccd INTEGER NOT NULL,
miscrevtot11c INTEGER NOT NULL,
miscrevtot11d INTEGER NOT NULL,
miscrevtot11e INTEGER NOT NULL,
totrevenue BIGINT NOT NULL,
grntstogovt BIGINT NOT NULL,
grnsttoindiv INTEGER NOT NULL,
grntstofrgngovt BIGINT NOT NULL,
benifitsmembrs BIGINT NOT NULL,
compnsatncurrofcr INTEGER NOT NULL,
compnsatnandothr INTEGER NOT NULL,
othrsalwages BIGINT NOT NULL,
pensionplancontrb INTEGER NOT NULL,
othremplyeebenef BIGINT NOT NULL,
payrolltx INTEGER NOT NULL,
feesforsrvcmgmt INTEGER NOT NULL,
legalfees INTEGER NOT NULL,
accntingfees INTEGER NOT NULL,
feesforsrvclobby INTEGER NOT NULL,
profndraising INTEGER NOT NULL,
feesforsrvcinvstmgmt INTEGER NOT NULL,
feesforsrvcothr BIGINT NOT NULL,
advrtpromo INTEGER NOT NULL,
officexpns INTEGER NOT NULL,
infotech BIGINT NOT NULL,
royaltsexpns INTEGER NOT NULL,
occupancy INTEGER NOT NULL,
travel INTEGER NOT NULL,
travelofpublicoffcl INTEGER NOT NULL,
converconventmtng INTEGER NOT NULL,
interestamt INTEGER NOT NULL,
pymtoaffiliates INTEGER NOT NULL,
deprcatndepletn INTEGER NOT NULL,
insurance INTEGER NOT NULL,
othrexpnsa BIGINT NOT NULL,
othrexpnsb BIGINT NOT NULL,
othrexpnsc BIGINT NOT NULL,
othrexpnsd INTEGER NOT NULL,
othrexpnse INTEGER NOT NULL,
othrexpnsf INTEGER NOT NULL,
totfuncexpns BIGINT NOT NULL,
nonintcashend INTEGER NOT NULL,
svngstempinvend BIGINT NOT NULL,
pldgegrntrcvblend BIGINT NOT NULL,
accntsrcvblend BIGINT NOT NULL,
currfrmrcvblend INTEGER NOT NULL,
rcvbldisqualend INTEGER NOT NULL,
notesloansrcvblend BIGINT NOT NULL,
invntriesalesend INTEGER NOT NULL,
prepaidexpnsend INTEGER NOT NULL,
lndbldgsequipend BIGINT NOT NULL,
invstmntsend BIGINT NOT NULL,
invstmntsothrend BIGINT NOT NULL,
invstmntsprgmend BIGINT NOT NULL,
intangibleassetsend INTEGER NOT NULL,
othrassetsend BIGINT NOT NULL,
totassetsend BIGINT NOT NULL,
accntspayableend BIGINT NOT NULL,
grntspayableend INTEGER NOT NULL,
deferedrevnuend BIGINT NOT NULL,
txexmptbndsend BIGINT NOT NULL,
escrwaccntliabend INTEGER NOT NULL,
paybletoffcrsend INTEGER NOT NULL,
secrdmrtgsend BIGINT NOT NULL,
unsecurednotesend BIGINT NOT NULL,
othrliabend BIGINT NOT NULL,
totliabend BIGINT NOT NULL,
unrstrctnetasstsend BIGINT NOT NULL,
temprstrctnetasstsend BIGINT NOT NULL,
permrstrctnetasstsend BIGINT NOT NULL,
capitalstktrstend BIGINT NOT NULL,
paidinsurplusend BIGINT NOT NULL,
retainedearnend BIGINT NOT NULL,
totnetassetend BIGINT NOT NULL,
totnetliabastend BIGINT NOT NULL,
nonpfrea VARCHAR(2) NOT NULL,
totnooforgscnt INTEGER NOT NULL,
totsupport BIGINT NOT NULL,
gftgrntsrcvd170 BIGINT NOT NULL,
txrevnuelevied170 INTEGER NOT NULL,
srvcsval170 INTEGER NOT NULL,
pubsuppsubtot170 BIGINT NOT NULL,
exceeds2pct170 BIGINT NOT NULL,
pubsupplesspct170 BIGINT NOT NULL,
samepubsuppsubtot170 BIGINT NOT NULL,
grsinc170 BIGINT NOT NULL,
netincunreltd170 INTEGER NOT NULL,
othrinc170 INTEGER NOT NULL,
totsupp170 BIGINT NOT NULL,
grsrcptsrelated170 BIGINT NOT NULL,
totgftgrntrcvd509 BIGINT NOT NULL,
grsrcptsadmissn509 BIGINT NOT NULL,
grsrcptsactivities509 INTEGER NOT NULL,
txrevnuelevied509 INTEGER NOT NULL,
srvcsval509 INTEGER NOT NULL,
pubsuppsubtot509 BIGINT NOT NULL,
rcvdfrmdisqualsub509 INTEGER NOT NULL,
exceeds1pct509 BIGINT NOT NULL,
subtotpub509 BIGINT NOT NULL,
pubsupplesub509 BIGINT NOT NULL,
samepubsuppsubtot509 BIGINT NOT NULL,
grsinc509 INTEGER NOT NULL,
unreltxincls511tx509 INTEGER NOT NULL,
subtotsuppinc509 INTEGER NOT NULL,
netincunrelatd509 INTEGER NOT NULL,
othrinc509 INTEGER NOT NULL,
totsupp509 BIGINT NOT NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment