Title: Iraq and Afghanistan War Funding, Unemployment Benefits Extension, and GI Bill
Vote to concur on HR 2642, a bill that appropriates $190.39 billion and rescinds $3.86 billion for a net expenditure of $186.53 billion. This bill provides education funding for certain veterans, extends unemployment compensation, establishes a moratorium on certain actions regarding Medicaid, and appropriates funds for military operations in Iraq and Afghanistan.
Title: Funding for Operations in Iraq and Afghanistan
Vote to concur with the Senate amendment to provide funding for the Department of Defense in the amount of $99.57 billion for fiscal year 2008 and $65.77 billion for fiscal year 2009, totaling $165.35 billion.
Title: GI Bill, Funding for Midwest Flood Cleanup, Extension of Unemployment Benefits, and Other Provisions
Vote to adopt an amendment to HR 2642 that appropriates $21.11 billion to increase education and unemployment benefits for veterans and transfer funds to various disaster and democracy programs.
Title: G.I. Bill Expansion and Other Domestic Provisions
Vote to adopt an amendment to HR 2642 that provides education funding for eligible members of the Armed Forces, extends unemployment compensation, establishes moratoria on certain actions regarding Medicaid, and appropriates funds for various domestic and international purposes.
Title: Iraq Related Provisions such as a Troop Withdrawal, a Permanent Base Ban, and Limiting Interrogation Techniques
Vote to adopt an amendment to HR 2642 that provides regulations regarding the United States' activity in Iraq and other activities in foreign territories in which the U.S. may engage.
Title: Funding for Military Operations in Iraq and Afghanistan
NOTE: THIS IS A SUBSTITUTE BILL, MEANING THE LANGUAGE OF THE ORIGINAL BILL HAS BEEN REPLACED. THE DEGREE TO WHICH THE SUBSTITUTE BILL TEXT DIFFERS FROM THE PREVIOUS VERSION OF THE TEXT CAN VARY GREATLY.
Title: Military Construction and Veterans' Affairs Appropriations
| 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 | 3132.554 msec |
| System CPU time | 46.551 msec |
| Total CPU time | 3179.105 msec |
| Elapsed time | 3235.491 msec |
| Context switches | 1544 voluntary, 2008 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 | 119491 |
| 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/6948/19243/iraq-related-provisions-such-as-a-troop-withdrawal-a-permanent-base-ban-and-limiting-interrogation-techniques |
| 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': '6948', 'congstatusId': '19243'} |
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" = 6948 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" = 6948 AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."statusdate" DESC, "congstatus"."rank" DESC, "congstage"."rank" DESC |
28.12 | ||||||||||||||||||||
|
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", "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", "office"."office_id", "office"."officetype_id", "office"."release_id", "office"."code", "office"."name", "office"."title", "office"."npatoffice", "office"."shorttitle", "office"."rank", "candidate"."candidate_id", "candidate"."candidatestatus_id", "candidate"."candidatetitle_id", "candidate"."state_id", "candidate"."release_id", "candidate"."firstname", "candidate"."middlename", "candidate"."lastname", "candidate"."nickname", "candidate"."pronunciation", "candidate"."gender", "candidate"."suffix", "candidate"."birthdate", "candidate"."birthplace", "candidate"."homecity", "candidate"."education", "candidate"."family", "candidate"."profession", "candidate"."political", "candidate"."religion", "candidate"."orgmember", "candidate"."specialmsg", "candidate"."caucus", "candidate"."bioformyear", "candidate"."fecid", "candidate"."photourl", "candidate"."bioid", "candidate"."callnote", "candidate"."password", "candidate"."candidatepreferredname_id" FROM "office_candidate" INNER JOIN "office" ON ("office_candidate"."office_id" = "office"."office_id") INNER JOIN "candidate" ON ("office_candidate"."candidate_id" = "candidate"."candidate_id") WHERE ("office_candidate"."office_id" IN (1, 2, 3, 4) AND "office_candidate"."office_candidate_id" = 8384) LIMIT 1SELECT (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", "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", "office"."office_id", "office"."officetype_id", "office"."release_id", "office"."code", "office"."name", "office"."title", "office"."npatoffice", "office"."shorttitle", "office"."rank", "candidate"."candidate_id", "candidate"."candidatestatus_id", "candidate"."candidatetitle_id", "candidate"."state_id", "candidate"."release_id", "candidate"."firstname", "candidate"."middlename", "candidate"."lastname", "candidate"."nickname", "candidate"."pronunciation", "candidate"."gender", "candidate"."suffix", "candidate"."birthdate", "candidate"."birthplace", "candidate"."homecity", "candidate"."education", "candidate"."family", "candidate"."profession", "candidate"."political", "candidate"."religion", "candidate"."orgmember", "candidate"."specialmsg", "candidate"."caucus", "candidate"."bioformyear", "candidate"."fecid", "candidate"."photourl", "candidate"."bioid", "candidate"."callnote", "candidate"."password", "candidate"."candidatepreferredname_id" FROM "office_candidate" INNER JOIN "office" ON ("office_candidate"."office_id" = "office"."office_id") INNER JOIN "candidate" ON ("office_candidate"."candidate_id" = "candidate"."candidate_id") WHERE ("office_candidate"."office_id" IN (1, 2, 3, 4) AND "office_candidate"."office_candidate_id" = 8384) LIMIT 1 |
10.38 | ||||||||||||||||||||
|
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(454) bill[i].executive = tempCand[0] |
|||||||||||||||||||||
|
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" = 6948 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" = 6948 AND "congstatus"."release_id" >= 1) ORDER BY "congaction"."rank" ASC, "candidate"."lastname" ASC |
12.01 | ||||||||||||||||||||
|
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 (
10 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" = 20207 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" = 20207 AND "congstatus"."release_id" >= 1) |
8.80 | ||||||||||||||||||||
|
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 (
10 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" = 20208 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" = 20208 AND "congstatus"."release_id" >= 1) |
18.67 | ||||||||||||||||||||
|
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 (
10 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" = 20027 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" = 20027 AND "congstatus"."release_id" >= 1) |
31.53 | ||||||||||||||||||||
|
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 (
10 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" = 20029 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" = 20029 AND "congstatus"."release_id" >= 1) |
26.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(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
10 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" = 19243 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" = 19243 AND "congstatus"."release_id" >= 1) |
26.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(599) party_breakdown = parse_votes(bill_congstatus_id) /var/www/justfacts/keyvotes/views.py in parse_votes(43) if not votes: |
|||||||||||||||||||||
|
SELECT (
10 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" = 19241 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" = 19241 AND "congstatus"."release_id" >= 1) |
23.59 | ||||||||||||||||||||
|
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 (
10 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" = 19238 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" = 19238 AND "congstatus"."release_id" >= 1) |
27.73 | ||||||||||||||||||||
|
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 (
10 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" = 19236 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" = 19236 AND "congstatus"."release_id" >= 1) |
8.73 | ||||||||||||||||||||
|
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 (
10 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" = 19235 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" = 19235 AND "congstatus"."release_id" >= 1) |
5.50 | ||||||||||||||||||||
|
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 (
10 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" = 19234 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" = 19234 AND "congstatus"."release_id" >= 1) |
5.07 | ||||||||||||||||||||
|
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" ~ '*.6948.*' 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" ~ '*.6948.*' AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."congress_id" ASC |
16.37 | ||||||||||||||||||||
|
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" ~ '*.6948.*' 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" ~ '*.6948.*' AND "congstatus"."release_id" >= 1) ORDER BY "congstatus"."congress_id" ASC) subquery |
7.71 | ||||||||||||||||||||
|
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 = 6948SELECT 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 = 6948 |
2.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(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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 22 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 22 LIMIT 21 |
2.07 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 25 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 25 LIMIT 21 |
5.60 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 47 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 47 LIMIT 21 |
3.25 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 63 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 63 LIMIT 21 |
3.52 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 66 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 66 LIMIT 21 |
2.98 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 67 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 67 LIMIT 21 |
3.77 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 83 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 83 LIMIT 21 |
6.46 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 91 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 91 LIMIT 21 |
3.25 | ||||||||||||||||||||
|
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",
9 similar queries.
"category"."name", "category"."description", "category"."release_id", "category"."key", "category"."rank" FROM "category" WHERE "category"."category_id" = 93 LIMIT 21SELECT ••• FROM "category" WHERE "category"."category_id" = 93 LIMIT 21 |
3.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(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 "candidatepreferredname"."candidatepreferredname_id",
"candidatepreferredname"."name" FROM "candidatepreferredname" WHERE "candidatepreferredname"."candidatepreferredname_id" = 'F' LIMIT 21SELECT ••• FROM "candidatepreferredname" WHERE "candidatepreferredname"."candidatepreferredname_id" = 'F' LIMIT 21 |
3.38 | ||||||||||||||||||||
|
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(315) return 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/base.py in render(988) output = self.filter_expression.resolve(context) /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/candidate/models.py in get_preferred_name(1339) if self.candidatepreferredname.candidatepreferredname_id == 'N':
/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" = 6948) 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" = 6948) ORDER BY "congaction"."rank" ASC, "committee"."name" ASC |
3.65 | ||||||||||||||||||||
|
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 |
|||||||||||||||||||||
None
| 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: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df9063d70>>'}
{'comObj': '<<queryset of candidate.CommitteeCandidate>>',
'committee': <Committee: Committee object (11444)>,
'sponsoredStatus': '<<queryset of keyvotes.CongstatusCommittee>>',
'subComObj': '<<queryset of offices.Committee>>',
'title': 'Government Operations and Military Affairs Committee - Vermont '
'House Committee'}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'False': False, 'None': None, 'True': True}
{'DEFAULT_MESSAGE_LEVELS': {'DEBUG': 10,
'ERROR': 40,
'INFO': 20,
'SUCCESS': 25,
'WARNING': 30},
'csrf_token': '<SimpleLazyObject: '
"'w5gTMS0Ah3SZemZfZF99qFnKiufeEIALxmpYaF5GKQmRMyj7jqjsMsqfgaQjACJy'>",
'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df9cb5820>,
'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df88af0b0>,
'request': '<<request>>',
'user': '<SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object '
'at 0x7e8df8cca840>>'}
{'bill': '<<queryset of keyvotes.Congstatus>>',
'billYear': 2008,
'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': {'Sponsor': [<OfficeCandidate: OfficeCandidate object (9499)>]},
'state_id': 'NA',
'title': 'HR 2642 - Iraq and Afghanistan War Funding, Unemployment Benefits '
'Extension, and GI Bill - National Key Vote',
'unique_bills_in_family': <bound method QuerySet.count of <QuerySet [<Congstatus: Congstatus object (20207)>, <Congstatus: Congstatus object (19354)>, <Congstatus: Congstatus object (19356)>, <Congstatus: Congstatus object (19358)>]>>}
{'csrf_token': <SimpleLazyObject: '3JeQn54Nfrf20bRp2gjdAat6sdYyA1Ml40nVLS9TIeJUynbhm1twWXwBqTzDwVV8'>}
{}
{'request': <WSGIRequest: GET '/offices/committee/11444/government-operations-and-military-affairs-committee'>}
{'user': <SimpleLazyObject: <django.contrib.auth.models.AnonymousUser object at 0x7e8df9063d70>>, 'perms': <django.contrib.auth.context_processors.PermWrapper object at 0x7e8df92453a0>}
{'messages': <django.contrib.messages.storage.fallback.FallbackStorage object at 0x7e8df8bcbfb0>, '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 |