{"id":26166,"date":"2024-03-09T17:27:24","date_gmt":"2024-03-09T16:27:24","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/where-to-find-big-datasets-with-updated_at-date-column\/"},"modified":"2024-03-09T17:27:24","modified_gmt":"2024-03-09T16:27:24","slug":"where-to-find-big-datasets-with-updated_at-date-column","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/where-to-find-big-datasets-with-updated_at-date-column\/","title":{"rendered":"Where To Find Big Datasets With &#8220;updated_at&#8221; Date Column?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi,<\/p>\n<p>I want to create a sample SCD Type 2 table. To do so, I am looking for some big dataset (&gt;5GB) which updates daily and has &#8220;updated_at&#8221; date attribute that represents a date when a row has changed.<\/p>\n<p>Example:<\/p>\n<p>Today dataset looks like this<\/p>\n<p>   id color updated_at    1 blue 01.01.2024   2 red 01.01.2024   <\/p>\n<p>Tomorrow dataset looks like this:<\/p>\n<p>   id color updated_at    1 <strong>yellow<\/strong> <strong>10.03.2024<\/strong>   2 red 01.01.2024   <\/p>\n<p>Do you know where I could find such datasets?<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Betelgeitze\"> \/u\/Betelgeitze <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1bakc70\/where_to_find_big_datasets_with_updated_at_date\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1bakc70\/where_to_find_big_datasets_with_updated_at_date\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-26166 jlk' href='javascript:void(0)' data-task='like' data-post_id='26166' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-26166 lc'>0<\/span><\/a><\/div><\/div> <div class='status-26166 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi, I want to create a sample SCD Type 2 table. To do so, I am looking&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-26166","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/26166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=26166"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/26166\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=26166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=26166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=26166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}