participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,299 rows where station_code = "AU002B" 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 |
---|---|---|---|---|---|
5097112 | 5097112 | 20240912144213_6C7gB | AU002B | 2024-09-16T12:16:45.410Z | 2024-09-16T12:17:32.037Z |
5097083 | 5097083 | 20240912142709_u0NMb | AU002B | 2024-09-16T12:16:44.548Z | 2024-09-16T12:17:32.026Z |
5096937 | 5096937 | 20240912123115_Ds5uB | AU002B | 2024-09-16T12:16:38.465Z | 2024-09-16T12:17:31.969Z |
5096887 | 5096887 | 20240912120258_iSV8m | AU002B | 2024-09-16T12:16:36.803Z | 2024-09-16T12:17:31.949Z |
5084628 | 5084628 | 20240912195821_9AFWD | AU002B | 2024-09-16T12:02:40.506Z | 2024-09-16T12:17:04.395Z |
5084219 | 5084219 | 20240912185920_2hsms | AU002B | 2024-09-16T12:01:35.849Z | 2024-09-16T12:17:04.186Z |
5084175 | 5084175 | 20240912184604_aB1oq | AU002B | 2024-09-16T12:01:25.472Z | 2024-09-16T12:17:04.160Z |
5083947 | 5083947 | 20240912170349_N7zML | AU002B | 2024-09-16T12:00:42.531Z | 2024-09-16T12:17:03.996Z |
5083923 | 5083923 | 20240912164605_cYg11 | AU002B | 2024-09-16T12:00:39.540Z | 2024-09-16T12:17:03.977Z |
5083899 | 5083899 | 20240912163922_LB9G5 | AU002B | 2024-09-16T12:00:36.877Z | 2024-09-16T12:17:03.968Z |
5083787 | 5083787 | 20240912153432_Z2nP2 | AU002B | 2024-09-16T12:00:22.461Z | 2024-09-16T12:17:03.908Z |
5083712 | 5083712 | 20240911141242_7g8sj | AU002B | 2024-09-15T12:18:45.641Z | 2024-09-16T12:19:20.172Z |
5083569 | 5083569 | 20240911135057_FbQkW | AU002B | 2024-09-15T12:18:44.033Z | 2024-09-16T12:19:19.514Z |
5073019 | 5073019 | 20240911205213_syV9q | AU002B | 2024-09-15T12:06:26.856Z | 2024-09-16T12:17:29.185Z |
5072819 | 5072819 | 20240911204134_6kkIe | AU002B | 2024-09-15T12:06:09.553Z | 2024-09-16T12:17:29.153Z |
5072697 | 5072697 | 20240911203809_JF73a | AU002B | 2024-09-15T12:06:02.295Z | 2024-09-16T12:17:29.138Z |
5072420 | 5072420 | 20240911200719_XI34e | AU002B | 2024-09-15T12:05:20.592Z | 2024-09-16T12:17:29.080Z |
5072354 | 5072354 | 20240911195756_gNSXj | AU002B | 2024-09-15T12:05:13.651Z | 2024-09-16T12:17:29.066Z |
5072348 | 5072348 | 20240911195626_GMT8x | AU002B | 2024-09-15T12:05:13.250Z | 2024-09-16T12:17:29.066Z |
5071895 | 5071895 | 20240911185129_JNmLf | AU002B | 2024-09-15T12:03:57.804Z | 2024-09-16T12:17:28.972Z |
5071881 | 5071881 | 20240911184651_q3IKM | AU002B | 2024-09-15T12:03:54.807Z | 2024-09-16T12:17:28.966Z |
5071806 | 5071806 | 20240911182345_qO9Bq | AU002B | 2024-09-15T12:03:40.139Z | 2024-09-16T12:17:28.946Z |
5071775 | 5071775 | 20240911181530_BPvG3 | AU002B | 2024-09-15T12:03:30.220Z | 2024-09-16T12:17:28.937Z |
5071714 | 5071714 | 20240911175742_L8y1c | AU002B | 2024-09-15T12:03:18.478Z | 2024-09-16T12:17:28.911Z |
5071631 | 5071631 | 20240911173116_b5LqY | AU002B | 2024-09-15T12:03:07.017Z | 2024-09-16T12:17:28.881Z |
5071625 | 5071625 | 20240911173027_po64U | AU002B | 2024-09-15T12:03:06.081Z | 2024-09-16T12:17:28.879Z |
5071413 | 5071413 | 20240911164804_qcCH1 | AU002B | 2024-09-15T12:02:29.163Z | 2024-09-16T12:17:28.804Z |
5071377 | 5071377 | 20240911164318_cZr4N | AU002B | 2024-09-15T12:02:23.986Z | 2024-09-16T12:17:28.795Z |
5071063 | 5071063 | 20240911155337_lWQIK | AU002B | 2024-09-15T12:01:34.621Z | 2024-09-16T12:17:28.723Z |
5070656 | 5070656 | 20240911144608_84lCl | AU002B | 2024-09-15T12:00:28.306Z | 2024-09-16T12:17:28.637Z |
5070538 | 5070538 | 20240911142817_GwMSl | AU002B | 2024-09-15T12:00:15.986Z | 2024-09-16T12:17:28.613Z |
5069050 | 5069050 | 20240910133053_VSb20 | AU002B | 2024-09-14T12:19:24.801Z | 2024-09-16T12:20:16.258Z |
5063199 | 5063199 | 20240909201630_3C2sT | AU002B | 2024-09-14T12:13:39.914Z | 2024-09-16T12:19:42.527Z |
5063192 | 5063192 | 20240909201403_w68FT | AU002B | 2024-09-14T12:13:39.212Z | 2024-09-16T12:19:42.524Z |
5062490 | 5062490 | 20240909173125_J4Iei | AU002B | 2024-09-14T12:12:27.753Z | 2024-09-16T12:19:37.539Z |
5060820 | 5060820 | 20240910211744_21zW3 | AU002B | 2024-09-14T12:09:37.255Z | 2024-09-16T12:18:20.077Z |
5060436 | 5060436 | 20240910203047_tOV7R | AU002B | 2024-09-14T12:08:48.989Z | 2024-09-16T12:18:15.643Z |
5060399 | 5060399 | 20240910202716_SHsg6 | AU002B | 2024-09-14T12:08:44.646Z | 2024-09-16T12:18:15.226Z |
5060017 | 5060017 | 20240910193449_tGZAB | AU002B | 2024-09-14T12:07:58.080Z | 2024-09-16T12:18:11.528Z |
5059861 | 5059861 | 20240910190608_mgP13 | AU002B | 2024-09-14T12:07:26.947Z | 2024-09-16T12:18:09.517Z |
5059815 | 5059815 | 20240910185908_aSZfZ | AU002B | 2024-09-14T12:07:19.986Z | 2024-09-16T12:18:08.872Z |
5059782 | 5059782 | 20240910185240_xSrLM | AU002B | 2024-09-14T12:07:11.163Z | 2024-09-16T12:18:08.353Z |
5059767 | 5059767 | 20240910184636_bFVAl | AU002B | 2024-09-14T12:07:09.359Z | 2024-09-16T12:18:08.292Z |
5059633 | 5059633 | 20240910182111_bHMNd | AU002B | 2024-09-14T12:06:38.260Z | 2024-09-16T12:18:06.648Z |
5059616 | 5059616 | 20240910181749_iYZMj | AU002B | 2024-09-14T12:06:35.970Z | 2024-09-16T12:18:06.548Z |
5059457 | 5059457 | 20240910174555_jIdN9 | AU002B | 2024-09-14T12:06:08.514Z | 2024-09-16T12:18:05.069Z |
5059451 | 5059451 | 20240910174539_2NqOC | AU002B | 2024-09-14T12:06:07.231Z | 2024-09-16T12:18:05.047Z |
5058773 | 5058773 | 20240910164512_m3QYv | AU002B | 2024-09-14T12:04:30.324Z | 2024-09-16T12:17:57.732Z |
5058679 | 5058679 | 20240910163516_Kr2Jz | AU002B | 2024-09-14T12:04:18.330Z | 2024-09-16T12:17:57.078Z |
5058308 | 5058308 | 20240910160159_5j5Ua | AU002B | 2024-09-14T12:03:25.495Z | 2024-09-16T12:17:52.666Z |
5058012 | 5058012 | 20240910153530_LNswR | AU002B | 2024-09-14T12:02:36.666Z | 2024-09-16T12:17:49.281Z |
5057841 | 5057841 | 20240910151726_9bANx | AU002B | 2024-09-14T12:02:13.046Z | 2024-09-16T12:17:47.965Z |
5057741 | 5057741 | 20240910150753_Tomc9 | AU002B | 2024-09-14T12:01:51.425Z | 2024-09-16T12:17:46.859Z |
5057660 | 5057660 | 20240910150115_xu6tf | AU002B | 2024-09-14T12:01:40.635Z | 2024-09-16T12:17:46.091Z |
5057466 | 5057466 | 20240910143228_3nGGe | AU002B | 2024-09-14T12:01:07.205Z | 2024-09-16T12:17:44.205Z |
5057081 | 5057081 | 20240908120913_oVojP | AU002B | 2024-09-13T12:17:44.544Z | 2024-09-16T12:21:28.744Z |
5057056 | 5057056 | 20240908120550_3M4Ca | AU002B | 2024-09-13T12:17:44.384Z | 2024-09-16T12:21:28.722Z |
5056682 | 5056682 | 20240908110718_wLSai | AU002B | 2024-09-13T12:17:37.596Z | 2024-09-16T12:21:26.754Z |
5050064 | 5050064 | 20240909123823_6k7HP | AU002B | 2024-09-13T12:12:38.424Z | 2024-09-16T12:20:45.309Z |
5050057 | 5050057 | 20240909123522_lYufC | AU002B | 2024-09-13T12:12:38.180Z | 2024-09-16T12:20:45.304Z |
5049999 | 5049999 | 20240909121653_D8cCC | AU002B | 2024-09-13T12:12:35.453Z | 2024-09-16T12:20:45.049Z |
5049799 | 5049799 | 20240909114149_d5RFN | AU002B | 2024-09-13T12:12:26.883Z | 2024-09-16T12:20:44.191Z |
5045556 | 5045556 | 20240908172347_CnaX9 | AU002B | 2024-09-13T12:04:19.821Z | 2024-09-16T12:20:26.048Z |
5044081 | 5044081 | 20240908141125_35nhF | AU002B | 2024-09-13T12:01:25.413Z | 2024-09-16T12:20:19.875Z |
5043901 | 5043901 | 20240908133426_xt2pQ | AU002B | 2024-09-13T12:00:56.553Z | 2024-09-16T12:20:19.458Z |
5043732 | 5043732 | 20240908125317_2H1Um | AU002B | 2024-09-13T12:00:31.920Z | 2024-09-16T12:20:18.727Z |
5043679 | 5043679 | 20240908123707_KSgN3 | AU002B | 2024-09-13T12:00:22.996Z | 2024-09-16T12:20:18.479Z |
5043607 | 5043607 | 20240908122106_C5R1t | AU002B | 2024-09-13T12:00:13.512Z | 2024-09-16T12:20:18.252Z |
5038704 | 5038704 | 20240905212820_pys5M | AU002B | 2024-09-12T12:14:55.420Z | 2024-09-14T12:22:57.281Z |
5038681 | 5038681 | 20240905212409_AesJY | AU002B | 2024-09-12T12:14:54.645Z | 2024-09-14T12:22:57.157Z |
5038451 | 5038451 | 20240905201920_e0FPo | AU002B | 2024-09-12T12:14:41.434Z | 2024-09-14T12:22:56.128Z |
5038449 | 5038449 | 20240905201850_u59Hp | AU002B | 2024-09-12T12:14:41.175Z | 2024-09-14T12:22:56.128Z |
5038258 | 5038258 | 20240905181211_h2tvX | AU002B | 2024-09-12T12:14:29.292Z | 2024-09-14T12:22:55.435Z |
5036319 | 5036319 | 20240905131425_VmaLc | AU002B | 2024-09-12T12:13:34.677Z | 2024-09-14T12:22:52.270Z |
5031264 | 5031264 | 20240906210423_3rKcb | AU002B | 2024-09-12T12:04:24.103Z | 2024-09-15T12:21:21.863Z |
5030583 | 5030583 | 20240906170232_143OR | AU002B | 2024-09-12T12:02:24.527Z | 2024-09-15T12:21:19.176Z |
5030162 | 5030162 | 20240906131943_RKd8A | AU002B | 2024-09-12T12:01:18.067Z | 2024-09-15T12:21:18.162Z |
5024274 | 5024274 | 20240905212820_zCiRd | AU002B | 2024-09-11T12:03:12.302Z | 2024-09-11T12:16:32.043Z |
5024255 | 5024255 | 20240905212409_LYQlU | AU002B | 2024-09-11T12:03:06.973Z | 2024-09-11T12:16:32.036Z |
5024099 | 5024099 | 20240905201850_7r2vd | AU002B | 2024-09-11T12:02:38.029Z | 2024-09-11T12:16:31.940Z |
5024085 | 5024085 | 20240905195132_R4WBU | AU002B | 2024-09-11T12:02:35.804Z | 2024-09-14T12:22:55.840Z |
5018892 | 5018892 | 20240904205803_7TpIB | AU002B | 2024-09-10T12:11:43.296Z | 2024-09-13T12:19:49.680Z |
5014638 | 5014638 | 20240905131426_Z09Pk | AU002B | 2024-09-10T12:03:36.359Z | 2024-09-14T12:22:52.274Z |
5007510 | 5007510 | 20240903213006_FH6pk | AU002B | 2024-09-09T12:05:50.039Z | 2024-09-12T12:19:13.553Z |
5007348 | 5007348 | 20240903205340_fAg6T | AU002B | 2024-09-09T12:05:42.750Z | 2024-09-12T12:19:12.659Z |
5007313 | 5007313 | 20240903204834_1z3mm | AU002B | 2024-09-09T12:05:41.793Z | 2024-09-12T12:19:12.599Z |
5007162 | 5007162 | 20240903201247_ox75I | AU002B | 2024-09-09T12:05:29.754Z | 2024-09-12T12:19:11.737Z |
5007117 | 5007117 | 20240903195946_rdAdC | AU002B | 2024-09-09T12:05:27.123Z | 2024-09-12T12:19:11.530Z |
5007112 | 5007112 | 20240903195847_vvwpx | AU002B | 2024-09-09T12:05:26.763Z | 2024-09-12T12:19:11.490Z |
5006337 | 5006337 | 20240903172541_mAfqO | AU002B | 2024-09-09T12:04:31.410Z | 2024-09-12T12:19:08.153Z |
5006264 | 5006264 | 20240903171002_4RCqH | AU002B | 2024-09-09T12:04:27.318Z | 2024-09-12T12:19:08.063Z |
5005795 | 5005795 | 20240903161210_xa4ND | AU002B | 2024-09-09T12:04:05.563Z | 2024-09-12T12:19:06.662Z |
5005760 | 5005760 | 20240903160655_2nSY2 | AU002B | 2024-09-09T12:04:02.554Z | 2024-09-12T12:19:06.561Z |
5005745 | 5005745 | 20240903160313_ykYaf | AU002B | 2024-09-09T12:04:01.540Z | 2024-09-12T12:19:06.548Z |
5005680 | 5005680 | 20240903155519_qrApY | AU002B | 2024-09-09T12:03:54.951Z | 2024-09-12T12:19:06.426Z |
5005387 | 5005387 | 20240903150453_FAPeB | AU002B | 2024-09-09T12:03:40.267Z | 2024-09-12T12:19:05.866Z |
5005351 | 5005351 | 20240903145702_XUlOQ | AU002B | 2024-09-09T12:03:38.301Z | 2024-09-12T12:19:05.793Z |
5005182 | 5005182 | 20240903142639_kfa88 | AU002B | 2024-09-09T12:03:25.240Z | 2024-09-12T12:19:05.418Z |
5004929 | 5004929 | 20240903132842_ZaWf5 | AU002B | 2024-09-09T12:03:11.941Z | 2024-09-12T12:19:04.519Z |
5004777 | 5004777 | 20240903123835_5rzr8 | AU002B | 2024-09-09T12:03:02.015Z | 2024-09-12T12:19:03.966Z |
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);