participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
128 rows where station_code = "AT0002" 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 |
---|---|---|---|---|---|
5079145 | 5079145 | 20240911023443_NegD8 | AT0002 | 2024-09-15T12:16:08.248Z | 2024-09-19T12:21:41.166Z |
5078622 | 5078622 | 20240911020622_yc3mE | AT0002 | 2024-09-15T12:15:45.521Z | 2024-09-19T12:21:40.619Z |
5077384 | 5077384 | 20240911004853_807wc | AT0002 | 2024-09-15T12:14:40.878Z | 2024-09-19T12:21:38.842Z |
5077274 | 5077274 | 20240911004024_sGWlY | AT0002 | 2024-09-15T12:14:36.447Z | 2024-09-19T12:21:38.616Z |
5077248 | 5077248 | 20240911003632_0F5GU | AT0002 | 2024-09-15T12:14:33.881Z | 2024-09-19T12:21:38.559Z |
5077077 | 5077077 | 20240911002300_F2v1D | AT0002 | 2024-09-15T12:14:21.595Z | 2024-09-19T12:21:38.199Z |
5076569 | 5076569 | 20240910234731_Gc5MA | AT0002 | 2024-09-15T12:13:44.069Z | 2024-09-19T12:21:37.358Z |
5076393 | 5076393 | 20240910233142_32QoH | AT0002 | 2024-09-15T12:13:32.238Z | 2024-09-19T12:21:36.790Z |
5076079 | 5076079 | 20240910230640_rEVBJ | AT0002 | 2024-09-15T12:13:17.253Z | 2024-09-19T12:21:36.423Z |
5070249 | 5070249 | 20240910224642_2KwPk | AT0002 | 2024-09-14T12:20:17.303Z | 2024-09-19T12:21:35.952Z |
5070194 | 5070194 | 20240910224121_hJ2FK | AT0002 | 2024-09-14T12:20:16.378Z | 2024-09-19T12:21:35.869Z |
5069875 | 5069875 | 20240910221208_D9F33 | AT0002 | 2024-09-14T12:20:08.382Z | 2024-09-19T12:21:35.383Z |
5069487 | 5069487 | 20240910214551_khx46 | AT0002 | 2024-09-14T12:19:58.202Z | 2024-09-19T12:21:34.944Z |
5069403 | 5069403 | 20240910214000_DW2Z9 | AT0002 | 2024-09-14T12:19:56.508Z | 2024-09-19T12:21:34.870Z |
5069174 | 5069174 | 20240910211517_OnHTg | AT0002 | 2024-09-14T12:19:47.239Z | 2024-09-19T12:21:33.776Z |
5060638 | 5060638 | 20240910204640_o1ogR | AT0002 | 2024-09-14T12:09:15.508Z | 2024-09-19T12:21:33.277Z |
5060530 | 5060530 | 20240910203609_8Qr4G | AT0002 | 2024-09-14T12:08:59.079Z | 2024-09-19T12:21:32.518Z |
5060305 | 5060305 | 20240910201707_nWzqw | AT0002 | 2024-09-14T12:08:37.116Z | 2024-09-19T12:21:32.145Z |
5054575 | 5054575 | 20240908031147_t4EGh | AT0002 | 2024-09-13T12:16:47.522Z | 2024-09-16T12:21:16.122Z |
5054521 | 5054521 | 20240908030433_ogrR3 | AT0002 | 2024-09-13T12:16:45.830Z | 2024-09-16T12:21:15.880Z |
5054465 | 5054465 | 20240908025448_mpbbV | AT0002 | 2024-09-13T12:16:42.660Z | 2024-09-16T12:21:15.654Z |
5054225 | 5054225 | 20240908023009_9kFik | AT0002 | 2024-09-13T12:16:34.573Z | 2024-09-16T12:21:14.590Z |
5054183 | 5054183 | 20240908022236_vrDCT | AT0002 | 2024-09-13T12:16:32.616Z | 2024-09-16T12:21:14.218Z |
5054020 | 5054020 | 20240908020116_LlYm2 | AT0002 | 2024-09-13T12:16:26.720Z | 2024-09-16T12:21:13.777Z |
5054012 | 5054012 | 20240908020055_Tif1X | AT0002 | 2024-09-13T12:16:26.414Z | 2024-09-16T12:21:13.757Z |
5054006 | 5054006 | 20240908020040_wOWqu | AT0002 | 2024-09-13T12:16:26.307Z | 2024-09-16T12:21:13.752Z |
5053999 | 5053999 | 20240908015930_nv0Mb | AT0002 | 2024-09-13T12:16:26.126Z | 2024-09-16T12:21:13.732Z |
5053805 | 5053805 | 20240908013325_2i9Q2 | AT0002 | 2024-09-13T12:16:17.918Z | 2024-09-16T12:21:12.795Z |
5053790 | 5053790 | 20240908013115_qr6ca | AT0002 | 2024-09-13T12:16:17.583Z | 2024-09-16T12:21:12.776Z |
5053724 | 5053724 | 20240908012135_vLdKZ | AT0002 | 2024-09-13T12:16:15.416Z | 2024-09-16T12:21:12.602Z |
5053720 | 5053720 | 20240908012120_43OO2 | AT0002 | 2024-09-13T12:16:15.082Z | 2024-09-16T12:21:12.601Z |
5053612 | 5053612 | 20240908010648_jYuVx | AT0002 | 2024-09-13T12:16:10.247Z | 2024-09-16T12:21:12.169Z |
5053610 | 5053610 | 20240908010631_XiL3i | AT0002 | 2024-09-13T12:16:10.230Z | 2024-09-16T12:21:12.167Z |
5053452 | 5053452 | 20240908003738_31HTf | AT0002 | 2024-09-13T12:16:04.456Z | 2024-09-16T12:21:11.265Z |
5053303 | 5053303 | 20240908000637_KPbRh | AT0002 | 2024-09-13T12:15:57.785Z | 2024-09-16T12:21:10.295Z |
5053263 | 5053263 | 20240908000005_IXKeN | AT0002 | 2024-09-13T12:15:55.653Z | 2024-09-16T12:21:10.172Z |
5053235 | 5053235 | 20240907235527_QavYz | AT0002 | 2024-09-13T12:15:54.536Z | 2024-09-16T12:21:10.051Z |
5053134 | 5053134 | 20240907233145_oSisA | AT0002 | 2024-09-13T12:15:48.375Z | 2024-09-16T12:21:09.711Z |
5053102 | 5053102 | 20240907232644_d305Y | AT0002 | 2024-09-13T12:15:46.690Z | 2024-09-16T12:21:09.476Z |
5053084 | 5053084 | 20240907232020_vjKvZ | AT0002 | 2024-09-13T12:15:45.459Z | 2024-09-16T12:21:09.447Z |
5053052 | 5053052 | 20240907231125_Q40C9 | AT0002 | 2024-09-13T12:15:43.677Z | 2024-09-16T12:21:09.214Z |
5053003 | 5053003 | 20240907225919_9jign | AT0002 | 2024-09-13T12:15:41.701Z | 2024-09-16T12:21:08.939Z |
5052995 | 5052995 | 20240907225648_EF4lK | AT0002 | 2024-09-13T12:15:41.219Z | 2024-09-16T12:21:08.892Z |
5052956 | 5052956 | 20240907224615_bZ2Vs | AT0002 | 2024-09-13T12:15:38.581Z | 2024-09-16T12:21:08.721Z |
5052952 | 5052952 | 20240907224550_jnRS7 | AT0002 | 2024-09-13T12:15:37.933Z | 2024-09-16T12:21:08.679Z |
5052941 | 5052941 | 20240907224301_xhPC0 | AT0002 | 2024-09-13T12:15:37.302Z | 2024-09-16T12:21:08.646Z |
5052935 | 5052935 | 20240907224224_OlhOp | AT0002 | 2024-09-13T12:15:37.232Z | 2024-09-16T12:21:08.637Z |
5052863 | 5052863 | 20240907222506_G8q2a | AT0002 | 2024-09-13T12:15:33.098Z | 2024-09-16T12:21:08.282Z |
5052845 | 5052845 | 20240907222006_XtWC2 | AT0002 | 2024-09-13T12:15:31.793Z | 2024-09-16T12:21:08.218Z |
5052687 | 5052687 | 20240907213656_MLVtl | AT0002 | 2024-09-13T12:15:19.644Z | 2024-09-16T12:21:07.109Z |
5052577 | 5052577 | 20240907210756_KW8p5 | AT0002 | 2024-09-13T12:15:14.409Z | 2024-09-16T12:21:06.495Z |
5052575 | 5052575 | 20240907210717_3ZVJY | AT0002 | 2024-09-13T12:15:14.333Z | 2024-09-16T12:21:06.494Z |
5052570 | 5052570 | 20240907210536_7Rltg | AT0002 | 2024-09-13T12:15:14.263Z | 2024-09-16T12:21:06.490Z |
5052454 | 5052454 | 20240907204552_P2mcs | AT0002 | 2024-09-13T12:15:09.677Z | 2024-09-16T12:21:05.646Z |
5052189 | 5052189 | 20240907195610_jFXKd | AT0002 | 2024-09-13T12:14:59.752Z | 2024-09-16T12:21:04.335Z |
5052093 | 5052093 | 20240907194044_N3pyF | AT0002 | 2024-09-13T12:14:56.578Z | 2024-09-16T12:21:03.715Z |
5051980 | 5051980 | 20240907191829_UHU7E | AT0002 | 2024-09-13T12:14:51.509Z | 2024-09-16T12:21:02.703Z |
5051830 | 5051830 | 20240907184905_WI6Km | AT0002 | 2024-09-13T12:14:37.039Z | 2024-09-16T12:21:02.105Z |
5033573 | 5033573 | 20240907031242_3uQtt | AT0002 | 2024-09-12T12:09:41.585Z | 2024-09-15T12:21:30.530Z |
5033563 | 5033563 | 20240907031015_13siy | AT0002 | 2024-09-12T12:09:40.864Z | 2024-09-15T12:21:30.495Z |
5033543 | 5033543 | 20240907030815_sypfA | AT0002 | 2024-09-12T12:09:38.732Z | 2024-09-15T12:21:30.462Z |
5033474 | 5033474 | 20240907030145_P9NXo | AT0002 | 2024-09-12T12:09:33.961Z | 2024-09-15T12:21:30.207Z |
5033459 | 5033459 | 20240907030042_qgiLX | AT0002 | 2024-09-12T12:09:33.290Z | 2024-09-15T12:21:30.168Z |
5033227 | 5033227 | 20240907024021_YAjCH | AT0002 | 2024-09-12T12:08:59.495Z | 2024-09-15T12:21:29.264Z |
5033144 | 5033144 | 20240907022930_2WFZ6 | AT0002 | 2024-09-12T12:08:52.487Z | 2024-09-15T12:21:29.050Z |
5033041 | 5033041 | 20240907021849_cH5Uk | AT0002 | 2024-09-12T12:08:45.495Z | 2024-09-15T12:21:28.904Z |
5032934 | 5032934 | 20240907020620_RIMEr | AT0002 | 2024-09-12T12:08:32.030Z | 2024-09-15T12:21:28.369Z |
5032902 | 5032902 | 20240907020248_eCS2h | AT0002 | 2024-09-12T12:08:22.797Z | 2024-09-15T12:21:28.163Z |
5032822 | 5032822 | 20240907015248_695Cr | AT0002 | 2024-09-12T12:08:07.476Z | 2024-09-15T12:21:27.993Z |
5032814 | 5032814 | 20240907015119_N4FSu | AT0002 | 2024-09-12T12:08:06.498Z | 2024-09-15T12:21:27.975Z |
5032554 | 5032554 | 20240907011358_SrcLq | AT0002 | 2024-09-12T12:07:40.117Z | 2024-09-15T12:21:26.783Z |
5032514 | 5032514 | 20240907011116_flKRd | AT0002 | 2024-09-12T12:07:26.932Z | 2024-09-15T12:21:26.670Z |
5032478 | 5032478 | 20240907010721_XLmaK | AT0002 | 2024-09-12T12:07:23.219Z | 2024-09-15T12:21:26.569Z |
5032470 | 5032470 | 20240907010610_LkSRn | AT0002 | 2024-09-12T12:07:22.850Z | 2024-09-15T12:21:26.531Z |
5032375 | 5032375 | 20240907005442_29XSE | AT0002 | 2024-09-12T12:07:12.485Z | 2024-09-15T12:21:26.301Z |
5032350 | 5032350 | 20240907005124_l6d3q | AT0002 | 2024-09-12T12:07:09.680Z | 2024-09-15T12:21:26.218Z |
5032345 | 5032345 | 20240907005022_Fl325 | AT0002 | 2024-09-12T12:07:09.322Z | 2024-09-15T12:21:26.201Z |
5032154 | 5032154 | 20240907002134_8k3ic | AT0002 | 2024-09-12T12:06:38.923Z | 2024-09-15T12:21:25.363Z |
5031950 | 5031950 | 20240906234516_HgRbM | AT0002 | 2024-09-12T12:06:09.532Z | 2024-09-15T12:21:24.857Z |
5031873 | 5031873 | 20240906233501_3diH2 | AT0002 | 2024-09-12T12:05:58.943Z | 2024-09-15T12:21:24.604Z |
5031624 | 5031624 | 20240906224435_du1iK | AT0002 | 2024-09-12T12:05:17.718Z | 2024-09-15T12:21:23.466Z |
5031614 | 5031614 | 20240906224317_3QVNM | AT0002 | 2024-09-12T12:05:16.748Z | 2024-09-15T12:21:23.439Z |
5031573 | 5031573 | 20240906223426_cOvb3 | AT0002 | 2024-09-12T12:05:12.226Z | 2024-09-15T12:21:23.140Z |
5031565 | 5031565 | 20240906223011_43O8j | AT0002 | 2024-09-12T12:05:11.296Z | 2024-09-15T12:21:23.111Z |
5031548 | 5031548 | 20240906222713_eViiZ | AT0002 | 2024-09-12T12:05:09.275Z | 2024-09-15T12:21:22.987Z |
5031544 | 5031544 | 20240906222508_zQ16F | AT0002 | 2024-09-12T12:05:08.714Z | 2024-09-15T12:21:22.919Z |
5031530 | 5031530 | 20240906222017_gDwib | AT0002 | 2024-09-12T12:05:06.962Z | 2024-09-15T12:21:22.808Z |
5031466 | 5031466 | 20240906220208_Wj1F6 | AT0002 | 2024-09-12T12:04:59.324Z | 2024-09-15T12:21:22.640Z |
5026222 | 5026222 | 20240905024308_MgQB7 | AT0002 | 2024-09-11T12:12:06.013Z | 2024-09-13T12:19:57.186Z |
5026032 | 5026032 | 20240905020403_yAkFD | AT0002 | 2024-09-11T12:11:48.179Z | 2024-09-13T12:19:56.633Z |
5025810 | 5025810 | 20240905011936_9DSzS | AT0002 | 2024-09-11T12:11:08.118Z | 2024-09-13T12:19:55.746Z |
5020811 | 5020811 | 20240905031003_Qd3VF | AT0002 | 2024-09-10T12:15:02.662Z | 2024-09-13T12:19:57.788Z |
5020719 | 5020719 | 20240905025123_EZcuL | AT0002 | 2024-09-10T12:14:58.230Z | 2024-09-13T12:19:57.442Z |
5020666 | 5020666 | 20240905024308_NWPE1 | AT0002 | 2024-09-10T12:14:55.438Z | 2024-09-10T12:16:55.210Z |
5020467 | 5020467 | 20240905020403_CYTTb | AT0002 | 2024-09-10T12:14:31.721Z | 2024-09-10T12:16:55.156Z |
5020242 | 5020242 | 20240905011936_rKX98 | AT0002 | 2024-09-10T12:14:10.059Z | 2024-09-10T12:16:55.107Z |
5020070 | 5020070 | 20240905004921_8rGGU | AT0002 | 2024-09-10T12:13:53.429Z | 2024-09-13T12:19:54.948Z |
5019888 | 5019888 | 20240905001302_Xddbe | AT0002 | 2024-09-10T12:13:40.576Z | 2024-09-13T12:19:54.258Z |
5019883 | 5019883 | 20240905001216_uDOHC | AT0002 | 2024-09-10T12:13:40.145Z | 2024-09-13T12:19:54.246Z |
5008395 | 5008395 | 20240903233946_veyOE | AT0002 | 2024-09-09T12:06:41.945Z | 2024-09-12T12:19:17.439Z |
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);