Data migration project 1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "\n",
    "os.environ['AWS_ACCESS_KEY_ID'] = '*************'\n",
    "os.environ['AWS_SECRET_ACCESS_KEY'] = '*******************'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "successfully aws session created\n"
     ]
    }
   ],
   "source": [
    "import boto3\n",
    "\n",
    "session = boto3.Session(region_name = 'us-east-2',aws_access_key_id = os.environ.get('AWS_ACCESS_KEY_ID'),\n",
    "                    aws_secret_access_key = os.environ.get('AWS_SECRET_ACCESS_KEY'))\n",
    "print('successfully aws session created')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "import logging\n",
    "import boto3\n",
    "from botocore.exceptions import ClientError\n",
    "\n",
    "\n",
    "def create_bucket(bucket_name, region=\"us-east-2\"):\n",
    "    \"\"\"Create an S3 bucket in a specified region\n",
    "\n",
    "    If a region is not specified, the bucket is created in the S3 default\n",
    "    region (us-east-1).\n",
    "\n",
    "    :param bucket_name: Bucket to create\n",
    "    :param region: String region to create bucket in, e.g., 'us-west-2'\n",
    "    :return: True if bucket created, else False\n",
    "    \"\"\"\n",
    "\n",
    "    # Create bucket\n",
    "    try:\n",
    "        if region is None:\n",
    "            s3_client = boto3.client('s3')\n",
    "            s3_client.create_bucket(Bucket=bucket_name)\n",
    "        else:\n",
    "            s3_client = boto3.client('s3', region_name=region)\n",
    "            location = {'LocationConstraint': region}\n",
    "            s3_client.create_bucket(Bucket=bucket_name,\n",
    "                                    CreateBucketConfiguration=location)\n",
    "    except ClientError as e:\n",
    "        logging.error(e)\n",
    "        return False\n",
    "    return True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "create_bucket(\"aws-json-from-website\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Existing buckets:\n",
      "  aws-json-from-website\n"
     ]
    }
   ],
   "source": [
    "import boto3\n",
    "s3 = boto3.client('s3')\n",
    "response = s3.list_buckets()\n",
    "\n",
    "# Output the bucket names\n",
    "print('Existing buckets:')\n",
    "for bucket in response['Buckets']:\n",
    "    print(f'  {bucket[\"Name\"]}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "got zipfile from url\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import zipfile\n",
    "\n",
    "url = \"https://www.sec.gov/Archives/edgar/daily-index/bulkdata/submissions.zip\"\n",
    "\n",
    "headers = {'user-agent': \"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0\"}\n",
    "\n",
    "r = requests.get(url,headers = headers, stream = True)\n",
    "\n",
    "content = r.content\n",
    "\n",
    "print(\"got zipfile from url\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('submissions.zip', 'wb') as f:\n",
    "    f.write(content)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import zipfile\n",
    "import os\n",
    "import boto3\n",
    "\n",
    "# Unzip the file in local\n",
    "with zipfile.ZipFile('C:/Users/ASUS/Desktop/jupyter notebook/submissions.zip', 'r') as zip_ref:\n",
    "    zip_ref.extractall('C:/Users/ASUS/Desktop/jupyter notebook/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'ResponseMetadata': {'RequestId': '00QAYBR6WFQZ7C0Y', 'HostId': 'qk7yXDrQJgCcQh3/JL0DmQW6zwke503M2QGtw/kd8Ie9M8lJcPa+5oyYFTf0ix/MB8Mr5A5+bSw=', 'HTTPStatusCode': 200, 'HTTPHeaders': {'x-amz-id-2': 'qk7yXDrQJgCcQh3/JL0DmQW6zwke503M2QGtw/kd8Ie9M8lJcPa+5oyYFTf0ix/MB8Mr5A5+bSw=', 'x-amz-request-id': '00QAYBR6WFQZ7C0Y', 'date': 'Tue, 28 Feb 2023 12:00:59 GMT', 'x-amz-server-side-encryption': 'AES256', 'etag': '\"d41d8cd98f00b204e9800998ecf8427e\"', 'server': 'AmazonS3', 'content-length': '0'}, 'RetryAttempts': 0}, 'ETag': '\"d41d8cd98f00b204e9800998ecf8427e\"', 'ServerSideEncryption': 'AES256'}\n"
     ]
    }
   ],
   "source": [
    "import boto3\n",
    "\n",
    "# Set up the S3 client\n",
    "s3 = boto3.client('s3')\n",
    "\n",
    "# Define the bucket and folder name\n",
    "bucket_name = 'aws-json-from-website'\n",
    "folder_name = 'jsonfile/'\n",
    "\n",
    "# Create the folder (prefix)\n",
    "response = s3.put_object(Bucket=bucket_name, Key=folder_name)\n",
    "\n",
    "# Print the response\n",
    "print(response)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "uploaded the jsonfiles to s3\n"
     ]
    }
   ],
   "source": [
    "bucket_name = 'aws-json-from-website'\n",
    "folder_name = 'jsonfile/'\n",
    "\n",
    "s3.put_object(Bucket=bucket_name, Key=(folder_name + '/'))\n",
    "\n",
    "for file in os.listdir('C:/Users/ASUS/Desktop/jupyter notebook/submissions'):\n",
    "    if file.endswith('.json'):\n",
    "        # Upload the file to the S3 bucket\n",
    "        s3.upload_file(Filename=os.path.join('C:/Users/ASUS/Desktop/jupyter notebook/submissions', file), Bucket=bucket_name, Key=(folder_name + file))\n",
    "print('uploaded the jsonfiles to s3')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "jsonfile/CIK0000000003.json\n",
      "jsonfile/CIK0000000013.json\n",
      "jsonfile/CIK0000000014.json\n",
      "jsonfile/CIK0000000017.json\n",
      "jsonfile/CIK0000000018.json\n",
      "jsonfile/CIK0000000020.json\n",
      "jsonfile/CIK0000000049.json\n",
      "jsonfile/CIK0000000051.json\n",
      "jsonfile/CIK0000000063.json\n",
      "jsonfile/CIK0000001750-submissions-001.json\n",
      "jsonfile/CIK0000001750.json\n",
      "jsonfile/CIK0000001761.json\n",
      "jsonfile/CIK0000001800-submissions-001.json\n",
      "jsonfile/CIK0000001800-submissions-002.json\n",
      "jsonfile/CIK0000001800.json\n",
      "jsonfile/CIK0000001830.json\n",
      "jsonfile/CIK0000001841.json\n",
      "jsonfile/CIK0000001848.json\n",
      "jsonfile/CIK0000001853.json\n",
      "jsonfile/CIK0000001860.json\n",
      "jsonfile/CIK0000001904.json\n",
      "jsonfile/CIK0000001918.json\n",
      "jsonfile/CIK0000001923.json\n",
      "jsonfile/CIK0000001947.json\n",
      "jsonfile/CIK0000001952.json\n",
      "jsonfile/CIK0000001958.json\n",
      "jsonfile/CIK0000001961.json\n",
      "jsonfile/CIK0000001969.json\n",
      "jsonfile/CIK0000001985.json\n",
      "jsonfile/CIK0000001988.json\n",
      "jsonfile/CIK0000002024.json\n",
      "jsonfile/CIK0000002034-submissions-001.json\n",
      "jsonfile/CIK0000002034.json\n",
      "jsonfile/CIK0000002036.json\n",
      "jsonfile/CIK0000002062.json\n",
      "jsonfile/CIK0000002066.json\n",
      "jsonfile/CIK0000002070.json\n",
      "jsonfile/CIK0000002071.json\n",
      "jsonfile/CIK0000002093.json\n",
      "jsonfile/CIK0000002098.json\n",
      "jsonfile/CIK0000002110.json\n",
      "jsonfile/CIK0000002135-submissions-001.json\n",
      "jsonfile/CIK0000002135.json\n",
      "jsonfile/CIK0000002145.json\n",
      "jsonfile/CIK0000002178.json\n",
      "jsonfile/CIK0000002186.json\n",
      "jsonfile/CIK0000002230.json\n",
      "jsonfile/CIK0000002303.json\n",
      "jsonfile/CIK0000002308.json\n",
      "jsonfile/CIK0000002310.json\n",
      "jsonfile/CIK0000002380.json\n",
      "jsonfile/CIK0000002381.json\n",
      "jsonfile/CIK0000002435.json\n",
      "jsonfile/CIK0000002457.json\n",
      "jsonfile/CIK0000002467.json\n",
      "jsonfile/CIK0000002473.json\n",
      "jsonfile/CIK0000002488-submissions-001.json\n",
      "jsonfile/CIK0000002488.json\n",
      "jsonfile/CIK0000002491.json\n",
      "jsonfile/CIK0000002554.json\n",
      "jsonfile/CIK0000002589.json\n",
      "jsonfile/CIK0000002601.json\n",
      "jsonfile/CIK0000002619.json\n",
      "jsonfile/CIK0000002636.json\n",
      "jsonfile/CIK0000002646.json\n",
      "jsonfile/CIK0000002648.json\n",
      "jsonfile/CIK0000002663.json\n",
      "jsonfile/CIK0000002664.json\n",
      "jsonfile/CIK0000002668.json\n",
      "jsonfile/CIK0000002691.json\n",
      "jsonfile/CIK0000002702.json\n",
      "jsonfile/CIK0000002732.json\n",
      "jsonfile/CIK0000002741.json\n",
      "jsonfile/CIK0000002745.json\n",
      "jsonfile/CIK0000002768.json\n",
      "jsonfile/CIK0000002781.json\n",
      "jsonfile/CIK0000002784.json\n",
      "jsonfile/CIK0000002809.json\n",
      "jsonfile/CIK0000002817.json\n",
      "jsonfile/CIK0000002825.json\n",
      "jsonfile/CIK0000002834.json\n",
      "jsonfile/CIK0000002852.json\n",
      "jsonfile/CIK0000002869.json\n",
      "jsonfile/CIK0000002880.json\n",
      "jsonfile/CIK0000002903.json\n",
      "jsonfile/CIK0000002915.json\n",
      "jsonfile/CIK0000002969-submissions-001.json\n",
      "jsonfile/CIK0000002969.json\n",
      "jsonfile/CIK0000003000.json\n",
      "jsonfile/CIK0000003070.json\n",
      "jsonfile/CIK0000003116-submissions-001.json\n",
      "jsonfile/CIK0000003116.json\n",
      "jsonfile/CIK0000003124.json\n",
      "jsonfile/CIK0000003133.json\n",
      "jsonfile/CIK0000003146.json\n",
      "jsonfile/CIK0000003153.json\n",
      "jsonfile/CIK0000003155.json\n",
      "jsonfile/CIK0000003158.json\n",
      "jsonfile/CIK0000003197-submissions-001.json\n",
      "jsonfile/CIK0000003197.json\n",
      "jsonfile/CIK0000003202.json\n",
      "jsonfile/CIK0000003228.json\n",
      "jsonfile/CIK0000003270.json\n",
      "jsonfile/CIK0000003292.json\n",
      "jsonfile/CIK0000003303.json\n",
      "jsonfile/CIK0000003327.json\n",
      "jsonfile/CIK0000003333.json\n",
      "jsonfile/CIK0000003370-submissions-001.json\n",
      "jsonfile/CIK0000003370.json\n",
      "jsonfile/CIK0000003398.json\n",
      "jsonfile/CIK0000003433.json\n",
      "jsonfile/CIK0000003449.json\n",
      "jsonfile/CIK0000003453-submissions-001.json\n",
      "jsonfile/CIK0000003453.json\n",
      "jsonfile/CIK0000003475.json\n",
      "jsonfile/CIK0000003499.json\n",
      "jsonfile/CIK0000003520.json\n",
      "jsonfile/CIK0000003521-submissions-001.json\n",
      "jsonfile/CIK0000003521.json\n",
      "jsonfile/CIK0000003530.json\n",
      "jsonfile/CIK0000003535.json\n",
      "jsonfile/CIK0000003545-submissions-001.json\n",
      "jsonfile/CIK0000003545.json\n",
      "jsonfile/CIK0000003559.json\n",
      "jsonfile/CIK0000003565.json\n",
      "jsonfile/CIK0000003570-submissions-001.json\n",
      "jsonfile/CIK0000003570.json\n",
      "jsonfile/CIK0000003588.json\n",
      "jsonfile/CIK0000003642.json\n",
      "jsonfile/CIK0000003650.json\n",
      "jsonfile/CIK0000003656.json\n",
      "jsonfile/CIK0000003662.json\n",
      "jsonfile/CIK0000003673-submissions-001.json\n",
      "jsonfile/CIK0000003673.json\n",
      "jsonfile/CIK0000003683.json\n",
      "jsonfile/CIK0000003711.json\n",
      "jsonfile/CIK0000003721.json\n",
      "jsonfile/CIK0000003753.json\n",
      "jsonfile/CIK0000003794-submissions-001.json\n",
      "jsonfile/CIK0000003794.json\n",
      "jsonfile/CIK0000003798.json\n",
      "jsonfile/CIK0000003845.json\n",
      "jsonfile/CIK0000003878.json\n",
      "jsonfile/CIK0000003898.json\n",
      "jsonfile/CIK0000003906-submissions-001.json\n",
      "jsonfile/CIK0000003906.json\n",
      "jsonfile/CIK0000003933.json\n",
      "jsonfile/CIK0000003941.json\n",
      "jsonfile/CIK0000003952.json\n",
      "jsonfile/CIK0000003959.json\n",
      "jsonfile/CIK0000003972.json\n",
      "jsonfile/CIK0000003975.json\n",
      "jsonfile/CIK0000003982.json\n",
      "jsonfile/CIK0000003995.json\n",
      "jsonfile/CIK0000003999.json\n",
      "jsonfile/CIK0000004123.json\n",
      "jsonfile/CIK0000004127-submissions-001.json\n",
      "jsonfile/CIK0000004127.json\n",
      "jsonfile/CIK0000004164.json\n",
      "jsonfile/CIK0000004165.json\n",
      "jsonfile/CIK0000004187.json\n",
      "jsonfile/CIK0000004250.json\n",
      "jsonfile/CIK0000004261.json\n",
      "jsonfile/CIK0000004280.json\n",
      "jsonfile/CIK0000004281-submissions-001.json\n",
      "jsonfile/CIK0000004281-submissions-002.json\n",
      "jsonfile/CIK0000004281.json\n",
      "jsonfile/CIK0000004285.json\n",
      "jsonfile/CIK0000004310.json\n",
      "jsonfile/CIK0000004317.json\n",
      "jsonfile/CIK0000004319.json\n",
      "jsonfile/CIK0000004325.json\n",
      "jsonfile/CIK0000004342.json\n",
      "jsonfile/CIK0000004344.json\n",
      "jsonfile/CIK0000004363.json\n",
      "jsonfile/CIK0000004405.json\n",
      "jsonfile/CIK0000004417.json\n",
      "jsonfile/CIK0000004421.json\n",
      "jsonfile/CIK0000004427.json\n",
      "jsonfile/CIK0000004438.json\n",
      "jsonfile/CIK0000004444.json\n",
      "jsonfile/CIK0000004447-submissions-001.json\n",
      "jsonfile/CIK0000004447.json\n",
      "jsonfile/CIK0000004457.json\n",
      "jsonfile/CIK0000004458.json\n",
      "jsonfile/CIK0000004471.json\n",
      "jsonfile/CIK0000004507.json\n",
      "jsonfile/CIK0000004515-submissions-001.json\n",
      "jsonfile/CIK0000004515.json\n",
      "jsonfile/CIK0000004527.json\n",
      "jsonfile/CIK0000004560.json\n",
      "jsonfile/CIK0000004568.json\n",
      "jsonfile/CIK0000004570.json\n",
      "jsonfile/CIK0000004572.json\n",
      "jsonfile/CIK0000004588.json\n",
      "jsonfile/CIK0000004611.json\n",
      "jsonfile/CIK0000004659.json\n",
      "jsonfile/CIK0000004672.json\n",
      "jsonfile/CIK0000004707.json\n",
      "jsonfile/CIK0000004727.json\n",
      "jsonfile/CIK0000004811.json\n",
      "jsonfile/CIK0000004828.json\n",
      "jsonfile/CIK0000004829.json\n",
      "jsonfile/CIK0000004833.json\n",
      "jsonfile/CIK0000004879.json\n",
      "jsonfile/CIK0000004904-submissions-001.json\n",
      "jsonfile/CIK0000004904.json\n",
      "jsonfile/CIK0000004911.json\n",
      "jsonfile/CIK0000004926.json\n",
      "jsonfile/CIK0000004960.json\n",
      "jsonfile/CIK0000004962-submissions-001.json\n",
      "jsonfile/CIK0000004962.json\n",
      "jsonfile/CIK0000004969.json\n",
      "jsonfile/CIK0000004975.json\n",
      "jsonfile/CIK0000004977-submissions-001.json\n",
      "jsonfile/CIK0000004977.json\n",
      "jsonfile/CIK0000004980.json\n",
      "jsonfile/CIK0000004995.json\n",
      "jsonfile/CIK0000004999.json\n",
      "jsonfile/CIK0000005006.json\n",
      "jsonfile/CIK0000005007.json\n",
      "jsonfile/CIK0000005009.json\n",
      "jsonfile/CIK0000005016.json\n",
      "jsonfile/CIK0000005075.json\n",
      "jsonfile/CIK0000005076.json\n",
      "jsonfile/CIK0000005094.json\n",
      "jsonfile/CIK0000005096.json\n",
      "jsonfile/CIK0000005099.json\n",
      "jsonfile/CIK0000005100.json\n",
      "jsonfile/CIK0000005103.json\n",
      "jsonfile/CIK0000005108.json\n",
      "jsonfile/CIK0000005114.json\n",
      "jsonfile/CIK0000005115.json\n",
      "jsonfile/CIK0000005117.json\n",
      "jsonfile/CIK0000005133-submissions-001.json\n",
      "jsonfile/CIK0000005133.json\n",
      "jsonfile/CIK0000005138.json\n",
      "jsonfile/CIK0000005139.json\n",
      "jsonfile/CIK0000005172.json\n",
      "jsonfile/CIK0000005177.json\n",
      "jsonfile/CIK0000005181.json\n",
      "jsonfile/CIK0000005187.json\n",
      "jsonfile/CIK0000005197.json\n",
      "jsonfile/CIK0000005207.json\n",
      "jsonfile/CIK0000005216.json\n",
      "jsonfile/CIK0000005227.json\n",
      "jsonfile/CIK0000005261.json\n",
      "jsonfile/CIK0000005270.json\n",
      "jsonfile/CIK0000005272-submissions-001.json\n",
      "jsonfile/CIK0000005272-submissions-002.json\n",
      "jsonfile/CIK0000005272-submissions-003.json\n",
      "jsonfile/CIK0000005272.json\n",
      "jsonfile/CIK0000005320.json\n",
      "jsonfile/CIK0000005337.json\n",
      "jsonfile/CIK0000005352.json\n",
      "jsonfile/CIK0000005368.json\n",
      "jsonfile/CIK0000005384.json\n",
      "jsonfile/CIK0000005385.json\n",
      "jsonfile/CIK0000005405.json\n",
      "jsonfile/CIK0000005441.json\n",
      "jsonfile/CIK0000005486.json\n",
      "jsonfile/CIK0000005506.json\n",
      "jsonfile/CIK0000005508.json\n",
      "jsonfile/CIK0000005513-submissions-001.json\n",
      "jsonfile/CIK0000005513.json\n",
      "jsonfile/CIK0000005529.json\n",
      "jsonfile/CIK0000005533.json\n",
      "jsonfile/CIK0000005550.json\n",
      "jsonfile/CIK0000005588.json\n",
      "jsonfile/CIK0000005611.json\n",
      "jsonfile/CIK0000005656.json\n",
      "jsonfile/CIK0000005657.json\n",
      "jsonfile/CIK0000005696.json\n",
      "jsonfile/CIK0000005719.json\n",
      "jsonfile/CIK0000005732.json\n",
      "jsonfile/CIK0000005768.json\n",
      "jsonfile/CIK0000005784.json\n",
      "jsonfile/CIK0000005786.json\n",
      "jsonfile/CIK0000005818.json\n",
      "jsonfile/CIK0000005850.json\n",
      "jsonfile/CIK0000005861.json\n",
      "jsonfile/CIK0000005876.json\n",
      "jsonfile/CIK0000005907-submissions-001.json\n",
      "jsonfile/CIK0000005907.json\n",
      "jsonfile/CIK0000005910.json\n",
      "jsonfile/CIK0000005966.json\n",
      "jsonfile/CIK0000005971.json\n",
      "jsonfile/CIK0000005981-submissions-001.json\n",
      "jsonfile/CIK0000005981.json\n",
      "jsonfile/CIK0000006019.json\n",
      "jsonfile/CIK0000006035.json\n",
      "jsonfile/CIK0000006064.json\n",
      "jsonfile/CIK0000006071.json\n",
      "jsonfile/CIK0000006075.json\n",
      "jsonfile/CIK0000006082.json\n",
      "jsonfile/CIK0000006113.json\n",
      "jsonfile/CIK0000006161.json\n",
      "jsonfile/CIK0000006164.json\n",
      "jsonfile/CIK0000006176-submissions-001.json\n",
      "jsonfile/CIK0000006176.json\n",
      "jsonfile/CIK0000006182.json\n",
      "jsonfile/CIK0000006201-submissions-001.json\n",
      "jsonfile/CIK0000006201-submissions-002.json\n",
      "jsonfile/CIK0000006201.json\n",
      "jsonfile/CIK0000006207.json\n",
      "jsonfile/CIK0000006216.json\n",
      "jsonfile/CIK0000006247.json\n",
      "jsonfile/CIK0000006260.json\n",
      "jsonfile/CIK0000006281-submissions-001.json\n",
      "jsonfile/CIK0000006281.json\n",
      "jsonfile/CIK0000006284-submissions-001.json\n",
      "jsonfile/CIK0000006284.json\n",
      "jsonfile/CIK0000006292.json\n",
      "jsonfile/CIK0000006314.json\n",
      "jsonfile/CIK0000006331.json\n",
      "jsonfile/CIK0000006342.json\n",
      "jsonfile/CIK0000006383.json\n",
      "jsonfile/CIK0000006389.json\n",
      "jsonfile/CIK0000006413.json\n",
      "jsonfile/CIK0000006435.json\n",
      "jsonfile/CIK0000006474.json\n",
      "jsonfile/CIK0000006494.json\n",
      "jsonfile/CIK0000006501.json\n",
      "jsonfile/CIK0000006527.json\n",
      "jsonfile/CIK0000006571.json\n",
      "jsonfile/CIK0000006578.json\n",
      "jsonfile/CIK0000006627.json\n",
      "jsonfile/CIK0000006664.json\n",
      "jsonfile/CIK0000006684.json\n",
      "jsonfile/CIK0000006694.json\n",
      "jsonfile/CIK0000006713.json\n",
      "jsonfile/CIK0000006715.json\n",
      "jsonfile/CIK0000006720.json\n",
      "jsonfile/CIK0000006732.json\n",
      "jsonfile/CIK0000006769-submissions-001.json\n",
      "jsonfile/CIK0000006769-submissions-002.json\n",
      "jsonfile/CIK0000006769-submissions-003.json\n",
      "jsonfile/CIK0000006769.json\n",
      "jsonfile/CIK0000006814.json\n",
      "jsonfile/CIK0000006845-submissions-001.json\n",
      "jsonfile/CIK0000006845.json\n",
      "jsonfile/CIK0000006879.json\n",
      "jsonfile/CIK0000006885-submissions-001.json\n",
      "jsonfile/CIK0000006885.json\n",
      "jsonfile/CIK0000006948.json\n",
      "jsonfile/CIK0000006951-submissions-001.json\n",
      "jsonfile/CIK0000006951.json\n",
      "jsonfile/CIK0000006955-submissions-001.json\n",
      "jsonfile/CIK0000006955.json\n",
      "jsonfile/CIK0000006992.json\n",
      "jsonfile/CIK0000007032.json\n",
      "jsonfile/CIK0000007039.json\n",
      "jsonfile/CIK0000007059.json\n",
      "jsonfile/CIK0000007084-submissions-001.json\n",
      "jsonfile/CIK0000007084-submissions-002.json\n",
      "jsonfile/CIK0000007084.json\n",
      "jsonfile/CIK0000007105.json\n",
      "jsonfile/CIK0000007119.json\n",
      "jsonfile/CIK0000007169.json\n",
      "jsonfile/CIK0000007184.json\n",
      "jsonfile/CIK0000007195.json\n",
      "jsonfile/CIK0000007214.json\n",
      "jsonfile/CIK0000007255.json\n",
      "jsonfile/CIK0000007286.json\n",
      "jsonfile/CIK0000007297.json\n",
      "jsonfile/CIK0000007302.json\n",
      "jsonfile/CIK0000007314.json\n",
      "jsonfile/CIK0000007323.json\n",
      "jsonfile/CIK0000007332-submissions-001.json\n",
      "jsonfile/CIK0000007332.json\n",
      "jsonfile/CIK0000007340.json\n",
      "jsonfile/CIK0000007346.json\n",
      "jsonfile/CIK0000007373.json\n",
      "jsonfile/CIK0000007383.json\n",
      "jsonfile/CIK0000007426.json\n",
      "jsonfile/CIK0000007431-submissions-001.json\n",
      "jsonfile/CIK0000007431.json\n",
      "jsonfile/CIK0000007443.json\n",
      "jsonfile/CIK0000007470.json\n",
      "jsonfile/CIK0000007533.json\n",
      "jsonfile/CIK0000007536-submissions-001.json\n",
      "jsonfile/CIK0000007536.json\n",
      "jsonfile/CIK0000007610.json\n",
      "jsonfile/CIK0000007623.json\n",
      "jsonfile/CIK0000007636.json\n",
      "jsonfile/CIK0000007645.json\n",
      "jsonfile/CIK0000007646.json\n",
      "jsonfile/CIK0000007649.json\n",
      "jsonfile/CIK0000007694-submissions-001.json\n",
      "jsonfile/CIK0000007694.json\n",
      "jsonfile/CIK0000007711.json\n",
      "jsonfile/CIK0000007773.json\n",
      "jsonfile/CIK0000007789-submissions-001.json\n",
      "jsonfile/CIK0000007789-submissions-002.json\n",
      "jsonfile/CIK0000007789-submissions-003.json\n",
      "jsonfile/CIK0000007789.json\n",
      "jsonfile/CIK0000007823.json\n",
      "jsonfile/CIK0000007948.json\n",
      "jsonfile/CIK0000007951.json\n",
      "jsonfile/CIK0000007973.json\n",
      "jsonfile/CIK0000007974.json\n",
      "jsonfile/CIK0000008038.json\n",
      "jsonfile/CIK0000008063-submissions-001.json\n",
      "jsonfile/CIK0000008063.json\n",
      "jsonfile/CIK0000008065.json\n",
      "jsonfile/CIK0000008069.json\n",
      "jsonfile/CIK0000008088.json\n",
      "jsonfile/CIK0000008109.json\n",
      "jsonfile/CIK0000008117.json\n",
      "jsonfile/CIK0000008137.json\n",
      "jsonfile/CIK0000008146-submissions-001.json\n",
      "jsonfile/CIK0000008146.json\n",
      "jsonfile/CIK0000008154.json\n",
      "jsonfile/CIK0000008155.json\n",
      "jsonfile/CIK0000008177.json\n",
      "jsonfile/CIK0000008192.json\n",
      "jsonfile/CIK0000008286.json\n",
      "jsonfile/CIK0000008299.json\n",
      "jsonfile/CIK0000008302.json\n",
      "jsonfile/CIK0000008328.json\n",
      "jsonfile/CIK0000008345.json\n",
      "jsonfile/CIK0000008411-submissions-001.json\n",
      "jsonfile/CIK0000008411.json\n",
      "jsonfile/CIK0000008412.json\n",
      "jsonfile/CIK0000008462.json\n",
      "jsonfile/CIK0000008486.json\n",
      "jsonfile/CIK0000008497.json\n",
      "jsonfile/CIK0000008504.json\n",
      "jsonfile/CIK0000008565.json\n",
      "jsonfile/CIK0000008588.json\n",
      "jsonfile/CIK0000008598.json\n",
      "jsonfile/CIK0000008643.json\n",
      "jsonfile/CIK0000008670-submissions-001.json\n",
      "jsonfile/CIK0000008670.json\n",
      "jsonfile/CIK0000008699.json\n",
      "jsonfile/CIK0000008725.json\n",
      "jsonfile/CIK0000008734.json\n",
      "jsonfile/CIK0000008762.json\n",
      "jsonfile/CIK0000008775.json\n",
      "jsonfile/CIK0000008776.json\n",
      "jsonfile/CIK0000008795.json\n",
      "jsonfile/CIK0000008800.json\n",
      "jsonfile/CIK0000008802.json\n",
      "jsonfile/CIK0000008818-submissions-001.json\n",
      "jsonfile/CIK0000008818.json\n",
      "jsonfile/CIK0000008855.json\n",
      "jsonfile/CIK0000008858-submissions-001.json\n",
      "jsonfile/CIK0000008858.json\n",
      "jsonfile/CIK0000008867.json\n",
      "jsonfile/CIK0000008868-submissions-001.json\n",
      "jsonfile/CIK0000008868.json\n",
      "jsonfile/CIK0000008919.json\n",
      "jsonfile/CIK0000008943.json\n",
      "jsonfile/CIK0000008947-submissions-001.json\n",
      "jsonfile/CIK0000008947.json\n",
      "jsonfile/CIK0000008960.json\n",
      "jsonfile/CIK0000009014.json\n",
      "jsonfile/CIK0000009015-submissions-001.json\n",
      "jsonfile/CIK0000009015.json\n",
      "jsonfile/CIK0000009017.json\n",
      "jsonfile/CIK0000009092-submissions-001.json\n",
      "jsonfile/CIK0000009092.json\n",
      "jsonfile/CIK0000009096.json\n",
      "jsonfile/CIK0000009108.json\n",
      "jsonfile/CIK0000009120.json\n",
      "jsonfile/CIK0000009128.json\n",
      "jsonfile/CIK0000009145.json\n",
      "jsonfile/CIK0000009157.json\n",
      "jsonfile/CIK0000009189.json\n",
      "jsonfile/CIK0000009209.json\n",
      "jsonfile/CIK0000009211.json\n",
      "jsonfile/CIK0000009217.json\n",
      "jsonfile/CIK0000009220.json\n",
      "jsonfile/CIK0000009235.json\n",
      "jsonfile/CIK0000009263.json\n",
      "jsonfile/CIK0000009268.json\n",
      "jsonfile/CIK0000009318.json\n",
      "jsonfile/CIK0000009319.json\n",
      "jsonfile/CIK0000009326.json\n",
      "jsonfile/CIK0000009342-submissions-001.json\n",
      "jsonfile/CIK0000009342.json\n",
      "jsonfile/CIK0000009346-submissions-001.json\n",
      "jsonfile/CIK0000009346.json\n",
      "jsonfile/CIK0000009367.json\n",
      "jsonfile/CIK0000009382.json\n",
      "jsonfile/CIK0000009389-submissions-001.json\n",
      "jsonfile/CIK0000009389-submissions-002.json\n",
      "jsonfile/CIK0000009389.json\n",
      "jsonfile/CIK0000009435.json\n",
      "jsonfile/CIK0000009436.json\n",
      "jsonfile/CIK0000009442.json\n",
      "jsonfile/CIK0000009456.json\n",
      "jsonfile/CIK0000009466.json\n",
      "jsonfile/CIK0000009521.json\n",
      "jsonfile/CIK0000009528.json\n",
      "jsonfile/CIK0000009534.json\n",
      "jsonfile/CIK0000009548.json\n",
      "jsonfile/CIK0000009568.json\n",
      "jsonfile/CIK0000009572.json\n",
      "jsonfile/CIK0000009586.json\n",
      "jsonfile/CIK0000009621.json\n",
      "jsonfile/CIK0000009622.json\n",
      "jsonfile/CIK0000009626-submissions-001.json\n",
      "jsonfile/CIK0000009626.json\n",
      "jsonfile/CIK0000009631-submissions-001.json\n",
      "jsonfile/CIK0000009631-submissions-002.json\n",
      "jsonfile/CIK0000009631-submissions-003.json\n",
      "jsonfile/CIK0000009631.json\n",
      "jsonfile/CIK0000009634.json\n",
      "jsonfile/CIK0000009651.json\n",
      "jsonfile/CIK0000009659.json\n",
      "jsonfile/CIK0000009664.json\n",
      "jsonfile/CIK0000009672.json\n",
      "jsonfile/CIK0000009677.json\n",
      "jsonfile/CIK0000009681.json\n",
      "jsonfile/CIK0000009696.json\n",
      "jsonfile/CIK0000009712-submissions-001.json\n",
      "jsonfile/CIK0000009712.json\n",
      "jsonfile/CIK0000009713.json\n",
      "jsonfile/CIK0000009714.json\n",
      "jsonfile/CIK0000009738.json\n",
      "jsonfile/CIK0000009749.json\n",
      "jsonfile/CIK0000009779.json\n",
      "jsonfile/CIK0000009781.json\n",
      "jsonfile/CIK0000009801.json\n",
      "jsonfile/CIK0000009822.json\n",
      "jsonfile/CIK0000009874.json\n",
      "jsonfile/CIK0000009892-submissions-001.json\n",
      "jsonfile/CIK0000009892.json\n",
      "jsonfile/CIK0000009911.json\n",
      "jsonfile/CIK0000009984-submissions-001.json\n",
      "jsonfile/CIK0000009984.json\n",
      "jsonfile/CIK0000010012.json\n",
      "jsonfile/CIK0000010048.json\n",
      "jsonfile/CIK0000010074.json\n",
      "jsonfile/CIK0000010081.json\n",
      "jsonfile/CIK0000010117.json\n",
      "jsonfile/CIK0000010119.json\n",
      "jsonfile/CIK0000010154.json\n",
      "jsonfile/CIK0000010193.json\n",
      "jsonfile/CIK0000010242.json\n",
      "jsonfile/CIK0000010245.json\n",
      "jsonfile/CIK0000010254.json\n",
      "jsonfile/CIK0000010267.json\n",
      "jsonfile/CIK0000010283.json\n",
      "jsonfile/CIK0000010329-submissions-001.json\n",
      "jsonfile/CIK0000010329.json\n",
      "jsonfile/CIK0000010359.json\n",
      "jsonfile/CIK0000010418.json\n",
      "jsonfile/CIK0000010427-submissions-001.json\n",
      "jsonfile/CIK0000010427.json\n",
      "jsonfile/CIK0000010443.json\n",
      "jsonfile/CIK0000010456-submissions-001.json\n",
      "jsonfile/CIK0000010456.json\n",
      "jsonfile/CIK0000010481.json\n",
      "jsonfile/CIK0000010488.json\n",
      "jsonfile/CIK0000010497.json\n",
      "jsonfile/CIK0000010578.json\n",
      "jsonfile/CIK0000010580.json\n",
      "jsonfile/CIK0000010581.json\n",
      "jsonfile/CIK0000010624.json\n",
      "jsonfile/CIK0000010664.json\n",
      "jsonfile/CIK0000010724.json\n",
      "jsonfile/CIK0000010742.json\n",
      "jsonfile/CIK0000010767.json\n",
      "jsonfile/CIK0000010795-submissions-001.json\n",
      "jsonfile/CIK0000010795.json\n",
      "jsonfile/CIK0000010872.json\n",
      "jsonfile/CIK0000010885.json\n",
      "jsonfile/CIK0000010975.json\n",
      "jsonfile/CIK0000011027.json\n",
      "jsonfile/CIK0000011107.json\n",
      "jsonfile/CIK0000011118.json\n",
      "jsonfile/CIK0000011166.json\n",
      "jsonfile/CIK0000011199-submissions-001.json\n",
      "jsonfile/CIK0000011199.json\n",
      "jsonfile/CIK0000011290.json\n",
      "jsonfile/CIK0000011390.json\n",
      "jsonfile/CIK0000011454.json\n",
      "jsonfile/CIK0000011499.json\n",
      "jsonfile/CIK0000011544-submissions-001.json\n",
      "jsonfile/CIK0000011544.json\n",
      "jsonfile/CIK0000011545.json\n",
      "jsonfile/CIK0000011557.json\n",
      "jsonfile/CIK0000011788.json\n",
      "jsonfile/CIK0000011790.json\n",
      "jsonfile/CIK0000011806.json\n",
      "jsonfile/CIK0000011814.json\n",
      "jsonfile/CIK0000011821.json\n",
      "jsonfile/CIK0000011825.json\n",
      "jsonfile/CIK0000011856.json\n",
      "jsonfile/CIK0000011860.json\n",
      "jsonfile/CIK0000011884.json\n",
      "jsonfile/CIK0000011913.json\n",
      "jsonfile/CIK0000011917.json\n",
      "jsonfile/CIK0000011934.json\n",
      "jsonfile/CIK0000011975.json\n",
      "jsonfile/CIK0000011987.json\n",
      "jsonfile/CIK0000012027.json\n",
      "jsonfile/CIK0000012040.json\n",
      "jsonfile/CIK0000012105.json\n",
      "jsonfile/CIK0000012180.json\n",
      "jsonfile/CIK0000012203.json\n",
      "jsonfile/CIK0000012208-submissions-001.json\n",
      "jsonfile/CIK0000012208.json\n",
      "jsonfile/CIK0000012228.json\n",
      "jsonfile/CIK0000012239-submissions-001.json\n",
      "jsonfile/CIK0000012239.json\n",
      "jsonfile/CIK0000012245.json\n",
      "jsonfile/CIK0000012265.json\n",
      "jsonfile/CIK0000012311.json\n",
      "jsonfile/CIK0000012318.json\n",
      "jsonfile/CIK0000012355-submissions-001.json\n",
      "jsonfile/CIK0000012355.json\n",
      "jsonfile/CIK0000012388.json\n",
      "jsonfile/CIK0000012400.json\n",
      "jsonfile/CIK0000012406.json\n",
      "jsonfile/CIK0000012449.json\n",
      "jsonfile/CIK0000012469.json\n",
      "jsonfile/CIK0000012473.json\n",
      "jsonfile/CIK0000012500.json\n",
      "jsonfile/CIK0000012518.json\n",
      "jsonfile/CIK0000012532.json\n",
      "jsonfile/CIK0000012570.json\n",
      "jsonfile/CIK0000012600.json\n",
      "jsonfile/CIK0000012601-submissions-001.json\n",
      "jsonfile/CIK0000012601.json\n",
      "jsonfile/CIK0000012602.json\n",
      "jsonfile/CIK0000012603.json\n",
      "jsonfile/CIK0000012614.json\n",
      "jsonfile/CIK0000012635.json\n",
      "jsonfile/CIK0000012654.json\n",
      "jsonfile/CIK0000012659-submissions-001.json\n",
      "jsonfile/CIK0000012659.json\n",
      "jsonfile/CIK0000012707.json\n",
      "jsonfile/CIK0000012733.json\n",
      "jsonfile/CIK0000012779.json\n",
      "jsonfile/CIK0000012793.json\n",
      "jsonfile/CIK0000012906.json\n",
      "jsonfile/CIK0000012927-submissions-001.json\n",
      "jsonfile/CIK0000012927-submissions-002.json\n",
      "jsonfile/CIK0000012927.json\n",
      "jsonfile/CIK0000012933.json\n",
      "jsonfile/CIK0000012953.json\n",
      "jsonfile/CIK0000012978-submissions-001.json\n",
      "jsonfile/CIK0000012978.json\n",
      "jsonfile/CIK0000013006.json\n",
      "jsonfile/CIK0000013021.json\n",
      "jsonfile/CIK0000013033.json\n",
      "jsonfile/CIK0000013055.json\n",
      "jsonfile/CIK0000013075.json\n",
      "jsonfile/CIK0000013083.json\n",
      "jsonfile/CIK0000013156.json\n",
      "jsonfile/CIK0000013191.json\n",
      "jsonfile/CIK0000013222.json\n",
      "jsonfile/CIK0000013237.json\n",
      "jsonfile/CIK0000013239.json\n",
      "jsonfile/CIK0000013246.json\n",
      "jsonfile/CIK0000013290.json\n",
      "jsonfile/CIK0000013299.json\n",
      "jsonfile/CIK0000013310.json\n",
      "jsonfile/CIK0000013338.json\n",
      "jsonfile/CIK0000013351.json\n",
      "jsonfile/CIK0000013352.json\n",
      "jsonfile/CIK0000013353.json\n",
      "jsonfile/CIK0000013361.json\n",
      "jsonfile/CIK0000013372.json\n",
      "jsonfile/CIK0000013386.json\n",
      "jsonfile/CIK0000013390.json\n",
      "jsonfile/CIK0000013393.json\n",
      "jsonfile/CIK0000013463.json\n",
      "jsonfile/CIK0000013522.json\n",
      "jsonfile/CIK0000013547.json\n",
      "jsonfile/CIK0000013573.json\n",
      "jsonfile/CIK0000013585.json\n",
      "jsonfile/CIK0000013606.json\n",
      "jsonfile/CIK0000013610-submissions-001.json\n",
      "jsonfile/CIK0000013610.json\n",
      "jsonfile/CIK0000013777.json\n",
      "jsonfile/CIK0000013783.json\n",
      "jsonfile/CIK0000013824.json\n",
      "jsonfile/CIK0000013839.json\n",
      "jsonfile/CIK0000013878.json\n",
      "jsonfile/CIK0000014029.json\n",
      "jsonfile/CIK0000014049.json\n",
      "jsonfile/CIK0000014056.json\n",
      "jsonfile/CIK0000014060.json\n",
      "jsonfile/CIK0000014073.json\n",
      "jsonfile/CIK0000014169.json\n",
      "jsonfile/CIK0000014170.json\n",
      "jsonfile/CIK0000014177.json\n",
      "jsonfile/CIK0000014195-submissions-001.json\n",
      "jsonfile/CIK0000014195.json\n",
      "jsonfile/CIK0000014213.json\n",
      "jsonfile/CIK0000014232.json\n",
      "jsonfile/CIK0000014272-submissions-001.json\n",
      "jsonfile/CIK0000014272.json\n",
      "jsonfile/CIK0000014280.json\n",
      "jsonfile/CIK0000014294.json\n",
      "jsonfile/CIK0000014306.json\n",
      "jsonfile/CIK0000014333.json\n",
      "jsonfile/CIK0000014343.json\n",
      "jsonfile/CIK0000014358.json\n",
      "jsonfile/CIK0000014399.json\n",
      "jsonfile/CIK0000014407.json\n",
      "jsonfile/CIK0000014423.json\n",
      "jsonfile/CIK0000014463.json\n",
      "jsonfile/CIK0000014525.json\n",
      "jsonfile/CIK0000014537.json\n",
      "jsonfile/CIK0000014550.json\n",
      "jsonfile/CIK0000014595.json\n",
      "jsonfile/CIK0000014611.json\n",
      "jsonfile/CIK0000014632.json\n",
      "jsonfile/CIK0000014637.json\n",
      "jsonfile/CIK0000014651.json\n",
      "jsonfile/CIK0000014661.json\n",
      "jsonfile/CIK0000014693-submissions-001.json\n",
      "jsonfile/CIK0000014693.json\n",
      "jsonfile/CIK0000014698.json\n",
      "jsonfile/CIK0000014707-submissions-001.json\n",
      "jsonfile/CIK0000014707.json\n",
      "jsonfile/CIK0000014745.json\n",
      "jsonfile/CIK0000014767.json\n",
      "jsonfile/CIK0000014798.json\n",
      "jsonfile/CIK0000014803.json\n",
      "jsonfile/CIK0000014827.json\n",
      "jsonfile/CIK0000014846-submissions-001.json\n",
      "jsonfile/CIK0000014846.json\n",
      "jsonfile/CIK0000014847.json\n",
      "jsonfile/CIK0000014864.json\n",
      "jsonfile/CIK0000014899.json\n",
      "jsonfile/CIK0000014920.json\n",
      "jsonfile/CIK0000014930-submissions-001.json\n",
      "jsonfile/CIK0000014930.json\n",
      "jsonfile/CIK0000014957.json\n",
      "jsonfile/CIK0000014971.json\n",
      "jsonfile/CIK0000014995.json\n",
      "jsonfile/CIK0000015019.json\n",
      "jsonfile/CIK0000015168.json\n",
      "jsonfile/CIK0000015260.json\n",
      "jsonfile/CIK0000015266.json\n",
      "jsonfile/CIK0000015288.json\n",
      "jsonfile/CIK0000015310.json\n",
      "jsonfile/CIK0000015354.json\n",
      "jsonfile/CIK0000015357.json\n",
      "jsonfile/CIK0000015393.json\n",
      "jsonfile/CIK0000015466.json\n",
      "jsonfile/CIK0000015470.json\n",
      "jsonfile/CIK0000015486.json\n",
      "jsonfile/CIK0000015511.json\n",
      "jsonfile/CIK0000015590.json\n",
      "jsonfile/CIK0000015615-submissions-001.json\n",
      "jsonfile/CIK0000015615.json\n",
      "jsonfile/CIK0000015678.json\n",
      "jsonfile/CIK0000015681.json\n",
      "jsonfile/CIK0000015699.json\n",
      "jsonfile/CIK0000015715.json\n",
      "jsonfile/CIK0000015836.json\n",
      "jsonfile/CIK0000015840.json\n",
      "jsonfile/CIK0000015847.json\n",
      "jsonfile/CIK0000015867.json\n",
      "jsonfile/CIK0000015869.json\n",
      "jsonfile/CIK0000015876.json\n",
      "jsonfile/CIK0000015916.json\n",
      "jsonfile/CIK0000015939.json\n",
      "jsonfile/CIK0000015983.json\n",
      "jsonfile/CIK0000016015.json\n",
      "jsonfile/CIK0000016040-submissions-001.json\n",
      "jsonfile/CIK0000016040.json\n",
      "jsonfile/CIK0000016058-submissions-001.json\n",
      "jsonfile/CIK0000016058.json\n",
      "jsonfile/CIK0000016095.json\n",
      "jsonfile/CIK0000016099-submissions-001.json\n",
      "jsonfile/CIK0000016099.json\n",
      "jsonfile/CIK0000016104.json\n",
      "jsonfile/CIK0000016121.json\n",
      "jsonfile/CIK0000016160.json\n",
      "jsonfile/CIK0000016190.json\n",
      "jsonfile/CIK0000016218.json\n",
      "jsonfile/CIK0000016250.json\n",
      "jsonfile/CIK0000016287.json\n",
      "jsonfile/CIK0000016317.json\n",
      "jsonfile/CIK0000016343.json\n",
      "jsonfile/CIK0000016357.json\n",
      "jsonfile/CIK0000016387.json\n",
      "jsonfile/CIK0000016422.json\n",
      "jsonfile/CIK0000016476.json\n",
      "jsonfile/CIK0000016496.json\n",
      "jsonfile/CIK0000016573.json\n",
      "jsonfile/CIK0000016590.json\n",
      "jsonfile/CIK0000016614-submissions-001.json\n",
      "jsonfile/CIK0000016614.json\n",
      "jsonfile/CIK0000016652.json\n",
      "jsonfile/CIK0000016686.json\n",
      "jsonfile/CIK0000016694.json\n",
      "jsonfile/CIK0000016715.json\n",
      "jsonfile/CIK0000016732-submissions-001.json\n",
      "jsonfile/CIK0000016732.json\n",
      "jsonfile/CIK0000016735.json\n",
      "jsonfile/CIK0000016741.json\n",
      "jsonfile/CIK0000016754.json\n",
      "jsonfile/CIK0000016760.json\n",
      "jsonfile/CIK0000016789.json\n",
      "jsonfile/CIK0000016804.json\n",
      "jsonfile/CIK0000016847.json\n",
      "jsonfile/CIK0000016859.json\n",
      "jsonfile/CIK0000016868.json\n",
      "jsonfile/CIK0000016873.json\n",
      "jsonfile/CIK0000016875-submissions-001.json\n",
      "jsonfile/CIK0000016875.json\n",
      "jsonfile/CIK0000016893.json\n",
      "jsonfile/CIK0000016906.json\n",
      "jsonfile/CIK0000016918-submissions-001.json\n",
      "jsonfile/CIK0000016918.json\n",
      "jsonfile/CIK0000016972.json\n",
      "jsonfile/CIK0000016988.json\n",
      "jsonfile/CIK0000017018.json\n",
      "jsonfile/CIK0000017024.json\n",
      "jsonfile/CIK0000017071.json\n",
      "jsonfile/CIK0000017109.json\n",
      "jsonfile/CIK0000017123.json\n",
      "jsonfile/CIK0000017140.json\n",
      "jsonfile/CIK0000017147.json\n",
      "jsonfile/CIK0000017206.json\n",
      "jsonfile/CIK0000017221.json\n",
      "jsonfile/CIK0000017225.json\n",
      "jsonfile/CIK0000017237.json\n",
      "jsonfile/CIK0000017271.json\n",
      "jsonfile/CIK0000017283-submissions-001.json\n",
      "jsonfile/CIK0000017283-submissions-002.json\n",
      "jsonfile/CIK0000017283.json\n",
      "jsonfile/CIK0000017292.json\n",
      "jsonfile/CIK0000017294.json\n",
      "jsonfile/CIK0000017313-submissions-001.json\n",
      "jsonfile/CIK0000017313.json\n",
      "jsonfile/CIK0000017385.json\n",
      "jsonfile/CIK0000017482.json\n",
      "jsonfile/CIK0000017485.json\n",
      "jsonfile/CIK0000017493.json\n",
      "jsonfile/CIK0000017527.json\n",
      "jsonfile/CIK0000017544.json\n",
      "jsonfile/CIK0000017732.json\n",
      "jsonfile/CIK0000017757.json\n",
      "jsonfile/CIK0000017797.json\n",
      "jsonfile/CIK0000017843-submissions-001.json\n",
      "jsonfile/CIK0000017843.json\n",
      "jsonfile/CIK0000017862.json\n",
      "jsonfile/CIK0000017872.json\n",
      "jsonfile/CIK0000017914.json\n",
      "jsonfile/CIK0000017927.json\n",
      "jsonfile/CIK0000017940.json\n",
      "jsonfile/CIK0000017996.json\n",
      "jsonfile/CIK0000018000.json\n",
      "jsonfile/CIK0000018026.json\n",
      "jsonfile/CIK0000018061.json\n",
      "jsonfile/CIK0000018072.json\n",
      "jsonfile/CIK0000018109.json\n",
      "jsonfile/CIK0000018122.json\n",
      "jsonfile/CIK0000018128.json\n",
      "jsonfile/CIK0000018148.json\n",
      "jsonfile/CIK0000018169.json\n",
      "jsonfile/CIK0000018172-submissions-001.json\n",
      "jsonfile/CIK0000018172.json\n",
      "jsonfile/CIK0000018180.json\n",
      "jsonfile/CIK0000018230-submissions-001.json\n",
      "jsonfile/CIK0000018230-submissions-002.json\n",
      "jsonfile/CIK0000018230.json\n",
      "jsonfile/CIK0000018239.json\n",
      "jsonfile/CIK0000018255-submissions-001.json\n",
      "jsonfile/CIK0000018255.json\n",
      "jsonfile/CIK0000018347.json\n",
      "jsonfile/CIK0000018349-submissions-001.json\n",
      "jsonfile/CIK0000018349-submissions-002.json\n",
      "jsonfile/CIK0000018349.json\n",
      "jsonfile/CIK0000018366.json\n",
      "jsonfile/CIK0000018382.json\n",
      "jsonfile/CIK0000018396-submissions-001.json\n",
      "jsonfile/CIK0000018396.json\n",
      "jsonfile/CIK0000018429.json\n",
      "jsonfile/CIK0000018443.json\n",
      "jsonfile/CIK0000018497.json\n",
      "jsonfile/CIK0000018498-submissions-001.json\n",
      "jsonfile/CIK0000018498.json\n",
      "jsonfile/CIK0000018508.json\n",
      "jsonfile/CIK0000018530.json\n",
      "jsonfile/CIK0000018532-submissions-001.json\n",
      "jsonfile/CIK0000018532.json\n",
      "jsonfile/CIK0000018540.json\n",
      "jsonfile/CIK0000018564.json\n",
      "jsonfile/CIK0000018568-submissions-001.json\n",
      "jsonfile/CIK0000018568.json\n",
      "jsonfile/CIK0000018572.json\n",
      "jsonfile/CIK0000018605.json\n",
      "jsonfile/CIK0000018620.json\n",
      "jsonfile/CIK0000018647.json\n",
      "jsonfile/CIK0000018651.json\n",
      "jsonfile/CIK0000018654.json\n",
      "jsonfile/CIK0000018672.json\n",
      "jsonfile/CIK0000018675.json\n",
      "jsonfile/CIK0000018713.json\n",
      "jsonfile/CIK0000018734.json\n",
      "jsonfile/CIK0000018748.json\n",
      "jsonfile/CIK0000018779.json\n",
      "jsonfile/CIK0000018783.json\n",
      "jsonfile/CIK0000018787.json\n",
      "jsonfile/CIK0000018792.json\n",
      "jsonfile/CIK0000018808-submissions-001.json\n",
      "jsonfile/CIK0000018808.json\n",
      "jsonfile/CIK0000018827.json\n",
      "jsonfile/CIK0000018873.json\n",
      "jsonfile/CIK0000018886.json\n",
      "jsonfile/CIK0000018905.json\n",
      "jsonfile/CIK0000018912.json\n",
      "jsonfile/CIK0000018914.json\n",
      "jsonfile/CIK0000018922.json\n",
      "jsonfile/CIK0000018926-submissions-001.json\n",
      "jsonfile/CIK0000018926.json\n",
      "jsonfile/CIK0000018934.json\n",
      "jsonfile/CIK0000018937.json\n",
      "jsonfile/CIK0000019002.json\n",
      "jsonfile/CIK0000019024.json\n",
      "jsonfile/CIK0000019033.json\n",
      "jsonfile/CIK0000019034.json\n",
      "jsonfile/CIK0000019047.json\n",
      "jsonfile/CIK0000019119.json\n",
      "jsonfile/CIK0000019144.json\n",
      "jsonfile/CIK0000019149.json\n",
      "jsonfile/CIK0000019150.json\n",
      "jsonfile/CIK0000019161.json\n",
      "jsonfile/CIK0000019252.json\n",
      "jsonfile/CIK0000019283.json\n",
      "jsonfile/CIK0000019289.json\n",
      "jsonfile/CIK0000019342.json\n",
      "jsonfile/CIK0000019353-submissions-001.json\n",
      "jsonfile/CIK0000019353.json\n",
      "jsonfile/CIK0000019392.json\n",
      "jsonfile/CIK0000019399.json\n",
      "jsonfile/CIK0000019411-submissions-001.json\n",
      "jsonfile/CIK0000019411.json\n",
      "jsonfile/CIK0000019446-submissions-001.json\n",
      "jsonfile/CIK0000019446.json\n",
      "jsonfile/CIK0000019469.json\n",
      "jsonfile/CIK0000019475.json\n",
      "jsonfile/CIK0000019481.json\n",
      "jsonfile/CIK0000019489.json\n",
      "jsonfile/CIK0000019520.json\n",
      "jsonfile/CIK0000019532.json\n",
      "jsonfile/CIK0000019552.json\n",
      "jsonfile/CIK0000019572.json\n",
      "jsonfile/CIK0000019584-submissions-001.json\n",
      "jsonfile/CIK0000019584.json\n",
      "jsonfile/CIK0000019600.json\n",
      "jsonfile/CIK0000019612-submissions-001.json\n",
      "jsonfile/CIK0000019612.json\n",
      "jsonfile/CIK0000019614.json\n",
      "jsonfile/CIK0000019617-submissions-001.json\n",
      "jsonfile/CIK0000019617-submissions-002.json\n",
      "jsonfile/CIK0000019617-submissions-003.json\n",
      "jsonfile/CIK0000019617-submissions-004.json\n",
      "jsonfile/CIK0000019617-submissions-005.json\n",
      "jsonfile/CIK0000019617-submissions-006.json\n",
      "jsonfile/CIK0000019617-submissions-007.json\n",
      "jsonfile/CIK0000019617-submissions-008.json\n",
      "jsonfile/CIK0000019617-submissions-009.json\n",
      "jsonfile/CIK0000019617-submissions-010.json\n",
      "jsonfile/CIK0000019617-submissions-011.json\n",
      "jsonfile/CIK0000019617-submissions-012.json\n",
      "jsonfile/CIK0000019617-submissions-013.json\n",
      "jsonfile/CIK0000019617-submissions-014.json\n",
      "jsonfile/CIK0000019617-submissions-015.json\n",
      "jsonfile/CIK0000019617-submissions-016.json\n",
      "jsonfile/CIK0000019617-submissions-017.json\n",
      "jsonfile/CIK0000019617-submissions-018.json\n",
      "jsonfile/CIK0000019617-submissions-019.json\n",
      "jsonfile/CIK0000019617-submissions-020.json\n",
      "jsonfile/CIK0000019617-submissions-021.json\n",
      "jsonfile/CIK0000019617-submissions-022.json\n",
      "jsonfile/CIK0000019617-submissions-023.json\n",
      "jsonfile/CIK0000019617-submissions-024.json\n",
      "jsonfile/CIK0000019617-submissions-025.json\n",
      "jsonfile/CIK0000019617-submissions-026.json\n",
      "jsonfile/CIK0000019617-submissions-027.json\n",
      "jsonfile/CIK0000019617-submissions-028.json\n",
      "jsonfile/CIK0000019617-submissions-029.json\n",
      "jsonfile/CIK0000019617-submissions-030.json\n",
      "jsonfile/CIK0000019617-submissions-031.json\n",
      "jsonfile/CIK0000019617-submissions-032.json\n",
      "jsonfile/CIK0000019617-submissions-033.json\n",
      "jsonfile/CIK0000019617-submissions-034.json\n",
      "jsonfile/CIK0000019617-submissions-035.json\n",
      "jsonfile/CIK0000019617.json\n",
      "jsonfile/CIK0000019660.json\n",
      "jsonfile/CIK0000019704.json\n",
      "jsonfile/CIK0000019719.json\n",
      "jsonfile/CIK0000019722.json\n",
      "jsonfile/CIK0000019724.json\n",
      "jsonfile/CIK0000019725.json\n",
      "jsonfile/CIK0000019731.json\n"
     ]
    }
   ],
   "source": [
    "import boto3\n",
    "\n",
    "# Create an S3 client object\n",
    "s3_client = boto3.client('s3')\n",
    "\n",
    "# Specify the bucket name and folder name\n",
    "bucket_name = 'aws-json-from-website'\n",
    "folder_name = 'jsonfile/'\n",
    "\n",
    "# List the objects in the folder\n",
    "objects = s3_client.list_objects_v2(Bucket=bucket_name, Prefix=folder_name)\n",
    "\n",
    "# Iterate through each object and print its key\n",
    "for obj in objects['Contents']:\n",
    "    if obj['Key'].endswith('.json'):\n",
    "        print(obj['Key'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'cik': '15470', 'entityType': 'other', 'sic': '', 'sicDescription': '', 'insiderTransactionForOwnerExists': 0, 'insiderTransactionForIssuerExists': 0, 'name': 'BURKE, LAWTON, BREWER & BURKE, LLC', 'tickers': [], 'exchanges': [], 'ein': '236392440', 'description': '', 'website': '', 'investorWebsite': '', 'category': '', 'fiscalYearEnd': '1231', 'stateOfIncorporation': 'PA', 'stateOfIncorporationDescription': 'PA', 'addresses': {'mailing': {'street1': 'P.O. BOX 1010', 'street2': None, 'city': 'MONTGOMERYVILLE', 'stateOrCountry': 'PA', 'zipCode': '18936', 'stateOrCountryDescription': 'PA'}, 'business': {'street1': '103 MONTGOMERY AVENUE', 'street2': None, 'city': 'MONTGOMERYVILLE', 'stateOrCountry': 'PA', 'zipCode': '18936', 'stateOrCountryDescription': 'PA'}}, 'phone': '215-643-9100', 'flags': '', 'formerNames': [{'name': 'BURKE, LAWTON, BREWER & BURKE', 'from': '2003-12-31T00:00:00.000Z', 'to': '2004-12-06T00:00:00.000Z'}, {'name': 'BURKE LAWTON BREWER & BURKE                             /BD', 'from': '2002-12-02T00:00:00.000Z', 'to': '2003-12-01T00:00:00.000Z'}], 'filings': {'recent': {'accessionNumber': ['9999999997-19-001641', '9999999997-18-001572', '9999999997-17-001149', '9999999997-16-017297', '9999999997-14-015381', '9999999997-13-017483', '9999999997-12-014875', '9999999997-12-014874', '9999999997-11-016770', '9999999997-11-001313', '9999999997-09-026971', '9999999997-08-046212', '9999999997-08-000770', '9999999997-06-047341', '9999999997-06-005878', '9999999997-04-046038', '9999999997-04-003957', '9999999997-03-043900', '9999999997-02-060211'], 'filingDate': ['2019-02-25', '2018-02-26', '2017-02-23', '2016-02-23', '2014-11-24', '2013-11-18', '2012-11-19', '2012-11-19', '2011-11-18', '2011-02-14', '2009-11-18', '2008-11-19', '2007-11-26', '2006-11-22', '2005-11-25', '2004-12-06', '2003-12-31', '2003-12-01', '2002-12-02'], 'reportDate': ['2018-12-31', '2017-12-31', '2016-12-31', '2015-12-31', '2014-09-30', '2013-09-30', '2012-09-30', '2012-09-30', '2011-09-30', '2010-09-30', '2009-09-30', '2008-09-30', '2007-09-30', '2006-09-30', '2005-09-30', '2004-09-30', '2003-09-30', '2003-09-30', '2002-09-30'], 'acceptanceDateTime': ['2019-03-20T12:58:59.000Z', '2018-03-06T10:36:50.000Z', '2017-02-28T08:51:28.000Z', '2016-02-24T13:43:47.000Z', '2014-12-01T10:29:53.000Z', '2013-12-18T16:55:29.000Z', '2012-11-27T18:21:56.000Z', '2012-11-27T18:20:34.000Z', '2011-11-18T14:50:18.000Z', '2011-02-24T12:07:48.000Z', '2009-11-27T08:54:55.000Z', '2008-11-24T15:14:15.000Z', '2008-01-07T09:51:10.000Z', '2006-11-30T12:15:54.000Z', '2006-02-21T17:05:58.000Z', '2004-12-09T15:30:28.000Z', '2004-02-03T18:40:57.000Z', '2003-12-04T15:04:46.000Z', '2002-12-10T15:54:02.000Z'], 'act': ['34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '', '', ''], 'form': ['X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'FOCUSN', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5/A', 'X-17A-5', 'X-17A-5'], 'fileNumber': ['008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173', '008-12173'], 'filmNumber': ['19005683', '18000917', '17005564', '16003295', '14041916', '13026240', '12062875', '12063001', '11023462', '11015614', '09042751', '08033059', '07008533', '06051171', '05044201', '04013363', '03051553', '03052562', '02053945'], 'items': ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], 'size': [1670, 1656, 1645, 1616, 1622, 1622, 1622, 1619, 1622, 2034, 2034, 2034, 2034, 2034, 2036, 2019, 1996, 1882, 1882], 'isXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'isInlineXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'primaryDocument': ['9999999997-19-001641.paper', '9999999997-18-001572.paper', '9999999997-17-001149.paper', '9999999997-16-017297.paper', '9999999997-14-015381.paper', '9999999997-13-017483.paper', '9999999997-12-014875.paper', '9999999997-12-014874.paper', '9999999997-11-016770.paper', '9999999997-11-001313.paper', '9999999997-09-026971.paper', '9999999997-08-046212.paper', '9999999997-08-000770.paper', '9999999997-06-047341.paper', '9999999997-06-005878.paper', '9999999997-04-046038.paper', '9999999997-04-003957.paper', '9999999997-03-043900.paper', '9999999997-02-060211.paper'], 'primaryDocDescription': ['AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT']}, 'files': []}}\n"
     ]
    }
   ],
   "source": [
    "import boto3\n",
    "import json\n",
    "\n",
    "# Define the S3 bucket and file path\n",
    "bucket_name = 'aws-json-from-website'\n",
    "file_key = 'jsonfile/CIK0000015470.json'\n",
    "\n",
    "# Create an S3 client\n",
    "s3 = boto3.client('s3')\n",
    "\n",
    "# Get the contents of the file\n",
    "response = s3.get_object(Bucket=bucket_name, Key=file_key)\n",
    "\n",
    "# Parse the contents of the file as JSON\n",
    "json_contents = json.loads(response['Body'].read())\n",
    "\n",
    "# Print the contents of the file\n",
    "print(json_contents)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'accessionNumber': ['0001047469-98-019874', '0001047469-98-017047', '0000080255-98-000360', '0001047469-98-013754', '0001047469-98-013585', '0000912938-98-000201', '0000912938-98-000194', '0000950134-98-001400', '0000950134-98-001213', '0000912938-98-000036', '0000315066-98-000172', '0000080255-98-000022', '0000054771-98-000008', '0000766524-98-000109', '0000950134-98-000056', '0000950134-97-009533', '0001047469-97-007966', '0001047469-97-007026', '0001047469-97-005123', '0001047469-97-004994', '0000950134-97-008530', '0000080255-97-000387', '0000950134-97-007729', '0000950134-97-007093', '0000950134-97-007019', '0000912057-97-028669', '0000912057-97-028661', '0000950134-97-003990', '0000315066-97-001517', '0000912938-97-000227', '0000766524-97-000319', '0000950134-97-000988', '0000315066-97-000694', '0000912938-97-000062', '0000766524-97-000015', '0000912057-97-001232', '0000054771-96-000005', '0000950134-96-006345', '0000950134-96-006245', '0000950134-96-005135', '0000912057-96-021531', '0000912057-96-020192', '0000950134-96-003537', '0000315066-96-001737', '0000912057-96-014050', '0000912057-96-013062', '0000912057-96-011994', '0000950134-96-001866', '0000950154-96-000044', '0000912938-96-000168', '0000950135-95-001680', '0000950135-95-000175'], 'filingDate': ['1998-05-13', '1998-04-29', '1998-04-06', '1998-04-03', '1998-04-02', '1998-03-17', '1998-03-17', '1998-02-19', '1998-02-13', '1998-02-11', '1998-02-09', '1998-02-05', '1998-01-28', '1998-01-21', '1998-01-06', '1997-12-23', '1997-12-16', '1997-12-08', '1997-11-17', '1997-11-14', '1997-11-14', '1997-11-07', '1997-10-28', '1997-09-29', '1997-09-25', '1997-08-21', '1997-08-20', '1997-05-15', '1997-05-09', '1997-03-10', '1997-03-07', '1997-02-13', '1997-02-12', '1997-02-11', '1997-01-28', '1997-01-17', '1996-12-18', '1996-11-18', '1996-11-14', '1996-09-30', '1996-09-30', '1996-09-12', '1996-07-15', '1996-07-10', '1996-07-08', '1996-06-25', '1996-06-10', '1996-05-13', '1996-02-22', '1996-02-13', '1995-08-10', '1995-02-13'], 'reportDate': ['', '', '', '1998-03-20', '', '', '', '1998-02-19', '1997-12-31', '', '', '', '', '', '1997-12-08', '1997-12-16', '', '', '', '1997-12-16', '1997-09-30', '', '1997-06-30', '1997-06-30', '1997-09-20', '', '1997-08-05', '1997-03-31', '', '', '', '1996-12-31', '', '', '', '', '', '1996-09-30', '1996-09-30', '1996-06-30', '1996-10-28', '1996-10-28', '', '', '1996-06-21', '', '', '1996-03-31', '', '', '', ''], 'acceptanceDateTime': ['1998-05-13T00:00:00.000Z', '1998-04-29T00:00:00.000Z', '1998-04-06T00:00:00.000Z', '1998-04-03T00:00:00.000Z', '1998-04-02T00:00:00.000Z', '1998-03-17T00:00:00.000Z', '1998-03-17T00:00:00.000Z', '1998-02-19T00:00:00.000Z', '1998-02-13T00:00:00.000Z', '1998-02-11T00:00:00.000Z', '1998-02-09T00:00:00.000Z', '1998-02-05T00:00:00.000Z', '1998-01-28T00:00:00.000Z', '1998-01-21T00:00:00.000Z', '1998-01-06T00:00:00.000Z', '1997-12-23T00:00:00.000Z', '1997-12-16T00:00:00.000Z', '1997-12-08T00:00:00.000Z', '1997-11-17T00:00:00.000Z', '1997-11-14T00:00:00.000Z', '1997-11-14T00:00:00.000Z', '1997-11-07T00:00:00.000Z', '1997-10-28T00:00:00.000Z', '1997-09-29T00:00:00.000Z', '1997-09-25T00:00:00.000Z', '1997-08-21T00:00:00.000Z', '1997-08-20T00:00:00.000Z', '1997-05-15T00:00:00.000Z', '1997-05-09T00:00:00.000Z', '1997-03-10T00:00:00.000Z', '1997-03-07T00:00:00.000Z', '1997-02-13T00:00:00.000Z', '1997-02-12T00:00:00.000Z', '1997-02-11T00:00:00.000Z', '1997-01-28T00:00:00.000Z', '1997-01-17T00:00:00.000Z', '1996-12-18T00:00:00.000Z', '1996-11-18T00:00:00.000Z', '1996-11-14T00:00:00.000Z', '1996-09-30T00:00:00.000Z', '1996-09-30T00:00:00.000Z', '1996-09-12T00:00:00.000Z', '1996-07-15T00:00:00.000Z', '1996-07-10T00:00:00.000Z', '1996-07-08T00:00:00.000Z', '1996-06-25T00:00:00.000Z', '1996-06-10T00:00:00.000Z', '1996-05-13T00:00:00.000Z', '1996-02-22T00:00:00.000Z', '1996-02-13T00:00:00.000Z', '1995-08-10T00:00:00.000Z', '1995-02-13T00:00:00.000Z'], 'act': ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], 'form': ['424B3', 'S-3/A', 'SC 13G/A', '8-K', 'S-3', 'SC 13G/A', 'SC 13G/A', '8-K', '10-Q', 'SC 13G/A', 'SC 13G/A', 'SC 13G/A', 'SC 13G', 'SC 13G/A', '8-K', '8-K', 'S-8', '424B3', 'S-4', 'DEF 14A', '10-Q', 'SC 13G', '10-K405/A', '10-K405', '8-K', '8-A12G', '8-K', '10-Q', 'SC 13G/A', 'SC 13G/A', 'SC 13G/A', '10-Q', 'SC 13G/A', 'SC 13G/A', 'SC 13G', '8-A12B', 'SC 13G', '10-Q/A', '10-Q', '10-K405', 'DEF 14A', 'PRE 14A', '424B2', 'SC 13G', '8-K', '424B4', 'S-3', '10-Q', 'SC 13G', 'SC 13G/A', 'SC 13G/A', 'SC 13G'], 'fileNumber': ['333-49301', '333-49301', '005-43971', '001-12665', '333-49301', '005-43971', '005-43971', '001-12665', '001-12665', '005-43971', '005-43971', '005-43971', '005-43971', '005-43971', '001-12665', '001-12665', '333-42385', '333-40351', '333-40351', '001-12665', '001-12665', '005-43971', '001-12665', '001-12665', '001-12665', '000-24782', '001-12665', '001-12665', '005-43971', '005-43971', '005-43971', '001-12665', '005-43971', '005-43971', '005-43971', '001-12665', '005-43971', '000-24782', '000-24782', '000-24782', '000-24782', '000-24782', '033-79394', '005-43971', '000-24782', '333-05639', '333-05639', '000-24782', '005-43971', '005-43971', '005-43971', '005-43971'], 'filmNumber': ['98618981', '98604705', '98587860', '98587484', '98586722', '98567105', '98566982', '98545568', '98540063', '98532033', '98525029', '98522494', '98514935', '98509923', '98501680', '97743682', '97739329', '97733684', '97722552', '97721384', '97718577', '97710161', '97702278', '97687835', '97685414', '97667334', '97667231', '97607027', '97599056', '97553189', '97552461', '97531375', '97525803', '97524081', '97511977', '97507545', '96682811', '96668113', '96665414', '96637155', '96636999', '96629397', '96595085', '96592888', '96592055', '96585228', '96579042', '96560908', '96524202', '96516560', '95560551', '95509405'], 'items': ['', '', '', '7,9', '', '', '', '5,7', '', '', '', '', '', '', '5,7', '2,7', '', '', '', '', '', '', '', '', '5,7', '', '5,7', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2,7', '', '', '', '', '', '', ''], 'size': [128999, 149375, 10367, 441869, 613961, 9152, 9152, 133488, 58918, 9182, 10092, 10308, 8129, 20424, 13124, 9936, 23906, 3560, 858458, 781860, 43402, 10361, 41249, 474641, 13522, 158914, 154178, 54714, 10452, 9174, 20668, 45897, 10553, 9176, 20627, 11793, 2213, 9264, 40004, 411638, 165373, 165785, 28863, 10514, 36086, 427121, 712884, 271761, 10058, 9025, 9345, 9781], 'isXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'isInlineXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'primaryDocument': ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], 'primaryDocDescription': ['424B3', 'S-3/A', '', '8-K', 'S-3', 'AFFILIATED COMPUTER SERVICES, INC.', 'AFFILIATED COMPUTER SERVICES, INC.', 'FORM 8-K', 'FORM 10-Q FOR QUARTER ENDED DECEMBER 31, 1997', 'AFFILIATED COMPUTER SERVICES, INC.', 'SCHEDULE 13G -2-14-98 - AFFILIATED COMPUTER SERVICES', '', '', 'MONTHLY 5% HOLDINGS REPORT', 'FORM 8-K FOR PERIOD ENDING 12/8/97', 'FORM 8-K', 'S-8', 'S-4 SUPPLEMENT', 'S-4', 'DEF 14A', 'FORM 10-Q FOR QUARTER ENDED 09/30/97', '', 'AMDMT NO. 1 TO ANNUAL REPORT ON FORM 10-K/A', 'FORM 10-K FOR YEAR ENDED JUNE 30, 1997', 'FORM 8-K', 'FORM 8-A', '8-K', 'FORM 10-Q FOR QUARTER ENDED MARCH 31, 1997', 'SCHEDULE 13G -05-10-97 - AFFILIATED COMPUTER SERVICES', 'AFFILIATED COMPUTER SERVICES, INC.', '5% MONTHLY HOLDINGS', 'FORM 10-Q FOR QUARTER ENDING DECEMBER 31, 1996', 'SCHEDULE 13G -02-14-97 - AFFILIATED COMPUTER SERVICES', 'AFFILIATED COMPUTER SERVICES, INC.', '5% MONTHLY HOLDINGS', '8-A12B', '', 'AMENDMENT TO FORM 10-Q FOR Q.E. SEPTEMBER 30, 1996', 'FORM 10-Q FOR QUARTER ENDED SEPTEMBER 30, 1996', 'FORM 10-K FOR YEAR ENDED JUNE 30, 1996', 'DEF 14A', 'PRE 14A', 'PROSPECTUS SUPPLEMENT', 'SCHEDULE 13G -7-10-96 - AFFILIATED COMPUTER SERVICES', 'FORM 8-K', '424B4', 'FORM S-3', 'FORM 10-Q FOR QUARTER ENDED MARCH 31, 1996', '', 'AFFILIATED COMPUTER SERVICES, INC.', 'AFFILIATED COMPUTER SERVICES, INC.', 'AFFILIATED COMPUTER SERVICES, INC.']}\n"
     ]
    }
   ],
   "source": [
    "import boto3\n",
    "import json\n",
    "\n",
    "# Define the S3 bucket and file path\n",
    "bucket_name = 'aws-json-from-website'\n",
    "file_key = 'jsonfile/CIK0000002135-submissions-001.json'\n",
    "\n",
    "# Create an S3 client\n",
    "s3 = boto3.client('s3')\n",
    "\n",
    "# Get the contents of the file\n",
    "response = s3.get_object(Bucket=bucket_name, Key=file_key)\n",
    "\n",
    "# Parse the contents of the file as JSON\n",
    "json_contents = json.loads(response['Body'].read())\n",
    "\n",
    "# Print the contents of the file\n",
    "print(json_contents)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      " \"cik\": \"2308\",\n",
      " \"entityType\": \"other\",\n",
      " \"sic\": \"3578\",\n",
      " \"sicDescription\": \"Calculating & Accounting Machines (No Electronic Computers)\",\n",
      " \"insiderTransactionForOwnerExists\": 0,\n",
      " \"insiderTransactionForIssuerExists\": 0,\n",
      " \"name\": \"ADDMASTER CORP\",\n",
      " \"tickers\": [],\n",
      " \"exchanges\": [],\n",
      " \"ein\": \"952239410\",\n",
      " \"description\": \"\",\n",
      " \"website\": \"\",\n",
      " \"investorWebsite\": \"\",\n",
      " \"category\": \"\",\n",
      " \"fiscalYearEnd\": \"0531\",\n",
      " \"stateOfIncorporation\": \"CA\",\n",
      " \"stateOfIncorporationDescription\": \"CA\",\n",
      " \"addresses\": {\n",
      "  \"mailing\": {\n",
      "   \"street1\": \"225 EAST HUNGTINGTON DRIVE\",\n",
      "   \"street2\": null,\n",
      "   \"city\": \"MONROVIA\",\n",
      "   \"stateOrCountry\": \"CA\",\n",
      "   \"zipCode\": \"91016\",\n",
      "   \"stateOrCountryDescription\": \"CA\"\n",
      "  },\n",
      "  \"business\": {\n",
      "   \"street1\": \"225 EAST HUNGTINGTON DRIVE\",\n",
      "   \"street2\": null,\n",
      "   \"city\": \"MONROVIA\",\n",
      "   \"stateOrCountry\": \"CA\",\n",
      "   \"zipCode\": \"91016\",\n",
      "   \"stateOrCountryDescription\": \"CA\"\n",
      "  }\n",
      " },\n",
      " \"phone\": \"6263582935\",\n",
      " \"flags\": \"\",\n",
      " \"formerNames\": [],\n",
      " \"filings\": {\n",
      "  \"recent\": {\n",
      "   \"accessionNumber\": [\n",
      "    \"0000902595-02-000043\",\n",
      "    \"0000902595-02-000031\"\n",
      "   ],\n",
      "   \"filingDate\": [\n",
      "    \"2002-05-03\",\n",
      "    \"2002-03-15\"\n",
      "   ],\n",
      "   \"reportDate\": [\n",
      "    \"\",\n",
      "    \"\"\n",
      "   ],\n",
      "   \"acceptanceDateTime\": [\n",
      "    \"2002-05-03T15:44:06.000Z\",\n",
      "    \"2002-03-15T00:00:00.000Z\"\n",
      "   ],\n",
      "   \"act\": [\n",
      "    \"\",\n",
      "    \"\"\n",
      "   ],\n",
      "   \"form\": [\n",
      "    \"SC 13D/A\",\n",
      "    \"SC 13D/A\"\n",
      "   ],\n",
      "   \"fileNumber\": [\n",
      "    \"005-78157\",\n",
      "    \"005-78157\"\n",
      "   ],\n",
      "   \"filmNumber\": [\n",
      "    \"02633560\",\n",
      "    \"02576561\"\n",
      "   ],\n",
      "   \"items\": [\n",
      "    \"\",\n",
      "    \"\"\n",
      "   ],\n",
      "   \"size\": [\n",
      "    11378,\n",
      "    17075\n",
      "   ],\n",
      "   \"isXBRL\": [\n",
      "    0,\n",
      "    0\n",
      "   ],\n",
      "   \"isInlineXBRL\": [\n",
      "    0,\n",
      "    0\n",
      "   ],\n",
      "   \"primaryDocument\": [\n",
      "    \"sc13d_a968701.txt\",\n",
      "    \"sc13da_958429-3.txt\"\n",
      "   ],\n",
      "   \"primaryDocDescription\": [\n",
      "    \"\",\n",
      "    \"SCHEDULE SC13D/A\"\n",
      "   ]\n",
      "  },\n",
      "  \"files\": []\n",
      " }\n",
      "}\n"
     ]
    }
   ],
   "source": [
    "bucket_name = 'aws-json-from-website'\n",
    "file_name = 'jsonfile/CIK0000002308.json'\n",
    "\n",
    "obj = s3.get_object(Bucket = bucket_name, Key = file_name)\n",
    "\n",
    "data1 = json.load(obj['Body'])\n",
    "\n",
    "print(json.dumps(data1, indent=1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Some packages we are going to use\n",
    "import pymongo\n",
    "import getpass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Amazon DocumentDB cluster endpoint:docdb1.cluster-c6zd23k986sf.us-east-2.docdb.amazonaws.com\n",
      "Amazon DocumentDB port:27017\n",
      "Username:sundar\n",
      "Password:········\n"
     ]
    }
   ],
   "source": [
    "# Prompt user for Amazon DocumentDB connection details and credentials\n",
    "docdb_host = input(\"Amazon DocumentDB cluster endpoint:\")\n",
    "docdb_port = input(\"Amazon DocumentDB port:\")\n",
    "username = input(\"Username:\")\n",
    "password = getpass.getpass(\"Password:\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Make a client connection to Amazon DocumentDB with the supplied connection detals and credentials\n",
    "pem_location = \"/home/ec2-user/SageMaker/rds-combined-ca-bundle.pem\"\n",
    "uri_str = \"mongodb://{username}:{password}@{docdb_host}:{docdb_port}/?ssl=true&tlsAllowInvalidCertificates=true&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false\"\n",
    "uri = uri_str.format(username=username, password=password, docdb_host=docdb_host, docdb_port=docdb_port, pem_location=pem_location)\n",
    "client = pymongo.MongoClient(uri)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'hosts': ['docdb1.c6zd23k986sf.us-east-2.docdb.amazonaws.com:27017'],\n",
       " 'setName': 'rs0',\n",
       " 'secondary': False,\n",
       " 'primary': 'docdb1.c6zd23k986sf.us-east-2.docdb.amazonaws.com:27017',\n",
       " 'me': 'docdb1.c6zd23k986sf.us-east-2.docdb.amazonaws.com:27017',\n",
       " 'electionId': ObjectId('7fffffff0000000000000002'),\n",
       " 'readOnly': False,\n",
       " 'lastWrite': {'opTime': {'ts': Timestamp(1678107618, 2), 't': 2},\n",
       "  'lastWriteDate': datetime.datetime(2023, 3, 6, 13, 0, 18)},\n",
       " 'ismaster': True,\n",
       " 'maxBsonObjectSize': 16777216,\n",
       " 'maxMessageSizeBytes': 48000000,\n",
       " 'maxWriteBatchSize': 100000,\n",
       " 'localTime': datetime.datetime(2023, 3, 6, 13, 0, 18),\n",
       " 'logicalSessionTimeoutMinutes': 30,\n",
       " 'maxWireVersion': 7,\n",
       " 'minWireVersion': 0,\n",
       " 'operationTime': Timestamp(1678107618, 2),\n",
       " 'ok': 1.0}"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Run a simple command to verify a connection\n",
    "#  This command will show cluster details for the Amazon DocumentDB cluster\n",
    "client[\"admin\"].command(\"ismaster\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "success\n"
     ]
    }
   ],
   "source": [
    "import json\n",
    "import os\n",
    "\n",
    "bucket_name = 'aws-json-from-website'\n",
    "folder_name = 'jsonfile/'\n",
    "\n",
    "db_name = \"awsdb\"  # database name\n",
    "coll_name = \"submission\"  # collection name\n",
    "\n",
    "# Get objects for the database and the collection\n",
    "db = client[db_name]\n",
    "coll = db[coll_name]\n",
    "\n",
    "# List all objects in the S3 folder\n",
    "result = s3.list_objects(Bucket=bucket_name, Prefix=folder_name)\n",
    "\n",
    "# Loop through each object in the S3 folder\n",
    "for content in result.get('Contents', []):\n",
    "    # Check if the object is a JSON file\n",
    "    if content['Key'].endswith('.json'):\n",
    "        # Get the object from S3 and load the JSON data\n",
    "        obj = s3.get_object(Bucket=bucket_name, Key=content['Key'])\n",
    "        data = json.load(obj['Body'])\n",
    "        \n",
    "        # Set the document ID to the filename without the extension\n",
    "        file_base_name = os.path.basename(content['Key'])\n",
    "        data['_id'] = os.path.splitext(file_base_name)[0]\n",
    "        \n",
    "        # Insert the document into the collection\n",
    "        coll.insert_one(data)\n",
    "        \n",
    "print('success')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['awsdb']"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "client.list_database_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['submission']"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "db.list_collection_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collection(Database(MongoClient(host=['docdb1.cluster-c6zd23k986sf.us-east-2.docdb.amazonaws.com:27017'], document_class=dict, tz_aware=False, connect=True, tlsallowinvalidcertificates=True, replicaset='rs0', readpreference='secondaryPreferred', retrywrites=False, tlsdisableocspendpointcheck=True, tls=True), 'awsdb'), 'submission.stats')\n"
     ]
    }
   ],
   "source": [
    "collection_info = coll.stats\n",
    "print(collection_info)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'_id': 'CIK0000002554', 'cik': '0000002554', 'entityType': 'other', 'sic': '', 'sicDescription': '', 'insiderTransactionForOwnerExists': 0, 'insiderTransactionForIssuerExists': 0, 'name': 'AEI SECURITIES, INC.', 'tickers': [], 'exchanges': [], 'ein': '410974576', 'description': '', 'website': '', 'investorWebsite': '', 'category': '', 'fiscalYearEnd': '1231', 'stateOfIncorporation': 'MN', 'stateOfIncorporationDescription': 'MN', 'addresses': {'mailing': {'street1': '1300 WELLS FARGO PLACE', 'street2': '30 SEVENTH STREET EAST', 'city': 'ST. PAUL', 'stateOrCountry': 'MN', 'zipCode': '55101-4901', 'stateOrCountryDescription': 'MN'}, 'business': {'street1': '1300 WELLS FARGO PLACE', 'street2': '30 SEVENTH STREET EAST', 'city': 'ST. PAUL', 'stateOrCountry': 'MN', 'zipCode': '55101-4901', 'stateOrCountryDescription': 'MN'}}, 'phone': '651-227-7333', 'flags': '', 'formerNames': [{'name': 'AEI SECURITIES INC                                      /BD', 'from': '2002-02-27T00:00:00.000Z', 'to': '2002-02-27T00:00:00.000Z'}], 'filings': {'recent': {'accessionNumber': ['9999999997-22-001459', '9999999997-21-001784', '9999999997-20-001905', '9999999997-19-004058', '9999999997-18-002113', '9999999997-17-001814', '9999999997-16-018060', '9999999997-15-002319', '9999999997-14-002735', '9999999997-13-002587', '9999999997-12-003041', '9999999997-11-001586', '9999999997-10-002931', '9999999997-09-006939', '9999999997-08-008872', '9999999997-07-011738', '9999999997-06-013997', '9999999997-05-009548', '9999999997-04-009591', '9999999997-03-008401', '9999999997-02-012356'], 'filingDate': ['2022-02-25', '2021-03-01', '2020-03-02', '2019-03-01', '2018-02-27', '2017-02-28', '2016-02-26', '2015-02-27', '2014-02-27', '2013-02-28', '2012-02-28', '2011-02-15', '2010-02-25', '2009-02-27', '2008-02-27', '2007-02-27', '2006-02-24', '2005-02-25', '2004-02-25', '2003-02-27', '2002-02-27'], 'reportDate': ['2021-12-31', '2020-12-31', '2019-12-31', '2018-12-31', '2017-12-31', '2016-12-31', '2015-12-31', '2014-12-31', '2013-12-31', '2012-12-31', '2011-12-31', '2010-12-31', '2009-12-31', '2008-12-31', '2007-12-31', '2006-12-31', '2005-12-31', '2004-12-31', '2003-12-31', '2002-12-31', '2001-12-31'], 'acceptanceDateTime': ['2022-04-04T12:50:27.000Z', '2021-04-19T11:00:34.000Z', '2020-04-20T19:14:30.000Z', '2019-05-08T10:58:23.000Z', '2018-03-12T12:15:06.000Z', '2017-03-09T11:35:34.000Z', '2016-03-02T09:44:59.000Z', '2015-03-04T14:28:53.000Z', '2014-03-18T15:44:38.000Z', '2013-03-09T10:04:45.000Z', '2012-03-15T15:45:09.000Z', '2011-02-28T12:59:32.000Z', '2010-03-05T15:13:50.000Z', '2009-03-12T10:39:58.000Z', '2008-03-04T19:48:42.000Z', '2007-03-14T14:10:04.000Z', '2006-04-12T14:45:40.000Z', '2005-03-10T18:38:14.000Z', '2004-03-12T17:19:28.000Z', '2003-03-12T10:11:30.000Z', '2002-02-27T00:00:00.000Z'], 'act': ['34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '34', '', '', ''], 'form': ['X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5', 'X-17A-5'], 'fileNumber': ['008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750', '008-16750'], 'filmNumber': ['22003316', '21001265', '20008086', '19008067', '18001298', '17005067', '16003170', '15046786', '14046975', '13013232', '12013150', '11015639', '10029220', '09058311', '08026426', '07003254', '06003729', '05037155', '04004495', '03001622', '02006420'], 'items': ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], 'size': [1628, 1628, 1628, 1628, 1628, 1617, 1588, 1594, 1594, 1594, 1594, 2006, 2006, 2006, 2006, 2006, 2006, 2006, 1977, 1999, 1862], 'isXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'isInlineXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'primaryDocument': ['9999999997-22-001459.paper', '9999999997-21-001784.paper', '9999999997-20-001905.paper', '9999999997-19-004058.paper', '9999999997-18-002113.paper', '9999999997-17-001814.paper', '9999999997-16-018060.paper', '9999999997-15-002319.paper', '9999999997-14-002735.paper', '9999999997-13-002587.paper', '9999999997-12-003041.paper', '9999999997-11-001586.paper', '9999999997-10-002931.paper', '9999999997-09-006939.paper', '9999999997-08-008872.paper', '9999999997-07-011738.paper', '9999999997-06-013997.paper', '9999999997-05-009548.paper', '9999999997-04-009591.paper', '9999999997-03-008401.paper', '9999999997-02-012356.paper'], 'primaryDocDescription': ['AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT', 'AUTO-GENERATED PAPER DOCUMENT']}, 'files': []}}\n"
     ]
    }
   ],
   "source": [
    "result = coll.find({'_id':'CIK0000002554'})\n",
    "for i in result:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'_id': 'CIK0000003197-submissions-001', 'accessionNumber': ['0000950131-02-004445', '0000950131-02-003831', '0000950131-02-003466', '0000950131-02-003054', '0000950131-02-002053', '0000950131-02-002032', '0000950131-02-001819', '0000950131-02-001242', '0000950131-02-001241', '9999999997-02-018790', '0000891554-02-001267', '0000950116-02-000046', '0000950116-02-000025', '0000950116-01-501194', '0000950116-01-501111', '0000950116-01-500998', '0000950116-01-500984', '0000950116-01-500806', '0000950116-01-500728', '0000950116-01-500610', '0000950116-01-500176', '0000950116-01-000611', '0000950116-01-000609', '0000950116-01-000606', '0000950116-01-000605', '0000950116-01-000604', '0000950116-01-000585', '0000950116-01-000287', '0000950116-00-002721', '0000950116-00-002567', '0000950116-00-002487', '0000950116-00-002446', '0000950116-00-001880', '0000950116-00-001630', '0000950116-00-001297', '0000950116-00-001231', '0000950116-00-000694', '0000950116-00-000619', '0000950116-00-000393', '0000950116-00-000314', '0000950116-99-002311', '0000950116-99-002123', '0000950116-99-001889', '0000950116-99-001776', '0000950116-99-001775', '0000950116-99-001689', '0000950116-99-001563', '0000950116-99-001438', '0000950116-99-001004', '0000950116-99-000570', '0000950116-99-000117', '0000950116-98-002410', '0000950116-98-002131', '0000950116-98-001930', '0000950116-98-001879', '0000950116-98-001669', '0000950116-98-001062', '0000950116-98-001034', '0000950116-98-000684', '0000950116-98-000447', '0000950116-98-000184', '0000950116-97-002263', '0000950116-97-002046', '0000950116-97-001922', '0000950116-97-001921', '0000950116-97-001920', '0000950116-97-001870', '0000950116-97-001447', '0000950116-97-001179', '0000950116-97-001174', '0000950116-97-000921', '0000950116-97-000541', '0000950137-96-002483', '0000950137-96-002482', '0000950137-96-002480', '0000950116-96-001261', '0000950137-96-001462', '0000950137-96-000715', '0000950137-96-000406', '0000950137-96-000031', '0000950124-95-003711', '0000950124-95-003484', '0000950124-95-002827', '0000950124-95-002505'], 'filingDate': ['2002-11-14', '2002-10-09', '2002-09-09', '2002-08-09', '2002-05-15', '2002-05-15', '2002-05-06', '2002-03-28', '2002-03-28', '2002-03-21', '2002-03-15', '2002-01-15', '2002-01-07', '2001-11-27', '2001-11-13', '2001-10-23', '2001-10-18', '2001-09-13', '2001-08-20', '2001-08-09', '2001-05-15', '2001-04-05', '2001-04-05', '2001-04-05', '2001-04-05', '2001-04-05', '2001-04-03', '2001-02-21', '2000-11-14', '2000-10-24', '2000-10-05', '2000-09-29', '2000-08-11', '2000-07-11', '2000-05-18', '2000-05-15', '2000-03-30', '2000-03-24', '2000-02-29', '2000-02-17', '1999-12-22', '1999-11-15', '1999-10-18', '1999-09-22', '1999-09-22', '1999-09-03', '1999-08-13', '1999-08-02', '1999-05-14', '1999-03-30', '1999-01-29', '1998-12-10', '1998-11-02', '1998-09-28', '1998-09-17', '1998-08-13', '1998-05-11', '1998-05-07', '1998-03-30', '1998-02-20', '1998-01-30', '1997-12-08', '1997-11-12', '1997-10-22', '1997-10-22', '1997-10-22', '1997-10-10', '1997-08-11', '1997-06-17', '1997-06-16', '1997-05-14', '1997-03-25', '1996-12-04', '1996-12-04', '1996-12-04', '1996-11-12', '1996-08-14', '1996-05-15', '1996-03-29', '1996-01-26', '1995-11-13', '1995-10-31', '1995-09-06', '1995-08-14'], 'reportDate': ['2002-09-30', '2002-11-11', '2002-11-11', '2002-06-30', '2002-03-31', '', '', '', '2001-12-31', '', '', '2001-12-31', '', '2001-12-03', '2001-09-30', '', '', '2001-11-05', '2001-06-30', '2001-06-30', '2001-03-31', '2000-12-31', '2000-09-30', '2000-06-30', '2000-03-31', '1999-12-31', '2000-12-31', '', '2000-09-30', '2000-11-22', '', '2000-09-29', '2000-06-30', '', '', '2000-03-31', '1999-12-31', '', '', '1999-12-07', '1999-12-07', '1999-09-30', '1999-11-16', '', '', '', '1999-06-30', '', '1999-03-31', '1998-12-31', '', '', '1998-09-30', '', '', '1998-06-30', '1998-03-31', '', '1997-12-31', '1998-02-18', '', '1997-09-25', '1997-09-30', '', '', '', '1997-09-25', '1997-06-30', '', '1997-06-12', '1997-03-31', '1996-12-31', '', '', '1996-11-21', '1996-09-30', '1996-06-30', '1996-03-31', '1995-12-31', '1996-01-16', '1995-09-30', '', '', '1995-06-30'], 'acceptanceDateTime': ['2002-11-14T12:20:28.000Z', '2002-10-09T15:43:30.000Z', '2002-09-09T13:20:38.000Z', '2002-08-09T17:26:19.000Z', '2002-05-15T15:57:22.000Z', '2002-05-15T13:33:43.000Z', '2002-05-06T14:11:53.000Z', '2002-03-28T00:00:00.000Z', '2002-03-28T00:00:00.000Z', '2002-03-21T00:00:00.000Z', '2002-03-15T00:00:00.000Z', '2002-01-15T00:00:00.000Z', '2002-01-07T00:00:00.000Z', '2001-11-27T00:00:00.000Z', '2001-11-13T00:00:00.000Z', '2001-10-23T00:00:00.000Z', '2001-10-18T00:00:00.000Z', '2001-09-13T00:00:00.000Z', '2001-08-20T00:00:00.000Z', '2001-08-09T00:00:00.000Z', '2001-05-15T00:00:00.000Z', '2001-04-05T00:00:00.000Z', '2001-04-05T00:00:00.000Z', '2001-04-05T00:00:00.000Z', '2001-04-05T00:00:00.000Z', '2001-04-05T00:00:00.000Z', '2001-04-03T00:00:00.000Z', '2001-02-21T00:00:00.000Z', '2000-11-14T00:00:00.000Z', '2000-10-24T00:00:00.000Z', '2000-10-05T00:00:00.000Z', '2000-09-29T00:00:00.000Z', '2000-08-11T00:00:00.000Z', '2000-07-11T00:00:00.000Z', '2000-05-18T00:00:00.000Z', '2000-05-15T00:00:00.000Z', '2000-03-30T00:00:00.000Z', '2000-03-24T00:00:00.000Z', '2000-02-29T00:00:00.000Z', '2000-02-17T00:00:00.000Z', '1999-12-22T00:00:00.000Z', '1999-11-15T00:00:00.000Z', '1999-10-18T00:00:00.000Z', '1999-09-22T00:00:00.000Z', '1999-09-22T00:00:00.000Z', '1999-09-03T00:00:00.000Z', '1999-08-13T00:00:00.000Z', '1999-08-02T00:00:00.000Z', '1999-05-14T00:00:00.000Z', '1999-03-30T00:00:00.000Z', '1999-01-29T00:00:00.000Z', '1998-12-10T00:00:00.000Z', '1998-11-02T00:00:00.000Z', '1998-09-28T00:00:00.000Z', '1998-09-17T00:00:00.000Z', '1998-08-13T00:00:00.000Z', '1998-05-11T00:00:00.000Z', '1998-05-07T00:00:00.000Z', '1998-03-30T00:00:00.000Z', '1998-02-20T00:00:00.000Z', '1998-01-30T00:00:00.000Z', '1997-12-08T00:00:00.000Z', '1997-11-12T00:00:00.000Z', '1997-10-22T00:00:00.000Z', '1997-10-22T00:00:00.000Z', '1997-10-22T00:00:00.000Z', '1997-10-10T00:00:00.000Z', '1997-08-11T00:00:00.000Z', '1997-06-17T00:00:00.000Z', '1997-06-16T00:00:00.000Z', '1997-05-14T00:00:00.000Z', '1997-03-25T00:00:00.000Z', '1996-12-04T00:00:00.000Z', '1996-12-04T00:00:00.000Z', '1996-12-04T00:00:00.000Z', '1996-11-12T00:00:00.000Z', '1996-08-14T00:00:00.000Z', '1996-05-15T00:00:00.000Z', '1996-03-29T00:00:00.000Z', '1996-01-26T00:00:00.000Z', '1995-11-13T00:00:00.000Z', '1995-10-31T00:00:00.000Z', '1995-09-06T00:00:00.000Z', '1995-08-14T00:00:00.000Z'], 'act': ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], 'form': ['10-Q', 'DEF 14A', 'PRE 14A', '10-Q', '10-Q', '424B3', 'S-1/A', 'S-1', '10-K405', 'REGDEX/A', 'SC 13G', '8-K', 'SC 13D', 'DEF 14A', '10QSB', 'PRER14A', 'PRER14A', 'PRE 14A', '10QSB', 'NT 10-Q', '10-Q', '10KSB', '10QSB/A', '10QSB/A', '10QSB/A', '10KSB/A', 'NT 10-K', 'SC 13D', '10QSB', 'DEF 14A', 'SC 13D/A', '8-K', '10QSB', 'SC 13D/A', 'SC 13D/A', '10QSB', '10KSB', 'S-8', 'SC 13D/A', '8-K/A', '8-K', '10QSB', 'DEF 14A', 'S-8 POS', 'S-8', 'SC 13D', '10QSB', 'SC 13D', '10-Q', '10KSB', 'SC 13D', 'S-8', '10QSB', 'SC 13D', 'S-8', '10QSB', '10QSB', 'S-8', '10KSB', '8-K', 'SC 13D', '8-K/A', '10QSB', 'SC 13D/A', 'SC 13D', 'SC 13D/A', '8-K', '10QSB', 'SC 13D', '8-K', '10QSB', '10KSB', 'SC 13D/A', 'SC 13D/A', '8-K', '10QSB', '10-Q', '10QSB', '10KSB', '10-C', '10QSB', 'SC 13D', 'S-8', '10QSB'], 'fileNumber': ['000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '333-85146', '333-85146', '333-85146', '000-07099', '021-00319-7B', '005-19763', '000-07099', '005-19763', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '005-19763', '000-07099', '000-07099', '', '000-07099', '000-07099', '', '005-19763', '000-07099', '000-07099', '333-33270', '', '000-07099', '000-07099', '000-07099', '000-07099', '333-87559', '333-87559', '005-19763', '000-07099', '', '000-07099', '000-07099', '005-19763', '333-68651', '000-07099', '005-19763', '333-63571', '000-07099', '000-07099', '333-52111', '000-07099', '000-07099', '005-19763', '000-07099', '000-07099', '005-19763', '005-19763', '', '000-07099', '000-07099', '', '000-07099', '000-07099', '000-07099', '', '005-19763', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '000-07099', '', '033-62377', '000-07099'], 'filmNumber': ['02823130', '02785140', '02759372', '02725491', '02652180', '02650353', '02634850', '02591838', '02591780', '02025779', '02575500', '2509264', '2503381', '1799441', '1782150', '1764522', '1761537', '1736044', '1718935', '1701442', '1634997', '1596112', '1596070', '1595981', '1595921', '1595866', '1594410', '1550984', '764442', '744485', '', '732770', '694319', '', '639498', '634616', '586802', '578515', '', '548084', '99778801', '99756854', '99729846', '99715285', '99715224', '99706230', '99689770', '', '99622420', '99579086', '99516852', '98766920', '98735938', '98715884', '98710838', '98684806', '98615886', '98613057', '98578408', '98546290', '98518251', '97734142', '97714343', '97699061', '97699025', '', '97694077', '97655015', '', '97624800', '97603516', '97561939', '', '96675618', '96675593', '96658070', '96613564', '96566613', '96541382', '96507606', '95590207', '', '95570541', '95562372'], 'items': ['', '', '', '', '', '', '', '', '', '06', '', '5,7', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '4,7', '', '', '', '', '', '', '', '2', '2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '9', '', '7', '', '', '', '', '2,5,7', '', '', '9', '', '', '', '', '9', '', '', '', '', '', '', '', '', ''], 'size': [59082, 74221, 77439, 43924, 40369, 306248, 338661, 331407, 567279, 1872, 17464, 150486, 30971, 104319, 45813, 103841, 128544, 123799, 46163, 7318, 36207, 554582, 64212, 59417, 57288, 285767, 7552, 25015, 55702, 52361, 37749, 7283, 56143, 38299, 33640, 54725, 278642, 49701, 42024, 231383, 919117, 56614, 83789, 6289, 40080, 33990, 53926, 51715, 48525, 592730, 19323, 113242, 46510, 18159, 38884, 44868, 42694, 23490, 425816, 4995, 18111, 78895, 49670, 14151, 16035, 36645, 7830, 38412, 36539, 5012, 35151, 185653, 36443, 28694, 4878, 40182, 34083, 34301, 140485, 5904, 37953, 16485, 24721, 40837], 'isXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'isInlineXBRL': [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], 'primaryDocument': ['d10q.txt', 'ddef14a.txt', 'dpre14a.txt', 'd10q.txt', 'd10q.txt', 'd424b3.txt', 'ds1a.txt', 'ds1.txt', 'd10k405.txt', '9999999997-02-018790.paper', 'd50008_13g.txt', 'eightk.txt', 'sc13d.txt', 'def14a.txt', 'tenqsb.txt', 'prer14a.txt', 'prer14a.txt', 'pre14a.txt', 'tenqsb.txt', 'nt10q.txt', 'ten-q.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '0001.txt', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], 'primaryDocDescription': ['FORM 10-Q', 'DEFINITIVE NOTICE & PROXY STATEMENT', 'PRELIMINARY PROXY STATEMENT', 'FORM 10-Q', 'FORM 10-Q', 'FORM 424(B)(3)', 'AMENDMENT NO. 1 TO FORM S-1', 'FORM S-1', 'FORM 10-K', 'AUTO-GENERATED PAPER DOCUMENT', 'SCHEDULE 13G', '8-K', 'SC 13D', 'DEF 14A', '10QSB', 'PRER14A', 'PRER14A', 'PRE 14A', '10QSB', 'NT10Q.TXT', '10-Q', '', '', '10QSB/A', '10QSB/A', 'FORM 10KSB/A', 'NT 10-K', 'SCHEDULE 13D', '', 'DEFINITIVE PROXY', '', '8-K', '10QSB', 'FORM SC 133/A', '', '', '', 'S-8', '', '8-K/A', '8-K', '10QSB', 'FORM DEF 14A', 'S-8 POS', 'FORM S-8', '', '', '', '', '', '', 'FORM S-8', 'FORM 10-QSB', '', 'FORM S-8', '', 'FORM 10-QSB', 'FORM S-8', '', 'FORM 8-K', '', '', '', '', 'SCHEDULE 13D', '', 'FORM 8-K', '', '', 'FORM 8-K', 'FORM 10-QSB', '', 'AMEND. NO. 13 TO SC 13D', 'AMEND. NO. 3 TO SC 13D', 'FORM 8-K', 'FORM 10-QSB', 'FORM 10-Q', 'FORM 10-QSB', 'FORM 10KSB', '10-C', 'FORM 10QSB', 'SCHEDULE 13D', 'FORM S-8', 'FORM 10QSB']}\n"
     ]
    }
   ],
   "source": [
    "result = coll.find({'_id':'CIK0000003197-submissions-001'})\n",
    "for i in result:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}