participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,582 rows where station_code = "AU003J" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5097114 | 5097114 | 20240912144213_6C7gB | AU003J | 2024-09-16T12:16:45.410Z | 2024-09-16T12:17:32.037Z |
5097046 | 5097046 | 20240912140159_Wkz32 | AU003J | 2024-09-16T12:16:43.385Z | 2024-09-16T12:17:32.011Z |
5097031 | 5097031 | 20240912135737_jEkz7 | AU003J | 2024-09-16T12:16:42.677Z | 2024-09-16T12:17:32.005Z |
5097017 | 5097017 | 20240912134045_PDL3Z | AU003J | 2024-09-16T12:16:42.326Z | 2024-09-16T12:17:31.997Z |
5096997 | 5096997 | 20240912132327_yvRhg | AU003J | 2024-09-16T12:16:41.834Z | 2024-09-16T12:17:31.991Z |
5096939 | 5096939 | 20240912123115_Ds5uB | AU003J | 2024-09-16T12:16:38.465Z | 2024-09-16T12:17:31.969Z |
5096932 | 5096932 | 20240912123055_RZv11 | AU003J | 2024-09-16T12:16:38.315Z | 2024-09-16T12:17:31.967Z |
5084828 | 5084828 | 20240912201654_S3ohr | AU003J | 2024-09-16T12:02:58.222Z | 2024-09-16T12:17:04.470Z |
5084701 | 5084701 | 20240912200733_kUBCF | AU003J | 2024-09-16T12:02:49.222Z | 2024-09-16T12:17:04.428Z |
5084377 | 5084377 | 20240912193054_IRw8n | AU003J | 2024-09-16T12:01:59.120Z | 2024-09-16T12:17:04.274Z |
5084220 | 5084220 | 20240912185920_2hsms | AU003J | 2024-09-16T12:01:35.849Z | 2024-09-16T12:17:04.186Z |
5084202 | 5084202 | 20240912185425_x2QKH | AU003J | 2024-09-16T12:01:33.916Z | 2024-09-16T12:17:04.172Z |
5084114 | 5084114 | 20240912181657_vyTVN | AU003J | 2024-09-16T12:01:11.047Z | 2024-09-16T12:17:04.101Z |
5084089 | 5084089 | 20240912180546_7e4Jt | AU003J | 2024-09-16T12:01:07.033Z | 2024-09-16T12:17:04.088Z |
5083862 | 5083862 | 20240912162035_Ev8sw | AU003J | 2024-09-16T12:00:32.585Z | 2024-09-16T12:17:03.952Z |
5083834 | 5083834 | 20240912160654_Hbd2W | AU003J | 2024-09-16T12:00:28.701Z | 2024-09-16T12:17:03.933Z |
5083680 | 5083680 | 20240911141034_bxU4l | AU003J | 2024-09-15T12:18:45.468Z | 2024-09-16T12:19:20.124Z |
5083543 | 5083543 | 20240911134607_fuYtS | AU003J | 2024-09-15T12:18:43.509Z | 2024-09-16T12:19:19.415Z |
5083494 | 5083494 | 20240911133206_3UOE3 | AU003J | 2024-09-15T12:18:42.565Z | 2024-09-16T12:19:18.713Z |
5082968 | 5082968 | 20240911113649_1R7iN | AU003J | 2024-09-15T12:18:32.080Z | 2024-09-16T12:19:16.151Z |
5073420 | 5073420 | 20240911212015_LYdu3 | AU003J | 2024-09-15T12:07:09.149Z | 2024-09-16T12:17:29.243Z |
5073020 | 5073020 | 20240911205213_syV9q | AU003J | 2024-09-15T12:06:26.856Z | 2024-09-16T12:17:29.185Z |
5072952 | 5072952 | 20240911204826_KZVmh | AU003J | 2024-09-15T12:06:21.036Z | 2024-09-16T12:17:29.174Z |
5072601 | 5072601 | 20240911202750_AphWo | AU003J | 2024-09-15T12:05:43.370Z | 2024-09-16T12:17:29.116Z |
5072433 | 5072433 | 20240911200842_N8x5g | AU003J | 2024-09-15T12:05:22.171Z | 2024-09-16T12:17:29.083Z |
5072355 | 5072355 | 20240911195756_gNSXj | AU003J | 2024-09-15T12:05:13.651Z | 2024-09-16T12:17:29.066Z |
5072349 | 5072349 | 20240911195626_GMT8x | AU003J | 2024-09-15T12:05:13.250Z | 2024-09-16T12:17:29.066Z |
5072181 | 5072181 | 20240911194453_ZuNGh | AU003J | 2024-09-15T12:04:49.956Z | 2024-09-16T12:17:29.041Z |
5072127 | 5072127 | 20240911193913_2YYyW | AU003J | 2024-09-15T12:04:42.557Z | 2024-09-16T12:17:29.030Z |
5072084 | 5072084 | 20240911193111_R5RLK | AU003J | 2024-09-15T12:04:37.240Z | 2024-09-16T12:17:29.021Z |
5072037 | 5072037 | 20240911192506_FWBIm | AU003J | 2024-09-15T12:04:29.498Z | 2024-09-16T12:17:29.009Z |
5071973 | 5071973 | 20240911191318_rtfW0 | AU003J | 2024-09-15T12:04:10.339Z | 2024-09-16T12:17:28.993Z |
5071966 | 5071966 | 20240911191204_uvNFs | AU003J | 2024-09-15T12:04:09.133Z | 2024-09-16T12:17:28.991Z |
5071962 | 5071962 | 20240911191101_4WAuR | AU003J | 2024-09-15T12:04:08.241Z | 2024-09-16T12:17:28.990Z |
5071955 | 5071955 | 20240911191044_vBqVh | AU003J | 2024-09-15T12:04:07.368Z | 2024-09-16T12:17:28.988Z |
5071953 | 5071953 | 20240911191013_nl61n | AU003J | 2024-09-15T12:04:06.570Z | 2024-09-16T12:17:28.987Z |
5071924 | 5071924 | 20240911190406_5zNvX | AU003J | 2024-09-15T12:04:02.140Z | 2024-09-16T12:17:28.980Z |
5071815 | 5071815 | 20240911182625_5nhDV | AU003J | 2024-09-15T12:03:44.815Z | 2024-09-16T12:17:28.948Z |
5071782 | 5071782 | 20240911181836_Vqfsh | AU003J | 2024-09-15T12:03:31.807Z | 2024-09-16T12:17:28.939Z |
5071776 | 5071776 | 20240911181530_BPvG3 | AU003J | 2024-09-15T12:03:30.220Z | 2024-09-16T12:17:28.937Z |
5071752 | 5071752 | 20240911181032_2pAMl | AU003J | 2024-09-15T12:03:24.795Z | 2024-09-16T12:17:28.920Z |
5071672 | 5071672 | 20240911174209_g0s7b | AU003J | 2024-09-15T12:03:12.763Z | 2024-09-16T12:17:28.892Z |
5071646 | 5071646 | 20240911173526_Cq8Ad | AU003J | 2024-09-15T12:03:09.612Z | 2024-09-16T12:17:28.886Z |
5071632 | 5071632 | 20240911173116_b5LqY | AU003J | 2024-09-15T12:03:07.017Z | 2024-09-16T12:17:28.881Z |
5071599 | 5071599 | 20240911172407_ET2pE | AU003J | 2024-09-15T12:03:02.923Z | 2024-09-16T12:17:28.872Z |
5071492 | 5071492 | 20240911170519_bs1YV | AU003J | 2024-09-15T12:02:40.727Z | 2024-09-16T12:17:28.845Z |
5071363 | 5071363 | 20240911163919_ekajK | AU003J | 2024-09-15T12:02:22.416Z | 2024-09-16T12:17:28.792Z |
5071225 | 5071225 | 20240911161833_Cn3h6 | AU003J | 2024-09-15T12:01:57.583Z | 2024-09-16T12:17:28.761Z |
5071086 | 5071086 | 20240911155750_lvhIa | AU003J | 2024-09-15T12:01:37.203Z | 2024-09-16T12:17:28.729Z |
5071081 | 5071081 | 20240911155654_mIxah | AU003J | 2024-09-15T12:01:36.464Z | 2024-09-16T12:17:28.728Z |
5071036 | 5071036 | 20240911154701_kR62j | AU003J | 2024-09-15T12:01:27.373Z | 2024-09-16T12:17:28.717Z |
5070880 | 5070880 | 20240911152239_U4TkT | AU003J | 2024-09-15T12:01:03.492Z | 2024-09-16T12:17:28.680Z |
5070753 | 5070753 | 20240911150604_wMuZd | AU003J | 2024-09-15T12:00:45.991Z | 2024-09-16T12:17:28.660Z |
5070674 | 5070674 | 20240911145048_YS3j9 | AU003J | 2024-09-15T12:00:32.828Z | 2024-09-16T12:17:28.640Z |
5069052 | 5069052 | 20240910133054_3woqS | AU003J | 2024-09-14T12:19:24.825Z | 2024-09-16T12:20:16.258Z |
5068930 | 5068930 | 20240910130430_EQ32s | AU003J | 2024-09-14T12:19:22.992Z | 2024-09-16T12:20:15.774Z |
5063428 | 5063428 | 20240909210856_lTFni | AU003J | 2024-09-14T12:13:59.380Z | 2024-09-16T12:19:43.861Z |
5063214 | 5063214 | 20240909202001_8PkjW | AU003J | 2024-09-14T12:13:42.823Z | 2024-09-16T12:19:42.696Z |
5063200 | 5063200 | 20240909201630_3C2sT | AU003J | 2024-09-14T12:13:39.914Z | 2024-09-16T12:19:42.527Z |
5063193 | 5063193 | 20240909201403_w68FT | AU003J | 2024-09-14T12:13:39.212Z | 2024-09-16T12:19:42.524Z |
5063108 | 5063108 | 20240909195354_2OyNS | AU003J | 2024-09-14T12:13:29.596Z | 2024-09-16T12:19:41.828Z |
5062977 | 5062977 | 20240909192535_Y2c2F | AU003J | 2024-09-14T12:13:12.536Z | 2024-09-16T12:19:40.686Z |
5062953 | 5062953 | 20240909192142_8XPn4 | AU003J | 2024-09-14T12:13:07.734Z | 2024-09-16T12:19:40.581Z |
5060602 | 5060602 | 20240910204106_V6skG | AU003J | 2024-09-14T12:09:10.902Z | 2024-09-16T12:18:16.682Z |
5060437 | 5060437 | 20240910203047_tOV7R | AU003J | 2024-09-14T12:08:48.990Z | 2024-09-16T12:18:15.643Z |
5060401 | 5060401 | 20240910202717_W27Gt | AU003J | 2024-09-14T12:08:44.802Z | 2024-09-16T12:18:15.235Z |
5060369 | 5060369 | 20240910202358_2llMS | AU003J | 2024-09-14T12:08:42.154Z | 2024-09-16T12:18:14.994Z |
5060254 | 5060254 | 20240910201100_JBoZo | AU003J | 2024-09-14T12:08:32.920Z | 2024-09-16T12:18:14.178Z |
5060060 | 5060060 | 20240910194418_lz1XN | AU003J | 2024-09-14T12:08:06.646Z | 2024-09-16T12:18:12.420Z |
5060019 | 5060019 | 20240910193450_Dy3VJ | AU003J | 2024-09-14T12:07:58.212Z | 2024-09-16T12:18:11.529Z |
5059913 | 5059913 | 20240910191914_uK54c | AU003J | 2024-09-14T12:07:37.017Z | 2024-09-16T12:18:10.015Z |
5059903 | 5059903 | 20240910191530_H0O8D | AU003J | 2024-09-14T12:07:35.132Z | 2024-09-16T12:18:09.959Z |
5059862 | 5059862 | 20240910190608_mgP13 | AU003J | 2024-09-14T12:07:26.947Z | 2024-09-16T12:18:09.517Z |
5059777 | 5059777 | 20240910185055_YL92G | AU003J | 2024-09-14T12:07:10.696Z | 2024-09-16T12:18:08.344Z |
5059634 | 5059634 | 20240910182111_bHMNd | AU003J | 2024-09-14T12:06:38.260Z | 2024-09-16T12:18:06.648Z |
5059618 | 5059618 | 20240910181750_28ybY | AU003J | 2024-09-14T12:06:36.260Z | 2024-09-16T12:18:06.549Z |
5059587 | 5059587 | 20240910181244_YvAne | AU003J | 2024-09-14T12:06:31.807Z | 2024-09-16T12:18:06.222Z |
5059579 | 5059579 | 20240910181001_6DayQ | AU003J | 2024-09-14T12:06:30.217Z | 2024-09-16T12:18:06.191Z |
5059560 | 5059560 | 20240910180649_x3amT | AU003J | 2024-09-14T12:06:27.151Z | 2024-09-16T12:18:06.062Z |
5059524 | 5059524 | 20240910175936_wsNk2 | AU003J | 2024-09-14T12:06:17.212Z | 2024-09-16T12:18:05.696Z |
5059459 | 5059459 | 20240910174555_emiXc | AU003J | 2024-09-14T12:06:08.927Z | 2024-09-16T12:18:05.078Z |
5059452 | 5059452 | 20240910174539_2NqOC | AU003J | 2024-09-14T12:06:07.231Z | 2024-09-16T12:18:05.047Z |
5059441 | 5059441 | 20240910174230_sA7Lx | AU003J | 2024-09-14T12:06:04.666Z | 2024-09-16T12:18:04.992Z |
5059435 | 5059435 | 20240910174217_N8Y2m | AU003J | 2024-09-14T12:06:02.917Z | 2024-09-16T12:18:04.914Z |
5059369 | 5059369 | 20240910173517_coM6A | AU003J | 2024-09-14T12:05:49.086Z | 2024-09-16T12:18:04.242Z |
5059319 | 5059319 | 20240910173044_7VwJ4 | AU003J | 2024-09-14T12:05:43.232Z | 2024-09-16T12:18:03.817Z |
5059303 | 5059303 | 20240910172925_YOFYk | AU003J | 2024-09-14T12:05:38.965Z | 2024-09-16T12:18:03.473Z |
5059162 | 5059162 | 20240910171814_UUjFY | AU003J | 2024-09-14T12:05:21.676Z | 2024-09-16T12:18:02.418Z |
5059148 | 5059148 | 20240910171653_Kol8i | AU003J | 2024-09-14T12:05:19.375Z | 2024-09-16T12:18:02.242Z |
5059132 | 5059132 | 20240910171608_cOGJt | AU003J | 2024-09-14T12:05:17.729Z | 2024-09-16T12:18:02.148Z |
5059126 | 5059126 | 20240910171516_jEfrX | AU003J | 2024-09-14T12:05:16.826Z | 2024-09-16T12:18:01.990Z |
5059124 | 5059124 | 20240910171410_vbl2i | AU003J | 2024-09-14T12:05:16.534Z | 2024-09-16T12:18:01.978Z |
5059115 | 5059115 | 20240910171344_b4Ofv | AU003J | 2024-09-14T12:05:15.701Z | 2024-09-16T12:18:01.912Z |
5059072 | 5059072 | 20240910171026_0WOkV | AU003J | 2024-09-14T12:05:11.454Z | 2024-09-16T12:18:01.554Z |
5059062 | 5059062 | 20240910170955_ekWkO | AU003J | 2024-09-14T12:05:09.855Z | 2024-09-16T12:18:01.376Z |
5058948 | 5058948 | 20240910170258_d608K | AU003J | 2024-09-14T12:04:57.444Z | 2024-09-16T12:18:00.053Z |
5058865 | 5058865 | 20240910165307_2nm28 | AU003J | 2024-09-14T12:04:41.077Z | 2024-09-16T12:17:59.184Z |
5058774 | 5058774 | 20240910164512_m3QYv | AU003J | 2024-09-14T12:04:30.324Z | 2024-09-16T12:17:57.732Z |
5058588 | 5058588 | 20240910162906_Ebnzg | AU003J | 2024-09-14T12:04:04.008Z | 2024-09-16T12:17:56.286Z |
5058014 | 5058014 | 20240910153531_40pJL | AU003J | 2024-09-14T12:02:37.014Z | 2024-09-16T12:17:49.288Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);