home

Shoe_Retail_US

Custom SQL query

Tables

ai_benefits

id, category, benefit_area, metric, impact_low, impact_high, roi_timeframe, shoe_retail_priority, notes

22 rows

ai_providers

id, category, provider, application, description, key_results, valuation_status, funding_raised, website, created_at, country, updated_at, previous_valuation

100 rows

alert_preferences

id, user_email, alert_type, alert_value, enabled, updated_at

0 rows

article_terms

id, article_id, article_source, term_id, frequency, in_title

157 rows

change_log

id, table_name, record_id, change_type, old_value, new_value, description, logged_at

0 rows

competitor_mentions

id, competitor, mentions

12 rows

detected_trends

id, term, signal_type, trend_score, recent_count, older_count, total_mentions, first_seen, last_seen, sample_titles, analyzed_at

120 rows

nrf_exhibitors_2026

id, exhid, company_name, website, booth_number, booth_level, booth_area, about_summary, product_categories, facebook_url, twitter_url, linkedin_url, instagram_url, collateral_json, logo_url, source_url, scraped_at, created_at

1,032 rows

rss_articles

id, url_hash, title, url, source, category, published_date, fetched_date, content, summary

13 rows

sources

id, title, url, domain, category, summary, content, fetched_at, date_added, enhanced_summary

982 rows

sqlite_sequence

name, seq

12 rows

trend_category_summary

id, category, article_count, total_mentions, avg_intensity, top_terms, updated_at

10 rows

trend_cooccurrence

id, term1, term2, cooccurrence_count, implication, updated_at

20 rows

trend_monthly

id, year_month, term, article_count, total_mentions, updated_at

112 rows

trend_monthly_category

id, year_month, category, article_count, total_mentions, updated_at

41 rows

trend_snapshots

id, snapshot_date, term_id, article_count, total_frequency

0 rows

trend_stats

id, stat_name, stat_value, updated_at

9 rows

trend_term_frequency

id, term, article_count, total_mentions, title_mentions, avg_intensity, term_type, updated_at

49 rows

trend_terms

id, term, normalized_term, category, first_seen, is_seed

88 rows

vendor_app_metrics

id, vendor_name, platform, rating, review_count, download_count, last_app_update, captured_date, short_description, store_url

6 rows

vendors

id, name, category, homepage, blog_url, playstore_url, appstore_url, notes, verified_date, created_at

7 rows

... and 5 hidden tables

Powered by Datasette · Queries took 11.998ms