participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,591 rows where station_code = "AU000D" 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 |
---|---|---|---|---|---|
5097110 | 5097110 | 20240912144213_6C7gB | AU000D | 2024-09-16T12:16:45.410Z | 2024-09-16T12:17:32.036Z |
5097090 | 5097090 | 20240912143415_fIErT | AU000D | 2024-09-16T12:16:44.752Z | 2024-09-16T12:17:32.029Z |
5097070 | 5097070 | 20240912141822_QMeS2 | AU000D | 2024-09-16T12:16:44.264Z | 2024-09-16T12:17:32.021Z |
5097058 | 5097058 | 20240912141013_9fIQt | AU000D | 2024-09-16T12:16:43.829Z | 2024-09-16T12:17:32.016Z |
5096947 | 5096947 | 20240912124409_BTrft | AU000D | 2024-09-16T12:16:39.974Z | 2024-09-16T12:17:31.973Z |
5096935 | 5096935 | 20240912123115_Ds5uB | AU000D | 2024-09-16T12:16:38.465Z | 2024-09-16T12:17:31.969Z |
5096924 | 5096924 | 20240912122341_cMEaJ | AU000D | 2024-09-16T12:16:38.134Z | 2024-09-16T12:17:31.965Z |
5096631 | 5096631 | 20240912112542_A8ckb | AU000D | 2024-09-16T12:16:30.152Z | 2024-09-16T12:17:31.828Z |
5085306 | 5085306 | 20240912210727_Y0VLC | AU000D | 2024-09-16T12:03:55.452Z | 2024-09-16T12:17:04.681Z |
5084996 | 5084996 | 20240912203907_UEGCD | AU000D | 2024-09-16T12:03:23.803Z | 2024-09-16T12:17:04.547Z |
5084824 | 5084824 | 20240912201654_S3ohr | AU000D | 2024-09-16T12:02:58.222Z | 2024-09-16T12:17:04.470Z |
5084697 | 5084697 | 20240912200733_kUBCF | AU000D | 2024-09-16T12:02:49.222Z | 2024-09-16T12:17:04.428Z |
5084550 | 5084550 | 20240912195009_HFQqx | AU000D | 2024-09-16T12:02:23.275Z | 2024-09-16T12:17:04.357Z |
5084380 | 5084380 | 20240912193155_hl8y6 | AU000D | 2024-09-16T12:01:59.656Z | 2024-09-16T12:17:04.277Z |
5084327 | 5084327 | 20240912192213_bCIgA | AU000D | 2024-09-16T12:01:53.017Z | 2024-09-16T12:17:04.250Z |
5084299 | 5084299 | 20240912191257_c3nql | AU000D | 2024-09-16T12:01:49.994Z | 2024-09-16T12:17:04.237Z |
5084217 | 5084217 | 20240912185920_2hsms | AU000D | 2024-09-16T12:01:35.849Z | 2024-09-16T12:17:04.186Z |
5084207 | 5084207 | 20240912185826_U5au3 | AU000D | 2024-09-16T12:01:34.846Z | 2024-09-16T12:17:04.181Z |
5084173 | 5084173 | 20240912184604_aB1oq | AU000D | 2024-09-16T12:01:25.472Z | 2024-09-16T12:17:04.160Z |
5084163 | 5084163 | 20240912184113_dhr17 | AU000D | 2024-09-16T12:01:21.912Z | 2024-09-16T12:17:04.148Z |
5084155 | 5084155 | 20240912183433_2F425 | AU000D | 2024-09-16T12:01:17.330Z | 2024-09-16T12:17:04.142Z |
5084130 | 5084130 | 20240912182254_oLYTG | AU000D | 2024-09-16T12:01:13.812Z | 2024-09-16T12:17:04.112Z |
5084102 | 5084102 | 20240912180937_wNbGG | AU000D | 2024-09-16T12:01:09.458Z | 2024-09-16T12:17:04.096Z |
5084081 | 5084081 | 20240912180325_g3n66 | AU000D | 2024-09-16T12:01:06.439Z | 2024-09-16T12:17:04.085Z |
5084063 | 5084063 | 20240912175742_SMXvy | AU000D | 2024-09-16T12:01:03.263Z | 2024-09-16T12:17:04.072Z |
5084029 | 5084029 | 20240912174201_MxCOS | AU000D | 2024-09-16T12:00:57.935Z | 2024-09-16T12:17:04.051Z |
5084009 | 5084009 | 20240912173702_dp4Rf | AU000D | 2024-09-16T12:00:55.183Z | 2024-09-16T12:17:04.034Z |
5083988 | 5083988 | 20240912172032_afNPg | AU000D | 2024-09-16T12:00:48.763Z | 2024-09-16T12:17:04.017Z |
5083974 | 5083974 | 20240912171225_2lk8f | AU000D | 2024-09-16T12:00:45.469Z | 2024-09-16T12:17:04.009Z |
5083945 | 5083945 | 20240912170349_N7zML | AU000D | 2024-09-16T12:00:42.530Z | 2024-09-16T12:17:03.996Z |
5083942 | 5083942 | 20240912170234_jgVWW | AU000D | 2024-09-16T12:00:42.309Z | 2024-09-16T12:17:03.994Z |
5083921 | 5083921 | 20240912164605_cYg11 | AU000D | 2024-09-16T12:00:39.540Z | 2024-09-16T12:17:03.977Z |
5083897 | 5083897 | 20240912163922_LB9G5 | AU000D | 2024-09-16T12:00:36.877Z | 2024-09-16T12:17:03.968Z |
5083880 | 5083880 | 20240912163212_wq7wq | AU000D | 2024-09-16T12:00:35.187Z | 2024-09-16T12:17:03.961Z |
5083840 | 5083840 | 20240912161152_RDuv7 | AU000D | 2024-09-16T12:00:30.037Z | 2024-09-16T12:17:03.937Z |
5083838 | 5083838 | 20240912161058_mX9oq | AU000D | 2024-09-16T12:00:29.595Z | 2024-09-16T12:17:03.936Z |
5083806 | 5083806 | 20240912154703_1Q4Yh | AU000D | 2024-09-16T12:00:25.109Z | 2024-09-16T12:17:03.919Z |
5083765 | 5083765 | 20240912151606_4DaaD | AU000D | 2024-09-16T12:00:17.404Z | 2024-09-16T12:17:03.889Z |
5083744 | 5083744 | 20240911141908_6Us4N | AU000D | 2024-09-15T12:18:45.869Z | 2024-09-16T12:19:20.414Z |
5083710 | 5083710 | 20240911141242_7g8sj | AU000D | 2024-09-15T12:18:45.641Z | 2024-09-16T12:19:20.172Z |
5083676 | 5083676 | 20240911141034_bxU4l | AU000D | 2024-09-15T12:18:45.468Z | 2024-09-16T12:19:20.124Z |
5083664 | 5083664 | 20240911140847_nzvPc | AU000D | 2024-09-15T12:18:45.276Z | 2024-09-16T12:19:20.095Z |
5083568 | 5083568 | 20240911135057_FbQkW | AU000D | 2024-09-15T12:18:44.033Z | 2024-09-16T12:19:19.514Z |
5083538 | 5083538 | 20240911134528_w1ZWs | AU000D | 2024-09-15T12:18:43.480Z | 2024-09-16T12:19:19.412Z |
5083360 | 5083360 | 20240911130136_SZfvp | AU000D | 2024-09-15T12:18:40.133Z | 2024-09-16T12:19:18.110Z |
5083351 | 5083351 | 20240911130020_GrCIz | AU000D | 2024-09-15T12:18:39.968Z | 2024-09-16T12:19:18.092Z |
5083312 | 5083312 | 20240911125405_9G6vg | AU000D | 2024-09-15T12:18:38.794Z | 2024-09-16T12:19:17.944Z |
5083304 | 5083304 | 20240911125158_cPR92 | AU000D | 2024-09-15T12:18:38.693Z | 2024-09-16T12:19:17.905Z |
5083266 | 5083266 | 20240911124021_iB6D6 | AU000D | 2024-09-15T12:18:37.920Z | 2024-09-16T12:19:17.660Z |
5082826 | 5082826 | 20240911110605_NOZUl | AU000D | 2024-09-15T12:18:26.645Z | 2024-09-16T12:19:14.774Z |
5073240 | 5073240 | 20240911210953_2U8nt | AU000D | 2024-09-15T12:06:57.266Z | 2024-09-16T12:17:29.218Z |
5073117 | 5073117 | 20240911210008_zrmuR | AU000D | 2024-09-15T12:06:41.955Z | 2024-09-16T12:17:29.198Z |
5073038 | 5073038 | 20240911205626_0zqhB | AU000D | 2024-09-15T12:06:32.016Z | 2024-09-16T12:17:29.191Z |
5073032 | 5073032 | 20240911205446_rhL30 | AU000D | 2024-09-15T12:06:30.315Z | 2024-09-16T12:17:29.188Z |
5073016 | 5073016 | 20240911205213_syV9q | AU000D | 2024-09-15T12:06:26.856Z | 2024-09-16T12:17:29.185Z |
5072978 | 5072978 | 20240911205059_bikva | AU000D | 2024-09-15T12:06:23.266Z | 2024-09-16T12:17:29.179Z |
5072950 | 5072950 | 20240911204826_KZVmh | AU000D | 2024-09-15T12:06:21.036Z | 2024-09-16T12:17:29.174Z |
5072720 | 5072720 | 20240911203819_fvIY3 | AU000D | 2024-09-15T12:06:03.252Z | 2024-09-16T12:17:29.140Z |
5072694 | 5072694 | 20240911203809_JF73a | AU000D | 2024-09-15T12:06:02.295Z | 2024-09-16T12:17:29.138Z |
5072621 | 5072621 | 20240911203009_bpZtL | AU000D | 2024-09-15T12:05:50.338Z | 2024-09-16T12:17:29.122Z |
5072587 | 5072587 | 20240911202526_5j23i | AU000D | 2024-09-15T12:05:40.757Z | 2024-09-16T12:17:29.113Z |
5072476 | 5072476 | 20240911201214_mPOOt | AU000D | 2024-09-15T12:05:27.832Z | 2024-09-16T12:17:29.093Z |
5072417 | 5072417 | 20240911200719_XI34e | AU000D | 2024-09-15T12:05:20.592Z | 2024-09-16T12:17:29.080Z |
5072345 | 5072345 | 20240911195626_GMT8x | AU000D | 2024-09-15T12:05:13.249Z | 2024-09-16T12:17:29.066Z |
5072185 | 5072185 | 20240911194609_BRkWO | AU000D | 2024-09-15T12:04:50.747Z | 2024-09-16T12:17:29.042Z |
5072033 | 5072033 | 20240911192506_FWBIm | AU000D | 2024-09-15T12:04:29.497Z | 2024-09-16T12:17:29.009Z |
5071997 | 5071997 | 20240911191810_AHhW2 | AU000D | 2024-09-15T12:04:16.109Z | 2024-09-16T12:17:29.000Z |
5071959 | 5071959 | 20240911191101_4WAuR | AU000D | 2024-09-15T12:04:08.241Z | 2024-09-16T12:17:28.990Z |
5071894 | 5071894 | 20240911185129_JNmLf | AU000D | 2024-09-15T12:03:57.804Z | 2024-09-16T12:17:28.972Z |
5071878 | 5071878 | 20240911184651_q3IKM | AU000D | 2024-09-15T12:03:54.807Z | 2024-09-16T12:17:28.966Z |
5071873 | 5071873 | 20240911184531_YcRZB | AU000D | 2024-09-15T12:03:54.117Z | 2024-09-16T12:17:28.964Z |
5071856 | 5071856 | 20240911183650_tFaFu | AU000D | 2024-09-15T12:03:51.368Z | 2024-09-16T12:17:28.960Z |
5071848 | 5071848 | 20240911183443_qkZ1L | AU000D | 2024-09-15T12:03:50.095Z | 2024-09-16T12:17:28.957Z |
5071811 | 5071811 | 20240911182625_5nhDV | AU000D | 2024-09-15T12:03:44.815Z | 2024-09-16T12:17:28.948Z |
5071809 | 5071809 | 20240911182545_La8da | AU000D | 2024-09-15T12:03:43.475Z | 2024-09-16T12:17:28.948Z |
5071807 | 5071807 | 20240911182528_3K8kY | AU000D | 2024-09-15T12:03:41.922Z | 2024-09-16T12:17:28.947Z |
5071803 | 5071803 | 20240911182345_qO9Bq | AU000D | 2024-09-15T12:03:40.139Z | 2024-09-16T12:17:28.946Z |
5071789 | 5071789 | 20240911181955_1CDaT | AU000D | 2024-09-15T12:03:33.888Z | 2024-09-16T12:17:28.942Z |
5071785 | 5071785 | 20240911181925_5SpY0 | AU000D | 2024-09-15T12:03:32.980Z | 2024-09-16T12:17:28.941Z |
5071712 | 5071712 | 20240911175742_L8y1c | AU000D | 2024-09-15T12:03:18.477Z | 2024-09-16T12:17:28.911Z |
5071690 | 5071690 | 20240911175049_wvMFS | AU000D | 2024-09-15T12:03:15.955Z | 2024-09-16T12:17:28.897Z |
5071676 | 5071676 | 20240911174340_chVe9 | AU000D | 2024-09-15T12:03:13.401Z | 2024-09-16T12:17:28.893Z |
5071629 | 5071629 | 20240911173116_b5LqY | AU000D | 2024-09-15T12:03:07.017Z | 2024-09-16T12:17:28.881Z |
5071626 | 5071626 | 20240911173112_Uaozf | AU000D | 2024-09-15T12:03:06.643Z | 2024-09-16T12:17:28.880Z |
5071623 | 5071623 | 20240911173027_po64U | AU000D | 2024-09-15T12:03:06.081Z | 2024-09-16T12:17:28.879Z |
5071620 | 5071620 | 20240911173024_vzevG | AU000D | 2024-09-15T12:03:05.743Z | 2024-09-16T12:17:28.878Z |
5071595 | 5071595 | 20240911172407_ET2pE | AU000D | 2024-09-15T12:03:02.923Z | 2024-09-16T12:17:28.872Z |
5071588 | 5071588 | 20240911172303_WlNp0 | AU000D | 2024-09-15T12:03:01.751Z | 2024-09-16T12:17:28.870Z |
5071410 | 5071410 | 20240911164804_qcCH1 | AU000D | 2024-09-15T12:02:29.163Z | 2024-09-16T12:17:28.804Z |
5071374 | 5071374 | 20240911164318_cZr4N | AU000D | 2024-09-15T12:02:23.986Z | 2024-09-16T12:17:28.795Z |
5071366 | 5071366 | 20240911164037_PYS2Y | AU000D | 2024-09-15T12:02:23.130Z | 2024-09-16T12:17:28.793Z |
5071060 | 5071060 | 20240911155337_lWQIK | AU000D | 2024-09-15T12:01:34.620Z | 2024-09-16T12:17:28.723Z |
5070658 | 5070658 | 20240911144609_lftT5 | AU000D | 2024-09-15T12:00:28.770Z | 2024-09-16T12:17:28.637Z |
5070655 | 5070655 | 20240911144608_84lCl | AU000D | 2024-09-15T12:00:28.306Z | 2024-09-16T12:17:28.637Z |
5070535 | 5070535 | 20240911142817_GwMSl | AU000D | 2024-09-15T12:00:15.976Z | 2024-09-16T12:17:28.613Z |
5070512 | 5070512 | 20240911142625_HOhq7 | AU000D | 2024-09-15T12:00:11.768Z | 2024-09-16T12:17:28.609Z |
5069072 | 5069072 | 20240910134008_joohS | AU000D | 2024-09-14T12:19:25.193Z | 2024-09-16T12:20:16.381Z |
5069049 | 5069049 | 20240910133053_VSb20 | AU000D | 2024-09-14T12:19:24.801Z | 2024-09-16T12:20:16.258Z |
5069038 | 5069038 | 20240910132852_9lxMX | AU000D | 2024-09-14T12:19:24.456Z | 2024-09-16T12:20:16.221Z |
5062804 | 5062804 | 20240909182751_r5IrT | AU000D | 2024-09-14T12:12:53.527Z | 2024-09-16T12:19:39.648Z |
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);