Created
June 9, 2022 11:13
-
-
Save aryangoti/a3797424ce0cb4fd87e194c05ad099b6 to your computer and use it in GitHub Desktop.
Details
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Enter value for tname: DATE_CODE | |
| OWNER TABLE_NAME PARTITION_NAME NUM_ROWS STATT STA | |
| ------------------------------ --------------------------- ------------------------------ ---------- ----- --- | |
| REPORT_ENGINE DATE_CODE 76930 NO | |
| 1 row selected. | |
| SQL> / | |
| Enter value for tname: LIT_FACT_BD | |
| OWNER TABLE_NAME PARTITION_NAME NUM_ROWS STATT STA | |
| ------------------------------ --------------------------- ------------------------------ ---------- ----- --- | |
| REPORT_ENGINE LIT_FACT_BD 855743052 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2012 36907892 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2013 38300272 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2014 38163672 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2015 36603492 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2016 35696992 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2017 36472376 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2018 38572480 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2019 37846808 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2020 35960132 NO | |
| REPORT_ENGINE LIT_FACT_BD LIT_FACT_2021 30239996 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1990 31196600 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1991 6506756 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1992 7226584 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1993 7266112 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1994 7733508 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1995 7784312 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1996 8754384 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1997 9172736 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1998 9849272 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_1999 10652388 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2000 24482216 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2001 27418324 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2002 27684956 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2003 27494460 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2004 28585804 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2005 28076644 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2006 31578940 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2007 31076116 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2008 38627520 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2009 36290532 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2010 37350724 NO | |
| REPORT_ENGINE LIT_FACT_BD REP_DATA_2011 36159264 NO | |
| REPORT_ENGINE LIT_FACT_BD SYS_P33220 61436 NO | |
| REPORT_ENGINE LIT_FACT_BD SYS_P33527 9971760 NO | |
| 35 rows selected. | |
| SQL> / | |
| Enter value for tname: OPPOSING_COUNSEL | |
| OWNER TABLE_NAME PARTITION_NAME NUM_ROWS STATT STA | |
| ------------------------------ --------------------------- ------------------------------ ---------- ----- --- | |
| REPORT_ENGINE OPPOSING_COUNSEL 20 NO | |
| 1 row selected. | |
| SQL> / | |
| Enter value for tname: FIRM | |
| OWNER TABLE_NAME PARTITION_NAME NUM_ROWS STATT STA | |
| ------------------------------ --------------------------- ------------------------------ ---------- ----- --- | |
| REPORT_ENGINE FIRM 606920 NO | |
| 1 row selected. | |
| SQL> | |
| SQL> | |
| SQL> | |
| SQL> select count(1) from "REPORT_ENGINE"."LIT_FACT_BD" "OPCLF" where "OPCLF"."YEAR_NUMBER" = 2019; | |
| COUNT(1) | |
| ---------- | |
| 37850906 | |
| 1 row selected. | |
| SQL> | |
| SQL> | |
| SQL> | |
| SQL> | |
| SQL> | |
| SQL> | |
| SQL> select count(1) from "REPORT_ENGINE"."LIT_FACT_BD" "OPCLF" where "OPCLF"."YEAR_NUMBER" = 2018; | |
| COUNT(1) | |
| ---------- | |
| 38576951 | |
| 1 row selected. | |
| OWNER TABLE_NAME COLUMN_NAME NUM_DISTINCT NUM_BUCKETS HISTOGRAM | |
| ------------------------------ --------------------------- --------------------------- ------------ ----------- --------------- | |
| REPORT_ENGINE DATE_CODE DATE_ID 76930 1 NONE | |
| REPORT_ENGINE DATE_CODE DATE_SORT_VALUE 76930 1 NONE | |
| REPORT_ENGINE DATE_CODE DATE_VALUE 73340 1 NONE | |
| REPORT_ENGINE DATE_CODE YEAR_NUMBER 201 1 NONE | |
| REPORT_ENGINE DATE_CODE CALENDAR_QUARTER 5 1 NONE | |
| REPORT_ENGINE DATE_CODE MONTH_NUMBER 13 1 NONE | |
| REPORT_ENGINE DATE_CODE MONTH_NAME 12 1 NONE | |
| REPORT_ENGINE DATE_CODE DAY_OF_MONTH 32 1 NONE | |
| REPORT_ENGINE FIRM OA_ID 2001 1 NONE | |
| REPORT_ENGINE FIRM FIRM_ID 603650 254 HEIGHT BALANCED | |
| REPORT_ENGINE FIRM LONG_DISPLAY_NAME 431530 1 NONE | |
| REPORT_ENGINE FIRM ADDRESS 407480 1 NONE | |
| REPORT_ENGINE FIRM PARENT_FIRM_ID 434597 1 NONE | |
| REPORT_ENGINE FIRM WLD_ID 603630 1 NONE | |
| REPORT_ENGINE FIRM PROFILE_ID 3 1 NONE | |
| REPORT_ENGINE FIRM SEARCH_NAME 327890 1 NONE | |
| REPORT_ENGINE FIRM TOTAL_FIRM_ATTORNEYS 388 254 HEIGHT BALANCED | |
| REPORT_ENGINE FIRM LEGAL_EVENT_COUNT 0 0 NONE | |
| REPORT_ENGINE FIRM PROFILE_TYPE 2 1 NONE | |
| REPORT_ENGINE FIRM ACTIVE_FLAG 2 1 NONE | |
| REPORT_ENGINE FIRM LEGAL_EVENT_TOTAL_COUNT 0 0 NONE | |
| REPORT_ENGINE FIRM LEGAL_EVENT_FIRST_YEAR 0 0 NONE | |
| REPORT_ENGINE FIRM LEGAL_EVENT_LAST_YEAR 0 0 NONE | |
| REPORT_ENGINE FIRM RPTOTALAMOUNT 627 1 NONE | |
| REPORT_ENGINE FIRM RPTOTALCOUNT 41 1 NONE | |
| REPORT_ENGINE FIRM MATOTALAMOUNT 554 1 NONE | |
| REPORT_ENGINE FIRM MATOTALCOUNT 30 1 NONE | |
| REPORT_ENGINE FIRM CITY 6957 1 NONE | |
| REPORT_ENGINE FIRM STATE_ID 55 55 FREQUENCY | |
| REPORT_ENGINE FIRM PATENT_COUNT 0 0 NONE | |
| REPORT_ENGINE FIRM TRADEMARK_COUNT 202 1 NONE | |
| REPORT_ENGINE FIRM HAS_CHILDREN 2 1 NONE | |
| REPORT_ENGINE FIRM IS_ULTIMATE_PARENT 2 1 NONE | |
| REPORT_ENGINE FIRM FIRM_SIZE_ID 9 1 NONE | |
| REPORT_ENGINE FIRM DISPLAY_ADDRESS 593260 1 NONE | |
| REPORT_ENGINE FIRM ZIP_CODE 64146 1 NONE | |
| REPORT_ENGINE FIRM COUNTRY_ID 111 1 NONE | |
| REPORT_ENGINE FIRM LOCATION_SEARCH 9034 1 NONE | |
| REPORT_ENGINE FIRM ULTIMATE_PARENT_FIRM_ID 435156 1 NONE | |
| REPORT_ENGINE FIRM URL 57882 1 NONE | |
| REPORT_ENGINE FIRM FIVE_YEAR_EVENT_FLAG 2 1 NONE | |
| REPORT_ENGINE FIRM CONTACT_NETWORK_ID 23658 1 NONE | |
| REPORT_ENGINE FIRM PHONE 387080 1 NONE | |
| REPORT_ENGINE FIRM FAX 218895 1 NONE | |
| REPORT_ENGINE FIRM LOCATION_ID 12800 254 HEIGHT BALANCED | |
| REPORT_ENGINE FIRM PERFDB_ID 603640 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD REPRESENTATION_ID 855743052 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD DOCUMENT_ID 125586855 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD DOC_TYPE_ID 1 1 FREQUENCY | |
| REPORT_ENGINE LIT_FACT_BD PUBLICATION_DATE_ID 22642 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD YEAR_NUMBER 73 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD COURT_ID 1260 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD JUDGE_ID 22078 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD LEGAL_TOPIC_ID 368 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD POSSIBLE_COMPANY_ID 64462610 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD OA_COMPANY_ID 2566694 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD COMPANY_ID 827179 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD INDUSTRY_ID 233 233 FREQUENCY | |
| REPORT_ENGINE LIT_FACT_BD FIRM_ID 209851 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD ATTORNEY_ID 872428 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD CLIENT_ROLE_ID 49 49 FREQUENCY | |
| REPORT_ENGINE LIT_FACT_BD COMPANY_CONFIDENCE_LEVEL 1 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD COMPANY_LOCATION_ID 29522 254 HEIGHT BALANCED | |
| REPORT_ENGINE LIT_FACT_BD OUTCOME_TYPE 26 26 FREQUENCY | |
| REPORT_ENGINE LIT_FACT_BD OUTCOME_DATE 10681 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD TIME_TO_OUTCOME 6079 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD OUTCOME_YEAR 50 50 FREQUENCY | |
| REPORT_ENGINE LIT_FACT_BD EXTERNAL_AUDIT_ID 1 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD CHANGE_CODE 2 1 NONE | |
| REPORT_ENGINE LIT_FACT_BD SYS_NC00024$ 84 1 NONE | |
| REPORT_ENGINE OPPOSING_COUNSEL OPPOSING_COUNSEL_ID 20 1 NONE | |
| REPORT_ENGINE OPPOSING_COUNSEL LEGAL_ROLE_ID 19 19 FREQUENCY | |
| REPORT_ENGINE OPPOSING_COUNSEL OPPOSING_COUNSEL_ROLE_ID 19 19 FREQUENCY |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment