participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
137 rows where station_code = "IT000B" 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 |
---|---|---|---|---|---|
5135758 | 5135758 | 20240918192340_jiDg3 | IT000B | 2024-09-20T12:00:25.195Z | 2024-09-20T12:06:54.608Z |
5135744 | 5135744 | 20240918190746_JZBKu | IT000B | 2024-09-20T12:00:23.274Z | 2024-09-20T12:06:54.603Z |
5132444 | 5132444 | 20240916010907_pfUIY | IT000B | 2024-09-19T12:16:13.169Z | 2024-09-20T12:13:11.576Z |
5132068 | 5132068 | 20240915230227_88g6b | IT000B | 2024-09-19T12:15:48.189Z | 2024-09-20T12:12:56.474Z |
5132000 | 5132000 | 20240915223534_byxfz | IT000B | 2024-09-19T12:15:42.289Z | 2024-09-20T12:12:52.610Z |
5131902 | 5131902 | 20240915220816_Yp2om | IT000B | 2024-09-19T12:15:33.263Z | 2024-09-20T12:12:49.208Z |
5131835 | 5131835 | 20240915212830_Our42 | IT000B | 2024-09-19T12:15:26.767Z | 2024-09-20T12:12:46.457Z |
5131598 | 5131598 | 20240915202437_R4ELM | IT000B | 2024-09-19T12:15:10.889Z | 2024-09-20T12:12:34.558Z |
5125517 | 5125517 | 20240918025300_s42O2 | IT000B | 2024-09-19T12:03:26.308Z | 2024-09-20T12:08:26.703Z |
5125459 | 5125459 | 20240918023956_RXKON | IT000B | 2024-09-19T12:03:18.073Z | 2024-09-20T12:08:20.472Z |
5125453 | 5125453 | 20240918023942_RWPBc | IT000B | 2024-09-19T12:03:17.183Z | 2024-09-20T12:08:19.763Z |
5125415 | 5125415 | 20240918023141_o15n8 | IT000B | 2024-09-19T12:03:11.594Z | 2024-09-20T12:08:15.762Z |
5125270 | 5125270 | 20240918015022_5Whcw | IT000B | 2024-09-19T12:02:38.619Z | 2024-09-20T12:08:02.326Z |
5125067 | 5125067 | 20240917235532_CgmR2 | IT000B | 2024-09-19T12:02:06.750Z | 2024-09-20T12:07:42.518Z |
5124938 | 5124938 | 20240917225455_WshGX | IT000B | 2024-09-19T12:01:49.628Z | 2024-09-20T12:07:32.749Z |
5124935 | 5124935 | 20240917225346_GHNyc | IT000B | 2024-09-19T12:01:49.246Z | 2024-09-20T12:07:32.615Z |
5124897 | 5124897 | 20240917223742_WV5Vg | IT000B | 2024-09-19T12:01:45.221Z | 2024-09-20T12:07:30.964Z |
5124738 | 5124738 | 20240917215633_B7U86 | IT000B | 2024-09-19T12:01:29.526Z | 2024-09-20T12:07:23.310Z |
5124382 | 5124382 | 20240917194649_PPIZL | IT000B | 2024-09-19T12:00:41.476Z | 2024-09-20T12:07:01.203Z |
5098688 | 5098688 | 20240913185913_z7iXH | IT000B | 2024-09-17T12:01:21.121Z | 2024-09-20T12:18:05.754Z |
5076212 | 5076212 | 20240910231329_TLPzM | IT000B | 2024-09-15T12:13:22.661Z | 2024-09-19T12:21:36.616Z |
5069630 | 5069630 | 20240910215527_qdi2z | IT000B | 2024-09-14T12:20:01.736Z | 2024-09-19T12:21:35.178Z |
5069606 | 5069606 | 20240910215323_6KgFy | IT000B | 2024-09-14T12:20:00.559Z | 2024-09-19T12:21:35.105Z |
5069393 | 5069393 | 20240910213729_C5AtR | IT000B | 2024-09-14T12:19:55.775Z | 2024-09-19T12:21:34.812Z |
5069326 | 5069326 | 20240910213059_8dUip | IT000B | 2024-09-14T12:19:54.499Z | 2024-09-19T12:21:34.601Z |
5069251 | 5069251 | 20240910212310_KXguI | IT000B | 2024-09-14T12:19:50.414Z | 2024-09-19T12:21:34.093Z |
5065339 | 5065339 | 20240910034810_sQP1X | IT000B | 2024-09-14T12:17:00.829Z | 2024-09-18T12:15:19.110Z |
5065248 | 5065248 | 20240910032840_wfrbT | IT000B | 2024-09-14T12:16:49.102Z | 2024-09-18T12:15:18.828Z |
5065007 | 5065007 | 20240910025033_H2wuY | IT000B | 2024-09-14T12:16:17.054Z | 2024-09-18T12:15:18.135Z |
5064935 | 5064935 | 20240910023616_x533o | IT000B | 2024-09-14T12:16:10.821Z | 2024-09-18T12:15:17.817Z |
5064800 | 5064800 | 20240910020658_4b9pX | IT000B | 2024-09-14T12:16:03.511Z | 2024-09-18T12:15:17.404Z |
5064733 | 5064733 | 20240910015206_vTiQt | IT000B | 2024-09-14T12:15:58.413Z | 2024-09-18T12:15:17.138Z |
5064489 | 5064489 | 20240910012043_oyWI2 | IT000B | 2024-09-14T12:15:32.319Z | 2024-09-18T12:15:16.756Z |
5064396 | 5064396 | 20240910005912_nOMg6 | IT000B | 2024-09-14T12:15:22.298Z | 2024-09-18T12:15:16.447Z |
5064333 | 5064333 | 20240910005113_8vUo3 | IT000B | 2024-09-14T12:15:18.064Z | 2024-09-18T12:15:16.154Z |
5064274 | 5064274 | 20240910003327_7EyAg | IT000B | 2024-09-14T12:15:11.525Z | 2024-09-18T12:15:16.032Z |
5064136 | 5064136 | 20240910000757_c5WZV | IT000B | 2024-09-14T12:14:58.529Z | 2024-09-18T12:15:15.565Z |
5063932 | 5063932 | 20240909230055_uBVVr | IT000B | 2024-09-14T12:14:29.753Z | 2024-09-18T12:15:14.910Z |
5063767 | 5063767 | 20240909223748_9AyYh | IT000B | 2024-09-14T12:14:21.125Z | 2024-09-18T12:15:14.727Z |
5063750 | 5063750 | 20240909223419_Ffb7Z | IT000B | 2024-09-14T12:14:18.875Z | 2024-09-18T12:15:14.509Z |
5063585 | 5063585 | 20240909214929_2dbm8 | IT000B | 2024-09-14T12:14:07.575Z | 2024-09-18T12:15:14.242Z |
5063567 | 5063567 | 20240909214647_9I1Nh | IT000B | 2024-09-14T12:14:06.986Z | 2024-09-18T12:15:14.233Z |
5063555 | 5063555 | 20240909214412_57WrB | IT000B | 2024-09-14T12:14:06.310Z | 2024-09-18T12:15:14.171Z |
5063361 | 5063361 | 20240909205836_h0iUR | IT000B | 2024-09-14T12:13:55.263Z | 2024-09-18T12:15:13.704Z |
5062965 | 5062965 | 20240909192249_ep4ag | IT000B | 2024-09-14T12:13:09.725Z | 2024-09-18T12:15:12.718Z |
5062921 | 5062921 | 20240909190314_oExao | IT000B | 2024-09-14T12:13:03.346Z | 2024-09-18T12:15:12.539Z |
5054339 | 5054339 | 20240908024119_ncDL1 | IT000B | 2024-09-13T12:16:38.686Z | 2024-09-16T12:21:15.148Z |
5054222 | 5054222 | 20240908022957_QdHxq | IT000B | 2024-09-13T12:16:34.373Z | 2024-09-16T12:21:14.540Z |
5054135 | 5054135 | 20240908021534_uSgG6 | IT000B | 2024-09-13T12:16:30.942Z | 2024-09-16T12:21:14.036Z |
5053674 | 5053674 | 20240908011434_ly38z | IT000B | 2024-09-13T12:16:13.170Z | 2024-09-16T12:21:12.393Z |
5053334 | 5053334 | 20240908001220_dBCkz | IT000B | 2024-09-13T12:15:59.160Z | 2024-09-16T12:21:10.342Z |
5053113 | 5053113 | 20240907232951_fWt7u | IT000B | 2024-09-13T12:15:46.926Z | 2024-09-16T12:21:09.516Z |
5052962 | 5052962 | 20240907224651_hZ3rk | IT000B | 2024-09-13T12:15:38.858Z | 2024-09-16T12:21:08.733Z |
5052921 | 5052921 | 20240907223658_TcDNh | IT000B | 2024-09-13T12:15:35.941Z | 2024-09-16T12:21:08.602Z |
5052544 | 5052544 | 20240907210128_qzg66 | IT000B | 2024-09-13T12:15:13.426Z | 2024-09-16T12:21:06.201Z |
5052307 | 5052307 | 20240907201449_bBui4 | IT000B | 2024-09-13T12:15:03.636Z | 2024-09-16T12:21:05.096Z |
5052167 | 5052167 | 20240907195021_rwYSb | IT000B | 2024-09-13T12:14:59.217Z | 2024-09-16T12:21:04.292Z |
5052140 | 5052140 | 20240907194446_FcBu3 | IT000B | 2024-09-13T12:14:58.425Z | 2024-09-16T12:21:03.974Z |
5051862 | 5051862 | 20240907185548_Umaqq | IT000B | 2024-09-13T12:14:39.515Z | 2024-09-16T12:21:02.323Z |
5040278 | 5040278 | 20240906032931_9I9By | IT000B | 2024-09-12T12:16:04.964Z | 2024-09-14T12:23:08.522Z |
5033738 | 5033738 | 20240907033819_ajJWP | IT000B | 2024-09-12T12:09:53.906Z | 2024-09-15T12:21:31.639Z |
5033711 | 5033711 | 20240907033235_3rTTf | IT000B | 2024-09-12T12:09:51.498Z | 2024-09-15T12:21:31.575Z |
5033528 | 5033528 | 20240907030622_rBUMC | IT000B | 2024-09-12T12:09:37.641Z | 2024-09-15T12:21:30.404Z |
5033426 | 5033426 | 20240907025738_AL3Rw | IT000B | 2024-09-12T12:09:30.526Z | 2024-09-15T12:21:30.061Z |
5033295 | 5033295 | 20240907024501_K393K | IT000B | 2024-09-12T12:09:05.535Z | 2024-09-15T12:21:29.560Z |
5032733 | 5032733 | 20240907014049_MlK6Q | IT000B | 2024-09-12T12:07:55.359Z | 2024-09-15T12:21:27.593Z |
5032340 | 5032340 | 20240907004843_LjnIA | IT000B | 2024-09-12T12:07:08.679Z | 2024-09-15T12:21:26.165Z |
5031660 | 5031660 | 20240906225229_MgC6A | IT000B | 2024-09-12T12:05:22.425Z | 2024-09-15T12:21:23.510Z |
5031394 | 5031394 | 20240906213927_j3AbR | IT000B | 2024-09-12T12:04:40.941Z | 2024-09-15T12:21:22.176Z |
5031232 | 5031232 | 20240906205649_jglUb | IT000B | 2024-09-12T12:04:20.419Z | 2024-09-15T12:21:21.779Z |
5031165 | 5031165 | 20240906204355_DKEMr | IT000B | 2024-09-12T12:04:06.099Z | 2024-09-15T12:21:21.615Z |
5031022 | 5031022 | 20240906200323_URmkd | IT000B | 2024-09-12T12:03:44.578Z | 2024-09-15T12:21:21.157Z |
5030886 | 5030886 | 20240906191918_Ae0wy | IT000B | 2024-09-12T12:03:19.741Z | 2024-09-15T12:21:20.276Z |
5030878 | 5030878 | 20240906191811_5Iyb2 | IT000B | 2024-09-12T12:03:18.799Z | 2024-09-15T12:21:20.249Z |
5030846 | 5030846 | 20240906190456_gSNYa | IT000B | 2024-09-12T12:03:13.686Z | 2024-09-15T12:21:20.141Z |
5030777 | 5030777 | 20240906183520_dra27 | IT000B | 2024-09-12T12:03:03.569Z | 2024-09-15T12:21:19.626Z |
5026441 | 5026441 | 20240905032943_u2wEM | IT000B | 2024-09-11T12:12:29.954Z | 2024-09-13T12:19:58.258Z |
5026035 | 5026035 | 20240905020433_v2xca | IT000B | 2024-09-11T12:11:48.534Z | 2024-09-13T12:19:56.636Z |
5025913 | 5025913 | 20240905013933_YXui7 | IT000B | 2024-09-11T12:11:30.005Z | 2024-09-13T12:19:56.169Z |
5025690 | 5025690 | 20240905005644_R1aXZ | IT000B | 2024-09-11T12:10:46.951Z | 2024-09-13T12:19:55.199Z |
5020895 | 5020895 | 20240905032943_CRgQN | IT000B | 2024-09-10T12:15:06.598Z | 2024-09-10T12:16:55.267Z |
5020470 | 5020470 | 20240905020433_jQuBm | IT000B | 2024-09-10T12:14:32.136Z | 2024-09-10T12:16:55.157Z |
5020355 | 5020355 | 20240905013933_ZBUML | IT000B | 2024-09-10T12:14:21.149Z | 2024-09-10T12:16:55.132Z |
5020111 | 5020111 | 20240905005644_Vef8V | IT000B | 2024-09-10T12:13:56.474Z | 2024-09-10T12:16:55.072Z |
5019976 | 5019976 | 20240905003027_bkdKW | IT000B | 2024-09-10T12:13:47.026Z | 2024-09-13T12:19:54.725Z |
5019604 | 5019604 | 20240904231715_HddNx | IT000B | 2024-09-10T12:12:59.048Z | 2024-09-13T12:19:52.962Z |
5019593 | 5019593 | 20240904231552_OF6bj | IT000B | 2024-09-10T12:12:57.719Z | 2024-09-13T12:19:52.891Z |
5019501 | 5019501 | 20240904225922_4jOpQ | IT000B | 2024-09-10T12:12:49.478Z | 2024-09-13T12:19:52.262Z |
5019309 | 5019309 | 20240904222738_3V732 | IT000B | 2024-09-10T12:12:35.523Z | 2024-09-13T12:19:51.353Z |
5019040 | 5019040 | 20240904212955_o1Pg5 | IT000B | 2024-09-10T12:11:57.653Z | 2024-09-13T12:19:50.196Z |
5018923 | 5018923 | 20240904210552_Tx2Sn | IT000B | 2024-09-10T12:11:45.895Z | 2024-09-13T12:19:49.811Z |
5018865 | 5018865 | 20240904205451_DDua7 | IT000B | 2024-09-10T12:11:41.100Z | 2024-09-13T12:19:49.546Z |
5018750 | 5018750 | 20240904200323_m2UVZ | IT000B | 2024-09-10T12:11:29.538Z | 2024-09-13T12:19:48.681Z |
5018632 | 5018632 | 20240904191517_u9tFj | IT000B | 2024-09-10T12:11:02.087Z | 2024-09-13T12:19:48.363Z |
5010235 | 5010235 | 20240904024652_KiZFl | IT000B | 2024-09-09T12:08:29.704Z | 2024-09-12T12:19:26.547Z |
5010059 | 5010059 | 20240904022941_2IL41 | IT000B | 2024-09-09T12:08:20.435Z | 2024-09-12T12:19:25.749Z |
5010033 | 5010033 | 20240904022739_QhxJA | IT000B | 2024-09-09T12:08:19.384Z | 2024-09-12T12:19:25.568Z |
5009762 | 5009762 | 20240904015814_n8375 | IT000B | 2024-09-09T12:08:00.406Z | 2024-09-12T12:19:24.316Z |
5009644 | 5009644 | 20240904014410_cOOo2 | IT000B | 2024-09-09T12:07:53.396Z | 2024-09-12T12:19:23.842Z |
5008495 | 5008495 | 20240903234915_EjdZj | IT000B | 2024-09-09T12:06:50.205Z | 2024-09-12T12:19:17.875Z |
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);