Title: Guiding and Establishing National Innovation for U.S. Stablecoins (GENIUS) Act
Vote to pass a bill that establishes regulations over payment stablecoins, and for other purposes.
Establishes regulations over payment stablecoins, other digital assets, and for other purposes (Sec. 2-18).
Establishes a regulatory framework for payment stablecoins (digital assets which an issuer must redeem for a fixed value) (Sec. 2-18).
Specifies that only permitted issuers may issue a payment stablecoin for use by U.S. persons, subject to certain exceptions and safe harbors. Permitted issuers must be a subsidiary of an insured depository institution, a federal-qualified nonbank payment stablecoin issuer, or a state-qualified payment stablecoin issuer (Sec. 2-18).
Requires that permitted issuers must be regulated by the appropriate federal or state regulator. Permitted issuers may choose federal or state regulation; however, state regulation is limited to those with a stablecoin issuance of $10 billion or less (Sec. 2-18).
Specifies that permitted issuers must maintain reserves backing the stablecoin on a one-to-one basis using U.S. currency or other similarly liquid assets (Sec. 2-18).
Specifies permitted issuers must also publicly disclose their redemption policy and publish monthly the details of their reserves (Sec. 2-18).
Specifies requirements for (Sec. 2-18):
Reusing reserves;
Providing safekeeping services for stablecoins; and
Supervisory, examination, and enforcement authority over federal-qualified issuers.
Authorizes foreign issuers of stablecoins to offer, sell, or make available in the United States stablecoins using digital asset service providers, subject to requirements, including a determination by the Department of the Treasury that they are subject to comparable foreign regulations (Sec. 2-18).
Specifies that permitted payment stablecoins are not considered securities under securities law. However, permitted issuers are subject to the Bank Secrecy Act for anti-money laundering and related purposes (Sec. 2-18).
Defines “digital assets” as any digital representation of value that is recorded on a cryptographically secured distributed ledger (Sec. 2-18).
Specifies that the provisions of this bill shall take effect 18 months after the enactment date of this bill (Sec. 19).
Title: Guiding and Establishing National Innovation for U.S. Stablecoins (GENIUS) Act
Vote to pass a bill that establishes regulations over payment stablecoins, and for other purposes.
Establishes regulations over payment stablecoins, other digital assets, and for other purposes (Sec. 2-18).
Establishes a regulatory framework for payment stablecoins (digital assets which an issuer must redeem for a fixed value) (Sec. 2-18).
Specifies that only permitted issuers may issue a payment stablecoin for use by U.S. persons, subject to certain exceptions and safe harbors. Permitted issuers must be a subsidiary of an insured depository institution, a federal-qualified nonbank payment stablecoin issuer, or a state-qualified payment stablecoin issuer (Sec. 2-18).
Requires that permitted issuers must be regulated by the appropriate federal or state regulator. Permitted issuers may choose federal or state regulation; however, state regulation is limited to those with a stablecoin issuance of $10 billion or less (Sec. 2-18).
Specifies that permitted issuers must maintain reserves backing the stablecoin on a one-to-one basis using U.S. currency or other similarly liquid assets (Sec. 2-18).
Specifies permitted issuers must also publicly disclose their redemption policy and publish monthly the details of their reserves (Sec. 2-18).
Specifies requirements for (Sec. 2-18):
Reusing reserves;
Providing safekeeping services for stablecoins; and
Supervisory, examination, and enforcement authority over federal-qualified issuers.
Authorizes foreign issuers of stablecoins to offer, sell, or make available in the United States stablecoins using digital asset service providers, subject to requirements, including a determination by the Department of the Treasury that they are subject to comparable foreign regulations (Sec. 2-18).
Specifies that permitted payment stablecoins are not considered securities under securities law. However, permitted issuers are subject to the Bank Secrecy Act for anti-money laundering and related purposes (Sec. 2-18).
Defines “digital assets” as any digital representation of value that is recorded on a cryptographically secured distributed ledger (Sec. 2-18).
Specifies that the provisions of this bill shall take effect 18 months after the enactment date of this bill (Sec. 19).
Title: Guiding and Establishing National Innovation for U.S. Stablecoins (GENIUS) Act
Vote to invoke cloture on a bill that establishes regulations over payment stablecoins, and for other purposes.
Establishes regulations over payment stablecoins, other digital assets, and for other purposes (Sec. 2-18).
Establishes a regulatory framework for payment stablecoins (digital assets which an issuer must redeem for a fixed value) (Sec. 2-18).
Specifies that only permitted issuers may issue a payment stablecoin for use by U.S. persons, subject to certain exceptions and safe harbors. Permitted issuers must be a subsidiary of an insured depository institution, a federal-qualified nonbank payment stablecoin issuer, or a state-qualified payment stablecoin issuer (Sec. 2-18).
Requires that permitted issuers must be regulated by the appropriate federal or state regulator. Permitted issuers may choose federal or state regulation; however, state regulation is limited to those with a stablecoin issuance of $10 billion or less (Sec. 2-18).
Specifies that permitted issuers must maintain reserves backing the stablecoin on a one-to-one basis using U.S. currency or other similarly liquid assets (Sec. 2-18).
Specifies permitted issuers must also publicly disclose their redemption policy and publish monthly the details of their reserves (Sec. 2-18).
Specifies requirements for (Sec. 2-18):
Reusing reserves;
Providing safekeeping services for stablecoins; and
Supervisory, examination, and enforcement authority over federal-qualified issuers.
Authorizes foreign issuers of stablecoins to offer, sell, or make available in the United States stablecoins using digital asset service providers, subject to requirements, including a determination by the Department of the Treasury that they are subject to comparable foreign regulations (Sec. 2-18).
Specifies that permitted payment stablecoins are not considered securities under securities law. However, permitted issuers are subject to the Bank Secrecy Act for anti-money laundering and related purposes (Sec. 2-18).
Defines “digital assets” as any digital representation of value that is recorded on a cryptographically secured distributed ledger (Sec. 2-18).
Specifies that the provisions of this bill shall take effect 18 months after the enactment date of this bill (Sec. 19).
NOTE: INVOKING CLOTURE REQUIRES A 3/5 MAJORITY OF THE SENATE. IT IS NOT A VOTE ON THE PASSAGE OF THE PIECE OF LEGISLATION, BUT LIMITS FURTHER DEBATE TO 30 HOURS. CLOTURE IS TYPICALLY USED TO END A FILIBUSTER. A FAILED CLOTURE VOTE OFTEN PREVENTS THE LEGISLATION FROM EVER COMING TO A VOTE.
Title: Guiding and Establishing National Innovation for U.S. Stablecoins (GENIUS) Act
Vote to invoke cloture on a bill that establishes regulations over payment stablecoins, and for other purposes.
Establishes regulations over payment stablecoins, other digital assets, and for other purposes (Sec. 2-18).
Establishes a regulatory framework for payment stablecoins (digital assets which an issuer must redeem for a fixed value) (Sec. 2-18).
Specifies that only permitted issuers may issue a payment stablecoin for use by U.S. persons, subject to certain exceptions and safe harbors. Permitted issuers must be a subsidiary of an insured depository institution, a federal-qualified nonbank payment stablecoin issuer, or a state-qualified payment stablecoin issuer (Sec. 2-18).
Requires that permitted issuers must be regulated by the appropriate federal or state regulator. Permitted issuers may choose federal or state regulation; however, state regulation is limited to those with a stablecoin issuance of $10 billion or less (Sec. 2-18).
Specifies that permitted issuers must maintain reserves backing the stablecoin on a one-to-one basis using U.S. currency or other similarly liquid assets (Sec. 2-18).
Specifies permitted issuers must also publicly disclose their redemption policy and publish monthly the details of their reserves (Sec. 2-18).
Specifies requirements for (Sec. 2-18):
Reusing reserves;
Providing safekeeping services for stablecoins; and
Supervisory, examination, and enforcement authority over federal-qualified issuers.
Authorizes foreign issuers of stablecoins to offer, sell, or make available in the United States stablecoins using digital asset service providers, subject to requirements, including a determination by the Department of the Treasury that they are subject to comparable foreign regulations (Sec. 2-18).
Specifies that permitted payment stablecoins are not considered securities under securities law. However, permitted issuers are subject to the Bank Secrecy Act for anti-money laundering and related purposes (Sec. 2-18).
Defines “digital assets” as any digital representation of value that is recorded on a cryptographically secured distributed ledger (Sec. 2-18).
Specifies that the provisions of this bill shall take effect 18 months after the enactment date of this bill (Sec. 19).
NOTE: THIS VOTE IS SUBJECT TO A SPECIAL ORDER REQUIRING A 3/5 MAJORITY FOR PASSAGE.
Title: Guiding and Establishing National Innovation for U.S. Stablecoins (GENIUS) Act
Vote to invoke cloture on a bill that establishes regulations over payment stablecoins, and for other purposes.
Establishes regulations over payment stablecoins, other digital assets, and for other purposes (Sec. 2-18).
Establishes a regulatory framework for payment stablecoins (digital assets which an issuer must redeem for a fixed value) (Sec. 2-18).
Specifies that only permitted issuers may issue a payment stablecoin for use by U.S. persons, subject to certain exceptions and safe harbors. Permitted issuers must be a subsidiary of an insured depository institution, a federal-qualified nonbank payment stablecoin issuer, or a state-qualified payment stablecoin issuer (Sec. 2-18).
Requires that permitted issuers must be regulated by the appropriate federal or state regulator. Permitted issuers may choose federal or state regulation; however, state regulation is limited to those with a stablecoin issuance of $10 billion or less (Sec. 2-18).
Specifies that permitted issuers must maintain reserves backing the stablecoin on a one-to-one basis using U.S. currency or other similarly liquid assets (Sec. 2-18).
Specifies permitted issuers must also publicly disclose their redemption policy and publish monthly the details of their reserves (Sec. 2-18).
Specifies requirements for (Sec. 2-18):
Reusing reserves;
Providing safekeeping services for stablecoins; and
Supervisory, examination, and enforcement authority over federal-qualified issuers.
Authorizes foreign issuers of stablecoins to offer, sell, or make available in the United States stablecoins using digital asset service providers, subject to requirements, including a determination by the Department of the Treasury that they are subject to comparable foreign regulations (Sec. 2-18).
Specifies that permitted payment stablecoins are not considered securities under securities law. However, permitted issuers are subject to the Bank Secrecy Act for anti-money laundering and related purposes (Sec. 2-18).
Defines “digital assets” as any digital representation of value that is recorded on a cryptographically secured distributed ledger (Sec. 2-18).
Specifies that the provisions of this bill shall take effect 18 months after the enactment date of this bill (Sec. 19).
NOTE: INVOKING CLOTURE REQUIRES A 3/5 MAJORITY OF THE SENATE. IT IS NOT A VOTE ON THE PASSAGE OF THE PIECE OF LEGISLATION, BUT LIMITS FURTHER DEBATE TO 30 HOURS. CLOTURE IS TYPICALLY USED TO END A FILIBUSTER. A FAILED CLOTURE VOTE OFTEN PREVENTS THE LEGISLATION FROM EVER COMING TO A VOTE.
Title: Guiding and Establishing National Innovation for U.S. Stablecoins (GENIUS) Act
| Package | Name | Version |
|---|---|---|
| Django | 3.2.25 | |
| Python | 3.12.3 | |
| crispy_forms | Crispy_Forms | 2.0 |
| debug_toolbar | Debug Toolbar | 4.3.0 |
| rest_framework | Django REST framework | 3.15.1 |
| rest_framework_simplejwt | Rest_Framework_Simplejwt | 5.3.1 |
| tagging | Tagging | 0.5.0 |
| Resource | Value |
|---|---|
| User CPU time | 2142.960 msec |
| System CPU time | 18.291 msec |
| Total CPU time | 2161.251 msec |
| Elapsed time | 2185.568 msec |
| Context switches | 958 voluntary, 1343 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Setting | Value |
|---|---|
| ABSOLUTE_URL_OVERRIDES | {} |
| ADMINS | [] |
| ADMIN_ENABLED | False |
| ADMIN_MEDIA_PREFIX | '/static/admin/' |
| ALLOWED_DOCUMENT_EXTENSIONS | ('doc', 'docx', 'odt', 'pdf', 'txt', 'rtf') |
| ALLOWED_HOSTS | ['0.0.0.0',
'192.168.1.10',
'127.0.0.1',
'localhost',
'average-owl-21.loca.lt',
'0e3f-35-155-34-40.ngrok-free.app',
'j.futurefacts.votesmart.io',
'n.futurefacts.votesmart.io'] |
| API_ACCESS_KEY | '********************' |
| API_PROFILE | '********************' |
| API_SECRET_KEY | '********************' |
| APPEND_SLASH | True |
| APP_ROOT | '/var/www/justfacts/justfacts_project' |
| AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
| AUTH_PASSWORD_VALIDATORS | '********************' |
| AUTH_PROFILE_MODULE | 'misc.UserProfile' |
| AUTH_USER_MODEL | 'auth.User' |
| BANNED_EMAILS | [] |
| BASE_DIR | '/var/www/justfacts' |
| CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache',
'LOCATION': 'jwt-blacklist'}} |
| CACHE_CRP_TIMEOUT | 86400 |
| CACHE_MIDDLEWARE_ALIAS | 'default' |
| CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
| CACHE_MIDDLEWARE_SECONDS | 600 |
| CACHE_NIMSP_TIMEOUT | 86400 |
| CACHE_USE_ANYWAY | False |
| CORS_ALLOWED_ORIGINS | ['http://localhost:3000',
'http://127.0.0.1:3000',
'https://www.votesmart.org',
'http://n.futurefacts.votesmart.io:3000',
'http://n.futurefacts.votesmart.io',
'http://j.futurefacts.votesmart.io'] |
| CORS_ALLOW_CREDENTIALS | True |
| CORS_ALLOW_METHODS | ['GET', 'POST'] |
| CORS_ORIGIN_ALLOW_ALL | True |
| CRISPY_TEMPLATE_PACK | 'bootstrap4' |
| CSRF_COOKIE_AGE | 31449600 |
| CSRF_COOKIE_DOMAIN | None |
| CSRF_COOKIE_HTTPONLY | False |
| CSRF_COOKIE_NAME | 'csrftoken' |
| CSRF_COOKIE_PATH | '/' |
| CSRF_COOKIE_SAMESITE | 'Lax' |
| CSRF_COOKIE_SECURE | True |
| CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
| CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
| CSRF_TRUSTED_ORIGINS | [] |
| CSRF_USE_SESSIONS | False |
| DATABASES | {'default': {'ATOMIC_REQUESTS': False,
'AUTOCOMMIT': True,
'CONN_MAX_AGE': 0,
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': '52.27.7.38',
'NAME': 'pvsadmin',
'OPTIONS': {},
'PASSWORD': '********************',
'PORT': '5432',
'TEST': {'CHARSET': None,
'COLLATION': None,
'MIGRATE': True,
'MIRROR': None,
'NAME': None},
'TIME_ZONE': None,
'USER': 'web'}} |
| DATABASE_ROUTERS | [] |
| DATA_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| DATA_UPLOAD_MAX_NUMBER_FIELDS | 1000 |
| DATA_UPLOAD_MAX_NUMBER_FILES | 100 |
| DATETIME_FORMAT | 'N j, Y, P' |
| DATETIME_INPUT_FORMATS | ['%Y-%m-%d %H:%M:%S',
'%Y-%m-%d %H:%M:%S.%f',
'%Y-%m-%d %H:%M',
'%m/%d/%Y %H:%M:%S',
'%m/%d/%Y %H:%M:%S.%f',
'%m/%d/%Y %H:%M',
'%m/%d/%y %H:%M:%S',
'%m/%d/%y %H:%M:%S.%f',
'%m/%d/%y %H:%M'] |
| DATE_FORMAT | 'N j, Y' |
| DATE_INPUT_FORMATS | ['%Y-%m-%d',
'%m/%d/%Y',
'%m/%d/%y',
'%b %d %Y',
'%b %d, %Y',
'%d %b %Y',
'%d %b, %Y',
'%B %d %Y',
'%B %d, %Y',
'%d %B %Y',
'%d %B, %Y'] |
| DEBUG | True |
| DEBUG_PROPAGATE_EXCEPTIONS | False |
| DEBUG_TOOLBAR_CONFIG | {'SHOW_TOOLBAR_CALLBACK': <function <lambda> at 0x7e8dfd2eccc0>} |
| DEBUG_TOOLBAR_PANELS | ['debug_toolbar.panels.versions.VersionsPanel',
'debug_toolbar.panels.timer.TimerPanel',
'debug_toolbar.panels.settings.SettingsPanel',
'debug_toolbar.panels.headers.HeadersPanel',
'debug_toolbar.panels.request.RequestPanel',
'debug_toolbar.panels.sql.SQLPanel',
'debug_toolbar.panels.staticfiles.StaticFilesPanel',
'debug_toolbar.panels.templates.TemplatesPanel',
'debug_toolbar.panels.cache.CachePanel',
'debug_toolbar.panels.signals.SignalsPanel',
'debug_toolbar.panels.logging.LoggingPanel',
'debug_toolbar.panels.redirects.RedirectsPanel'] |
| DECIMAL_SEPARATOR | '.' |
| DEFAULT_AUTO_FIELD | 'django.db.models.AutoField' |
| DEFAULT_CHARSET | 'utf-8' |
| DEFAULT_EXCEPTION_REPORTER | 'django.views.debug.ExceptionReporter' |
| DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
| DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
| DEFAULT_FROM_EMAIL | 'webmaster@votesmart.org' |
| DEFAULT_HASHING_ALGORITHM | 'sha256' |
| DEFAULT_INDEX_TABLESPACE | '' |
| DEFAULT_TABLESPACE | '' |
| DISALLOWED_USER_AGENTS | [] |
| DONATE_ACCESS_KEY | '********************' |
| DONATE_CAPTCHA | True |
| DONATE_CLOSED | False |
| DONATE_PROFILE | 'WEBDONATE090622' |
| DONATE_SECRET_KEY | '********************' |
| ELECTION_CUTOFF | datetime.datetime(2025, 8, 20, 17, 27, 3, 867430) |
| ELECTION_SHORT_CUTOFF | datetime.datetime(2025, 12, 4, 17, 27, 3, 867441) |
| EMAIL_BACKEND | 'justfacts_project.email_backend.EmailBackend' |
| EMAIL_HOST | 'email-smtp.us-east-1.amazonaws.com' |
| EMAIL_HOST_PASSWORD | '********************' |
| EMAIL_HOST_USER | 'AKIAJZFXFJLPUOI3BUGQ' |
| EMAIL_PORT | 587 |
| EMAIL_SSL_CERTFILE | None |
| EMAIL_SSL_KEYFILE | '********************' |
| EMAIL_SUBJECT_PREFIX | '[Django] ' |
| EMAIL_TIMEOUT | None |
| EMAIL_USE_LOCALTIME | False |
| EMAIL_USE_SSL | False |
| EMAIL_USE_TLS | True |
| FACEBOOK_ACCESS_TOKEN | '********************' |
| FACEBOOK_API_SECRET | '********************' |
| FACEBOOK_APP_ID | '380926668611330' |
| FACEBOOK_AUTH_EXTRA_ARGUMENTS | {'scope': 'email,user_location'} |
| FACEBOOK_EXTENDED_PERMISSIONS | ['email', 'user_location', 'publish_actions'] |
| FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
| FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler',
'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
| FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| FILE_UPLOAD_PERMISSIONS | 420 |
| FILE_UPLOAD_TEMP_DIR | None |
| FIRST_DAY_OF_WEEK | 0 |
| FIXTURE_DIRS | [] |
| FORCE_SCRIPT_NAME | None |
| FORMAT_MODULE_PATH | None |
| FORM_RENDERER | 'django.forms.renderers.DjangoTemplates' |
| GOOGLE_ANALYTICS | {'google_analytics_id': 'UA-31404458-5'} |
| ICONTACT_AUTH | {'api_key': '********************',
'password': '********************',
'username': 'votesmart'} |
| IGNORABLE_404_URLS | [] |
| INSTALLED_APPS | ['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.sites',
'django.contrib.staticfiles',
'django.contrib.humanize',
'django.contrib.postgres',
'pypvs.apps.PypvsConfig',
'about.apps.AboutConfig',
'candidate.apps.CandidateConfig',
'government.apps.GovernmentConfig',
'offices.apps.OfficesConfig',
'misc.apps.MiscConfig',
'search.apps.SearchConfig',
'keyvotes.apps.KeyvotesConfig',
'elections.apps.ElectionsConfig',
'education.apps.EducationConfig',
'survey.apps.SurveyConfig',
'share.apps.ShareConfig',
'tracking.apps.TrackingConfig',
'vetoes.apps.VetoesConfig',
'vsjax.apps.VsjaxConfig',
'hoover.apps.HooverConfig',
'helpus.apps.HelpusConfig',
'blog.apps.BlogConfig',
'media.apps.MediaConfig',
'sidebysideAPI.apps.SidebysideapiConfig',
'nextfactsAPI.apps.NextfactsapiConfig',
'google_analytics',
'crispy_forms',
'crispy_bootstrap4',
'django_comments',
'tagging',
'debug_toolbar',
'corsheaders',
'rest_framework',
'rest_framework_simplejwt'] |
| INTERNAL_IP | ('127.0.0.1',) |
| INTERNAL_IPS | [] |
| IS_BSD | False |
| JWT_ACCESS_TTL | datetime.timedelta(seconds=900) |
| JWT_ALGORITHM | 'HS256' |
| JWT_COOKIE_NAME | 'access_token' |
| JWT_SECRET_KEY | '********************' |
| LANGUAGES | [('af', 'Afrikaans'),
('ar', 'Arabic'),
('ar-dz', 'Algerian Arabic'),
('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'),
('be', 'Belarusian'),
('bn', 'Bengali'),
('br', 'Breton'),
('bs', 'Bosnian'),
('ca', 'Catalan'),
('cs', 'Czech'),
('cy', 'Welsh'),
('da', 'Danish'),
('de', 'German'),
('dsb', 'Lower Sorbian'),
('el', 'Greek'),
('en', 'English'),
('en-au', 'Australian English'),
('en-gb', 'British English'),
('eo', 'Esperanto'),
('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'),
('eu', 'Basque'),
('fa', 'Persian'),
('fi', 'Finnish'),
('fr', 'French'),
('fy', 'Frisian'),
('ga', 'Irish'),
('gd', 'Scottish Gaelic'),
('gl', 'Galician'),
('he', 'Hebrew'),
('hi', 'Hindi'),
('hr', 'Croatian'),
('hsb', 'Upper Sorbian'),
('hu', 'Hungarian'),
('hy', 'Armenian'),
('ia', 'Interlingua'),
('id', 'Indonesian'),
('ig', 'Igbo'),
('io', 'Ido'),
('is', 'Icelandic'),
('it', 'Italian'),
('ja', 'Japanese'),
('ka', 'Georgian'),
('kab', 'Kabyle'),
('kk', 'Kazakh'),
('km', 'Khmer'),
('kn', 'Kannada'),
('ko', 'Korean'),
('ky', 'Kyrgyz'),
('lb', 'Luxembourgish'),
('lt', 'Lithuanian'),
('lv', 'Latvian'),
('mk', 'Macedonian'),
('ml', 'Malayalam'),
('mn', 'Mongolian'),
('mr', 'Marathi'),
('my', 'Burmese'),
('nb', 'Norwegian Bokmål'),
('ne', 'Nepali'),
('nl', 'Dutch'),
('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'),
('pa', 'Punjabi'),
('pl', 'Polish'),
('pt', 'Portuguese'),
('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'),
('ru', 'Russian'),
('sk', 'Slovak'),
('sl', 'Slovenian'),
('sq', 'Albanian'),
('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'),
('sw', 'Swahili'),
('ta', 'Tamil'),
('te', 'Telugu'),
('tg', 'Tajik'),
('th', 'Thai'),
('tk', 'Turkmen'),
('tr', 'Turkish'),
('tt', 'Tatar'),
('udm', 'Udmurt'),
('uk', 'Ukrainian'),
('ur', 'Urdu'),
('uz', 'Uzbek'),
('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')] |
| LANGUAGES_BIDI | ['he', 'ar', 'ar-dz', 'fa', 'ur'] |
| LANGUAGE_CODE | 'en-us' |
| LANGUAGE_COOKIE_AGE | None |
| LANGUAGE_COOKIE_DOMAIN | None |
| LANGUAGE_COOKIE_HTTPONLY | False |
| LANGUAGE_COOKIE_NAME | 'django_language' |
| LANGUAGE_COOKIE_PATH | '/' |
| LANGUAGE_COOKIE_SAMESITE | None |
| LANGUAGE_COOKIE_SECURE | False |
| LOCALE_PATHS | [] |
| LOGGING | {'disable_existing_loggers': False,
'handlers': {'file': {'class': 'logging.FileHandler',
'filename': '/var/www/justfacts/django_errors.log',
'level': 'ERROR'}},
'loggers': {'django': {'handlers': ['file'],
'level': 'ERROR',
'propagate': True}},
'version': 1} |
| LOGGING_CONFIG | 'logging.config.dictConfig' |
| LOGIN_ERROR_URL | '/login' |
| LOGIN_REDIRECT_URL | '/user' |
| LOGIN_URL | '/login' |
| LOGOUT_REDIRECT_URL | None |
| MANAGERS | [] |
| MEDIA_ROOT | '' |
| MEDIA_URL | '/' |
| MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
| MIDDLEWARE | ['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'misc.middleware.RedisConnectionPoolMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware',
'misc.middleware.MessagesMiddleware',
'corsheaders.middleware.CorsMiddleware',
'django.middleware.common.CommonMiddleware'] |
| MIGRATION_MODULES | {} |
| MONTH_DAY_FORMAT | 'F j' |
| NUMBER_GROUPING | 0 |
| PASSWORD_HASHERS | '********************' |
| PASSWORD_RESET_TIMEOUT | '********************' |
| PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
| PHOTO_URL | '//votesmart.org/canphoto/' |
| PREPEND_WWW | False |
| RECAPTCHA_PRIVATE_KEY | '********************' |
| RECAPTCHA_PUBLIC_KEY | '********************' |
| REDIS_HOST | '34.222.112.159' |
| REDIS_PORT | 6379 |
| REGISTRATION_OPEN | True |
| RELEASE_ID | 1 |
| REST_FRAMEWORK | {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework_simplejwt.authentication.JWTAuthentication',)} |
| ROOT_URLCONF | 'justfacts_project.urls' |
| SECRET_KEY | '********************' |
| SECURE_BROWSER_XSS_FILTER | False |
| SECURE_CONTENT_TYPE_NOSNIFF | True |
| SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
| SECURE_HSTS_PRELOAD | False |
| SECURE_HSTS_SECONDS | 0 |
| SECURE_PROXY_SSL_HEADER | None |
| SECURE_REDIRECT_EXEMPT | [] |
| SECURE_REFERRER_POLICY | 'same-origin' |
| SECURE_SSL_HOST | None |
| SECURE_SSL_REDIRECT | False |
| SECURITY_BRUTE_FORCE_KEY_PREFIX | '********************' |
| SECURITY_BRUTE_FORCE_TIMEOUT | 900 |
| SECURITY_BRUTE_FORCE_URL_PATTERN | 'check-key|check-user' |
| SECURITY_FORCE_PROTECTIONS | False |
| SECURITY_LOGIN_MAX_TRIES | 3 |
| SERVER_EMAIL | 'root@localhost' |
| SESSION_CACHE_ALIAS | 'default' |
| SESSION_COOKIE_AGE | 1209600 |
| SESSION_COOKIE_DOMAIN | None |
| SESSION_COOKIE_HTTPONLY | True |
| SESSION_COOKIE_NAME | 'sessionid' |
| SESSION_COOKIE_PATH | '/' |
| SESSION_COOKIE_SAMESITE | 'Lax' |
| SESSION_COOKIE_SECURE | True |
| SESSION_ENGINE | 'django.contrib.sessions.backends.signed_cookies' |
| SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
| SESSION_FILE_PATH | None |
| SESSION_SAVE_EVERY_REQUEST | False |
| SESSION_SERIALIZER | 'django.contrib.sessions.serializers.PickleSerializer' |
| SETTINGS_MODULE | 'justfacts_project.settings' |
| SHORT_DATETIME_FORMAT | 'm/d/Y P' |
| SHORT_DATE_FORMAT | 'm/d/Y' |
| SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
| SILENCED_SYSTEM_CHECKS | ['models.E007', 'fields.E311', 'fields.E903'] |
| SIMPLE_JWT | {'ACCESS_TOKEN_LIFETIME': '********************',
'REFRESH_TOKEN_LIFETIME': '********************'} |
| SITE_ID | 1 |
| SOCIAL_AUTH_BACKEND_ERROR_URL | '/login' |
| SOCIAL_AUTH_RAISE_EXCEPTIONS | False |
| STAFF_PHOTO_PATH | 'images/staff' |
| STATICFILES_DIRS | ['/var/www/justfacts/assets'] |
| STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
| STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
| STATIC_ROOT | '/var/www/justfacts/static/' |
| STATIC_URL | '/static/' |
| TEMPLATES | [{'APP_DIRS': True,
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': ['/var/www/justfacts/templates',
'/var/www/justfacts/sidebyside/sidebyside_react_app/'],
'OPTIONS': {'context_processors': ['django.template.context_processors.debug',
'django.template.context_processors.request',
'django.contrib.auth.context_processors.auth',
'django.contrib.messages.context_processors.messages']}}] |
| TESTING | False |
| TEST_NON_SERIALIZED_APPS | [] |
| TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
| THOUSAND_SEPARATOR | ',' |
| TIME_FORMAT | 'P' |
| TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
| TIME_ZONE | 'UTC' |
| TWITTER_CONSUMER_KEY | '********************' |
| TWITTER_CONSUMER_SECRET | '********************' |
| USE_I18N | True |
| USE_L10N | True |
| USE_THOUSAND_SEPARATOR | False |
| USE_TZ | False |
| USE_X_FORWARDED_HOST | False |
| USE_X_FORWARDED_PORT | False |
| WSGI_APPLICATION | 'justfacts_project.wsgi.application' |
| X_FRAME_OPTIONS | 'DENY' |
| YEAR_MONTH_FORMAT | 'F Y' |
| Key | Value |
|---|---|
| Accept | */* |
| Accept-Encoding | gzip, br, zstd, deflate |
| Cookie | => see Request panel |
| Host | j.futurefacts.votesmart.io |
| User-Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Key | Value |
|---|---|
| Content-Length | 109728 |
| Content-Type | text/html; charset=utf-8 |
| Vary | origin |
Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.
| Key | Value |
|---|---|
| CONTENT_LENGTH | |
| CONTENT_TYPE | |
| PATH_INFO | /bill/40147/112441/guiding-and-establishing-national-innovation-for-us-stablecoins-genius-act |
| QUERY_STRING | |
| REMOTE_ADDR | 216.73.216.136 |
| REQUEST_METHOD | GET |
| SCRIPT_NAME | |
| SERVER_NAME | j.futurefacts.votesmart.io |
| SERVER_PORT | 443 |
| SERVER_PROTOCOL | HTTP/1.1 |
| View function | Arguments | Keyword arguments | URL name |
|---|---|---|---|
keyvotes.views.keyVoteDetail |
() |
{'congressId': '40147', 'congstatusId': '112441'} |
key_vote_detail |
| Variable | Value |
|---|---|
'__utmmobile' |
'cf245c5a-0be3-421b-8cd4-9349e43ecece' |
'csrftoken' |
'W4UZam40HkHguHR4KxWw0Tm452CHLmLKXl34y996a7b82TbW4i6PmGpz3IdMHgUx' |
'sessionid' |
'gAWVGwAAAAAAAAB9lIwSZ2FfY2FtcGFpZ25fcGFyYW1zlH2Ucy4:1vYnNU:upx0fQcYE-hySc_fTO6qKcj5v-WBMHG2H7kdd4xSj1o' |
| Variable | Value |
|---|---|
'ga_campaign_params' |
{} |
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT (
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT ct.outcometext FROM congoutcometext ct JOIN congtools cts ON ct.congoutcometext_id = cts.congoutcometext_id AND cts.congstage_id = congstatus.congstage_id AND cts.conglevel_id = congstatus.conglevel_id AND cts.congtype_id = congress.congtype_id AND cts.congoutcome_id = congstatus.congoutcome_id ORDER BY cts.rank LIMIT 1 ) AS "outcometext", ( SELECT ca.name FROM congaction ca JOIN congstatus_candidate csc USING (congaction_id) WHERE csc.congstatus_id = congstatus.congstatus_id AND congstatus.conglevel_id = 'E' ) AS "specialaction", (ARRAY(SELECT s1cn.note FROM congnote s1cn JOIN congnote_congress s1cnc USING (congnote_id) WHERE s1cnc.congress_id = congress.congress_id)) AS "congressnote", (ARRAY(SELECT s2cn.note FROM congnote s2cn JOIN congnote_status s2cnc USING (congnote_id) WHERE s2cnc.congstatus_id = congstatus.congstatus_id)) AS "congstatusnote", ( SELECT true FROM congstatus_candidate csc JOIN congaction ca ON ca.congaction_id = csc.congaction_id WHERE congactiontype_id = 'V' AND csc.congstatus_id = congstatus.congstatus_id LIMIT 1 ) AS "keyvote", ( SELECT DISTINCT path FROM congvetotext cv JOIN congstatus_vetotext csv USING (congvetotext_id) WHERE csv.congstatus_id = congstatus.congstatus_id LIMIT 1 ) AS "vetotext", ( SELECT s7oc.office_candidate_id FROM congstatus_candidate s7csc JOIN congstatus s7cs USING (congstatus_id) JOIN office_candidate s7oc ON s7oc.office_candidate_id = s7csc.office_candidate_id WHERE s7csc.congstatus_id = congstatus.congstatus_id AND s7cs.conglevel_id = 'E' LIMIT 1 ) AS "executive", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus".keyvote, "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "congtype"."congtype_id", "congtype"."name", "state"."state_id", "state"."statetype_id", "state"."statecode", "state"."name", "state"."nickname", "state"."capital", "state"."area", "state"."population", "state"."statehood", "state"."motto", "state"."flower", "state"."tree", "state"."bird", "state"."high", "state"."low", "state"."type", "state"."legisname", "state"."ltgov", "state"."bicameral", "state"."lowername", "state"."senators", "state"."reps", "state"."termlimit", "state"."termlength", "state"."billurl", "state"."voteurl", "state"."registration", "state"."primarydate", "state"."generaldate", "state"."absenteewho", "state"."absenteehow", "state"."absenteewhen", "state"."largestcity", "state"."atlarge", "state"."ushousename", "state"."rollupper", "state"."rolllower", "state"."uscircuit", "state"."electoralvotes", "state"."caucus", "conglevel"."conglevel_id", "conglevel"."name", "conglevel"."rank", "congstage"."congstage_id", "congstage"."name", "congstage"."rank", "congstage"."voting", "congoutcome"."congoutcome_id", "congoutcome"."name", "congoutcome"."rank", "congtitle"."congtitle_id", "congtitle".title, "conghighlight"."conghighlight_id", "conghighlight"."highlight", "congsynopsis"."congsynopsis_id", "congsynopsis"."synopsis", "congtext"."congtext_id", "congtext"."congtext", "congtext"."path", "congtext"."name" FROM "congstatus" INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "congtype" ON ("congress"."congtype_id" = "congtype"."congtype_id") INNER JOIN "state" ON ("congress"."state_id" = "state"."state_id") INNER JOIN "conglevel" ON ("congstatus"."conglevel_id" = "conglevel"."conglevel_id") INNER JOIN "congstage" ON ("congstatus"."congstage_id" = "congstage"."congstage_id") LEFT OUTER JOIN "congoutcome" ON ("congstatus"."congoutcome_id" = "congoutcome"."congoutcome_id") LEFT OUTER JOIN "congtitle" ON ("congstatus"."congtitle_id" = "congtitle"."congtitle_id") LEFT OUTER JOIN "conghighlight" ON ("congstatus"."conghighlight_id" = "conghighlight"."conghighlight_id") LEFT OUTER JOIN "congsynopsis" ON ("congstatus"."congsynopsis_id" = "congsynopsis"."congsynopsis_id") LEFT OUTER JOIN "congtext" ON ("congstatus"."congtext_id" = "congtext"."congtext_id") WHERE ("congstatus"."congress_id" = 40147 AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."statusdate" DESC, "congstatus"."rank" DESC, "congstage"."rank" DESCSELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT ct.outcometext FROM congoutcometext ct JOIN congtools cts ON ct.congoutcometext_id = cts.congoutcometext_id AND cts.congstage_id = congstatus.congstage_id AND cts.conglevel_id = congstatus.conglevel_id AND cts.congtype_id = congress.congtype_id AND cts.congoutcome_id = congstatus.congoutcome_id ORDER BY cts.rank LIMIT 1) AS "outcometext", (SELECT ca.name FROM congaction ca JOIN congstatus_candidate csc USING (congaction_id) WHERE csc.congstatus_id = congstatus.congstatus_id AND congstatus.conglevel_id = 'E') AS "specialaction", (ARRAY(SELECT s1cn.note FROM congnote s1cn JOIN congnote_congress s1cnc USING (congnote_id) WHERE s1cnc.congress_id = congress.congress_id)) AS "congressnote", (ARRAY(SELECT s2cn.note FROM congnote s2cn JOIN congnote_status s2cnc USING (congnote_id) WHERE s2cnc.congstatus_id = congstatus.congstatus_id)) AS "congstatusnote", (SELECT true FROM congstatus_candidate csc JOIN congaction ca ON ca.congaction_id = csc.congaction_id WHERE congactiontype_id = 'V' AND csc.congstatus_id = congstatus.congstatus_id LIMIT 1) AS "keyvote", (SELECT DISTINCT path FROM congvetotext cv JOIN congstatus_vetotext csv USING (congvetotext_id) WHERE csv.congstatus_id = congstatus.congstatus_id LIMIT 1) AS "vetotext", (SELECT s7oc.office_candidate_id FROM congstatus_candidate s7csc JOIN congstatus s7cs USING (congstatus_id) JOIN office_candidate s7oc ON s7oc.office_candidate_id = s7csc.office_candidate_id WHERE s7csc.congstatus_id = congstatus.congstatus_id AND s7cs.conglevel_id = 'E' LIMIT 1) AS "executive", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus".keyvote, "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "congtype"."congtype_id", "congtype"."name", "state"."state_id", "state"."statetype_id", "state"."statecode", "state"."name", "state"."nickname", "state"."capital", "state"."area", "state"."population", "state"."statehood", "state"."motto", "state"."flower", "state"."tree", "state"."bird", "state"."high", "state"."low", "state"."type", "state"."legisname", "state"."ltgov", "state"."bicameral", "state"."lowername", "state"."senators", "state"."reps", "state"."termlimit", "state"."termlength", "state"."billurl", "state"."voteurl", "state"."registration", "state"."primarydate", "state"."generaldate", "state"."absenteewho", "state"."absenteehow", "state"."absenteewhen", "state"."largestcity", "state"."atlarge", "state"."ushousename", "state"."rollupper", "state"."rolllower", "state"."uscircuit", "state"."electoralvotes", "state"."caucus", "conglevel"."conglevel_id", "conglevel"."name", "conglevel"."rank", "congstage"."congstage_id", "congstage"."name", "congstage"."rank", "congstage"."voting", "congoutcome"."congoutcome_id", "congoutcome"."name", "congoutcome"."rank", "congtitle"."congtitle_id", "congtitle".title, "conghighlight"."conghighlight_id", "conghighlight"."highlight", "congsynopsis"."congsynopsis_id", "congsynopsis"."synopsis", "congtext"."congtext_id", "congtext"."congtext", "congtext"."path", "congtext"."name" FROM "congstatus" INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "congtype" ON ("congress"."congtype_id" = "congtype"."congtype_id") INNER JOIN "state" ON ("congress"."state_id" = "state"."state_id") INNER JOIN "conglevel" ON ("congstatus"."conglevel_id" = "conglevel"."conglevel_id") INNER JOIN "congstage" ON ("congstatus"."congstage_id" = "congstage"."congstage_id") LEFT OUTER JOIN "congoutcome" ON ("congstatus"."congoutcome_id" = "congoutcome"."congoutcome_id") LEFT OUTER JOIN "congtitle" ON ("congstatus"."congtitle_id" = "congtitle"."congtitle_id") LEFT OUTER JOIN "conghighlight" ON ("congstatus"."conghighlight_id" = "conghighlight"."conghighlight_id") LEFT OUTER JOIN "congsynopsis" ON ("congstatus"."congsynopsis_id" = "congsynopsis"."congsynopsis_id") LEFT OUTER JOIN "congtext" ON ("congstatus"."congtext_id" = "congtext"."congtext_id") WHERE ("congstatus"."congress_id" = 40147 AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."statusdate" DESC, "congstatus"."rank" DESC, "congstage"."rank" DESC |
27.03 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(448) for b in bill: |
|||||||||||||||||||||
|
SELECT (
SELECT appointed FROM office_state os WHERE os.office_id = office_candidate.office_id AND os.state_id = office_candidate.state_id ) AS "office_appointed", ( SELECT string_agg(name, ', ') FROM leadership JOIN leadership_candidate USING (leadership_id) WHERE leadership_candidate.office_candidate_id = office_candidate.office_candidate_id ) AS "leadership", (substring(pvs_office_party(office_candidate.office_candidate_id) from 1 for 1)) AS "party", "office_candidate"."office_candidate_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."officecandidatestatus_id", "candidate"."candidate_id", "candidate"."firstname", "candidate"."middlename", "candidate"."lastname", "candidate"."nickname", "candidate"."suffix", "candidate"."candidatepreferredname_id", "officecandidatestatus"."officecandidatestatus_id", "officecandidatestatus"."name", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "office_candidate" INNER JOIN "congstatus_candidate" ON ("office_candidate"."office_candidate_id" = "congstatus_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "candidate" ON ("office_candidate"."candidate_id" = "candidate"."candidate_id") INNER JOIN "officecandidatestatus" ON ("office_candidate"."officecandidatestatus_id" = "officecandidatestatus"."officecandidatestatus_id") WHERE ("congaction"."congactiontype_id" = 'S' AND "congstatus"."congress_id" = 40147 AND "congstatus"."release_id" >= 1) ORDER BY "congaction"."rank" ASC, "candidate"."lastname" ASCSELECT (SELECT appointed FROM office_state os WHERE os.office_id = office_candidate.office_id AND os.state_id = office_candidate.state_id) AS "office_appointed", (SELECT string_agg(name, ', ') FROM leadership JOIN leadership_candidate USING (leadership_id) WHERE leadership_candidate.office_candidate_id = office_candidate.office_candidate_id) AS "leadership", (substring(pvs_office_party(office_candidate.office_candidate_id) from 1 for 1)) AS "party", "office_candidate"."office_candidate_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."officecandidatestatus_id", "candidate"."candidate_id", "candidate"."firstname", "candidate"."middlename", "candidate"."lastname", "candidate"."nickname", "candidate"."suffix", "candidate"."candidatepreferredname_id", "officecandidatestatus"."officecandidatestatus_id", "officecandidatestatus"."name", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "office_candidate" INNER JOIN "congstatus_candidate" ON ("office_candidate"."office_candidate_id" = "congstatus_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "candidate" ON ("office_candidate"."candidate_id" = "candidate"."candidate_id") INNER JOIN "officecandidatestatus" ON ("office_candidate"."officecandidatestatus_id" = "officecandidatestatus"."officecandidatestatus_id") WHERE ("congaction"."congactiontype_id" = 'S' AND "congstatus"."congress_id" = 40147 AND "congstatus"."release_id" >= 1) ORDER BY "congaction"."rank" ASC, "candidate"."lastname" ASC |
20.04 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(546) for oc in sponsors: |
|||||||||||||||||||||
|
SELECT (
6 similar queries.
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 112441 AND "congstatus"."release_id" >= 1)SELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 112441 AND "congstatus"."release_id" >= 1) |
31.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
6 similar queries.
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 111219 AND "congstatus"."release_id" >= 1)SELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 111219 AND "congstatus"."release_id" >= 1) |
13.91 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
6 similar queries.
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 110944 AND "congstatus"."release_id" >= 1)SELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 110944 AND "congstatus"."release_id" >= 1) |
10.00 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
6 similar queries.
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 109804 AND "congstatus"."release_id" >= 1)SELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 109804 AND "congstatus"."release_id" >= 1) |
18.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
6 similar queries.
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 109444 AND "congstatus"."release_id" >= 1)SELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 109444 AND "congstatus"."release_id" >= 1) |
15.41 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
6 similar queries.
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 109443 AND "congstatus"."release_id" >= 1)SELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", (pvs_office_party(office_candidate.office_candidate_id)) AS "party", "congstatus_candidate"."congstatus_candidate_id", "congstatus_candidate"."congstatus_id", "congstatus_candidate"."office_candidate_id", "congstatus_candidate"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "congress"."congress_id", "congress"."parent_id", "congress"."congtype_id", "congress"."state_id", "congress"."release_id", "congress"."billnumber", "congress"."law", "congress"."url", "congress"."path", "office_candidate"."office_candidate_id", "office_candidate"."office_id", "office_candidate"."candidate_id", "office_candidate"."state_id", "office_candidate"."districtname_id", "office_candidate"."officecandidatestatus_id", "office_candidate"."local_id", "office_candidate"."termstart", "office_candidate"."termend", "office_candidate"."specialmsg", "office_candidate"."importid", "office_candidate"."lastelect", "office_candidate"."nextelect", "office_candidate"."firstelect", "office_candidate"."appointed", "office_candidate"."parent_id", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_candidate" INNER JOIN "congstatus" ON ("congstatus_candidate"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") INNER JOIN "office_candidate" ON ("congstatus_candidate"."office_candidate_id" = "office_candidate"."office_candidate_id") INNER JOIN "congaction" ON ("congstatus_candidate"."congaction_id" = "congaction"."congaction_id") WHERE ("congstatus_candidate"."congstatus_id" = 109443 AND "congstatus"."release_id" >= 1) |
8.81 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT DISTINCT (
SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."congtitle_id", "congress"."congress_id", "congress"."billnumber", "congtitle"."congtitle_id", "congtitle".title FROM "congstatus" INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") LEFT OUTER JOIN "congtitle" ON ("congstatus"."congtitle_id" = "congtitle"."congtitle_id") WHERE ("congress"."path" ~ '*.40147.*' AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."congress_id" ASCSELECT ••• FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."congtitle_id", "congress"."congress_id", "congress"."billnumber", "congtitle"."congtitle_id", "congtitle".title FROM "congstatus" INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") LEFT OUTER JOIN "congtitle" ON ("congstatus"."congtitle_id" = "congtitle"."congtitle_id") WHERE ("congress"."path" ~ '*.40147.*' AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."congress_id" ASC |
14.36 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(646) return HttpResponse(template.render(context, request)) /usr/local/lib/python3.12/dist-packages/django/template/backends/django.py in render(61) return self.template.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(170) return self._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /usr/local/lib/python3.12/dist-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /usr/local/lib/python3.12/dist-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)),
/var/www/justfacts/templates/keyvotes/detail.html |
|||||||||||||||||||||
|
SELECT COUNT(*)
FROM ( SELECT DISTINCT ON ("congstatus"."congress_id") ( SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1 ) AS "title", ( SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id ) AS "outcometext", "congstatus"."congstatus_id" AS Col1, "congstatus"."congress_id" AS Col2, "congstatus"."congtitle_id" AS Col3 FROM "congstatus" INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") WHERE ("congress"."path" ~ '*.40147.*' AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."congress_id" ASC ) subquerySELECT COUNT(*) FROM (SELECT DISTINCT ON ("congstatus"."congress_id") (SELECT ct.title FROM congtitle ct JOIN congstatus cs USING (congtitle_id) WHERE cs.congress_id = congstatus.congress_id AND cs.statusdate <= congstatus.statusdate AND (ct.title != '' and ct.title is not null) ORDER BY cs.statusdate DESC LIMIT 1) AS "title", (SELECT cot.outcometext FROM congoutcometext cot JOIN congtools ct USING (congoutcometext_id) WHERE ct.congtype_id = congress.congtype_id AND ct.conglevel_id = congstatus.conglevel_id AND ct.congstage_id = congstatus.congstage_id AND ct.congoutcome_id = congstatus.congoutcome_id) AS "outcometext", "congstatus"."congstatus_id" AS Col1, "congstatus"."congress_id" AS Col2, "congstatus"."congtitle_id" AS Col3 FROM "congstatus" INNER JOIN "congress" ON ("congstatus"."congress_id" = "congress"."congress_id") WHERE ("congress"."path" ~ '*.40147.*' AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."congress_id" ASC) subquery |
15.18 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(646) return HttpResponse(template.render(context, request)) /usr/local/lib/python3.12/dist-packages/django/template/backends/django.py in render(61) return self.template.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(170) return self._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(308) match = condition.eval(context) /usr/local/lib/python3.12/dist-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /usr/local/lib/python3.12/dist-packages/django/template/smartif.py in <lambda>(95) 'and': infix(7, lambda context, x, y: x.eval(context) and y.eval(context)), /usr/local/lib/python3.12/dist-packages/django/template/smartif.py in eval(58) return func(context, self.first, self.second) /usr/local/lib/python3.12/dist-packages/django/template/smartif.py in <lambda>(103) '>': infix(10, lambda context, x, y: x.eval(context) > y.eval(context)), /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in eval(892) return self.value.resolve(context, ignore_failures=True) /usr/local/lib/python3.12/dist-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in _resolve_lookup(858) current = current()
/var/www/justfacts/templates/keyvotes/detail.html |
|||||||||||||||||||||
|
SELECT DISTINCT 0 AS category_id,
new_category_id, name, description FROM congstatus cs JOIN congcategory_category ccc USING (congcategory_id) JOIN v_category_resolve vc USING (category_id) WHERE cs.congress_id = 40147SELECT DISTINCT 0 AS category_id, new_category_id, name, description FROM congstatus cs JOIN congcategory_category ccc USING (congcategory_id) JOIN v_category_resolve vc USING (category_id) WHERE cs.congress_id = 40147 |
8.78 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(646) return HttpResponse(template.render(context, request)) /usr/local/lib/python3.12/dist-packages/django/template/backends/django.py in render(61) return self.template.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(170) return self._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(171) len_values = len(values)
/var/www/justfacts/templates/keyvotes/detail.html |
|||||||||||||||||||||
|
SELECT "category"."category_id",
2 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 82 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 82 LIMIT 21 |
14.95 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(646) return HttpResponse(template.render(context, request)) /usr/local/lib/python3.12/dist-packages/django/template/backends/django.py in render(61) return self.template.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(170) return self._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(240) compare_to = [var.resolve(context, ignore_failures=True) for var in self._varlist] /usr/local/lib/python3.12/dist-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/var/www/justfacts/templates/keyvotes/detail.html |
|||||||||||||||||||||
|
SELECT "category"."category_id",
2 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 84 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 84 LIMIT 21 |
3.02 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(646) return HttpResponse(template.render(context, request)) /usr/local/lib/python3.12/dist-packages/django/template/backends/django.py in render(61) return self.template.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(170) return self._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(214) nodelist.append(node.render_annotated(context)) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(240) compare_to = [var.resolve(context, ignore_failures=True) for var in self._varlist] /usr/local/lib/python3.12/dist-packages/django/template/base.py in resolve(671) obj = self.var.resolve(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in resolve(796) value = self._resolve_lookup(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in _resolve_lookup(837) current = getattr(current, bit)
/var/www/justfacts/templates/keyvotes/detail.html |
|||||||||||||||||||||
|
SELECT "congstatus_committee"."congstatus_committee_id",
"congstatus_committee"."congstatus_id", "congstatus_committee"."committee_id", "congstatus_committee"."congaction_id", "congstatus"."congstatus_id", "congstatus"."congress_id", "congstatus"."conglevel_id", "congstatus"."congstage_id", "congstatus"."congoutcome_id", "congstatus"."congofficialtitle_id", "congstatus"."congtitle_id", "congstatus"."conghighlight_id", "congstatus"."congsynopsis_id", "congstatus"."congcategory_id", "congstatus"."congofficialsynopsis_id", "congstatus"."congtext_id", "congstatus"."congdocgroup_id", "congstatus"."release_id", "congstatus"."rank", "congstatus"."statusdate", "congstatus"."rollnumber", "congstatus"."yea", "congstatus"."nay", "congstatus"."voicevote", "congstatus"."keyvote", "committee"."committee_id", "committee"."parent_id", "committee"."state_id", "committee"."committeetype_id", "committee"."name", "committee"."address1", "committee"."address2", "committee"."zip", "committee"."phone", "committee"."fax", "committee"."email", "committee"."url", "committee"."staffcontact", "committee"."jurisdiction", "committee"."city", "committee"."state", "committee"."active", "committee"."special", "congaction"."congaction_id", "congaction"."congactiontype_id", "congaction"."name", "congaction"."rank", "congaction"."code" FROM "congstatus_committee" INNER JOIN "congaction" ON ("congstatus_committee"."congaction_id" = "congaction"."congaction_id") INNER JOIN "congstatus" ON ("congstatus_committee"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "committee" ON ("congstatus_committee"."committee_id" = "committee"."committee_id") WHERE ("congstatus_committee"."congaction_id" IN ('S', 'C', 'B') AND "congstatus"."congress_id" = 40147) ORDER BY "congaction"."rank" ASC, "committee"."name" ASCSELECT ••• FROM "congstatus_committee" INNER JOIN "congaction" ON ("congstatus_committee"."congaction_id" = "congaction"."congaction_id") INNER JOIN "congstatus" ON ("congstatus_committee"."congstatus_id" = "congstatus"."congstatus_id") INNER JOIN "committee" ON ("congstatus_committee"."committee_id" = "committee"."committee_id") WHERE ("congstatus_committee"."congaction_id" IN ('S', 'C', 'B') AND "congstatus"."congress_id" = 40147) ORDER BY "congaction"."rank" ASC, "committee"."name" ASC |
9.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /var/www/justfacts/misc/middleware.py in __call__(50) return self.get_response(request) /usr/local/lib/python3.12/dist-packages/corsheaders/middleware.py in __call__(56) result = self.get_response(request) /var/www/justfacts/keyvotes/views.py in keyVoteDetail(646) return HttpResponse(template.render(context, request)) /usr/local/lib/python3.12/dist-packages/django/template/backends/django.py in render(61) return self.template.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(170) return self._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(150) return compiled_parent._render(context) /usr/local/lib/python3.12/dist-packages/django/test/utils.py in instrumented_test_render(100) return self.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/loader_tags.py in render(62) result = block.nodelist.render(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render(938) bit = node.render_annotated(context) /usr/local/lib/python3.12/dist-packages/django/template/base.py in render_annotated(905) return self.render(context) /usr/local/lib/python3.12/dist-packages/django/template/defaulttags.py in render(314) if match:
/var/www/justfacts/templates/keyvotes/detail.html |
|||||||||||||||||||||
| Path | Location |
|---|---|
| .DS_Store | /var/www/justfacts/assets/.DS_Store |
| .well-known/apple-developer-merchantid-domain-association | /var/www/justfacts/assets/.well-known/apple-developer-merchantid-domain-association |
| pdfs/Mobile_Messaging_Terms_and_conditions.pdf | /var/www/justfacts/assets/pdfs/Mobile_Messaging_Terms_and_conditions.pdf |
| pdfs/CNIP-signed-bylaws-2023.pdf | /var/www/justfacts/assets/pdfs/CNIP-signed-bylaws-2023.pdf |
| pdfs/PolicyforFundraisingandGiftAcceptance_1.3_Edition.pdf | /var/www/justfacts/assets/pdfs/PolicyforFundraisingandGiftAcceptance_1.3_Edition.pdf |
| pdfs/CNIP2018.pdf | /var/www/justfacts/assets/pdfs/CNIP2018.pdf |
| pdfs/CNIP2019.pdf | /var/www/justfacts/assets/pdfs/CNIP2019.pdf |
| pdfs/2021/162017-Vote Smart-Brochure-Proof.pdf | /var/www/justfacts/assets/pdfs/2021/162017-Vote Smart-Brochure-Proof.pdf |
| pdfs/2021/990-2021.pdf | /var/www/justfacts/assets/pdfs/2021/990-2021.pdf |
| pdfs/2020/CNIP2020.pdf | /var/www/justfacts/assets/pdfs/2020/CNIP2020.pdf |
| pdfs/2020/Vote-Smart-FY21-Audit-Report-Final-Signed.pdf | /var/www/justfacts/assets/pdfs/2020/Vote-Smart-FY21-Audit-Report-Final-Signed.pdf |
| pdfs/2020/VoteSmartbrochure.pdf | /var/www/justfacts/assets/pdfs/2020/VoteSmartbrochure.pdf |
| pdfs/forcandidates/2023_states/2023_New_Jersey_State_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/2023_states/2023_New_Jersey_State_PCT.pdf |
| pdfs/forcandidates/2023_states/2023_Mississippi_State_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/2023_states/2023_Mississippi_State_PCT.pdf |
| pdfs/forcandidates/2023_states/2023_Virginia_State_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/2023_states/2023_Virginia_State_PCT.pdf |
| pdfs/forcandidates/2023_states/2023_Kentucky_State_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/2023_states/2023_Kentucky_State_PCT.pdf |
| pdfs/forcandidates/2023_states/2023_Louisiana_State_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/2023_states/2023_Louisiana_State_PCT.pdf |
| pdfs/forcandidates/states/2022_MS_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MS_PCT.pdf |
| pdfs/forcandidates/states/2022_IN_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_IN_PCT.pdf |
| pdfs/forcandidates/states/2022_AL_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_AL_PCT.pdf |
| pdfs/forcandidates/states/2022_WY_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_WY_PCT.pdf |
| pdfs/forcandidates/states/2022_NY_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NY_PCT.pdf |
| pdfs/forcandidates/states/2022_NJ_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NJ_PCT.pdf |
| pdfs/forcandidates/states/2022_SC_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_SC_PCT.pdf |
| pdfs/forcandidates/states/2022_MA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MA_PCT.pdf |
| pdfs/forcandidates/states/2022_NM_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NM_PCT.pdf |
| pdfs/forcandidates/states/2022_NB_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NB_PCT.pdf |
| pdfs/forcandidates/states/2022_MD_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MD_PCT.pdf |
| pdfs/forcandidates/states/2022_MO_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MO_PCT.pdf |
| pdfs/forcandidates/states/2022_MINN_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MINN_PCT.pdf |
| pdfs/forcandidates/states/2022_AZ_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_AZ_PCT.pdf |
| pdfs/forcandidates/states/2022_PA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_PA_PCT.pdf |
| pdfs/forcandidates/states/2022_OK_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_OK_PCT.pdf |
| pdfs/forcandidates/states/2022_OH_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_OH_PCT.pdf |
| pdfs/forcandidates/states/2022_NV_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NV_PCT.pdf |
| pdfs/forcandidates/states/2022_WA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_WA_PCT.pdf |
| pdfs/forcandidates/states/2022_FL_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_FL_PCT.pdf |
| pdfs/forcandidates/states/2022_MI_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MI_PCT.pdf |
| pdfs/forcandidates/states/2022_CO_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_CO_PCT.pdf |
| pdfs/forcandidates/states/2022_OR_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_OR_PCT.pdf |
| pdfs/forcandidates/states/2022_VA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_VA_PCT.pdf |
| pdfs/forcandidates/states/2022_WV_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_WV_PCT.pdf |
| pdfs/forcandidates/states/2022_ME_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_ME_PCT.pdf |
| pdfs/forcandidates/states/2022_NH_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NH_PCT.pdf |
| pdfs/forcandidates/states/2022_AR_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_AR_PCT.pdf |
| pdfs/forcandidates/states/2022_ND_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_ND_PCT.pdf |
| pdfs/forcandidates/states/2022_TN_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_TN_PCT.pdf |
| pdfs/forcandidates/states/2022_CT_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_CT_PCT.pdf |
| pdfs/forcandidates/states/2022_IL_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_IL_PCT.pdf |
| pdfs/forcandidates/states/2022_ID_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_ID_PCT.pdf |
| pdfs/forcandidates/states/2022_GA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_GA_PCT.pdf |
| pdfs/forcandidates/states/2022_DE_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_DE_PCT.pdf |
| pdfs/forcandidates/states/2022_KS_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_KS_PCT.pdf |
| pdfs/forcandidates/states/2022_CA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_CA_PCT.pdf |
| pdfs/forcandidates/states/2022_SD_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_SD_PCT.pdf |
| pdfs/forcandidates/states/2022_UT_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_UT_PCT.pdf |
| pdfs/forcandidates/states/2022_KY_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_KY_PCT.pdf |
| pdfs/forcandidates/states/2022_NC_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_NC_PCT.pdf |
| pdfs/forcandidates/states/2022_TX_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_TX_PCT.pdf |
| pdfs/forcandidates/states/2022_MISS_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_MISS_PCT.pdf |
| pdfs/forcandidates/states/2022_VT_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_VT_PCT.pdf |
| pdfs/forcandidates/states/2022_IA_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_IA_PCT.pdf |
| pdfs/forcandidates/states/2022_HI_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_HI_PCT.pdf |
| pdfs/forcandidates/states/2022_AK_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_AK_PCT.pdf |
| pdfs/forcandidates/states/2022_WI_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_WI_PCT.pdf |
| pdfs/forcandidates/states/2022_RI_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/states/2022_RI_PCT.pdf |
| pdfs/forcandidates/congressional/2022_Congressional_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/congressional/2022_Congressional_PCT.pdf |
| pdfs/forcandidates/congressional/2024_Federal_PCT.pdf | /var/www/justfacts/assets/pdfs/forcandidates/congressional/2024_Federal_PCT.pdf |
| pdfs/about/3-Conflict-of-Interest-Policy.pdf | /var/www/justfacts/assets/pdfs/about/3-Conflict-of-Interest-Policy.pdf |
| pdfs/about/Amended-bylaws-2023.pdf | /var/www/justfacts/assets/pdfs/about/Amended-bylaws-2023.pdf |
| pdfs/about/Conflict-of-Interest-Policy.pdf | /var/www/justfacts/assets/pdfs/about/Conflict-of-Interest-Policy.pdf |
| images/candidate/Bull-Logo-Drk-Blue.png | /var/www/justfacts/assets/images/candidate/Bull-Logo-Drk-Blue.png |
| images/candidate/Bull-Logo-Drk-Blue_cropped.png | /var/www/justfacts/assets/images/candidate/Bull-Logo-Drk-Blue_cropped.png |
| images/homepage/seal-1.png | /var/www/justfacts/assets/images/homepage/seal-1.png |
| images/homepage/US-VOTING-BOOTH.png | /var/www/justfacts/assets/images/homepage/US-VOTING-BOOTH.png |
| images/homepage/VS-Side-By-Side-Checkmark-LRG.png | /var/www/justfacts/assets/images/homepage/VS-Side-By-Side-Checkmark-LRG.png |
| images/homepage/vs-facts-logo-2017.png | /var/www/justfacts/assets/images/homepage/vs-facts-logo-2017.png |
| images/homepage/VOTESMART_Iterations 2.png | /var/www/justfacts/assets/images/homepage/VOTESMART_Iterations 2.png |
| images/homepage/WebsiteRedesignAdSquareDesktop.png | /var/www/justfacts/assets/images/homepage/WebsiteRedesignAdSquareDesktop.png |
| images/homepage/vote-smart-logo-final_icon-color.png | /var/www/justfacts/assets/images/homepage/vote-smart-logo-final_icon-color.png |
| images/homepage/seal-2.png | /var/www/justfacts/assets/images/homepage/seal-2.png |
| images/homepage/donate-bg.png | /var/www/justfacts/assets/images/homepage/donate-bg.png |
| images/homepage/vote-smart-logo-final_icon-color.jpg | /var/www/justfacts/assets/images/homepage/vote-smart-logo-final_icon-color.jpg |
| images/homepage/votesmartlogfinalprimarycolor.png | /var/www/justfacts/assets/images/homepage/votesmartlogfinalprimarycolor.png |
| images/homepage/Bull-Adsquare-desktop_16-9_resize.png | /var/www/justfacts/assets/images/homepage/Bull-Adsquare-desktop_16-9_resize.png |
| images/homepage/Three-Star-Rating-Badge-Full-Color.png | /var/www/justfacts/assets/images/homepage/Three-Star-Rating-Badge-Full-Color.png |
| images/homepage/adsquare_announcement.png | /var/www/justfacts/assets/images/homepage/adsquare_announcement.png |
| images/helpus/JohananTaiHeadshot.jpg | /var/www/justfacts/assets/images/helpus/JohananTaiHeadshot.jpg |
| images/helpus/Carousel3.jpg | /var/www/justfacts/assets/images/helpus/Carousel3.jpg |
| images/helpus/bg-help.png | /var/www/justfacts/assets/images/helpus/bg-help.png |
| images/helpus/NIMSPlogo.png | /var/www/justfacts/assets/images/helpus/NIMSPlogo.png |
| images/helpus/Carousel2.jpg | /var/www/justfacts/assets/images/helpus/Carousel2.jpg |
| images/helpus/Carousel1.jpg | /var/www/justfacts/assets/images/helpus/Carousel1.jpg |
| images/helpus/intern-spotlight-carousel.png | /var/www/justfacts/assets/images/helpus/intern-spotlight-carousel.png |
| images/helpus/internship-spotlight-headshot.jpg | /var/www/justfacts/assets/images/helpus/internship-spotlight-headshot.jpg |
| images/helpus/Makala.jpeg | /var/www/justfacts/assets/images/helpus/Makala.jpeg |
| images/general/star-spangled-header-background.png | /var/www/justfacts/assets/images/general/star-spangled-header-background.png |
| images/general/myvs.png | /var/www/justfacts/assets/images/general/myvs.png |
| images/general/btn-star-spangles-1-resized.png | /var/www/justfacts/assets/images/general/btn-star-spangles-1-resized.png |
| images/general/capitol-background.png | /var/www/justfacts/assets/images/general/capitol-background.png |
| images/general/FTM_resized_new_logo.png | /var/www/justfacts/assets/images/general/FTM_resized_new_logo.png |
| images/general/btn-star-spangles-2-resized-60.png | /var/www/justfacts/assets/images/general/btn-star-spangles-2-resized-60.png |
| images/general/voteeasy_2018.png | /var/www/justfacts/assets/images/general/voteeasy_2018.png |
| images/general/ISPY-logo.png | /var/www/justfacts/assets/images/general/ISPY-logo.png |
| images/general/os_logo.jpg | /var/www/justfacts/assets/images/general/os_logo.jpg |
| images/general/ispy_logo.png | /var/www/justfacts/assets/images/general/ispy_logo.png |
| images/general/onpoint-btn.png | /var/www/justfacts/assets/images/general/onpoint-btn.png |
| images/general/logo-anniversary-200x200.png | /var/www/justfacts/assets/images/general/logo-anniversary-200x200.png |
| images/general/btn-star-spangles-3-resized.png | /var/www/justfacts/assets/images/general/btn-star-spangles-3-resized.png |
| images/general/btn-star-spangles-1.png | /var/www/justfacts/assets/images/general/btn-star-spangles-1.png |
| images/general/btn-star-spangles-3-resized-40.png | /var/www/justfacts/assets/images/general/btn-star-spangles-3-resized-40.png |
| images/general/pg.png | /var/www/justfacts/assets/images/general/pg.png |
| images/general/star-spangled-banner-image-cropped-rotated.png | /var/www/justfacts/assets/images/general/star-spangled-banner-image-cropped-rotated.png |
| images/general/btn-star-spangles-2.png | /var/www/justfacts/assets/images/general/btn-star-spangles-2.png |
| images/general/bull_logo.png | /var/www/justfacts/assets/images/general/bull_logo.png |
| images/general/btn-star-spangles-3.png | /var/www/justfacts/assets/images/general/btn-star-spangles-3.png |
| images/general/outline_star_black_18dp.png | /var/www/justfacts/assets/images/general/outline_star_black_18dp.png |
| images/general/Politician_naked.png | /var/www/justfacts/assets/images/general/Politician_naked.png |
| images/general/star-spangled-banner-image-cropped.png | /var/www/justfacts/assets/images/general/star-spangled-banner-image-cropped.png |
| images/general/star-spangled-banner-image.png | /var/www/justfacts/assets/images/general/star-spangled-banner-image.png |
| images/general/followmoney-1.png | /var/www/justfacts/assets/images/general/followmoney-1.png |
| images/general/aristotle-international-squarelogo.png | /var/www/justfacts/assets/images/general/aristotle-international-squarelogo.png |
| images/general/helpus-popup/VS-Lightbox1.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox1.jpg |
| images/general/helpus-popup/VS-Lightbox11.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox11.jpg |
| images/general/helpus-popup/VS-Lightbox2.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox2.jpg |
| images/general/helpus-popup/VS-Lightbox9.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox9.jpg |
| images/general/helpus-popup/VS-Lightbox3.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox3.jpg |
| images/general/helpus-popup/VS-Lightbox6_test.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox6_test.jpg |
| images/general/helpus-popup/VS-Lightbox7.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox7.jpg |
| images/general/helpus-popup/VS-Lightbox12.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox12.jpg |
| images/general/helpus-popup/VS-Lightbox8.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox8.jpg |
| images/general/helpus-popup/VS-Lightbox6.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox6.jpg |
| images/general/helpus-popup/VS-Lightbox4.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox4.jpg |
| images/general/helpus-popup/VS-Lightbox10.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox10.jpg |
| images/general/helpus-popup/VS-Lightbox13.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox13.jpg |
| images/general/helpus-popup/VS-Lightbox5.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox5.jpg |
| images/general/helpus-popup/VS-Lightbox15.png | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox15.png |
| images/general/helpus-popup/VS-Lightbox14.jpg | /var/www/justfacts/assets/images/general/helpus-popup/VS-Lightbox14.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox1.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox1.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox11.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox11.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox2.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox2.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox9.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox9.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox3.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox3.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox7.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox7.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox12.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox12.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox8.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox8.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox6.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox6.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox4.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox4.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox10.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox10.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox13.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox13.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox5.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox5.jpg |
| images/general/helpus-popup-cropped-internal/VS-Lightbox15.png | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox15.png |
| images/general/helpus-popup-cropped-internal/VS-Lightbox14.jpg | /var/www/justfacts/assets/images/general/helpus-popup-cropped-internal/VS-Lightbox14.jpg |
| images/general/favicon-new-branding/safari-pinned-tab.svg | /var/www/justfacts/assets/images/general/favicon-new-branding/safari-pinned-tab.svg |
| images/general/favicon-new-branding/android-chrome-512x512.png | /var/www/justfacts/assets/images/general/favicon-new-branding/android-chrome-512x512.png |
| images/general/favicon-new-branding/browserconfig.xml | /var/www/justfacts/assets/images/general/favicon-new-branding/browserconfig.xml |
| images/general/favicon-new-branding/mstile-150x150.png | /var/www/justfacts/assets/images/general/favicon-new-branding/mstile-150x150.png |
| images/general/favicon-new-branding/favicon.ico | /var/www/justfacts/assets/images/general/favicon-new-branding/favicon.ico |
| images/general/favicon-new-branding/favicon-16x16.png | /var/www/justfacts/assets/images/general/favicon-new-branding/favicon-16x16.png |
| images/general/favicon-new-branding/site.webmanifest | /var/www/justfacts/assets/images/general/favicon-new-branding/site.webmanifest |
| images/general/favicon-new-branding/android-chrome-192x192.png | /var/www/justfacts/assets/images/general/favicon-new-branding/android-chrome-192x192.png |
| images/general/favicon-new-branding/apple-touch-icon.png | /var/www/justfacts/assets/images/general/favicon-new-branding/apple-touch-icon.png |
| images/general/favicon-new-branding/favicon-32x32.png | /var/www/justfacts/assets/images/general/favicon-new-branding/favicon-32x32.png |
| images/general/favicons/android-chrome-256x256.png | /var/www/justfacts/assets/images/general/favicons/android-chrome-256x256.png |
| images/general/favicons/safari-pinned-tab.svg | /var/www/justfacts/assets/images/general/favicons/safari-pinned-tab.svg |
| images/general/favicons/browserconfig.xml | /var/www/justfacts/assets/images/general/favicons/browserconfig.xml |
| images/general/favicons/mstile-150x150.png | /var/www/justfacts/assets/images/general/favicons/mstile-150x150.png |
| images/general/favicons/favicon.ico | /var/www/justfacts/assets/images/general/favicons/favicon.ico |
| images/general/favicons/favicon-16x16.png | /var/www/justfacts/assets/images/general/favicons/favicon-16x16.png |
| images/general/favicons/site.webmanifest | /var/www/justfacts/assets/images/general/favicons/site.webmanifest |
| images/general/favicons/android-chrome-192x192.png | /var/www/justfacts/assets/images/general/favicons/android-chrome-192x192.png |
| images/general/favicons/apple-touch-icon.png | /var/www/justfacts/assets/images/general/favicons/apple-touch-icon.png |
| images/general/favicons/favicon-32x32.png | /var/www/justfacts/assets/images/general/favicons/favicon-32x32.png |
| images/share/voteSmartEmbedDivExample.svg | /var/www/justfacts/assets/images/share/voteSmartEmbedDivExample.svg |
| images/share/banner2SmallEmbed.svg | /var/www/justfacts/assets/images/share/banner2SmallEmbed.svg |
| images/share/carbon.svg | /var/www/justfacts/assets/images/share/carbon.svg |
| images/share/banner1.jpg | /var/www/justfacts/assets/images/share/banner1.jpg |
| images/share/logo-white_bg.gif | /var/www/justfacts/assets/images/share/logo-white_bg.gif |
| images/share/skyscraper.jpg | /var/www/justfacts/assets/images/share/skyscraper.jpg |
| images/share/banner1SmallEmbed.svg | /var/www/justfacts/assets/images/share/banner1SmallEmbed.svg |
| images/share/banner2-small.jpg | /var/www/justfacts/assets/images/share/banner2-small.jpg |
| images/share/leaderboard.jpg | /var/www/justfacts/assets/images/share/leaderboard.jpg |
| images/share/banner2Embed.svg | /var/www/justfacts/assets/images/share/banner2Embed.svg |
| images/share/banner1-small.jpg | /var/www/justfacts/assets/images/share/banner1-small.jpg |
| images/share/skyscraperEmbed.svg | /var/www/justfacts/assets/images/share/skyscraperEmbed.svg |
| images/share/Votesmart_widget.svg | /var/www/justfacts/assets/images/share/Votesmart_widget.svg |
| images/share/banner1Embed.svg | /var/www/justfacts/assets/images/share/banner1Embed.svg |
| images/share/VoteEasyLogoEmbed.svg | /var/www/justfacts/assets/images/share/VoteEasyLogoEmbed.svg |
| images/share/voteeasyBannerEmbed.svg | /var/www/justfacts/assets/images/share/voteeasyBannerEmbed.svg |
| images/share/banner2.jpg | /var/www/justfacts/assets/images/share/banner2.jpg |
| images/about/VE6.jpg | /var/www/justfacts/assets/images/about/VE6.jpg |
| images/about/voteeasy-banner1.jpg | /var/www/justfacts/assets/images/about/voteeasy-banner1.jpg |
| images/about/74573258-voter-registration-application-with-flag-of-united-states-of-america.jpg | /var/www/justfacts/assets/images/about/74573258-voter-registration-application-with-flag-of-united-states-of-america.jpg |
| images/about/VE8.jpg | /var/www/justfacts/assets/images/about/VE8.jpg |
| images/about/VE4.jpg | /var/www/justfacts/assets/images/about/VE4.jpg |
| images/about/vsdm_2018.png | /var/www/justfacts/assets/images/about/vsdm_2018.png |
| images/about/screenshots.png | /var/www/justfacts/assets/images/about/screenshots.png |
| images/about/VE5.jpg | /var/www/justfacts/assets/images/about/VE5.jpg |
| images/about/VE9.jpg | /var/www/justfacts/assets/images/about/VE9.jpg |
| images/about/VE2.jpg | /var/www/justfacts/assets/images/about/VE2.jpg |
| images/about/onpoint-bg.png | /var/www/justfacts/assets/images/about/onpoint-bg.png |
| images/about/VE3.jpg | /var/www/justfacts/assets/images/about/VE3.jpg |
| images/about/default-candidate-image.jpg | /var/www/justfacts/assets/images/about/default-candidate-image.jpg |
| images/about/phonehand1.png | /var/www/justfacts/assets/images/about/phonehand1.png |
| images/about/VE7.jpg | /var/www/justfacts/assets/images/about/VE7.jpg |
| images/about/88075232-election-in-united-states-of-america-voting-at-the-ballot-box-the-hand-of-woman-putting-her-vote-in-.jpg | /var/www/justfacts/assets/images/about/88075232-election-in-united-states-of-america-voting-at-the-ballot-box-the-hand-of-woman-putting-her-vote-in-.jpg |
| images/about/about_pvs_3.jpg | /var/www/justfacts/assets/images/about/about_pvs_3.jpg |
| images/about/VE1.jpg | /var/www/justfacts/assets/images/about/VE1.jpg |
| images/subpages/default-candidate-image.jpg | /var/www/justfacts/assets/images/subpages/default-candidate-image.jpg |
| fonts/us_declaration/Licence.txt | /var/www/justfacts/assets/fonts/us_declaration/Licence.txt |
| fonts/us_declaration/USDeclaration.ttf | /var/www/justfacts/assets/fonts/us_declaration/USDeclaration.ttf |
| js/material-kit.js | /var/www/justfacts/assets/js/material-kit.js |
| js/material-kit.min.js | /var/www/justfacts/assets/js/material-kit.min.js |
| js/material-kit.js.map | /var/www/justfacts/assets/js/material-kit.js.map |
| js/offices/offices.js | /var/www/justfacts/assets/js/offices/offices.js |
| js/offices/pie_chart.js | /var/www/justfacts/assets/js/offices/pie_chart.js |
| js/candidate/candidate_finance.js | /var/www/justfacts/assets/js/candidate/candidate_finance.js |
| js/candidate/candidate_opinions.js | /var/www/justfacts/assets/js/candidate/candidate_opinions.js |
| js/candidate/candidate_bull.js | /var/www/justfacts/assets/js/candidate/candidate_bull.js |
| js/candidate/candidate_votes.js | /var/www/justfacts/assets/js/candidate/candidate_votes.js |
| js/candidate/candidate_bio.js | /var/www/justfacts/assets/js/candidate/candidate_bio.js |
| js/candidate/candidate_summary.js | /var/www/justfacts/assets/js/candidate/candidate_summary.js |
| js/candidate/candidate_pct.js | /var/www/justfacts/assets/js/candidate/candidate_pct.js |
| js/candidate/candidate_statements.js | /var/www/justfacts/assets/js/candidate/candidate_statements.js |
| js/vetoes/vetoes.js | /var/www/justfacts/assets/js/vetoes/vetoes.js |
| js/core/popper.min.js | /var/www/justfacts/assets/js/core/popper.min.js |
| js/core/jquery.min.js | /var/www/justfacts/assets/js/core/jquery.min.js |
| js/core/bootstrap-material-design.min.js | /var/www/justfacts/assets/js/core/bootstrap-material-design.min.js |
| js/government/sigDetails.js | /var/www/justfacts/assets/js/government/sigDetails.js |
| js/government/public_statements.js | /var/www/justfacts/assets/js/government/public_statements.js |
| js/government/public_statementDetail.js | /var/www/justfacts/assets/js/government/public_statementDetail.js |
| js/government/government.js | /var/www/justfacts/assets/js/government/government.js |
| js/education/education.js | /var/www/justfacts/assets/js/education/education.js |
| js/keyvotes/breakdown_pie_chart.js | /var/www/justfacts/assets/js/keyvotes/breakdown_pie_chart.js |
| js/keyvotes/pie_chart.js | /var/www/justfacts/assets/js/keyvotes/pie_chart.js |
| js/keyvotes/keyvotes.js | /var/www/justfacts/assets/js/keyvotes/keyvotes.js |
| js/keyvotes/detail.js | /var/www/justfacts/assets/js/keyvotes/detail.js |
| js/helpus/helpus.js | /var/www/justfacts/assets/js/helpus/helpus.js |
| js/helpus/helpus-subnav.js | /var/www/justfacts/assets/js/helpus/helpus-subnav.js |
| js/home/site_search_handler.js | /var/www/justfacts/assets/js/home/site_search_handler.js |
| js/home/help-us-popup.js | /var/www/justfacts/assets/js/home/help-us-popup.js |
| js/home/home.js | /var/www/justfacts/assets/js/home/home.js |
| js/share/link-to-us.js | /var/www/justfacts/assets/js/share/link-to-us.js |
| js/share/share-subnav.js | /var/www/justfacts/assets/js/share/share-subnav.js |
| js/user/justfacts_login_utils.js | /var/www/justfacts/assets/js/user/justfacts_login_utils.js |
| js/user/view_blocker.js | /var/www/justfacts/assets/js/user/view_blocker.js |
| js/user/justfacts_reCAPTCHA.js | /var/www/justfacts/assets/js/user/justfacts_reCAPTCHA.js |
| js/forcandidates/forcandidates.js | /var/www/justfacts/assets/js/forcandidates/forcandidates.js |
| js/plugins/snackbar.min.js | /var/www/justfacts/assets/js/plugins/snackbar.min.js |
| js/plugins/bootstrap-selectpicker.js | /var/www/justfacts/assets/js/plugins/bootstrap-selectpicker.js |
| js/plugins/jquery.flexisel.js | /var/www/justfacts/assets/js/plugins/jquery.flexisel.js |
| js/plugins/nouislider.min.js | /var/www/justfacts/assets/js/plugins/nouislider.min.js |
| js/plugins/bootstrap-tagsinput.js | /var/www/justfacts/assets/js/plugins/bootstrap-tagsinput.js |
| js/plugins/jasny-bootstrap.min.js | /var/www/justfacts/assets/js/plugins/jasny-bootstrap.min.js |
| js/plugins/bootstrap-datetimepicker.js | /var/www/justfacts/assets/js/plugins/bootstrap-datetimepicker.js |
| js/plugins/moment.min.js | /var/www/justfacts/assets/js/plugins/moment.min.js |
| js/about/about.js | /var/www/justfacts/assets/js/about/about.js |
| js/elections/pie_chart.js | /var/www/justfacts/assets/js/elections/pie_chart.js |
| js/elections/elections.js | /var/www/justfacts/assets/js/elections/elections.js |
| js/tracking/tracking.js | /var/www/justfacts/assets/js/tracking/tracking.js |
| js/iSpy/iSpy.js | /var/www/justfacts/assets/js/iSpy/iSpy.js |
| css/material-kit.css | /var/www/justfacts/assets/css/material-kit.css |
| css/material-kit.css.map | /var/www/justfacts/assets/css/material-kit.css.map |
| scss/material-kit.scss | /var/www/justfacts/assets/scss/material-kit.scss |
| scss/offices/officials.scss | /var/www/justfacts/assets/scss/offices/officials.scss |
| scss/candidate/_candidate_opinions.scss | /var/www/justfacts/assets/scss/candidate/_candidate_opinions.scss |
| scss/candidate/_candidate_votes.scss | /var/www/justfacts/assets/scss/candidate/_candidate_votes.scss |
| scss/candidate/_candidate_pct.scss | /var/www/justfacts/assets/scss/candidate/_candidate_pct.scss |
| scss/candidate/_candidate_statements.scss | /var/www/justfacts/assets/scss/candidate/_candidate_statements.scss |
| scss/candidate/_candidate_finance.scss | /var/www/justfacts/assets/scss/candidate/_candidate_finance.scss |
| scss/candidate/_candidate_summary.scss | /var/www/justfacts/assets/scss/candidate/_candidate_summary.scss |
| scss/candidate/_candidate_long_dropdown.scss | /var/www/justfacts/assets/scss/candidate/_candidate_long_dropdown.scss |
| scss/candidate/_candidate_base.scss | /var/www/justfacts/assets/scss/candidate/_candidate_base.scss |
| scss/candidate/_candidate_contact_info.scss | /var/www/justfacts/assets/scss/candidate/_candidate_contact_info.scss |
| scss/vetoes/vetoes.scss | /var/www/justfacts/assets/scss/vetoes/vetoes.scss |
| scss/government/_ratings_detail.scss | /var/www/justfacts/assets/scss/government/_ratings_detail.scss |
| scss/government/_government_base.scss | /var/www/justfacts/assets/scss/government/_government_base.scss |
| scss/government/_issues.scss | /var/www/justfacts/assets/scss/government/_issues.scss |
| scss/government/_public_statements.scss | /var/www/justfacts/assets/scss/government/_public_statements.scss |
| scss/keyvotes/keyvotes.scss | /var/www/justfacts/assets/scss/keyvotes/keyvotes.scss |
| scss/helpus/_helpus.scss | /var/www/justfacts/assets/scss/helpus/_helpus.scss |
| scss/justfacts/_about.scss | /var/www/justfacts/assets/scss/justfacts/_about.scss |
| scss/justfacts/_footer.scss | /var/www/justfacts/assets/scss/justfacts/_footer.scss |
| scss/justfacts/_icons.scss | /var/www/justfacts/assets/scss/justfacts/_icons.scss |
| scss/justfacts/_home.scss | /var/www/justfacts/assets/scss/justfacts/_home.scss |
| scss/justfacts/_iSpy.scss | /var/www/justfacts/assets/scss/justfacts/_iSpy.scss |
| scss/justfacts/_global.scss | /var/www/justfacts/assets/scss/justfacts/_global.scss |
| scss/justfacts/_header.scss | /var/www/justfacts/assets/scss/justfacts/_header.scss |
| scss/justfacts/_search.scss | /var/www/justfacts/assets/scss/justfacts/_search.scss |
| scss/share/share.scss | /var/www/justfacts/assets/scss/share/share.scss |
| scss/user/_user_panel.scss | /var/www/justfacts/assets/scss/user/_user_panel.scss |
| scss/elections/_elections_base.scss | /var/www/justfacts/assets/scss/elections/_elections_base.scss |
| scss/elections/justfacts/_about.scss | /var/www/justfacts/assets/scss/elections/justfacts/_about.scss |
| scss/elections/justfacts/_footer.scss | /var/www/justfacts/assets/scss/elections/justfacts/_footer.scss |
| scss/elections/justfacts/_icons.scss | /var/www/justfacts/assets/scss/elections/justfacts/_icons.scss |
| scss/elections/justfacts/_home.scss | /var/www/justfacts/assets/scss/elections/justfacts/_home.scss |
| scss/elections/justfacts/_iSpy.scss | /var/www/justfacts/assets/scss/elections/justfacts/_iSpy.scss |
| scss/elections/justfacts/_global.scss | /var/www/justfacts/assets/scss/elections/justfacts/_global.scss |
| scss/elections/justfacts/_header.scss | /var/www/justfacts/assets/scss/elections/justfacts/_header.scss |
| scss/elections/justfacts/_search.scss | /var/www/justfacts/assets/scss/elections/justfacts/_search.scss |
| scss/material-kit/_misc-extend.scss | /var/www/justfacts/assets/scss/material-kit/_misc-extend.scss |
| scss/material-kit/_mixins.scss | /var/www/justfacts/assets/scss/material-kit/_mixins.scss |
| scss/material-kit/_nav.scss | /var/www/justfacts/assets/scss/material-kit/_nav.scss |
| scss/material-kit/_reboot.scss | /var/www/justfacts/assets/scss/material-kit/_reboot.scss |
| scss/material-kit/_ripples.scss | /var/www/justfacts/assets/scss/material-kit/_ripples.scss |
| scss/material-kit/_tooltip.scss | /var/www/justfacts/assets/scss/material-kit/_tooltip.scss |
| scss/material-kit/_list-group.scss | /var/www/justfacts/assets/scss/material-kit/_list-group.scss |
| scss/material-kit/_layout.scss | /var/www/justfacts/assets/scss/material-kit/_layout.scss |
| scss/material-kit/_navbar.scss | /var/www/justfacts/assets/scss/material-kit/_navbar.scss |
| scss/material-kit/_example-pages-extend.scss | /var/www/justfacts/assets/scss/material-kit/_example-pages-extend.scss |
| scss/material-kit/_misc.scss | /var/www/justfacts/assets/scss/material-kit/_misc.scss |
| scss/material-kit/_footers.scss | /var/www/justfacts/assets/scss/material-kit/_footers.scss |
| scss/material-kit/_tabs.scss | /var/www/justfacts/assets/scss/material-kit/_tabs.scss |
| scss/material-kit/_switches.scss | /var/www/justfacts/assets/scss/material-kit/_switches.scss |
| scss/material-kit/_drawer.scss | /var/www/justfacts/assets/scss/material-kit/_drawer.scss |
| scss/material-kit/_badges.scss | /var/www/justfacts/assets/scss/material-kit/_badges.scss |
| scss/material-kit/_modal.scss | /var/www/justfacts/assets/scss/material-kit/_modal.scss |
| scss/material-kit/_tables.scss | /var/www/justfacts/assets/scss/material-kit/_tables.scss |
| scss/material-kit/_modal-extend.scss | /var/www/justfacts/assets/scss/material-kit/_modal-extend.scss |
| scss/material-kit/_progress.scss | /var/www/justfacts/assets/scss/material-kit/_progress.scss |
| scss/material-kit/_popover.scss | /var/www/justfacts/assets/scss/material-kit/_popover.scss |
| scss/material-kit/_fileupload.scss | /var/www/justfacts/assets/scss/material-kit/_fileupload.scss |
| scss/material-kit/_headers.scss | /var/www/justfacts/assets/scss/material-kit/_headers.scss |
| scss/material-kit/_dropdown.scss | /var/www/justfacts/assets/scss/material-kit/_dropdown.scss |
| scss/material-kit/_pagination.scss | /var/www/justfacts/assets/scss/material-kit/_pagination.scss |
| scss/material-kit/_images.scss | /var/www/justfacts/assets/scss/material-kit/_images.scss |
| scss/material-kit/_forms.scss | /var/www/justfacts/assets/scss/material-kit/_forms.scss |
| scss/material-kit/_example-pages.scss | /var/www/justfacts/assets/scss/material-kit/_example-pages.scss |
| scss/material-kit/_togglebutton.scss | /var/www/justfacts/assets/scss/material-kit/_togglebutton.scss |
| scss/material-kit/_carousel.scss | /var/www/justfacts/assets/scss/material-kit/_carousel.scss |
| scss/material-kit/_responsive.scss | /var/www/justfacts/assets/scss/material-kit/_responsive.scss |
| scss/material-kit/_alerts.scss | /var/www/justfacts/assets/scss/material-kit/_alerts.scss |
| scss/material-kit/_type.scss | /var/www/justfacts/assets/scss/material-kit/_type.scss |
| scss/material-kit/_social-buttons.scss | /var/www/justfacts/assets/scss/material-kit/_social-buttons.scss |
| scss/material-kit/_input-group.scss | /var/www/justfacts/assets/scss/material-kit/_input-group.scss |
| scss/material-kit/_info-areas.scss | /var/www/justfacts/assets/scss/material-kit/_info-areas.scss |
| scss/material-kit/_sections.scss | /var/www/justfacts/assets/scss/material-kit/_sections.scss |
| scss/material-kit/_variables.scss | /var/www/justfacts/assets/scss/material-kit/_variables.scss |
| scss/material-kit/_custom-forms.scss | /var/www/justfacts/assets/scss/material-kit/_custom-forms.scss |
| scss/material-kit/_pills.scss | /var/www/justfacts/assets/scss/material-kit/_pills.scss |
| scss/material-kit/_cards.scss | /var/www/justfacts/assets/scss/material-kit/_cards.scss |
| scss/material-kit/_buttons.scss | /var/www/justfacts/assets/scss/material-kit/_buttons.scss |
| scss/material-kit/_core-bootstrap.scss | /var/www/justfacts/assets/scss/material-kit/_core-bootstrap.scss |
| scss/material-kit/_checkboxes.scss | /var/www/justfacts/assets/scss/material-kit/_checkboxes.scss |
| scss/material-kit/_radios.scss | /var/www/justfacts/assets/scss/material-kit/_radios.scss |
| scss/material-kit/_media.scss | /var/www/justfacts/assets/scss/material-kit/_media.scss |
| scss/material-kit/sections/_features.scss | /var/www/justfacts/assets/scss/material-kit/sections/_features.scss |
| scss/material-kit/sections/_pricing.scss | /var/www/justfacts/assets/scss/material-kit/sections/_pricing.scss |
| scss/material-kit/sections/_projects.scss | /var/www/justfacts/assets/scss/material-kit/sections/_projects.scss |
| scss/material-kit/sections/_contactus.scss | /var/www/justfacts/assets/scss/material-kit/sections/_contactus.scss |
| scss/material-kit/sections/_testimonials.scss | /var/www/justfacts/assets/scss/material-kit/sections/_testimonials.scss |
| scss/material-kit/sections/_team.scss | /var/www/justfacts/assets/scss/material-kit/sections/_team.scss |
| scss/material-kit/sections/_social-subscribe-lines.scss | /var/www/justfacts/assets/scss/material-kit/sections/_social-subscribe-lines.scss |
| scss/material-kit/sections/_footers-extend.scss | /var/www/justfacts/assets/scss/material-kit/sections/_footers-extend.scss |
| scss/material-kit/sections/_blogs.scss | /var/www/justfacts/assets/scss/material-kit/sections/_blogs.scss |
| scss/material-kit/sections/_headers-extend.scss | /var/www/justfacts/assets/scss/material-kit/sections/_headers-extend.scss |
| scss/material-kit/variables/_nav.scss | /var/www/justfacts/assets/scss/material-kit/variables/_nav.scss |
| scss/material-kit/variables/_tooltip.scss | /var/www/justfacts/assets/scss/material-kit/variables/_tooltip.scss |
| scss/material-kit/variables/_menu.scss | /var/www/justfacts/assets/scss/material-kit/variables/_menu.scss |
| scss/material-kit/variables/_list-group.scss | /var/www/justfacts/assets/scss/material-kit/variables/_list-group.scss |
| scss/material-kit/variables/_layout.scss | /var/www/justfacts/assets/scss/material-kit/variables/_layout.scss |
| scss/material-kit/variables/_bootstrap-material-design.scss | /var/www/justfacts/assets/scss/material-kit/variables/_bootstrap-material-design.scss |
| scss/material-kit/variables/_spacing.scss | /var/www/justfacts/assets/scss/material-kit/variables/_spacing.scss |
| scss/material-kit/variables/_drawer.scss | /var/www/justfacts/assets/scss/material-kit/variables/_drawer.scss |
| scss/material-kit/variables/_card.scss | /var/www/justfacts/assets/scss/material-kit/variables/_card.scss |
| scss/material-kit/variables/_tables.scss | /var/www/justfacts/assets/scss/material-kit/variables/_tables.scss |
| scss/material-kit/variables/_shadow.scss | /var/www/justfacts/assets/scss/material-kit/variables/_shadow.scss |
| scss/material-kit/variables/_dropdown.scss | /var/www/justfacts/assets/scss/material-kit/variables/_dropdown.scss |
| scss/material-kit/variables/_modals.scss | /var/www/justfacts/assets/scss/material-kit/variables/_modals.scss |
| scss/material-kit/variables/_pagination.scss | /var/www/justfacts/assets/scss/material-kit/variables/_pagination.scss |
| scss/material-kit/variables/_forms.scss | /var/www/justfacts/assets/scss/material-kit/variables/_forms.scss |
| scss/material-kit/variables/_carousel.scss | /var/www/justfacts/assets/scss/material-kit/variables/_carousel.scss |
| scss/material-kit/variables/_type.scss | /var/www/justfacts/assets/scss/material-kit/variables/_type.scss |
| scss/material-kit/variables/_snackbar.scss | /var/www/justfacts/assets/scss/material-kit/variables/_snackbar.scss |
| scss/material-kit/variables/_colors.scss | /var/www/justfacts/assets/scss/material-kit/variables/_colors.scss |
| scss/material-kit/variables/_custom-forms.scss | /var/www/justfacts/assets/scss/material-kit/variables/_custom-forms.scss |
| scss/material-kit/variables/_state.scss | /var/www/justfacts/assets/scss/material-kit/variables/_state.scss |
| scss/material-kit/variables/_code.scss | /var/www/justfacts/assets/scss/material-kit/variables/_code.scss |
| scss/material-kit/variables/_colors-map.scss | /var/www/justfacts/assets/scss/material-kit/variables/_colors-map.scss |
| scss/material-kit/variables/_body.scss | /var/www/justfacts/assets/scss/material-kit/variables/_body.scss |
| scss/material-kit/variables/_buttons.scss | /var/www/justfacts/assets/scss/material-kit/variables/_buttons.scss |
| scss/material-kit/variables/_brand.scss | /var/www/justfacts/assets/scss/material-kit/variables/_brand.scss |
| scss/material-kit/variables/_bootstrap-material-design-base.scss | /var/www/justfacts/assets/scss/material-kit/variables/_bootstrap-material-design-base.scss |
| scss/material-kit/mixins/_hover.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_hover.scss |
| scss/material-kit/mixins/_alert.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_alert.scss |
| scss/material-kit/mixins/_layout.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_layout.scss |
| scss/material-kit/mixins/_animations.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_animations.scss |
| scss/material-kit/mixins/_drawer.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_drawer.scss |
| scss/material-kit/mixins/_utilities.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_utilities.scss |
| scss/material-kit/mixins/_navbar-colors.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_navbar-colors.scss |
| scss/material-kit/mixins/_forms.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_forms.scss |
| scss/material-kit/mixins/_type.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_type.scss |
| scss/material-kit/mixins/_breakpoints.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_breakpoints.scss |
| scss/material-kit/mixins/_colored-shadows.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_colored-shadows.scss |
| scss/material-kit/mixins/_navs.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_navs.scss |
| scss/material-kit/mixins/_buttons.scss | /var/www/justfacts/assets/scss/material-kit/mixins/_buttons.scss |
| scss/material-kit/bootstrap/scss/_mixins.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_mixins.scss |
| scss/material-kit/bootstrap/scss/_nav.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_nav.scss |
| scss/material-kit/bootstrap/scss/_reboot.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_reboot.scss |
| scss/material-kit/bootstrap/scss/_alert.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_alert.scss |
| scss/material-kit/bootstrap/scss/_tooltip.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_tooltip.scss |
| scss/material-kit/bootstrap/scss/_list-group.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_list-group.scss |
| scss/material-kit/bootstrap/scss/_navbar.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_navbar.scss |
| scss/material-kit/bootstrap/scss/_utilities.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_utilities.scss |
| scss/material-kit/bootstrap/scss/_modal.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_modal.scss |
| scss/material-kit/bootstrap/scss/_card.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_card.scss |
| scss/material-kit/bootstrap/scss/_tables.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_tables.scss |
| scss/material-kit/bootstrap/scss/_functions.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_functions.scss |
| scss/material-kit/bootstrap/scss/_close.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_close.scss |
| scss/material-kit/bootstrap/scss/_progress.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_progress.scss |
| scss/material-kit/bootstrap/scss/_popover.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_popover.scss |
| scss/material-kit/bootstrap/scss/_dropdown.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_dropdown.scss |
| scss/material-kit/bootstrap/scss/_pagination.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_pagination.scss |
| scss/material-kit/bootstrap/scss/_print.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_print.scss |
| scss/material-kit/bootstrap/scss/_images.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_images.scss |
| scss/material-kit/bootstrap/scss/_forms.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_forms.scss |
| scss/material-kit/bootstrap/scss/_grid.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_grid.scss |
| scss/material-kit/bootstrap/scss/_carousel.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_carousel.scss |
| scss/material-kit/bootstrap/scss/_breadcrumb.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_breadcrumb.scss |
| scss/material-kit/bootstrap/scss/_type.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_type.scss |
| scss/material-kit/bootstrap/scss/_input-group.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_input-group.scss |
| scss/material-kit/bootstrap/scss/_variables.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_variables.scss |
| scss/material-kit/bootstrap/scss/_button-group.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_button-group.scss |
| scss/material-kit/bootstrap/scss/_custom-forms.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_custom-forms.scss |
| scss/material-kit/bootstrap/scss/_badge.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_badge.scss |
| scss/material-kit/bootstrap/scss/_root.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_root.scss |
| scss/material-kit/bootstrap/scss/_code.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_code.scss |
| scss/material-kit/bootstrap/scss/bootstrap-reboot.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/bootstrap-reboot.scss |
| scss/material-kit/bootstrap/scss/_buttons.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_buttons.scss |
| scss/material-kit/bootstrap/scss/bootstrap-grid.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/bootstrap-grid.scss |
| scss/material-kit/bootstrap/scss/_jumbotron.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_jumbotron.scss |
| scss/material-kit/bootstrap/scss/_media.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_media.scss |
| scss/material-kit/bootstrap/scss/bootstrap.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/bootstrap.scss |
| scss/material-kit/bootstrap/scss/_transitions.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/_transitions.scss |
| scss/material-kit/bootstrap/scss/utilities/_clearfix.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_clearfix.scss |
| scss/material-kit/bootstrap/scss/utilities/_screenreaders.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_screenreaders.scss |
| scss/material-kit/bootstrap/scss/utilities/_spacing.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_spacing.scss |
| scss/material-kit/bootstrap/scss/utilities/_embed.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_embed.scss |
| scss/material-kit/bootstrap/scss/utilities/_borders.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_borders.scss |
| scss/material-kit/bootstrap/scss/utilities/_align.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_align.scss |
| scss/material-kit/bootstrap/scss/utilities/_text.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_text.scss |
| scss/material-kit/bootstrap/scss/utilities/_background.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_background.scss |
| scss/material-kit/bootstrap/scss/utilities/_visibility.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_visibility.scss |
| scss/material-kit/bootstrap/scss/utilities/_flex.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_flex.scss |
| scss/material-kit/bootstrap/scss/utilities/_display.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_display.scss |
| scss/material-kit/bootstrap/scss/utilities/_position.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_position.scss |
| scss/material-kit/bootstrap/scss/utilities/_sizing.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_sizing.scss |
| scss/material-kit/bootstrap/scss/utilities/_float.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/utilities/_float.scss |
| scss/material-kit/bootstrap/scss/mixins/_hover.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_hover.scss |
| scss/material-kit/bootstrap/scss/mixins/_alert.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_alert.scss |
| scss/material-kit/bootstrap/scss/mixins/_caret.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_caret.scss |
| scss/material-kit/bootstrap/scss/mixins/_text-emphasis.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_text-emphasis.scss |
| scss/material-kit/bootstrap/scss/mixins/_list-group.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_list-group.scss |
| scss/material-kit/bootstrap/scss/mixins/_clearfix.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_clearfix.scss |
| scss/material-kit/bootstrap/scss/mixins/_transition.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_transition.scss |
| scss/material-kit/bootstrap/scss/mixins/_background-variant.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_background-variant.scss |
| scss/material-kit/bootstrap/scss/mixins/_resize.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_resize.scss |
| scss/material-kit/bootstrap/scss/mixins/_grid-framework.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_grid-framework.scss |
| scss/material-kit/bootstrap/scss/mixins/_image.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_image.scss |
| scss/material-kit/bootstrap/scss/mixins/_nav-divider.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_nav-divider.scss |
| scss/material-kit/bootstrap/scss/mixins/_size.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_size.scss |
| scss/material-kit/bootstrap/scss/mixins/_text-hide.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_text-hide.scss |
| scss/material-kit/bootstrap/scss/mixins/_pagination.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_pagination.scss |
| scss/material-kit/bootstrap/scss/mixins/_forms.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_forms.scss |
| scss/material-kit/bootstrap/scss/mixins/_visibility.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_visibility.scss |
| scss/material-kit/bootstrap/scss/mixins/_grid.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_grid.scss |
| scss/material-kit/bootstrap/scss/mixins/_reset-text.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_reset-text.scss |
| scss/material-kit/bootstrap/scss/mixins/_navbar-align.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_navbar-align.scss |
| scss/material-kit/bootstrap/scss/mixins/_breakpoints.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_breakpoints.scss |
| scss/material-kit/bootstrap/scss/mixins/_badge.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_badge.scss |
| scss/material-kit/bootstrap/scss/mixins/_box-shadow.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_box-shadow.scss |
| scss/material-kit/bootstrap/scss/mixins/_gradients.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_gradients.scss |
| scss/material-kit/bootstrap/scss/mixins/_buttons.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_buttons.scss |
| scss/material-kit/bootstrap/scss/mixins/_lists.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_lists.scss |
| scss/material-kit/bootstrap/scss/mixins/_border-radius.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_border-radius.scss |
| scss/material-kit/bootstrap/scss/mixins/_float.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_float.scss |
| scss/material-kit/bootstrap/scss/mixins/_table-row.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_table-row.scss |
| scss/material-kit/bootstrap/scss/mixins/_screen-reader.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_screen-reader.scss |
| scss/material-kit/bootstrap/scss/mixins/_text-truncate.scss | /var/www/justfacts/assets/scss/material-kit/bootstrap/scss/mixins/_text-truncate.scss |
| scss/material-kit/cards/_card-blog.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-blog.scss |
| scss/material-kit/cards/_card-carousel.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-carousel.scss |
| scss/material-kit/cards/_card-testimonials.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-testimonials.scss |
| scss/material-kit/cards/_card-collapse.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-collapse.scss |
| scss/material-kit/cards/_card-form-horizontal.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-form-horizontal.scss |
| scss/material-kit/cards/_card-pricing.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-pricing.scss |
| scss/material-kit/cards/_card-rotate.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-rotate.scss |
| scss/material-kit/cards/_card-product.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-product.scss |
| scss/material-kit/cards/_card-login.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-login.scss |
| scss/material-kit/cards/_card-profile.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-profile.scss |
| scss/material-kit/cards/_card-plain.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-plain.scss |
| scss/material-kit/cards/_card-contact.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-contact.scss |
| scss/material-kit/cards/_card-background.scss | /var/www/justfacts/assets/scss/material-kit/cards/_card-background.scss |
| scss/material-kit/plugins/_plugin-bootstrap-select.scss | /var/www/justfacts/assets/scss/material-kit/plugins/_plugin-bootstrap-select.scss |
| scss/material-kit/plugins/_plugin-tagsinput.scss | /var/www/justfacts/assets/scss/material-kit/plugins/_plugin-tagsinput.scss |
| scss/material-kit/plugins/_plugin-datetime-picker.scss | /var/www/justfacts/assets/scss/material-kit/plugins/_plugin-datetime-picker.scss |
| scss/material-kit/plugins/_plugin-flexisel.scss | /var/www/justfacts/assets/scss/material-kit/plugins/_plugin-flexisel.scss |
| scss/material-kit/plugins/_snackbar.scss | /var/www/justfacts/assets/scss/material-kit/plugins/_snackbar.scss |
| scss/material-kit/plugins/_plugin-nouislider.scss | /var/www/justfacts/assets/scss/material-kit/plugins/_plugin-nouislider.scss |
| Path | Location |
|---|---|
| admin/img/icon-no.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-no.svg |
| admin/img/README.txt | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/README.txt |
| admin/img/icon-yes.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-yes.svg |
| admin/img/inline-delete.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/inline-delete.svg |
| admin/img/selector-icons.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/selector-icons.svg |
| admin/img/icon-calendar.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-calendar.svg |
| admin/img/search.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/search.svg |
| admin/img/LICENSE | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/LICENSE |
| admin/img/icon-unknown.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-unknown.svg |
| admin/img/icon-viewlink.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-viewlink.svg |
| admin/img/icon-changelink.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-changelink.svg |
| admin/img/calendar-icons.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/calendar-icons.svg |
| admin/img/icon-alert.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-alert.svg |
| admin/img/icon-unknown-alt.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-unknown-alt.svg |
| admin/img/tooltag-add.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/tooltag-add.svg |
| admin/img/icon-addlink.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-addlink.svg |
| admin/img/sorting-icons.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/sorting-icons.svg |
| admin/img/icon-clock.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-clock.svg |
| admin/img/icon-deletelink.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/icon-deletelink.svg |
| admin/img/tooltag-arrowright.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/tooltag-arrowright.svg |
| admin/img/gis/move_vertex_off.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/gis/move_vertex_off.svg |
| admin/img/gis/move_vertex_on.svg | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/img/gis/move_vertex_on.svg |
| admin/fonts/README.txt | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/fonts/README.txt |
| admin/fonts/LICENSE.txt | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/fonts/LICENSE.txt |
| admin/fonts/Roboto-Regular-webfont.woff | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/fonts/Roboto-Regular-webfont.woff |
| admin/fonts/Roboto-Light-webfont.woff | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/fonts/Roboto-Light-webfont.woff |
| admin/fonts/Roboto-Bold-webfont.woff | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/fonts/Roboto-Bold-webfont.woff |
| admin/js/SelectFilter2.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/SelectFilter2.js |
| admin/js/nav_sidebar.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/nav_sidebar.js |
| admin/js/core.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/core.js |
| admin/js/popup_response.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/popup_response.js |
| admin/js/collapse.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/collapse.js |
| admin/js/autocomplete.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/autocomplete.js |
| admin/js/change_form.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/change_form.js |
| admin/js/jquery.init.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/jquery.init.js |
| admin/js/calendar.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/calendar.js |
| admin/js/urlify.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/urlify.js |
| admin/js/cancel.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/cancel.js |
| admin/js/prepopulate_init.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/prepopulate_init.js |
| admin/js/actions.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/actions.js |
| admin/js/prepopulate.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/prepopulate.js |
| admin/js/inlines.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/inlines.js |
| admin/js/SelectBox.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/SelectBox.js |
| admin/js/vendor/select2/LICENSE.md | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/LICENSE.md |
| admin/js/vendor/select2/select2.full.min.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/select2.full.min.js |
| admin/js/vendor/select2/select2.full.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/select2.full.js |
| admin/js/vendor/select2/i18n/ko.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ko.js |
| admin/js/vendor/select2/i18n/af.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/af.js |
| admin/js/vendor/select2/i18n/az.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/az.js |
| admin/js/vendor/select2/i18n/hr.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/hr.js |
| admin/js/vendor/select2/i18n/tr.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/tr.js |
| admin/js/vendor/select2/i18n/sr-Cyrl.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/sr-Cyrl.js |
| admin/js/vendor/select2/i18n/hsb.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/hsb.js |
| admin/js/vendor/select2/i18n/is.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/is.js |
| admin/js/vendor/select2/i18n/nb.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/nb.js |
| admin/js/vendor/select2/i18n/km.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/km.js |
| admin/js/vendor/select2/i18n/fr.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/fr.js |
| admin/js/vendor/select2/i18n/id.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/id.js |
| admin/js/vendor/select2/i18n/hu.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/hu.js |
| admin/js/vendor/select2/i18n/zh-CN.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/zh-CN.js |
| admin/js/vendor/select2/i18n/nl.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/nl.js |
| admin/js/vendor/select2/i18n/he.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/he.js |
| admin/js/vendor/select2/i18n/pt.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/pt.js |
| admin/js/vendor/select2/i18n/de.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/de.js |
| admin/js/vendor/select2/i18n/sq.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/sq.js |
| admin/js/vendor/select2/i18n/es.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/es.js |
| admin/js/vendor/select2/i18n/it.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/it.js |
| admin/js/vendor/select2/i18n/ne.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ne.js |
| admin/js/vendor/select2/i18n/ar.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ar.js |
| admin/js/vendor/select2/i18n/en.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/en.js |
| admin/js/vendor/select2/i18n/fa.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/fa.js |
| admin/js/vendor/select2/i18n/cs.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/cs.js |
| admin/js/vendor/select2/i18n/tk.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/tk.js |
| admin/js/vendor/select2/i18n/vi.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/vi.js |
| admin/js/vendor/select2/i18n/bg.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/bg.js |
| admin/js/vendor/select2/i18n/pt-BR.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/pt-BR.js |
| admin/js/vendor/select2/i18n/ru.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ru.js |
| admin/js/vendor/select2/i18n/hi.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/hi.js |
| admin/js/vendor/select2/i18n/ca.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ca.js |
| admin/js/vendor/select2/i18n/lt.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/lt.js |
| admin/js/vendor/select2/i18n/sl.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/sl.js |
| admin/js/vendor/select2/i18n/ka.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ka.js |
| admin/js/vendor/select2/i18n/el.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/el.js |
| admin/js/vendor/select2/i18n/bs.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/bs.js |
| admin/js/vendor/select2/i18n/uk.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/uk.js |
| admin/js/vendor/select2/i18n/gl.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/gl.js |
| admin/js/vendor/select2/i18n/eu.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/eu.js |
| admin/js/vendor/select2/i18n/sv.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/sv.js |
| admin/js/vendor/select2/i18n/dsb.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/dsb.js |
| admin/js/vendor/select2/i18n/fi.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/fi.js |
| admin/js/vendor/select2/i18n/ro.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ro.js |
| admin/js/vendor/select2/i18n/ja.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ja.js |
| admin/js/vendor/select2/i18n/zh-TW.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/zh-TW.js |
| admin/js/vendor/select2/i18n/sk.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/sk.js |
| admin/js/vendor/select2/i18n/th.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/th.js |
| admin/js/vendor/select2/i18n/mk.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/mk.js |
| admin/js/vendor/select2/i18n/hy.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/hy.js |
| admin/js/vendor/select2/i18n/da.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/da.js |
| admin/js/vendor/select2/i18n/ps.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ps.js |
| admin/js/vendor/select2/i18n/bn.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/bn.js |
| admin/js/vendor/select2/i18n/lv.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/lv.js |
| admin/js/vendor/select2/i18n/ms.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/ms.js |
| admin/js/vendor/select2/i18n/et.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/et.js |
| admin/js/vendor/select2/i18n/pl.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/pl.js |
| admin/js/vendor/select2/i18n/sr.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/select2/i18n/sr.js |
| admin/js/vendor/jquery/jquery.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/jquery/jquery.js |
| admin/js/vendor/jquery/LICENSE.txt | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/jquery/LICENSE.txt |
| admin/js/vendor/jquery/jquery.min.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/jquery/jquery.min.js |
| admin/js/vendor/xregexp/LICENSE.txt | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/xregexp/LICENSE.txt |
| admin/js/vendor/xregexp/xregexp.min.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/xregexp/xregexp.min.js |
| admin/js/vendor/xregexp/xregexp.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/vendor/xregexp/xregexp.js |
| admin/js/admin/RelatedObjectLookups.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/admin/RelatedObjectLookups.js |
| admin/js/admin/DateTimeShortcuts.js | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/js/admin/DateTimeShortcuts.js |
| admin/css/changelists.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/changelists.css |
| admin/css/responsive_rtl.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/responsive_rtl.css |
| admin/css/dashboard.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/dashboard.css |
| admin/css/nav_sidebar.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/nav_sidebar.css |
| admin/css/fonts.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/fonts.css |
| admin/css/autocomplete.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/autocomplete.css |
| admin/css/base.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/base.css |
| admin/css/widgets.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/widgets.css |
| admin/css/forms.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/forms.css |
| admin/css/login.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/login.css |
| admin/css/rtl.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/rtl.css |
| admin/css/responsive.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/responsive.css |
| admin/css/vendor/select2/select2.min.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/vendor/select2/select2.min.css |
| admin/css/vendor/select2/LICENSE-SELECT2.md | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/vendor/select2/LICENSE-SELECT2.md |
| admin/css/vendor/select2/select2.css | /usr/local/lib/python3.12/dist-packages/django/contrib/admin/static/admin/css/vendor/select2/select2.css |
| debug_toolbar/js/toolbar.js | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/js/toolbar.js |
| debug_toolbar/js/utils.js | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/js/utils.js |
| debug_toolbar/js/redirect.js | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/js/redirect.js |
| debug_toolbar/js/history.js | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/js/history.js |
| debug_toolbar/js/timer.js | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/js/timer.js |
| debug_toolbar/css/toolbar.css | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/css/toolbar.css |
| debug_toolbar/css/print.css | /usr/local/lib/python3.12/dist-packages/debug_toolbar/static/debug_toolbar/css/print.css |
| rest_framework/img/glyphicons-halflings-white.png | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/img/glyphicons-halflings-white.png |
| rest_framework/img/grid.png | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/img/grid.png |
| rest_framework/img/glyphicons-halflings.png | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/img/glyphicons-halflings.png |
| rest_framework/fonts/fontawesome-webfont.ttf | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/fontawesome-webfont.ttf |
| rest_framework/fonts/glyphicons-halflings-regular.woff | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/glyphicons-halflings-regular.woff |
| rest_framework/fonts/glyphicons-halflings-regular.ttf | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/glyphicons-halflings-regular.ttf |
| rest_framework/fonts/glyphicons-halflings-regular.eot | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/glyphicons-halflings-regular.eot |
| rest_framework/fonts/glyphicons-halflings-regular.svg | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/glyphicons-halflings-regular.svg |
| rest_framework/fonts/fontawesome-webfont.woff | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/fontawesome-webfont.woff |
| rest_framework/fonts/fontawesome-webfont.svg | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/fontawesome-webfont.svg |
| rest_framework/fonts/fontawesome-webfont.eot | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/fontawesome-webfont.eot |
| rest_framework/fonts/glyphicons-halflings-regular.woff2 | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/fonts/glyphicons-halflings-regular.woff2 |
| rest_framework/docs/img/favicon.ico | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/img/favicon.ico |
| rest_framework/docs/img/grid.png | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/img/grid.png |
| rest_framework/docs/js/jquery.json-view.min.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/js/jquery.json-view.min.js |
| rest_framework/docs/js/highlight.pack.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/js/highlight.pack.js |
| rest_framework/docs/js/api.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/js/api.js |
| rest_framework/docs/css/jquery.json-view.min.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/css/jquery.json-view.min.css |
| rest_framework/docs/css/highlight.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/css/highlight.css |
| rest_framework/docs/css/base.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/docs/css/base.css |
| rest_framework/js/ajax-form.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/ajax-form.js |
| rest_framework/js/jquery-3.7.1.min.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/jquery-3.7.1.min.js |
| rest_framework/js/load-ajax-form.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/load-ajax-form.js |
| rest_framework/js/prettify-min.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/prettify-min.js |
| rest_framework/js/bootstrap.min.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/bootstrap.min.js |
| rest_framework/js/csrf.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/csrf.js |
| rest_framework/js/default.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/default.js |
| rest_framework/js/coreapi-0.1.1.js | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/js/coreapi-0.1.1.js |
| rest_framework/css/bootstrap-tweaks.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/bootstrap-tweaks.css |
| rest_framework/css/font-awesome-4.0.3.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/font-awesome-4.0.3.css |
| rest_framework/css/default.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/default.css |
| rest_framework/css/prettify.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/prettify.css |
| rest_framework/css/bootstrap-theme.min.css.map | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/bootstrap-theme.min.css.map |
| rest_framework/css/bootstrap.min.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/bootstrap.min.css |
| rest_framework/css/bootstrap.min.css.map | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/bootstrap.min.css.map |
| rest_framework/css/bootstrap-theme.min.css | /usr/local/lib/python3.12/dist-packages/rest_framework/static/rest_framework/css/bootstrap-theme.min.css |
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df2f07500>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2025,
'candVote': None,
'candidate': None,
'categories': '<<rawqueryset of misc.VCategoryResolve>>',
'committeeSponsors': '<<queryset of keyvotes.CongstatusCommittee>>',
'congdoc': '<<queryset of keyvotes.Congdoc>>',
'family': '<<queryset of keyvotes.Congstatus>>',
'okStatus': [1, 3, 4],
'showReadMoreStatementsLinkInAlert': True,
'speechRange': [],
'sponsors': '<<queryset of candidate.OfficeCandidate>>',
'sponsorsDict': {'Co-sponsor': [<OfficeCandidate: OfficeCandidate object (100373)>,
<OfficeCandidate: OfficeCandidate object (72957)>,
<OfficeCandidate: OfficeCandidate object (79990)>],
'Sponsor': [<OfficeCandidate: OfficeCandidate object (100391)>]},
'state_id': 'NA',
'title': 'S 1582 - Guiding and Establishing National Innovation for U.S. '
'Stablecoins (GENIUS) Act - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (109444)>]>>}
{'csrf_token': <SimpleLazyObject: 'rOzlTXZWbsDEmbgkQTBcgVU697P14jHPs5IqhK42Ef7wUnAcaELvCIXB7Nq60dQC'>}
{}
{'request': <WSGIRequest: GET '/bill/40147/112441/guiding-and-establishing-national-innovation-for-us-stablecoins-genius-act'>}
{'user': <SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object at 0x7e8df2f07500>>, 'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df8a69f70>}
{'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df2f053a0>, 'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10, 'INFO': 20, 'SUCCESS': 25, 'WARNING': 30, 'ERROR': 40}}
| Total calls | Total time | Cache hits | Cache misses |
|---|---|---|---|
| 0 | 0 ms | 0 | 0 |
| add | get | set | get_or_set | touch | delete | clear | get_many | set_many | delete_many | has_key | incr | decr | incr_version | decr_version |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Signal | Receivers |
|---|---|
| class_prepared | |
| connection_created | register_type_handlers |
| got_request_exception | |
| m2m_changed | |
| post_delete | |
| post_init | ImageField.update_dimension_fields, ImageField.update_dimension_fields, ImageField.update_dimension_fields |
| post_migrate | create_permissions, create_contenttypes, create_default_site |
| post_save | create_user_profile, TagField._save |
| pre_delete | clear_site_cache |
| pre_init | |
| pre_migrate | inject_rename_contenttypes_operations |
| pre_save | clear_site_cache, set_zip4_userprofile |
| request_finished | close_old_connections, close_caches, reset_urlconf |
| request_started | reset_queries, close_old_connections |
| setting_changed | reset_cache, clear_cache_handlers, update_installed_apps, update_connections_time_zone, clear_routers_cache, reset_template_engines, clear_serializers_cache, language_changed, localize_settings_changed, file_storage_changed, complex_setting_changed, root_urlconf_changed, static_storage_changed, static_finders_changed, auth_password_validators_changed, user_model_swapped, update_toolbar_config, reset_hashers, reload_api_settings, reload_api_settings, uninstall_if_needed, clear_caches, FileSystemStorage._clear_cached_properties, FileSystemStorage._clear_cached_properties, FileSystemStorage._clear_cached_properties, FileSystemStorage._clear_cached_properties, StaticFilesStorage._clear_cached_properties |