participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,847 rows where station_code = "RO0002" 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 |
---|---|---|---|---|---|
5565273 | 5565273 | 20241120040950_nvJcl | RO0002 | 2024-11-21T14:18:44.339Z | 2024-11-22T14:21:45.032Z |
5552569 | 5552569 | 20241117184540_RI768 | RO0002 | 2024-11-19T14:08:40.100Z | 2024-11-22T14:22:42.135Z |
5552549 | 5552549 | 20241117183525_HvoxY | RO0002 | 2024-11-19T14:08:37.789Z | 2024-11-22T14:22:41.973Z |
5552495 | 5552495 | 20241117173826_np1U2 | RO0002 | 2024-11-19T14:08:15.858Z | 2024-11-22T14:22:40.668Z |
5548460 | 5548460 | 20241116234119_KljB8 | RO0002 | 2024-11-18T14:09:16.557Z | 2024-11-22T14:23:13.319Z |
5528971 | 5528971 | 20241111231350_WLU3q | RO0002 | 2024-11-13T14:11:50.664Z | 2024-11-20T14:25:37.951Z |
5527592 | 5527592 | 20241111174427_H6v8Z | RO0002 | 2024-11-13T14:08:43.289Z | 2024-11-20T14:25:14.551Z |
5527474 | 5527474 | 20241111170141_mlJP2 | RO0002 | 2024-11-13T14:08:20.369Z | 2024-11-20T14:25:11.878Z |
5524378 | 5524378 | 20241111040353_XTQA3 | RO0002 | 2024-11-12T14:17:11.670Z | 2024-11-19T14:22:20.811Z |
5524303 | 5524303 | 20241111035046_yVRgX | RO0002 | 2024-11-12T14:16:58.450Z | 2024-11-19T14:22:19.834Z |
5523437 | 5523437 | 20241111012308_3Z4aQ | RO0002 | 2024-11-12T14:15:36.865Z | 2024-11-19T14:22:12.132Z |
5523223 | 5523223 | 20241111003510_FhWLX | RO0002 | 2024-11-12T14:15:02.227Z | 2024-11-19T14:22:10.588Z |
5523180 | 5523180 | 20241111002338_jynF4 | RO0002 | 2024-11-12T14:14:54.421Z | 2024-11-19T14:22:10.354Z |
5523149 | 5523149 | 20241111001404_wgbZZ | RO0002 | 2024-11-12T14:14:50.136Z | 2024-11-19T14:22:10.184Z |
5523145 | 5523145 | 20241111001333_lMN4f | RO0002 | 2024-11-12T14:14:49.674Z | 2024-11-19T14:22:10.170Z |
5523027 | 5523027 | 20241110234113_AA2f3 | RO0002 | 2024-11-12T14:14:39.479Z | 2024-11-19T14:22:09.623Z |
5523025 | 5523025 | 20241110234053_20I4F | RO0002 | 2024-11-12T14:14:39.207Z | 2024-11-19T14:22:09.616Z |
5522986 | 5522986 | 20241110232519_ftccC | RO0002 | 2024-11-12T14:14:36.187Z | 2024-11-19T14:22:09.374Z |
5522977 | 5522977 | 20241110232112_8FIgA | RO0002 | 2024-11-12T14:14:35.092Z | 2024-11-19T14:22:09.230Z |
5522972 | 5522972 | 20241110232005_B0NnD | RO0002 | 2024-11-12T14:14:34.714Z | 2024-11-19T14:22:09.191Z |
5522958 | 5522958 | 20241110231634_cgRWD | RO0002 | 2024-11-12T14:14:33.474Z | 2024-11-19T14:22:09.137Z |
5522946 | 5522946 | 20241110231436_Zoxhr | RO0002 | 2024-11-12T14:14:32.759Z | 2024-11-19T14:22:09.082Z |
5522944 | 5522944 | 20241110231312_1qYwg | RO0002 | 2024-11-12T14:14:32.530Z | 2024-11-19T14:22:09.067Z |
5522942 | 5522942 | 20241110231029_6herc | RO0002 | 2024-11-12T14:14:32.372Z | 2024-11-19T14:22:09.056Z |
5522931 | 5522931 | 20241110230530_HzHbp | RO0002 | 2024-11-12T14:14:31.417Z | 2024-11-19T14:22:08.999Z |
5521301 | 5521301 | 20241110164722_knq94 | RO0002 | 2024-11-12T14:10:45.377Z | 2024-11-19T14:21:51.554Z |
5521149 | 5521149 | 20241110161130_gyvFS | RO0002 | 2024-11-12T14:10:32.964Z | 2024-11-19T14:21:49.406Z |
5517480 | 5517480 | 20241110035047_fY6wf | RO0002 | 2024-11-11T14:14:28.833Z | 2024-11-18T14:26:36.671Z |
5517372 | 5517372 | 20241110033535_fN97f | RO0002 | 2024-11-11T14:14:19.035Z | 2024-11-18T14:26:36.167Z |
5517283 | 5517283 | 20241110031830_PYaPS | RO0002 | 2024-11-11T14:14:12.068Z | 2024-11-18T14:26:35.782Z |
5517165 | 5517165 | 20241110025636_RR9wi | RO0002 | 2024-11-11T14:13:59.952Z | 2024-11-18T14:26:35.037Z |
5517032 | 5517032 | 20241110023655_y2Tdi | RO0002 | 2024-11-11T14:13:44.804Z | 2024-11-18T14:26:34.326Z |
5516942 | 5516942 | 20241110022425_L7wz4 | RO0002 | 2024-11-11T14:13:35.586Z | 2024-11-18T14:26:33.958Z |
5516838 | 5516838 | 20241110020752_Rm2Yx | RO0002 | 2024-11-11T14:13:25.703Z | 2024-11-18T14:26:33.505Z |
5516768 | 5516768 | 20241110015856_Ewh4K | RO0002 | 2024-11-11T14:13:19.467Z | 2024-11-18T14:26:33.179Z |
5516753 | 5516753 | 20241110015442_SaxVg | RO0002 | 2024-11-11T14:13:18.299Z | 2024-11-18T14:26:33.148Z |
5516712 | 5516712 | 20241110014746_AlNy2 | RO0002 | 2024-11-11T14:13:16.369Z | 2024-11-18T14:26:32.914Z |
5516705 | 5516705 | 20241110014614_bc74L | RO0002 | 2024-11-11T14:13:15.974Z | 2024-11-18T14:26:32.896Z |
5516670 | 5516670 | 20241110013750_qIzIg | RO0002 | 2024-11-11T14:13:14.409Z | 2024-11-18T14:26:32.740Z |
5516658 | 5516658 | 20241110013445_sRGHE | RO0002 | 2024-11-11T14:13:13.732Z | 2024-11-18T14:26:32.649Z |
5516621 | 5516621 | 20241110012939_rG9o7 | RO0002 | 2024-11-11T14:13:11.542Z | 2024-11-18T14:26:32.435Z |
5516613 | 5516613 | 20241110012844_0q91n | RO0002 | 2024-11-11T14:13:11.095Z | 2024-11-18T14:26:32.406Z |
5516584 | 5516584 | 20241110012416_ej20W | RO0002 | 2024-11-11T14:13:09.805Z | 2024-11-18T14:26:32.158Z |
5516363 | 5516363 | 20241110004603_OFHbN | RO0002 | 2024-11-11T14:12:52.723Z | 2024-11-18T14:26:30.851Z |
5516278 | 5516278 | 20241110002902_BcPBV | RO0002 | 2024-11-11T14:12:39.908Z | 2024-11-18T14:26:30.443Z |
5516224 | 5516224 | 20241110001729_4t7Eo | RO0002 | 2024-11-11T14:12:29.431Z | 2024-11-18T14:26:30.177Z |
5516131 | 5516131 | 20241109235738_n5k2t | RO0002 | 2024-11-11T14:12:18.142Z | 2024-11-18T14:26:29.666Z |
5516110 | 5516110 | 20241109235340_MFGTE | RO0002 | 2024-11-11T14:12:15.488Z | 2024-11-18T14:26:29.573Z |
5516092 | 5516092 | 20241109234915_NzgLw | RO0002 | 2024-11-11T14:12:11.929Z | 2024-11-18T14:26:29.482Z |
5516034 | 5516034 | 20241109233740_FugTx | RO0002 | 2024-11-11T14:12:01.219Z | 2024-11-18T14:26:29.073Z |
5516024 | 5516024 | 20241109233517_PJDhg | RO0002 | 2024-11-11T14:12:00.251Z | 2024-11-18T14:26:28.981Z |
5515923 | 5515923 | 20241109231353_0IXBt | RO0002 | 2024-11-11T14:11:47.275Z | 2024-11-18T14:26:28.506Z |
5515899 | 5515899 | 20241109230835_37u22 | RO0002 | 2024-11-11T14:11:45.086Z | 2024-11-18T14:26:28.368Z |
5515841 | 5515841 | 20241109225527_tNULZ | RO0002 | 2024-11-11T14:11:36.514Z | 2024-11-18T14:26:28.155Z |
5515835 | 5515835 | 20241109225400_dyGwv | RO0002 | 2024-11-11T14:11:35.729Z | 2024-11-18T14:26:28.137Z |
5515797 | 5515797 | 20241109224536_M2iOs | RO0002 | 2024-11-11T14:11:29.397Z | 2024-11-18T14:26:27.995Z |
5515652 | 5515652 | 20241109221522_rlBNs | RO0002 | 2024-11-11T14:11:19.457Z | 2024-11-18T14:26:27.236Z |
5515621 | 5515621 | 20241109221059_arFzI | RO0002 | 2024-11-11T14:11:17.813Z | 2024-11-18T14:26:27.101Z |
5515619 | 5515619 | 20241109221049_R1fbP | RO0002 | 2024-11-11T14:11:17.658Z | 2024-11-18T14:26:27.083Z |
5515596 | 5515596 | 20241109220616_sAktA | RO0002 | 2024-11-11T14:11:16.094Z | 2024-11-18T14:26:26.971Z |
5515493 | 5515493 | 20241109213814_x3Jyq | RO0002 | 2024-11-11T14:11:08.220Z | 2024-11-18T14:26:26.307Z |
5515470 | 5515470 | 20241109213149_MjM6K | RO0002 | 2024-11-11T14:11:06.718Z | 2024-11-18T14:26:26.183Z |
5515327 | 5515327 | 20241109203458_VxYq2 | RO0002 | 2024-11-11T14:10:44.824Z | 2024-11-18T14:26:25.526Z |
5515321 | 5515321 | 20241109203334_cMT5O | RO0002 | 2024-11-11T14:10:42.971Z | 2024-11-18T14:26:25.476Z |
5515243 | 5515243 | 20241109200101_oSGr6 | RO0002 | 2024-11-11T14:10:25.720Z | 2024-11-18T14:26:25.079Z |
5514755 | 5514755 | 20241109172036_6GAZW | RO0002 | 2024-11-11T14:09:08.060Z | 2024-11-18T14:26:22.271Z |
5514718 | 5514718 | 20241109170313_r8DUS | RO0002 | 2024-11-11T14:09:03.769Z | 2024-11-18T14:26:22.083Z |
5510938 | 5510938 | 20241109035828_oslHC | RO0002 | 2024-11-10T14:15:57.874Z | 2024-11-17T14:24:02.761Z |
5510923 | 5510923 | 20241109035541_lP44Z | RO0002 | 2024-11-10T14:15:55.787Z | 2024-11-17T14:24:02.580Z |
5510763 | 5510763 | 20241109033453_yYZZ6 | RO0002 | 2024-11-10T14:15:39.645Z | 2024-11-17T14:24:01.123Z |
5510747 | 5510747 | 20241109033219_WC67a | RO0002 | 2024-11-10T14:15:37.565Z | 2024-11-17T14:24:00.895Z |
5510745 | 5510745 | 20241109033152_S2fOn | RO0002 | 2024-11-10T14:15:37.487Z | 2024-11-17T14:24:00.882Z |
5510738 | 5510738 | 20241109033107_tEqmi | RO0002 | 2024-11-10T14:15:36.995Z | 2024-11-17T14:24:00.795Z |
5510683 | 5510683 | 20241109032547_e2fEF | RO0002 | 2024-11-10T14:15:33.861Z | 2024-11-17T14:24:00.331Z |
5510616 | 5510616 | 20241109031320_RZ2Fw | RO0002 | 2024-11-10T14:15:29.721Z | 2024-11-17T14:23:59.678Z |
5510579 | 5510579 | 20241109030402_LNmnH | RO0002 | 2024-11-10T14:15:27.735Z | 2024-11-17T14:23:59.477Z |
5510495 | 5510495 | 20241109024747_Fq3Y2 | RO0002 | 2024-11-10T14:15:22.745Z | 2024-11-17T14:23:58.397Z |
5510391 | 5510391 | 20241109023410_wmvqx | RO0002 | 2024-11-10T14:15:08.195Z | 2024-11-17T14:23:56.854Z |
5510263 | 5510263 | 20241109021124_lZAzd | RO0002 | 2024-11-10T14:14:53.336Z | 2024-11-17T14:23:54.762Z |
5510253 | 5510253 | 20241109020634_PYmyb | RO0002 | 2024-11-10T14:14:51.788Z | 2024-11-17T14:23:54.582Z |
5510175 | 5510175 | 20241109015446_7WJbc | RO0002 | 2024-11-10T14:14:45.078Z | 2024-11-17T14:23:53.712Z |
5510170 | 5510170 | 20241109015303_y00UX | RO0002 | 2024-11-10T14:14:42.257Z | 2024-11-17T14:23:53.687Z |
5510073 | 5510073 | 20241109013918_r2Eje | RO0002 | 2024-11-10T14:14:32.836Z | 2024-11-17T14:23:52.691Z |
5509885 | 5509885 | 20241109010244_uidkY | RO0002 | 2024-11-10T14:14:10.330Z | 2024-11-17T14:23:50.462Z |
5509878 | 5509878 | 20241109005934_mxQbN | RO0002 | 2024-11-10T14:14:09.773Z | 2024-11-17T14:23:50.373Z |
5509852 | 5509852 | 20241109005102_vQgPh | RO0002 | 2024-11-10T14:14:07.086Z | 2024-11-17T14:23:50.031Z |
5509843 | 5509843 | 20241109004953_O5ywe | RO0002 | 2024-11-10T14:14:06.413Z | 2024-11-17T14:23:49.938Z |
5509793 | 5509793 | 20241109003722_Q3oxY | RO0002 | 2024-11-10T14:14:01.447Z | 2024-11-17T14:23:49.237Z |
5509620 | 5509620 | 20241108235804_iRF2R | RO0002 | 2024-11-10T14:13:41.951Z | 2024-11-17T14:23:47.926Z |
5509594 | 5509594 | 20241108235208_Vv0P5 | RO0002 | 2024-11-10T14:13:38.057Z | 2024-11-17T14:23:47.478Z |
5509592 | 5509592 | 20241108235208_mSjCc | RO0002 | 2024-11-10T14:13:37.845Z | 2024-11-17T14:23:47.475Z |
5509576 | 5509576 | 20241108234909_vXR4g | RO0002 | 2024-11-10T14:13:36.498Z | 2024-11-17T14:23:47.047Z |
5509473 | 5509473 | 20241108232413_NP9zd | RO0002 | 2024-11-10T14:13:25.443Z | 2024-11-17T14:23:44.962Z |
5509386 | 5509386 | 20241108230344_ivuiC | RO0002 | 2024-11-10T14:13:17.788Z | 2024-11-17T14:23:43.791Z |
5509382 | 5509382 | 20241108230307_iZpx7 | RO0002 | 2024-11-10T14:13:17.469Z | 2024-11-17T14:23:43.787Z |
5509331 | 5509331 | 20241108225219_HD48b | RO0002 | 2024-11-10T14:13:12.883Z | 2024-11-17T14:23:43.175Z |
5509275 | 5509275 | 20241108224008_oLn92 | RO0002 | 2024-11-10T14:13:07.088Z | 2024-11-17T14:23:42.227Z |
5509260 | 5509260 | 20241108223754_xDX8S | RO0002 | 2024-11-10T14:13:03.590Z | 2024-11-17T14:23:42.109Z |
5509207 | 5509207 | 20241108222522_WVkXr | RO0002 | 2024-11-10T14:12:53.985Z | 2024-11-17T14:23:41.464Z |
5509173 | 5509173 | 20241108221352_T07Va | RO0002 | 2024-11-10T14:12:48.071Z | 2024-11-17T14:23:41.187Z |
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);