participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,903 rows where station_code = "PT0002" 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 |
---|---|---|---|---|---|
5505680 | 5505680 | 20241106041942_s6W2f | PT0002 | 2024-11-09T14:20:12.567Z | 2024-11-09T14:20:12.567Z |
5505676 | 5505676 | 20241106040919_jsrbZ | PT0002 | 2024-11-09T14:20:12.126Z | 2024-11-09T14:20:12.126Z |
5505674 | 5505674 | 20241106034907_g2mqT | PT0002 | 2024-11-09T14:20:10.976Z | 2024-11-09T14:20:10.976Z |
5505672 | 5505672 | 20241106034650_Zcg47 | PT0002 | 2024-11-09T14:20:10.803Z | 2024-11-09T14:20:10.803Z |
5505670 | 5505670 | 20241106034613_mfRz0 | PT0002 | 2024-11-09T14:20:10.749Z | 2024-11-09T14:20:10.749Z |
5505664 | 5505664 | 20241106033459_xWdp6 | PT0002 | 2024-11-09T14:20:10.163Z | 2024-11-09T14:20:10.163Z |
5505660 | 5505660 | 20241106032436_99DyO | PT0002 | 2024-11-09T14:20:09.587Z | 2024-11-09T14:20:09.587Z |
5505658 | 5505658 | 20241106032403_1EuhK | PT0002 | 2024-11-09T14:20:09.398Z | 2024-11-09T14:20:09.398Z |
5505656 | 5505656 | 20241106032131_KYu9V | PT0002 | 2024-11-09T14:20:08.818Z | 2024-11-09T14:20:08.818Z |
5505652 | 5505652 | 20241106025303_4S3Td | PT0002 | 2024-11-09T14:20:06.594Z | 2024-11-09T14:20:06.594Z |
5505646 | 5505646 | 20241106021648_lBp6V | PT0002 | 2024-11-09T14:20:04.934Z | 2024-11-09T14:20:04.934Z |
5485413 | 5485413 | 20241105053011_rBNqI | PT0002 | 2024-11-06T14:18:14.405Z | 2024-11-09T14:21:21.506Z |
5485411 | 5485411 | 20241105052840_7ETc5 | PT0002 | 2024-11-06T14:18:13.784Z | 2024-11-09T14:21:21.460Z |
5482114 | 5482114 | 20241104210851_qJCTc | PT0002 | 2024-11-06T14:12:24.827Z | 2024-11-09T14:20:55.488Z |
5469586 | 5469586 | 20241103034845_7dggx | PT0002 | 2024-11-04T14:16:38.518Z | 2024-11-09T14:23:03.143Z |
5469567 | 5469567 | 20241103034513_aM2jg | PT0002 | 2024-11-04T14:16:36.593Z | 2024-11-09T14:23:03.066Z |
5469537 | 5469537 | 20241103034050_3HTYo | PT0002 | 2024-11-04T14:16:34.600Z | 2024-11-09T14:23:02.960Z |
5469431 | 5469431 | 20241103032548_MIUXS | PT0002 | 2024-11-04T14:16:27.295Z | 2024-11-09T14:23:02.550Z |
5469165 | 5469165 | 20241103024241_4qUwW | PT0002 | 2024-11-04T14:15:47.337Z | 2024-11-09T14:23:01.142Z |
5468999 | 5468999 | 20241103022107_Hmcnz | PT0002 | 2024-11-04T14:15:21.836Z | 2024-11-09T14:23:00.604Z |
5468966 | 5468966 | 20241103021603_xGpSl | PT0002 | 2024-11-04T14:15:18.940Z | 2024-11-09T14:23:00.478Z |
5468881 | 5468881 | 20241103020420_VvM54 | PT0002 | 2024-11-04T14:15:11.138Z | 2024-11-09T14:23:00.137Z |
5468840 | 5468840 | 20241103015642_Nj6YL | PT0002 | 2024-11-04T14:15:07.590Z | 2024-11-09T14:22:59.948Z |
5468698 | 5468698 | 20241103012854_VpeT3 | PT0002 | 2024-11-04T14:14:55.987Z | 2024-11-09T14:22:59.339Z |
5468021 | 5468021 | 20241102231704_BV24G | PT0002 | 2024-11-04T14:13:08.300Z | 2024-11-09T14:22:56.524Z |
5467787 | 5467787 | 20241102223637_azU93 | PT0002 | 2024-11-04T14:12:31.427Z | 2024-11-09T14:22:55.646Z |
5467726 | 5467726 | 20241102222434_yp7qw | PT0002 | 2024-11-04T14:12:24.574Z | 2024-11-09T14:22:55.471Z |
5467670 | 5467670 | 20241102221319_sYbYz | PT0002 | 2024-11-04T14:12:19.428Z | 2024-11-09T14:22:55.337Z |
5467188 | 5467188 | 20241102202048_ERX8E | PT0002 | 2024-11-04T14:11:04.279Z | 2024-11-09T14:22:53.582Z |
5467182 | 5467182 | 20241102202035_nr03I | PT0002 | 2024-11-04T14:11:03.552Z | 2024-11-09T14:22:53.545Z |
5467084 | 5467084 | 20241102200356_tWRJP | PT0002 | 2024-11-04T14:10:35.725Z | 2024-11-09T14:22:53.255Z |
5463245 | 5463245 | 20241102030028_WCjFC | PT0002 | 2024-11-03T14:18:27.685Z | 2024-11-09T14:23:39.542Z |
5463151 | 5463151 | 20241102024427_3MvPU | PT0002 | 2024-11-03T14:18:23.560Z | 2024-11-09T14:23:38.299Z |
5453922 | 5453922 | 20241031031738_66IUE | PT0002 | 2024-11-02T12:22:45.102Z | 2024-11-08T14:23:19.681Z |
5453846 | 5453846 | 20241031030935_YlPg7 | PT0002 | 2024-11-02T12:22:43.719Z | 2024-11-08T14:23:19.531Z |
5453827 | 5453827 | 20241031030553_rknSZ | PT0002 | 2024-11-02T12:22:43.335Z | 2024-11-08T14:23:19.252Z |
5453804 | 5453804 | 20241031030207_9kbeG | PT0002 | 2024-11-02T12:22:42.853Z | 2024-11-08T14:23:19.114Z |
5453723 | 5453723 | 20241031025228_K7xVw | PT0002 | 2024-11-02T12:22:41.094Z | 2024-11-08T14:23:18.908Z |
5453721 | 5453721 | 20241031025211_DkMqQ | PT0002 | 2024-11-02T12:22:41.046Z | 2024-11-08T14:23:18.907Z |
5453568 | 5453568 | 20241031022604_n732r | PT0002 | 2024-11-02T12:22:36.276Z | 2024-11-08T14:23:18.103Z |
5453518 | 5453518 | 20241031021801_lJVI9 | PT0002 | 2024-11-02T12:22:35.021Z | 2024-11-08T14:23:17.653Z |
5453510 | 5453510 | 20241031021733_RcbgC | PT0002 | 2024-11-02T12:22:34.826Z | 2024-11-08T14:23:17.630Z |
5453211 | 5453211 | 20241031015052_FQbVV | PT0002 | 2024-11-02T12:22:29.874Z | 2024-11-08T14:23:16.167Z |
5453174 | 5453174 | 20241031014722_UltFY | PT0002 | 2024-11-02T12:22:28.819Z | 2024-11-08T14:23:16.116Z |
5444434 | 5444434 | 20241031012047_2sebY | PT0002 | 2024-11-01T12:21:17.712Z | 2024-11-08T14:23:15.518Z |
5444407 | 5444407 | 20241031011706_V0JPC | PT0002 | 2024-11-01T12:21:16.545Z | 2024-11-08T14:23:15.354Z |
5444377 | 5444377 | 20241031011428_XHnjP | PT0002 | 2024-11-01T12:21:14.647Z | 2024-11-08T14:23:14.748Z |
5444257 | 5444257 | 20241031010412_UKItj | PT0002 | 2024-11-01T12:21:11.777Z | 2024-11-08T14:23:14.256Z |
5444042 | 5444042 | 20241031004053_dkvDL | PT0002 | 2024-11-01T12:21:02.857Z | 2024-11-08T14:23:13.602Z |
5443831 | 5443831 | 20241031001929_rwcvo | PT0002 | 2024-11-01T12:20:53.460Z | 2024-11-08T14:23:12.701Z |
5443829 | 5443829 | 20241031001927_UCs68 | PT0002 | 2024-11-01T12:20:53.405Z | 2024-11-08T14:23:12.697Z |
5443670 | 5443670 | 20241031000237_03qJv | PT0002 | 2024-11-01T12:20:45.592Z | 2024-11-08T14:23:11.957Z |
5443653 | 5443653 | 20241030235947_A0ge5 | PT0002 | 2024-11-01T12:20:44.732Z | 2024-11-08T14:23:11.927Z |
5443590 | 5443590 | 20241030234801_eAWtC | PT0002 | 2024-11-01T12:20:40.543Z | 2024-11-08T14:23:11.691Z |
5440925 | 5440925 | 20241030232450_LaLZb | PT0002 | 2024-11-01T12:16:00.587Z | 2024-11-08T14:23:11.106Z |
5440662 | 5440662 | 20241030224253_AR7hP | PT0002 | 2024-11-01T12:15:42.596Z | 2024-11-08T14:23:10.231Z |
5440532 | 5440532 | 20241030222429_hVX6Q | PT0002 | 2024-11-01T12:15:35.245Z | 2024-11-08T14:23:09.824Z |
5432861 | 5432861 | 20241029045955_9NWXW | PT0002 | 2024-10-31T12:21:36.977Z | 2024-11-06T14:27:29.031Z |
5432818 | 5432818 | 20241029044745_9hd2s | PT0002 | 2024-10-31T12:21:36.012Z | 2024-11-06T14:27:28.810Z |
5431797 | 5431797 | 20241029015955_YVJ8x | PT0002 | 2024-10-31T12:20:40.482Z | 2024-11-06T14:27:24.887Z |
5431737 | 5431737 | 20241029015239_0ISes | PT0002 | 2024-10-31T12:20:35.290Z | 2024-11-06T14:27:24.642Z |
5430616 | 5430616 | 20241028231225_MJTBZ | PT0002 | 2024-10-31T12:18:43.428Z | 2024-11-06T14:27:20.720Z |
5430434 | 5430434 | 20241028223353_nw82A | PT0002 | 2024-10-31T12:18:22.613Z | 2024-11-06T14:27:19.979Z |
5430217 | 5430217 | 20241028213724_km6qu | PT0002 | 2024-10-31T12:17:53.665Z | 2024-11-06T14:27:19.353Z |
5430150 | 5430150 | 20241028211850_D1aST | PT0002 | 2024-10-31T12:17:45.263Z | 2024-11-06T14:27:19.047Z |
5429682 | 5429682 | 20241028195005_eQRuh | PT0002 | 2024-10-31T12:16:53.648Z | 2024-11-06T14:27:16.986Z |
5420908 | 5420908 | 20241028035424_bqmC4 | PT0002 | 2024-10-30T12:19:25.582Z | 2024-11-05T14:27:16.711Z |
5420896 | 5420896 | 20241028035231_G5cIM | PT0002 | 2024-10-30T12:19:24.805Z | 2024-11-05T14:27:16.685Z |
5420803 | 5420803 | 20241028033849_dNl26 | PT0002 | 2024-10-30T12:19:19.549Z | 2024-11-05T14:27:16.379Z |
5420781 | 5420781 | 20241028033516_3s2N6 | PT0002 | 2024-10-30T12:19:16.659Z | 2024-11-05T14:27:16.341Z |
5420776 | 5420776 | 20241028033501_fSRYl | PT0002 | 2024-10-30T12:19:16.181Z | 2024-11-05T14:27:16.297Z |
5420737 | 5420737 | 20241028032909_igQn3 | PT0002 | 2024-10-30T12:19:14.180Z | 2024-11-05T14:27:16.227Z |
5420664 | 5420664 | 20241028031649_8tppL | PT0002 | 2024-10-30T12:19:08.942Z | 2024-11-05T14:27:15.991Z |
5420589 | 5420589 | 20241028030415_5AcMK | PT0002 | 2024-10-30T12:19:02.947Z | 2024-11-05T14:27:15.850Z |
5420523 | 5420523 | 20241028025322_ht6sE | PT0002 | 2024-10-30T12:18:56.339Z | 2024-11-05T14:27:15.609Z |
5420498 | 5420498 | 20241028025008_wjAjT | PT0002 | 2024-10-30T12:18:55.010Z | 2024-11-05T14:27:15.582Z |
5420474 | 5420474 | 20241028024533_Hk733 | PT0002 | 2024-10-30T12:18:54.014Z | 2024-11-05T14:27:15.537Z |
5420345 | 5420345 | 20241028023144_IK5ub | PT0002 | 2024-10-30T12:18:44.116Z | 2024-11-05T14:27:15.212Z |
5420255 | 5420255 | 20241028022013_2Uc16 | PT0002 | 2024-10-30T12:18:38.218Z | 2024-11-05T14:27:15.019Z |
5420195 | 5420195 | 20241028021025_iqCmS | PT0002 | 2024-10-30T12:18:30.385Z | 2024-11-05T14:27:14.765Z |
5420171 | 5420171 | 20241028020706_wU3x8 | PT0002 | 2024-10-30T12:18:28.586Z | 2024-11-05T14:27:14.696Z |
5420076 | 5420076 | 20241028015430_UnJLm | PT0002 | 2024-10-30T12:18:19.129Z | 2024-11-05T14:27:14.475Z |
5419990 | 5419990 | 20241028014109_tKKnf | PT0002 | 2024-10-30T12:18:12.808Z | 2024-11-05T14:27:14.281Z |
5419939 | 5419939 | 20241028013218_s3VpA | PT0002 | 2024-10-30T12:18:07.480Z | 2024-11-05T14:27:14.150Z |
5419601 | 5419601 | 20241028002522_F7imy | PT0002 | 2024-10-30T12:17:37.602Z | 2024-11-05T14:27:13.535Z |
5419582 | 5419582 | 20241028002053_a5b1Z | PT0002 | 2024-10-30T12:17:34.698Z | 2024-11-05T14:27:13.482Z |
5419506 | 5419506 | 20241028001150_iKEsv | PT0002 | 2024-10-30T12:17:30.696Z | 2024-11-05T14:27:13.306Z |
5419368 | 5419368 | 20241027234410_baocg | PT0002 | 2024-10-30T12:17:23.074Z | 2024-11-05T14:27:12.923Z |
5410943 | 5410943 | 20241027055542_a2LVX | PT0002 | 2024-10-29T12:18:13.411Z | 2024-11-04T14:29:06.405Z |
5410930 | 5410930 | 20241027055436_R5JTz | PT0002 | 2024-10-29T12:18:12.595Z | 2024-11-04T14:29:06.383Z |
5410899 | 5410899 | 20241027054730_3s2gi | PT0002 | 2024-10-29T12:18:10.034Z | 2024-11-04T14:29:06.005Z |
5410774 | 5410774 | 20241027053551_yuI0L | PT0002 | 2024-10-29T12:18:04.873Z | 2024-11-04T14:29:05.465Z |
5410718 | 5410718 | 20241027053056_VL6Ic | PT0002 | 2024-10-29T12:18:03.265Z | 2024-11-04T14:29:05.300Z |
5410561 | 5410561 | 20241027051810_cjKom | PT0002 | 2024-10-29T12:17:58.280Z | 2024-11-04T14:29:04.976Z |
5410503 | 5410503 | 20241027051545_nVnZt | PT0002 | 2024-10-29T12:17:57.006Z | 2024-11-04T14:29:04.653Z |
5410256 | 5410256 | 20241027050357_LzEva | PT0002 | 2024-10-29T12:17:51.639Z | 2024-11-04T14:29:04.253Z |
5410254 | 5410254 | 20241027050304_Lrhsi | PT0002 | 2024-10-29T12:17:51.575Z | 2024-11-04T14:29:04.250Z |
5409532 | 5409532 | 20241027042329_9DyGG | PT0002 | 2024-10-29T12:17:28.849Z | 2024-11-04T14:29:01.939Z |
5409392 | 5409392 | 20241027041345_Na2L4 | PT0002 | 2024-10-29T12:17:19.599Z | 2024-11-04T14:29:01.633Z |
5408120 | 5408120 | 20241027031011_TjzG4 | PT0002 | 2024-10-29T12:16:07.916Z | 2024-11-04T14:28:58.881Z |
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);