participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
599 rows where station_code = "FR000U" 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 |
---|---|---|---|---|---|
5468528 | 5468528 | 20241103005245_ViSMR | FR000U | 2024-11-04T14:14:19.610Z | 2024-11-09T14:22:58.660Z |
5468324 | 5468324 | 20241103001127_BHgq6 | FR000U | 2024-11-04T14:13:57.251Z | 2024-11-09T14:22:57.993Z |
5463557 | 5463557 | 20241102035951_7rHYa | FR000U | 2024-11-03T14:18:57.231Z | 2024-11-09T14:23:41.975Z |
5462761 | 5462761 | 20241102012230_NJBJW | FR000U | 2024-11-03T14:18:03.578Z | 2024-11-09T14:23:36.045Z |
5462439 | 5462439 | 20241102002035_Ald2V | FR000U | 2024-11-03T14:17:26.511Z | 2024-11-09T14:23:34.371Z |
5462430 | 5462430 | 20241102001903_lD5Qz | FR000U | 2024-11-03T14:17:25.936Z | 2024-11-09T14:23:34.301Z |
5451753 | 5451753 | 20241101005820_C0khJ | FR000U | 2024-11-02T12:17:55.360Z | 2024-11-09T14:24:25.296Z |
5451718 | 5451718 | 20241101005241_RumJJ | FR000U | 2024-11-02T12:17:53.666Z | 2024-11-09T14:24:25.181Z |
4218756 | 4218756 | 20240419231314_Uxokl | FR000U | 2024-04-21T12:00:26.418Z | 2024-04-28T12:21:02.107Z |
4218352 | 4218352 | 20240419025237_S6JT3 | FR000U | 2024-04-20T12:14:46.444Z | 2024-04-27T12:20:14.491Z |
4214040 | 4214040 | 20240418032800_n3M7Q | FR000U | 2024-04-20T12:04:13.229Z | 2024-04-26T12:16:57.871Z |
4214020 | 4214020 | 20240418032534_bK4de | FR000U | 2024-04-20T12:04:12.397Z | 2024-04-26T12:16:57.772Z |
4213384 | 4213384 | 20240418021056_iCO5D | FR000U | 2024-04-20T12:02:51.552Z | 2024-04-26T12:16:50.952Z |
4205976 | 4205976 | 20240417025606_iQ2Yd | FR000U | 2024-04-18T12:13:16.087Z | 2024-04-25T12:21:23.978Z |
4201569 | 4201569 | 20240417022424_x82S3 | FR000U | 2024-04-18T12:03:39.370Z | 2024-04-25T12:21:20.160Z |
4199772 | 4199772 | 20240416034221_11j2N | FR000U | 2024-04-17T12:13:15.912Z | 2024-04-24T12:23:33.942Z |
4199746 | 4199746 | 20240416033857_ju0Sn | FR000U | 2024-04-17T12:13:14.729Z | 2024-04-24T12:23:33.627Z |
4199407 | 4199407 | 20240416024151_rHFKl | FR000U | 2024-04-17T12:12:43.401Z | 2024-04-24T12:23:28.890Z |
4190992 | 4190992 | 20240415023900_PFuan | FR000U | 2024-04-16T12:05:10.950Z | 2024-04-23T12:24:53.926Z |
4190490 | 4190490 | 20240415004602_HpexF | FR000U | 2024-04-16T12:03:52.092Z | 2024-04-23T12:24:47.299Z |
4190463 | 4190463 | 20240415004007_dGIj5 | FR000U | 2024-04-16T12:03:48.344Z | 2024-04-23T12:24:46.808Z |
4186300 | 4186300 | 20240414035904_RfCB9 | FR000U | 2024-04-15T12:06:25.875Z | 2024-04-22T12:22:28.958Z |
4186158 | 4186158 | 20240414032353_sULeD | FR000U | 2024-04-15T12:06:07.146Z | 2024-04-22T12:22:27.352Z |
4180215 | 4180215 | 20240413030029_pja6a | FR000U | 2024-04-14T12:04:25.293Z | 2024-04-21T12:21:44.333Z |
4175595 | 4175595 | 20240412025508_3g2pE | FR000U | 2024-04-13T12:06:28.904Z | 2024-04-20T12:25:30.344Z |
4175442 | 4175442 | 20240412022044_ClM8I | FR000U | 2024-04-13T12:06:00.311Z | 2024-04-20T12:25:28.825Z |
4175034 | 4175034 | 20240412002637_S5iLM | FR000U | 2024-04-13T12:04:39.859Z | 2024-04-20T12:25:21.913Z |
4171936 | 4171936 | 20240410032056_s5Chi | FR000U | 2024-04-12T12:08:38.334Z | 2024-04-18T12:21:21.038Z |
4171861 | 4171861 | 20240410031152_nZkbV | FR000U | 2024-04-12T12:08:28.579Z | 2024-04-18T12:21:20.704Z |
4170793 | 4170793 | 20240411014003_mISwl | FR000U | 2024-04-12T12:03:52.219Z | 2024-04-19T12:13:19.455Z |
4166115 | 4166115 | 20240409223302_6XodW | FR000U | 2024-04-11T12:04:57.934Z | 2024-04-18T12:21:07.469Z |
4142885 | 4142885 | 20240404025547_d36sl | FR000U | 2024-04-05T12:03:38.489Z | 2024-04-12T12:19:46.537Z |
4142862 | 4142862 | 20240404025036_D2Qxe | FR000U | 2024-04-05T12:03:34.780Z | 2024-04-12T12:19:46.328Z |
4142762 | 4142762 | 20240404013154_c7Rx9 | FR000U | 2024-04-05T12:03:13.562Z | 2024-04-12T12:19:45.417Z |
4142745 | 4142745 | 20240404005738_gW3fo | FR000U | 2024-04-05T12:03:07.269Z | 2024-04-12T12:19:45.265Z |
4135526 | 4135526 | 20240401232652_cqUqO | FR000U | 2024-04-03T12:05:03.506Z | 2024-04-10T12:17:48.241Z |
4078028 | 4078028 | 20240316041638_qcY2K | FR000U | 2024-03-17T12:09:15.022Z | 2024-03-24T12:20:55.263Z |
4076437 | 4076437 | 20240316010616_Zd21d | FR000U | 2024-03-17T12:07:48.527Z | 2024-03-24T12:20:44.661Z |
4076058 | 4076058 | 20240315232600_XDgj3 | FR000U | 2024-03-17T12:07:19.052Z | 2024-03-24T12:20:40.573Z |
4065579 | 4065579 | 20240313032600_FAGo5 | FR000U | 2024-03-14T12:05:02.477Z | 2024-03-21T12:22:17.048Z |
4063166 | 4063166 | 20240312040946_1FXSG | FR000U | 2024-03-13T12:05:23.804Z | 2024-03-20T12:21:38.017Z |
4063164 | 4063164 | 20240312040933_Ni7xF | FR000U | 2024-03-13T12:05:23.522Z | 2024-03-20T12:21:38.015Z |
4063064 | 4063064 | 20240312021222_j3oOa | FR000U | 2024-03-13T12:05:05.232Z | 2024-03-20T12:21:37.362Z |
4041420 | 4041420 | 20240307035510_zHJGD | FR000U | 2024-03-08T14:08:53.455Z | 2024-03-15T12:19:34.294Z |
4040960 | 4040960 | 20240307015629_2Z69A | FR000U | 2024-03-08T14:08:26.302Z | 2024-03-15T12:19:25.678Z |
4035812 | 4035812 | 20240306042824_c3ef5 | FR000U | 2024-03-07T14:08:32.351Z | 2024-03-14T12:25:26.734Z |
4035673 | 4035673 | 20240306041107_h31jf | FR000U | 2024-03-07T14:08:23.523Z | 2024-03-14T12:25:24.917Z |
4035443 | 4035443 | 20240306032010_6BzRi | FR000U | 2024-03-07T14:07:56.107Z | 2024-03-14T12:25:20.029Z |
4017128 | 4017128 | 20240302030049_ESdoh | FR000U | 2024-03-03T14:07:13.205Z | 2024-03-10T12:21:23.018Z |
4017115 | 4017115 | 20240302025132_V462j | FR000U | 2024-03-03T14:07:11.842Z | 2024-03-10T12:21:22.514Z |
4017078 | 4017078 | 20240302022710_OpM5M | FR000U | 2024-03-03T14:07:08.627Z | 2024-03-10T12:21:22.276Z |
4016998 | 4016998 | 20240302014226_8y3oN | FR000U | 2024-03-03T14:07:00.244Z | 2024-03-10T12:21:21.387Z |
3995183 | 3995183 | 20240221021155_XDKpI | FR000U | 2024-02-22T14:06:04.372Z | 2024-02-29T14:14:42.353Z |
3986107 | 3986107 | 20240218051818_F7UJ5 | FR000U | 2024-02-19T14:07:29.774Z | 2024-02-26T14:17:15.275Z |
3985668 | 3985668 | 20240217220846_n09aX | FR000U | 2024-02-19T14:06:03.582Z | 2024-02-26T14:16:44.253Z |
3965728 | 3965728 | 20240214021646_4A25s | FR000U | 2024-02-15T14:07:25.198Z | 2024-02-22T14:23:57.839Z |
3965693 | 3965693 | 20240214020722_Lm9dL | FR000U | 2024-02-15T14:07:20.883Z | 2024-02-22T14:23:56.560Z |
3965305 | 3965305 | 20240213224858_Hy0bI | FR000U | 2024-02-15T14:06:19.575Z | 2024-02-22T14:23:39.856Z |
3965183 | 3965183 | 20240213210209_QKoyh | FR000U | 2024-02-15T14:05:57.398Z | 2024-02-22T14:23:35.000Z |
3959405 | 3959405 | 20240213051104_mTPsA | FR000U | 2024-02-14T14:09:28.075Z | 2024-02-21T14:20:45.033Z |
3954240 | 3954240 | 20240212051326_m8ur8 | FR000U | 2024-02-13T14:08:46.423Z | 2024-02-20T14:26:05.504Z |
3953710 | 3953710 | 20240212041657_MrQh7 | FR000U | 2024-02-13T14:08:08.889Z | 2024-02-20T14:26:02.249Z |
3947697 | 3947697 | 20240211053446_mPDLb | FR000U | 2024-02-12T14:07:00.772Z | 2024-02-19T14:19:13.812Z |
3947630 | 3947630 | 20240211035726_3Op3K | FR000U | 2024-02-12T14:06:42.820Z | 2024-02-19T14:19:13.370Z |
3947592 | 3947592 | 20240211025936_xdojj | FR000U | 2024-02-12T14:06:36.468Z | 2024-02-19T14:19:13.058Z |
3947500 | 3947500 | 20240211003428_36xAo | FR000U | 2024-02-12T14:06:12.115Z | 2024-02-19T14:19:12.229Z |
3947496 | 3947496 | 20240211000908_y1SO5 | FR000U | 2024-02-12T14:06:11.398Z | 2024-02-19T14:19:12.181Z |
3936164 | 3936164 | 20240208044838_d7q32 | FR000U | 2024-02-09T14:06:32.980Z | 2024-02-16T14:18:33.292Z |
3916417 | 3916417 | 20240204045952_qxGeE | FR000U | 2024-02-05T14:03:15.197Z | 2024-02-12T14:23:11.127Z |
3916160 | 3916160 | 20240204023936_70UiV | FR000U | 2024-02-05T14:02:11.786Z | 2024-02-12T14:23:04.730Z |
3916145 | 3916145 | 20240204022149_fl2Ly | FR000U | 2024-02-05T14:02:08.352Z | 2024-02-12T14:23:04.438Z |
3916143 | 3916143 | 20240204021537_farjq | FR000U | 2024-02-05T14:02:07.901Z | 2024-02-12T14:23:04.401Z |
3916061 | 3916061 | 20240204003703_FWQ58 | FR000U | 2024-02-05T14:01:43.982Z | 2024-02-12T14:23:02.657Z |
3906000 | 3906000 | 20240201032322_XxLd2 | FR000U | 2024-02-02T14:04:49.649Z | 2024-02-09T14:20:12.992Z |
3905672 | 3905672 | 20240201013359_V27OB | FR000U | 2024-02-02T14:03:49.626Z | 2024-02-09T14:20:05.308Z |
3902128 | 3902128 | 20240131051626_SWkO6 | FR000U | 2024-02-01T14:05:17.904Z | 2024-02-08T14:20:23.196Z |
3883733 | 3883733 | 20240125035301_qGOO4 | FR000U | 2024-01-26T14:01:13.586Z | 2024-02-02T14:19:17.687Z |
3880656 | 3880656 | 20240123044234_sbagx | FR000U | 2024-01-25T14:02:40.153Z | 2024-01-31T14:18:11.338Z |
3878481 | 3878481 | 20240122054508_EJarc | FR000U | 2024-01-24T14:03:26.761Z | 2024-01-30T14:18:55.605Z |
3878200 | 3878200 | 20240122045652_47ep6 | FR000U | 2024-01-24T14:02:57.222Z | 2024-01-30T14:18:48.632Z |
3878115 | 3878115 | 20240122043407_tmLh8 | FR000U | 2024-01-24T14:02:33.731Z | 2024-01-30T14:18:44.677Z |
3878009 | 3878009 | 20240122040847_CQsuO | FR000U | 2024-01-24T14:02:15.051Z | 2024-01-30T14:18:39.119Z |
3877925 | 3877925 | 20240122034918_8yAUt | FR000U | 2024-01-24T14:01:55.536Z | 2024-01-30T14:18:35.523Z |
3877905 | 3877905 | 20240122034447_Psdbl | FR000U | 2024-01-24T14:01:52.289Z | 2024-01-30T14:18:35.059Z |
3877725 | 3877725 | 20240122023705_Z8IFe | FR000U | 2024-01-24T14:01:08.815Z | 2024-01-30T14:18:25.607Z |
3873623 | 3873623 | 20240120030855_J8VmH | FR000U | 2024-01-23T14:08:59.286Z | 2024-01-28T14:19:33.236Z |
3870936 | 3870936 | 20240121040622_QzOqP | FR000U | 2024-01-23T14:02:48.589Z | 2024-01-29T14:18:08.266Z |
3870816 | 3870816 | 20240121032123_Mf9AM | FR000U | 2024-01-23T14:02:22.381Z | 2024-01-29T14:18:03.815Z |
3870792 | 3870792 | 20240121030953_pGbjY | FR000U | 2024-01-23T14:02:19.384Z | 2024-01-29T14:18:03.050Z |
3870504 | 3870504 | 20240121004542_e8fZY | FR000U | 2024-01-23T14:01:06.945Z | 2024-01-29T14:17:47.963Z |
3855999 | 3855999 | 20240118051647_zUllY | FR000U | 2024-01-21T14:07:57.901Z | 2024-01-26T14:21:20.240Z |
3838952 | 3838952 | 20240116034149_eos23 | FR000U | 2024-01-19T14:01:59.449Z | 2024-01-25T14:21:12.284Z |
3838413 | 3838413 | 20240115235422_g88ti | FR000U | 2024-01-18T14:15:18.892Z | 2024-01-24T14:19:18.677Z |
3838247 | 3838247 | 20240115225655_Arfm6 | FR000U | 2024-01-18T14:15:12.122Z | 2024-01-24T14:19:18.248Z |
3831582 | 3831582 | 20240116010350_e4n7t | FR000U | 2024-01-18T14:00:53.342Z | 2024-01-25T14:20:59.753Z |
3823708 | 3823708 | 20240115031100_WqIzZ | FR000U | 2024-01-17T14:02:34.274Z | 2024-01-24T14:18:14.643Z |
3822300 | 3822300 | 20240114014331_ziC23 | FR000U | 2024-01-16T14:15:06.240Z | 2024-01-23T14:24:43.504Z |
3808055 | 3808055 | 20240112021758_eGmI6 | FR000U | 2024-01-15T14:02:20.724Z | 2024-01-21T14:27:28.102Z |
3771360 | 3771360 | 20240108043503_Jf33u | FR000U | 2024-01-10T14:01:05.651Z | 2024-01-17T14:23:16.447Z |
3710648 | 3710648 | 20231223025327_CmfJM | FR000U | 2024-01-06T00:05:53.845Z | 2024-01-06T00:05:53.845Z |
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);