
Dataset Name: gsq_measure_midsmallcap
Group: esg
Vendor: G&S Quotient
Data Starts at: 2014-01-01
Symbol Set: US Mid Cap Equities
Asset Class: Equity
Data Update Time(s): 8:30 AM EST
Data Update Frequency: day
NEW YORK MERCANTILE EXCHANGE
Data Contained in this Dataset
Column | Type | Description |
---|---|---|
_seq | uint | Internal sequence number used to keep data rows in order |
timestamp | string | Timestamp of the Data - America/New York Time. |
muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. (underlying field is nc_publish_date_actual) |
symbol | string | Trading Symbol or Ticker |
Data_Date | string | Data_Date |
Delivery_Date | string | Delivery_Date |
FIGI | string | FIGI ID. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country. |
111 | double | 111 |
112 | string | 112 |
1131y | int | Number of auditor departures of in past 1 year |
1132y | int | Number of auditor departures of in past 2 year |
1133y | int | Number of auditor departures of in past 3 years |
1134y | int | Number of auditor departures of in past 4 years |
1135y | int | Number of auditor departures of in past 5 years |
114 | string | 114 |
1211y | int | Number of restatements in past 1 years |
1212y | int | Number of restatements in past 2 years |
1213y | int | Number of restatements in past 3 years |
1214y | int | Number of restatements in past 4 years |
1215y | int | Number of restatements in past 5 years |
1216m | int | Number of restatements in past 6 months |
1221y | int | 1221y |
1222y | int | 1222y |
1223y | int | Number of fiscal quarters where non-recurring items (charges or gains) exceed 5% of sales or 1.5% of net assets in past 12 quarters |
1224y | int | 1224y |
1225y | int | 1225y |
1226m | int | 1226m |
1231y | int | 1231y |
1232y | int | 1232y |
1233y | int | 1233y |
1234y | int | 1234y |
1235y | int | 1235y |
1236m | int | 1236m |
1241y | int | Number of delayed filings in past 1 years |
1242y | int | Number of delayed filings in past 2 years |
1243y | int | Number of delayed filings in past 3 years |
1244y | int | Number of delayed filings in past 4 years |
1245y | int | Number of delayed filings in past 5 years |
1246m | int | 1246m |
1247 | int | 1247 |
12471 | int | 12471 |
12471y | int | 12471y |
12472y | int | 12472y |
12473y | int | 12473y |
12474y | int | 12474y |
12475y | int | 12475y |
12476m | int | 12476m |
1251y | int | Number of times material control weakness identified in past 1 years |
1252y | int | Number of times material control weakness identified in past 2 years |
1253y | int | Number of times material control weakness identified in past 3 years |
1254y | int | Number of times material control weakness identified in past 4 years |
1255y | int | Number of times material control weakness identified in past 5 years |
126 | string | 126 |
1311y | int | Number of SEC (US Securities Exchange Commission) investigations initially disclosed in past 1 year |
1312y | int | Number of SEC (US Securities Exchange Commission) investigations initially disclosed in past 2 year |
1313y | int | Number of SEC (US Securities Exchange Commission) investigations initially disclosed in past 3 year |
1314y | int | Number of SEC (US Securities Exchange Commission) investigations initially disclosed in past 4 year |
1315y | int | Number of SEC (US Securities Exchange Commission) investigations initially disclosed in past 5 year |
1316m | int | 1316m |
132 | int | 132 |
1331y | int | Number of enforcement actions by the SEC (Wells Notice) in past 1 years |
1332y | int | Number of enforcement actions by the SEC (Wells Notice) in past 2 years |
1333y | int | Number of enforcement actions by the SEC (Wells Notice) in past 3 years |
1334y | int | Number of enforcement actions by the SEC (Wells Notice) in past 4 years |
1335y | int | Number of enforcement actions by the SEC (Wells Notice) in past 5 years |
1336m | int | 1336m |
1341y | int | Number of DoJ (US Department of Justice) or State AG (Attorney General) investigations in past 1 years |
1342y | int | Number of DoJ (US Department of Justice) or State AG (Attorney General) investigations in past 2 years |
1343y | int | Number of DoJ (US Department of Justice) or State AG (Attorney General) investigations in past 3 years |
1344y | int | Number of DoJ (US Department of Justice) or State AG (Attorney General) investigations in past 4 years |
1345y | int | Number of DoJ (US Department of Justice) or State AG (Attorney General) investigations in past 5 years |
1346m | int | Number of DoJ (US Department of Justice) or State AG (Attorney General) investigations in past 6 Months |
135 | int | 135 |
1361y | int | Number of Audit Committee investigations in past 1 years |
1362y | int | Number of Audit Committee investigations in past 2 years |
1363y | int | Number of Audit Committee investigations in past 3 years |
1364y | int | Number of Audit Committee investigations in past 4 years |
1365y | int | Number of Audit Committee investigations in past 5 years |
1366m | int | Number of Audit Committee investigations in past 6MO |
137 | int | Number of Audit Committee investigations currently remaining open |
1381y | int | Number of SEC staff reviews in past 1 year |
1382y | int | Number of SEC staff reviews in past 2 year |
1383y | int | Number of SEC staff reviews in past 3 year |
1384y | int | Number of SEC staff reviews in past 4 year |
1385y | int | Number of SEC staff reviews in past 5 year |
1386m | int | Number of SEC staff reviews in past 6 MO |
1391y | int | 1391y |
1392y | int | 1392y |
1393y | int | 1393y |
1394y | int | 1394y |
1395y | int | 1395y |
1310 | int | 1310 |
1311 | int | 1311 |
13121y | int | 13121y |
13122y | int | 13122y |
13123y | int | 13123y |
13124y | int | 13124y |
13125y | int | 13125y |
13126m | int | 13126m |
13131y | int | 13131y |
13132y | int | 13132y |
13133y | int | 13133y |
13134y | int | 13134y |
13135y | int | 13135y |
13136m | int | 13136m |
13141y | int | 13141y |
13142y | int | 13142y |
13143y | int | 13143y |
13144y | int | 13144y |
13145y | int | 13145y |
13146m | int | 13146m |
13151y | int | 13151y |
13152y | int | 13152y |
13153y | int | 13153y |
13154y | int | 13154y |
13155y | int | 13155y |
13156m | int | 13156m |
13161y | int | 13161y |
13162y | int | 13162y |
13163y | int | 13163y |
13164y | int | 13164y |
13165y | int | 13165y |
13166m | int | 13166m |
13171y | int | 13171y |
13172y | int | 13172y |
13173y | int | 13173y |
13174y | int | 13174y |
13175y | int | 13175y |
13176m | int | 13176m |
211 | string | 211 |
212 | string | 212 |
213 | string | 213 |
214 | string | 214 |
221 | string | 221 |
2221 | string | 2221 |
2222 | string | 2222 |
2223 | string | 2223 |
2224 | string | 2224 |
2225 | string | 2225 |
223 | string | 223 |
231 | string | 231 |
232 | string | 232 |
2411y | int | 2411y |
2412y | int | 2412y |
2413y | int | 2413y |
2414y | int | 2414y |
2415y | int | 2415y |
2416m | int | 2416m |
2421y | int | 2421y |
2422y | int | 2422y |
2423y | int | 2423y |
2424y | int | 2424y |
2425y | int | 2425y |
2426m | int | 2426m |
311 | string | 311 |
312 | string | 312 |
321 | string | 321 |
322 | string | 322 |
323 | string | 323 |
331 | string | 331 |
332 | string | 332 |
333 | string | 333 |
341 | string | 341 |
342 | string | 342 |
3441y | int | 3441y |
3442y | int | 3442y |
3443y | int | 3443y |
3444y | int | 3444y |
3445y | int | 3445y |
3511y | int | 3511y |
3512y | int | 3512y |
3513y | int | 3513y |
3514y | int | 3514y |
3515y | int | 3515y |
3516m | int | 3516m |
3521y | int | 3521y |
3522y | int | 3522y |
3523y | int | 3523y |
3524y | int | 3524y |
3525y | int | 3525y |
3526m | int | 3526m |
3531y | int | 3531y |
3532y | int | 3532y |
3533y | int | 3533y |
3534y | int | 3534y |
3535y | int | 3535y |
3536m | int | 3536m |
3541y | int | 3541y |
3542y | int | 3542y |
3543y | int | 3543y |
3544y | int | 3544y |
3545y | int | 3545y |
3546m | int | 3546m |
3551y | int | 3551y |
3552y | int | 3552y |
3553y | int | 3553y |
3554y | int | 3554y |
3555y | int | 3555y |
3556m | int | 3556m |
3561y | int | 3561y |
3562y | int | 3562y |
3563y | int | 3563y |
3564y | int | 3564y |
3565y | int | 3565y |
3566m | int | 3566m |
3571y | int | 3571y |
3572y | int | 3572y |
3573y | int | 3573y |
3574y | int | 3574y |
3575y | int | 3575y |
3576m | int | 3576m |
3581y | int | 3581y |
3582y | int | 3582y |
3583y | int | 3583y |
3584y | int | 3584y |
3585y | int | 3585y |
3586m | int | 3586m |
41y1 | string | 41y1 |
41y2 | string | 41y2 |
41y3 | string | 41y3 |
41y4 | string | 41y4 |
42y1 | string | 42y1 |
42y2 | string | 42y2 |
42y3 | string | 42y3 |
42y4 | string | 42y4 |
43y1 | string | 43y1 |
43y2 | string | 43y2 |
43y3 | string | 43y3 |
43y4 | string | 43y4 |
44y1 | string | 44y1 |
44y2 | string | 44y2 |
44y3 | string | 44y3 |
44y4 | string | 44y4 |
45y1 | string | 45y1 |
45y2 | string | 45y2 |
45y3 | string | 45y3 |
45y4 | string | 45y4 |
421 | string | 421 |
422 | string | 422 |
4311y | int | 4311y |
4312y | int | 4312y |
4313y | int | 4313y |
4314y | int | 4314y |
4315y | int | 4315y |
4316m | int | 4316m |
4321y | int | 4321y |
4322y | int | 4322y |
4323y | int | 4323y |
4324y | int | 4324y |
4325y | int | 4325y |
4326m | int | 4326m |
4331y | int | 4331y |
4332y | int | 4332y |
4333y | int | 4333y |
4334y | int | 4334y |
4335y | int | 4335y |
4336m | int | 4336m |
4341y | int | 4341y |
4342y | int | 4342y |
4343y | int | 4343y |
4344y | int | 4344y |
4345y | int | 4345y |
4346m | int | 4346m |
4351y | int | 4351y |
4352y | int | 4352y |
4353y | int | 4353y |
4354y | int | 4354y |
4355y | int | 4355y |
4356m | int | 4356m |
4361y | int | 4361y |
4362y | int | 4362y |
4363y | int | 4363y |
4364y | int | 4364y |
4365y | int | 4365y |
4366m | int | 4366m |
5111y | int | 5111y |
5112y | int | 5112y |
5113y | int | 5113y |
5114y | int | 5114y |
5115y | int | 5115y |
5116m | int | 5116m |
512 | int | 512 |
5211y | int | 5211y |
5212y | int | 5212y |
5213y | int | 5213y |
5214y | int | 5214y |
5215y | int | 5215y |
5216m | int | 5216m |
522 | int | 522 |
523 | double | 523 |
524 | double | 524 |
531 | string | 531 |
532 | string | 532 |
MrktCap_Universe | string | MrktCap_Universe |