participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
952 rows where station_code = "JP0002" 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 |
---|---|---|---|---|---|
5569520 | 5569520 | 20241121154900_bAiuy | JP0002 | 2024-11-22T14:11:01.160Z | 2024-11-24T14:22:14.813Z |
5536837 | 5536837 | 20241112192230_RgbIl | JP0002 | 2024-11-14T14:10:36.223Z | 2024-11-21T14:26:06.247Z |
5536799 | 5536799 | 20241112191256_rhLvM | JP0002 | 2024-11-14T14:10:33.732Z | 2024-11-21T14:26:05.731Z |
5536694 | 5536694 | 20241112185408_BUaZB | JP0002 | 2024-11-14T14:10:28.228Z | 2024-11-21T14:26:04.680Z |
5536667 | 5536667 | 20241112185024_a3R6y | JP0002 | 2024-11-14T14:10:26.475Z | 2024-11-21T14:26:04.374Z |
5536593 | 5536593 | 20241112183448_n33tD | JP0002 | 2024-11-14T14:10:22.517Z | 2024-11-21T14:26:03.449Z |
5536375 | 5536375 | 20241112174847_ic1ff | JP0002 | 2024-11-14T14:09:45.315Z | 2024-11-21T14:26:00.375Z |
5536353 | 5536353 | 20241112174043_PKFKX | JP0002 | 2024-11-14T14:09:41.128Z | 2024-11-21T14:26:00.264Z |
5536331 | 5536331 | 20241112172849_fTTRh | JP0002 | 2024-11-14T14:09:38.579Z | 2024-11-21T14:26:00.140Z |
5536249 | 5536249 | 20241112164915_vRFzP | JP0002 | 2024-11-14T14:09:26.711Z | 2024-11-21T14:25:59.053Z |
5536053 | 5536053 | 20241112153103_vjxTe | JP0002 | 2024-11-14T14:09:09.054Z | 2024-11-21T14:25:56.432Z |
5536045 | 5536045 | 20241112152926_JvgYV | JP0002 | 2024-11-14T14:09:08.482Z | 2024-11-21T14:25:56.372Z |
5528280 | 5528280 | 20241111201052_afjAM | JP0002 | 2024-11-13T14:10:23.133Z | 2024-11-20T14:25:27.862Z |
5528278 | 5528278 | 20241111201000_ygUpy | JP0002 | 2024-11-13T14:10:22.748Z | 2024-11-20T14:25:27.789Z |
5527718 | 5527718 | 20241111182352_7AnO1 | JP0002 | 2024-11-13T14:08:58.878Z | 2024-11-20T14:25:18.429Z |
5527538 | 5527538 | 20241111173149_w5Mgq | JP0002 | 2024-11-13T14:08:37.116Z | 2024-11-20T14:25:13.218Z |
5527305 | 5527305 | 20241111142443_nooBL | JP0002 | 2024-11-13T14:07:35.548Z | 2024-11-20T14:25:02.531Z |
5501108 | 5501108 | 20241108201138_r5rt0 | JP0002 | 2024-11-09T14:07:42.411Z | 2024-11-17T14:23:35.641Z |
5501106 | 5501106 | 20241108200916_EJKJd | JP0002 | 2024-11-09T14:07:42.127Z | 2024-11-17T14:23:35.511Z |
5501088 | 5501088 | 20241108194758_RMd1A | JP0002 | 2024-11-09T14:07:40.778Z | 2024-11-17T14:23:34.388Z |
5501077 | 5501077 | 20241108193708_WYMNZ | JP0002 | 2024-11-09T14:07:39.544Z | 2024-11-17T14:23:34.124Z |
5501013 | 5501013 | 20241108185348_K7CuD | JP0002 | 2024-11-09T14:07:33.666Z | 2024-11-17T14:23:31.977Z |
5501011 | 5501011 | 20241108185112_z091B | JP0002 | 2024-11-09T14:07:33.463Z | 2024-11-17T14:23:31.977Z |
5500012 | 5500012 | 20241108142306_2vgic | JP0002 | 2024-11-09T14:05:29.413Z | 2024-11-17T14:23:17.961Z |
5499788 | 5499788 | 20241108132722_MGn3O | JP0002 | 2024-11-09T14:04:58.011Z | 2024-11-17T14:23:16.145Z |
5487797 | 5487797 | 20241106183825_BFtTW | JP0002 | 2024-11-07T14:06:48.380Z | 2024-11-15T14:24:46.644Z |
5487795 | 5487795 | 20241106183819_ujpp6 | JP0002 | 2024-11-07T14:06:48.088Z | 2024-11-15T14:24:46.641Z |
5481829 | 5481829 | 20241104195431_LWvPg | JP0002 | 2024-11-06T14:11:38.845Z | 2024-11-13T14:27:33.209Z |
5481316 | 5481316 | 20241104165640_mNNrs | JP0002 | 2024-11-06T14:09:59.028Z | 2024-11-13T14:27:27.109Z |
5481278 | 5481278 | 20241104163559_PsBwN | JP0002 | 2024-11-06T14:09:52.521Z | 2024-11-13T14:27:26.724Z |
5481271 | 5481271 | 20241104163005_PiPBH | JP0002 | 2024-11-06T14:09:51.533Z | 2024-11-13T14:27:26.680Z |
5481210 | 5481210 | 20241104153534_VxIIx | JP0002 | 2024-11-06T14:09:42.339Z | 2024-11-13T14:27:26.430Z |
5475208 | 5475208 | 20241103192835_WlhW2 | JP0002 | 2024-11-05T14:12:43.814Z | 2024-11-12T14:27:57.585Z |
5475038 | 5475038 | 20241103185448_2J5dv | JP0002 | 2024-11-05T14:12:26.550Z | 2024-11-12T14:27:56.531Z |
5474968 | 5474968 | 20241103184323_pVRSe | JP0002 | 2024-11-05T14:12:20.498Z | 2024-11-12T14:27:55.856Z |
5473704 | 5473704 | 20241103145127_XbA5D | JP0002 | 2024-11-05T14:09:28.646Z | 2024-11-12T14:27:49.944Z |
5473309 | 5473309 | 20241103135638_8lM3h | JP0002 | 2024-11-05T14:08:46.706Z | 2024-11-12T14:27:48.446Z |
5450200 | 5450200 | 20241031181303_jX10N | JP0002 | 2024-11-02T12:14:44.531Z | 2024-11-09T14:24:14.634Z |
5449918 | 5449918 | 20241031171314_t2lTe | JP0002 | 2024-11-02T12:13:57.783Z | 2024-11-09T14:24:12.801Z |
5449731 | 5449731 | 20241031162404_CVGMU | JP0002 | 2024-11-02T12:13:37.995Z | 2024-11-09T14:24:11.709Z |
5437945 | 5437945 | 20241030160451_HAm9I | JP0002 | 2024-11-01T12:10:45.092Z | 2024-11-08T14:22:58.549Z |
5437018 | 5437018 | 20241030142050_Y2BZm | JP0002 | 2024-11-01T12:08:44.258Z | 2024-11-08T14:22:56.342Z |
5436881 | 5436881 | 20241030140153_Vn62R | JP0002 | 2024-11-01T12:08:31.230Z | 2024-11-08T14:22:55.721Z |
5436853 | 5436853 | 20241030135653_JcdhV | JP0002 | 2024-11-01T12:08:28.480Z | 2024-11-08T14:22:55.684Z |
5436578 | 5436578 | 20241030132312_nIwJc | JP0002 | 2024-11-01T12:07:54.178Z | 2024-11-08T14:22:54.314Z |
5435422 | 5435422 | 20241030112813_1zdui | JP0002 | 2024-11-01T12:05:08.396Z | 2024-11-08T14:22:50.612Z |
5360089 | 5360089 | 20241023152610_DxTgB | JP0002 | 2024-10-25T12:10:09.621Z | 2024-11-01T12:26:47.052Z |
5332211 | 5332211 | 20241021191756_IQWoK | JP0002 | 2024-10-22T12:10:22.571Z | 2024-10-30T12:26:42.173Z |
5332203 | 5332203 | 20241021185406_NVzLm | JP0002 | 2024-10-22T12:10:21.408Z | 2024-10-30T12:26:41.903Z |
5332184 | 5332184 | 20241021175733_IO9dT | JP0002 | 2024-10-22T12:10:16.492Z | 2024-10-30T12:26:40.888Z |
5326064 | 5326064 | 20241020192925_H8z3B | JP0002 | 2024-10-21T12:07:35.470Z | 2024-10-29T12:26:33.089Z |
5326036 | 5326036 | 20241020191133_ISIvs | JP0002 | 2024-10-21T12:07:32.774Z | 2024-10-29T12:26:33.057Z |
5326010 | 5326010 | 20241020190221_wGOoN | JP0002 | 2024-10-21T12:07:29.931Z | 2024-10-29T12:26:32.998Z |
5325995 | 5325995 | 20241020185507_8DxKQ | JP0002 | 2024-10-21T12:07:28.422Z | 2024-10-29T12:26:32.971Z |
5325987 | 5325987 | 20241020185155_UHu3R | JP0002 | 2024-10-21T12:07:27.748Z | 2024-10-29T12:26:32.956Z |
5325954 | 5325954 | 20241020183741_SVEtL | JP0002 | 2024-10-21T12:07:23.461Z | 2024-10-29T12:26:32.819Z |
5325720 | 5325720 | 20241020171301_a2eFI | JP0002 | 2024-10-21T12:06:38.192Z | 2024-10-29T12:26:31.847Z |
5325621 | 5325621 | 20241020163238_GSD3Q | JP0002 | 2024-10-21T12:06:10.916Z | 2024-10-29T12:26:31.444Z |
5325548 | 5325548 | 20241020160848_qsdms | JP0002 | 2024-10-21T12:06:03.380Z | 2024-10-29T12:26:31.344Z |
5325535 | 5325535 | 20241020160337_eUr2A | JP0002 | 2024-10-21T12:06:02.098Z | 2024-10-29T12:26:31.339Z |
5325368 | 5325368 | 20241020144942_Kd2fK | JP0002 | 2024-10-21T12:05:36.378Z | 2024-10-29T12:26:31.059Z |
5324690 | 5324690 | 20241020105611_ub7Ap | JP0002 | 2024-10-21T12:03:40.132Z | 2024-10-29T12:26:29.800Z |
5316046 | 5316046 | 20241015161626_McpBc | JP0002 | 2024-10-17T12:05:42.792Z | 2024-10-24T12:27:55.230Z |
5305832 | 5305832 | 20241013192504_5UyZx | JP0002 | 2024-10-15T12:05:30.840Z | 2024-10-22T12:24:29.371Z |
5305793 | 5305793 | 20241013173733_P3oLg | JP0002 | 2024-10-15T12:05:24.702Z | 2024-10-22T12:24:28.365Z |
5305775 | 5305775 | 20241013165332_LMZGL | JP0002 | 2024-10-15T12:05:21.959Z | 2024-10-22T12:24:28.101Z |
5305623 | 5305623 | 20241013161848_BtFSq | JP0002 | 2024-10-15T12:04:57.027Z | 2024-10-22T12:24:27.396Z |
5305579 | 5305579 | 20241013155855_ROfb5 | JP0002 | 2024-10-15T12:04:50.973Z | 2024-10-22T12:24:27.005Z |
5305416 | 5305416 | 20241013150947_bhR50 | JP0002 | 2024-10-15T12:04:34.281Z | 2024-10-22T12:24:25.969Z |
5299756 | 5299756 | 20241012192806_46eCG | JP0002 | 2024-10-14T12:13:07.211Z | 2024-10-21T12:23:43.706Z |
5299437 | 5299437 | 20241012184850_hdm27 | JP0002 | 2024-10-14T12:12:16.203Z | 2024-10-21T12:23:38.934Z |
5299354 | 5299354 | 20241012183616_pKMEX | JP0002 | 2024-10-14T12:12:11.465Z | 2024-10-21T12:23:37.709Z |
5299172 | 5299172 | 20241012181334_7hY4h | JP0002 | 2024-10-14T12:11:59.196Z | 2024-10-21T12:23:35.020Z |
5298783 | 5298783 | 20241012171131_370p2 | JP0002 | 2024-10-14T12:11:08.779Z | 2024-10-21T12:23:31.398Z |
5298328 | 5298328 | 20241012161045_iGNfO | JP0002 | 2024-10-14T12:10:11.548Z | 2024-10-21T12:23:26.680Z |
5298118 | 5298118 | 20241012153119_x3aZT | JP0002 | 2024-10-14T12:09:55.357Z | 2024-10-21T12:23:25.140Z |
5291030 | 5291030 | 20241011193751_2W1yt | JP0002 | 2024-10-13T12:13:51.697Z | 2024-10-20T12:24:24.160Z |
5290385 | 5290385 | 20241011173552_9RKd8 | JP0002 | 2024-10-13T12:12:18.455Z | 2024-10-20T12:24:15.509Z |
5289736 | 5289736 | 20241011160014_6DQaG | JP0002 | 2024-10-13T12:11:19.578Z | 2024-10-20T12:24:09.975Z |
5281381 | 5281381 | 20241010182059_ABbA3 | JP0002 | 2024-10-12T12:14:03.065Z | 2024-10-19T12:27:32.779Z |
5281353 | 5281353 | 20241010181704_u3CQh | JP0002 | 2024-10-12T12:14:00.567Z | 2024-10-19T12:27:32.641Z |
5281351 | 5281351 | 20241010181650_ItXPI | JP0002 | 2024-10-12T12:14:00.368Z | 2024-10-19T12:27:32.641Z |
5281146 | 5281146 | 20241010174009_1evWK | JP0002 | 2024-10-12T12:13:36.321Z | 2024-10-19T12:27:29.810Z |
5273921 | 5273921 | 20241009190543_bM2Hi | JP0002 | 2024-10-11T12:13:29.794Z | 2024-10-18T12:22:05.310Z |
5273481 | 5273481 | 20241009173702_rjlH6 | JP0002 | 2024-10-11T12:12:32.560Z | 2024-10-18T12:22:02.121Z |
5273062 | 5273062 | 20241009161406_GKDxS | JP0002 | 2024-10-11T12:11:57.622Z | 2024-10-18T12:21:59.607Z |
5272979 | 5272979 | 20241009160127_Zdrz2 | JP0002 | 2024-10-11T12:11:48.878Z | 2024-10-18T12:21:59.182Z |
5272741 | 5272741 | 20241009151352_ibGjo | JP0002 | 2024-10-11T12:11:16.268Z | 2024-10-18T12:21:58.078Z |
5271615 | 5271615 | 20241010121553_BFyaA | JP0002 | 2024-10-11T12:07:19.510Z | 2024-10-19T12:27:06.878Z |
5209912 | 5209912 | 20241001180217_nyYW2 | JP0002 | 2024-10-03T12:13:58.025Z | 2024-10-10T12:24:44.351Z |
5209631 | 5209631 | 20241001161015_gzRUy | JP0002 | 2024-10-03T12:13:35.430Z | 2024-10-10T12:24:43.437Z |
5209534 | 5209534 | 20241001153636_2LeC5 | JP0002 | 2024-10-03T12:13:29.079Z | 2024-10-10T12:24:43.130Z |
5203578 | 5203578 | 20240930162535_q9W66 | JP0002 | 2024-10-02T12:10:24.053Z | 2024-10-09T12:29:08.501Z |
5110377 | 5110377 | 20240913153948_V31Rk | JP0002 | 2024-09-17T12:15:07.728Z | 2024-09-21T12:16:54.488Z |
5110348 | 5110348 | 20240913152432_wfiC2 | JP0002 | 2024-09-17T12:15:06.265Z | 2024-09-21T12:16:54.244Z |
5110332 | 5110332 | 20240913151105_0W4jU | JP0002 | 2024-09-17T12:15:05.443Z | 2024-09-21T12:16:54.015Z |
5110318 | 5110318 | 20240913150037_A7OoZ | JP0002 | 2024-09-17T12:15:04.496Z | 2024-09-21T12:16:53.782Z |
5098320 | 5098320 | 20240913155330_gPwld | JP0002 | 2024-09-17T12:00:10.005Z | 2024-09-22T12:17:38.015Z |
5070594 | 5070594 | 20240911143650_iFEjA | JP0002 | 2024-09-15T12:00:22.499Z | 2024-09-20T12:21:16.032Z |
5062247 | 5062247 | 20240909170335_oZ8Sr | JP0002 | 2024-09-14T12:12:00.045Z | 2024-09-18T12:15:10.803Z |
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);