participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
935 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 |
---|---|---|---|---|---|
5501108 | 5501108 | 20241108201138_r5rt0 | JP0002 | 2024-11-09T14:07:42.411Z | 2024-11-09T14:07:42.411Z |
5501106 | 5501106 | 20241108200916_EJKJd | JP0002 | 2024-11-09T14:07:42.127Z | 2024-11-09T14:07:42.127Z |
5501088 | 5501088 | 20241108194758_RMd1A | JP0002 | 2024-11-09T14:07:40.778Z | 2024-11-09T14:07:40.778Z |
5501077 | 5501077 | 20241108193708_WYMNZ | JP0002 | 2024-11-09T14:07:39.544Z | 2024-11-09T14:07:39.544Z |
5501013 | 5501013 | 20241108185348_K7CuD | JP0002 | 2024-11-09T14:07:33.666Z | 2024-11-09T14:07:33.666Z |
5501011 | 5501011 | 20241108185112_z091B | JP0002 | 2024-11-09T14:07:33.463Z | 2024-11-09T14:07:33.463Z |
5500012 | 5500012 | 20241108142306_2vgic | JP0002 | 2024-11-09T14:05:29.413Z | 2024-11-09T14:05:29.413Z |
5499788 | 5499788 | 20241108132722_MGn3O | JP0002 | 2024-11-09T14:04:58.011Z | 2024-11-09T14:04:58.011Z |
5487797 | 5487797 | 20241106183825_BFtTW | JP0002 | 2024-11-07T14:06:48.380Z | 2024-11-09T14:17:42.621Z |
5487795 | 5487795 | 20241106183819_ujpp6 | JP0002 | 2024-11-07T14:06:48.088Z | 2024-11-09T14:17:42.569Z |
5481829 | 5481829 | 20241104195431_LWvPg | JP0002 | 2024-11-06T14:11:38.845Z | 2024-11-09T14:20:51.556Z |
5481316 | 5481316 | 20241104165640_mNNrs | JP0002 | 2024-11-06T14:09:59.028Z | 2024-11-09T14:20:43.904Z |
5481278 | 5481278 | 20241104163559_PsBwN | JP0002 | 2024-11-06T14:09:52.521Z | 2024-11-09T14:20:43.469Z |
5481271 | 5481271 | 20241104163005_PiPBH | JP0002 | 2024-11-06T14:09:51.533Z | 2024-11-09T14:20:43.415Z |
5481210 | 5481210 | 20241104153534_VxIIx | JP0002 | 2024-11-06T14:09:42.339Z | 2024-11-09T14:20:41.755Z |
5475208 | 5475208 | 20241103192835_WlhW2 | JP0002 | 2024-11-05T14:12:43.814Z | 2024-11-09T14:21:56.576Z |
5475038 | 5475038 | 20241103185448_2J5dv | JP0002 | 2024-11-05T14:12:26.550Z | 2024-11-09T14:21:55.379Z |
5474968 | 5474968 | 20241103184323_pVRSe | JP0002 | 2024-11-05T14:12:20.498Z | 2024-11-09T14:21:54.848Z |
5473704 | 5473704 | 20241103145127_XbA5D | JP0002 | 2024-11-05T14:09:28.646Z | 2024-11-09T14:21:40.507Z |
5473309 | 5473309 | 20241103135638_8lM3h | JP0002 | 2024-11-05T14:08:46.706Z | 2024-11-09T14:21:37.754Z |
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 |
5045759 | 5045759 | 20240908185925_a1zNf | JP0002 | 2024-09-13T12:04:53.233Z | 2024-09-17T12:18:57.231Z |
5045741 | 5045741 | 20240908184712_bs10H | JP0002 | 2024-09-13T12:04:50.386Z | 2024-09-17T12:18:57.190Z |
5045653 | 5045653 | 20240908173730_aYxSA | JP0002 | 2024-09-13T12:04:36.777Z | 2024-09-17T12:18:56.927Z |
5045182 | 5045182 | 20240908162903_T5ucW | JP0002 | 2024-09-13T12:03:38.120Z | 2024-09-17T12:18:56.020Z |
5038311 | 5038311 | 20240905191102_1H2fw | JP0002 | 2024-09-12T12:14:32.749Z | 2024-09-14T12:22:55.558Z |
5038094 | 5038094 | 20240905172246_5479Z | JP0002 | 2024-09-12T12:14:21.883Z | 2024-09-14T12:22:55.028Z |
5038075 | 5038075 | 20240905172129_ChqgE | JP0002 | 2024-09-12T12:14:21.322Z | 2024-09-14T12:22:55.011Z |
5037166 | 5037166 | 20240905151745_XT2rT | JP0002 | 2024-09-12T12:14:02.341Z | 2024-09-14T12:22:53.821Z |
5037143 | 5037143 | 20240905151446_6dMMD | JP0002 | 2024-09-12T12:14:01.654Z | 2024-09-14T12:22:53.800Z |
5036254 | 5036254 | 20240905130432_ot3bK | JP0002 | 2024-09-12T12:13:31.009Z | 2024-09-14T12:22:52.144Z |
5036105 | 5036105 | 20240905124217_CjgkV | JP0002 | 2024-09-12T12:13:23.840Z | 2024-09-14T12:22:51.879Z |
5024066 | 5024066 | 20240905191102_VgZ79 | JP0002 | 2024-09-11T12:02:30.387Z | 2024-09-11T12:16:31.918Z |
5023930 | 5023930 | 20240905172246_4rYJA | JP0002 | 2024-09-10T12:16:52.009Z | 2024-09-11T12:16:31.848Z |
5023912 | 5023912 | 20240905172129_ry0bz | JP0002 | 2024-09-10T12:16:51.644Z | 2024-09-11T12:16:31.840Z |
5023056 | 5023056 | 20240905151745_Eso57 | JP0002 | 2024-09-10T12:16:38.412Z | 2024-09-11T12:16:31.517Z |
5018626 | 5018626 | 20240904191424_eSxBE | JP0002 | 2024-09-10T12:11:00.941Z | 2024-09-13T12:19:48.356Z |
5016853 | 5016853 | 20240904150425_kKjMF | JP0002 | 2024-09-10T12:08:24.640Z | 2024-09-13T12:19:46.391Z |
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);