participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,352 rows where station_code = "IT0008" 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 |
---|---|---|---|---|---|
5571963 | 5571963 | 20241121011338_hH5tw | IT0008 | 2024-11-22T14:17:49.725Z | 2024-11-22T14:19:22.232Z |
5561386 | 5561386 | 20241119202045_22qrh | IT0008 | 2024-11-21T14:13:11.484Z | 2024-11-22T14:20:34.094Z |
5548413 | 5548413 | 20241116231442_EVyiW | IT0008 | 2024-11-18T14:09:10.298Z | 2024-11-22T14:23:12.967Z |
5548148 | 5548148 | 20241116201838_uZqZC | IT0008 | 2024-11-18T14:08:20.238Z | 2024-11-22T14:23:10.321Z |
5548054 | 5548054 | 20241116185233_Krr0j | IT0008 | 2024-11-18T14:07:55.698Z | 2024-11-22T14:23:08.806Z |
5543903 | 5543903 | 20241115042604_stRIG | IT0008 | 2024-11-16T14:07:37.812Z | 2024-11-22T14:24:02.380Z |
5543883 | 5543883 | 20241115040904_2n0l4 | IT0008 | 2024-11-16T14:07:36.052Z | 2024-11-22T14:24:02.261Z |
5531704 | 5531704 | 20241112040147_Ss0lv | IT0008 | 2024-11-13T14:15:51.571Z | 2024-11-20T14:26:13.616Z |
5531678 | 5531678 | 20241112035954_oi033 | IT0008 | 2024-11-13T14:15:50.416Z | 2024-11-20T14:26:13.258Z |
5531429 | 5531429 | 20241112033859_ND4Sb | IT0008 | 2024-11-13T14:15:38.954Z | 2024-11-20T14:26:11.230Z |
5531008 | 5531008 | 20241112030550_1RAf8 | IT0008 | 2024-11-13T14:15:00.456Z | 2024-11-20T14:26:05.920Z |
5529843 | 5529843 | 20241112010829_WUj3j | IT0008 | 2024-11-13T14:13:14.620Z | 2024-11-20T14:25:49.858Z |
5524452 | 5524452 | 20241111041540_l1XAS | IT0008 | 2024-11-12T14:17:22.361Z | 2024-11-19T14:22:21.425Z |
5524351 | 5524351 | 20241111035931_aYpxI | IT0008 | 2024-11-12T14:17:05.956Z | 2024-11-19T14:22:20.460Z |
5523405 | 5523405 | 20241111011844_AbbA3 | IT0008 | 2024-11-12T14:15:33.101Z | 2024-11-19T14:22:11.783Z |
5485115 | 5485115 | 20241105040626_mOYus | IT0008 | 2024-11-06T14:17:46.722Z | 2024-11-13T14:27:40.782Z |
5483248 | 5483248 | 20241105001820_o4L3o | IT0008 | 2024-11-06T14:14:49.507Z | 2024-11-13T14:27:35.909Z |
5482925 | 5482925 | 20241104233416_3cU3V | IT0008 | 2024-11-06T14:14:20.627Z | 2024-11-13T14:27:35.372Z |
5482430 | 5482430 | 20241104221141_YwK7Q | IT0008 | 2024-11-06T14:13:10.556Z | 2024-11-13T14:27:34.563Z |
5481445 | 5481445 | 20241104174622_sGBh4 | IT0008 | 2024-11-06T14:10:34.102Z | 2024-11-13T14:27:28.822Z |
5478067 | 5478067 | 20241104031651_MuqD6 | IT0008 | 2024-11-05T14:17:51.086Z | 2024-11-12T14:28:14.136Z |
5478001 | 5478001 | 20241104030549_khyP9 | IT0008 | 2024-11-05T14:17:43.753Z | 2024-11-12T14:28:13.758Z |
5477808 | 5477808 | 20241104023901_OhobB | IT0008 | 2024-11-05T14:17:26.392Z | 2024-11-12T14:28:13.019Z |
5477796 | 5477796 | 20241104023653_ostrH | IT0008 | 2024-11-05T14:17:25.787Z | 2024-11-12T14:28:12.956Z |
5468303 | 5468303 | 20241103000812_yHpL9 | IT0008 | 2024-11-04T14:13:55.434Z | 2024-11-11T14:22:52.623Z |
5467974 | 5467974 | 20241102230516_zM2W3 | IT0008 | 2024-11-04T14:13:03.495Z | 2024-11-11T14:22:50.646Z |
5466663 | 5466663 | 20241102182634_CLXWv | IT0008 | 2024-11-04T14:09:31.011Z | 2024-11-11T14:22:42.303Z |
5463500 | 5463500 | 20241102034731_UIulo | IT0008 | 2024-11-03T14:18:51.051Z | 2024-11-10T14:26:35.383Z |
5463378 | 5463378 | 20241102033009_lc5GH | IT0008 | 2024-11-03T14:18:40.661Z | 2024-11-10T14:26:35.046Z |
5463111 | 5463111 | 20241102023609_0arhK | IT0008 | 2024-11-03T14:18:19.489Z | 2024-11-10T14:26:34.271Z |
5463096 | 5463096 | 20241102023325_DpUzy | IT0008 | 2024-11-03T14:18:17.967Z | 2024-11-10T14:26:34.261Z |
5463074 | 5463074 | 20241102022952_bNz5o | IT0008 | 2024-11-03T14:18:16.966Z | 2024-11-10T14:26:34.198Z |
5462471 | 5462471 | 20241102002452_amsV5 | IT0008 | 2024-11-03T14:17:28.428Z | 2024-11-10T14:26:32.594Z |
5461482 | 5461482 | 20241101191323_MQmUh | IT0008 | 2024-11-03T14:15:49.015Z | 2024-11-10T14:26:28.918Z |
5461326 | 5461326 | 20241101175857_yWWP4 | IT0008 | 2024-11-03T14:15:10.340Z | 2024-11-10T14:26:28.119Z |
5453580 | 5453580 | 20241031022711_hFtvE | IT0008 | 2024-11-02T12:22:36.460Z | 2024-11-08T14:23:18.134Z |
5453235 | 5453235 | 20241031015305_LcT6K | IT0008 | 2024-11-02T12:22:30.133Z | 2024-11-08T14:23:16.202Z |
5453057 | 5453057 | 20241031013141_Wvc0F | IT0008 | 2024-11-02T12:22:25.016Z | 2024-11-08T14:23:15.840Z |
5452710 | 5452710 | 20241101041344_fq4xv | IT0008 | 2024-11-02T12:19:16.375Z | 2024-11-09T14:24:33.283Z |
5452437 | 5452437 | 20241101031257_FIDCZ | IT0008 | 2024-11-02T12:18:49.187Z | 2024-11-09T14:24:31.060Z |
5451434 | 5451434 | 20241031235555_FMtyi | IT0008 | 2024-11-02T12:17:09.657Z | 2024-11-09T14:24:23.653Z |
5450766 | 5450766 | 20241031205150_K7kf5 | IT0008 | 2024-11-02T12:15:51.267Z | 2024-11-09T14:24:17.849Z |
5443261 | 5443261 | 20241030042344_kz3hX | IT0008 | 2024-11-01T12:20:25.061Z | 2024-11-07T14:26:50.342Z |
5443222 | 5443222 | 20241030040531_3b304 | IT0008 | 2024-11-01T12:20:23.535Z | 2024-11-07T14:26:50.135Z |
5443054 | 5443054 | 20241030032624_EM7N9 | IT0008 | 2024-11-01T12:20:16.681Z | 2024-11-07T14:26:49.308Z |
5438405 | 5438405 | 20241030171447_Z8Bt2 | IT0008 | 2024-11-01T12:11:40.070Z | 2024-11-08T14:22:59.953Z |
5432796 | 5432796 | 20241029044053_PgJmh | IT0008 | 2024-10-31T12:21:35.352Z | 2024-11-06T14:27:28.738Z |
5432726 | 5432726 | 20241029042656_F94Qq | IT0008 | 2024-10-31T12:21:32.716Z | 2024-11-06T14:27:28.571Z |
5432671 | 5432671 | 20241029041308_a02Df | IT0008 | 2024-10-31T12:21:30.697Z | 2024-11-06T14:27:28.356Z |
5432665 | 5432665 | 20241029041238_MTNhW | IT0008 | 2024-10-31T12:21:30.500Z | 2024-11-06T14:27:28.325Z |
5432227 | 5432227 | 20241029025756_ziZbQ | IT0008 | 2024-10-31T12:21:14.052Z | 2024-11-06T14:27:26.308Z |
5432223 | 5432223 | 20241029025707_VnyqP | IT0008 | 2024-10-31T12:21:13.807Z | 2024-11-06T14:27:26.304Z |
5432140 | 5432140 | 20241029024751_qVoHO | IT0008 | 2024-10-31T12:21:05.702Z | 2024-11-06T14:27:26.054Z |
5431892 | 5431892 | 20241029021258_21SUz | IT0008 | 2024-10-31T12:20:47.270Z | 2024-11-06T14:27:25.191Z |
5431325 | 5431325 | 20241029005547_23HoF | IT0008 | 2024-10-31T12:19:54.942Z | 2024-11-06T14:27:23.281Z |
5430936 | 5430936 | 20241029000541_yldaD | IT0008 | 2024-10-31T12:19:19.511Z | 2024-11-06T14:27:22.283Z |
5430800 | 5430800 | 20241028234020_M2Wni | IT0008 | 2024-10-31T12:19:03.776Z | 2024-11-06T14:27:21.604Z |
5430513 | 5430513 | 20241028224928_LDsBn | IT0008 | 2024-10-31T12:18:30.148Z | 2024-11-06T14:27:20.283Z |
5419515 | 5419515 | 20241028001243_vVn3o | IT0008 | 2024-10-30T12:17:31.238Z | 2024-11-05T14:27:13.311Z |
5418782 | 5418782 | 20241027215654_xd3lL | IT0008 | 2024-10-30T12:16:10.598Z | 2024-11-05T14:27:11.227Z |
5332747 | 5332747 | 20241020221508_m06Yk | IT0008 | 2024-10-22T12:14:17.452Z | 2024-10-29T12:26:33.786Z |
5313190 | 5313190 | 20241014035044_lzFNV | IT0008 | 2024-10-16T12:13:52.744Z | 2024-10-22T12:24:43.038Z |
5313134 | 5313134 | 20241014032136_YErvu | IT0008 | 2024-10-16T12:13:44.716Z | 2024-10-22T12:24:41.602Z |
5313124 | 5313124 | 20241014031716_I2KDl | IT0008 | 2024-10-16T12:13:44.004Z | 2024-10-22T12:24:41.548Z |
5313122 | 5313122 | 20241014031322_dJ8AO | IT0008 | 2024-10-16T12:13:43.689Z | 2024-10-22T12:24:41.531Z |
5313118 | 5313118 | 20241014030936_1jMBq | IT0008 | 2024-10-16T12:13:43.153Z | 2024-10-22T12:24:41.452Z |
5313097 | 5313097 | 20241014025756_KsgZQ | IT0008 | 2024-10-16T12:13:40.397Z | 2024-10-22T12:24:40.873Z |
5312959 | 5312959 | 20241014011958_MXBze | IT0008 | 2024-10-16T12:13:14.811Z | 2024-10-22T12:24:36.363Z |
5312921 | 5312921 | 20241014002934_ouwg5 | IT0008 | 2024-10-16T12:13:06.316Z | 2024-10-22T12:24:33.662Z |
5312529 | 5312529 | 20241015034952_SeKRL | IT0008 | 2024-10-16T12:10:46.059Z | 2024-10-23T12:24:51.598Z |
5312379 | 5312379 | 20241015032454_suKV3 | IT0008 | 2024-10-16T12:10:31.812Z | 2024-10-23T12:24:50.728Z |
5312368 | 5312368 | 20241015032404_2dIy7 | IT0008 | 2024-10-16T12:10:29.266Z | 2024-10-23T12:24:50.587Z |
5312315 | 5312315 | 20241015031620_1Wk2Q | IT0008 | 2024-10-16T12:10:24.444Z | 2024-10-23T12:24:50.070Z |
5312211 | 5312211 | 20241015030135_st5ya | IT0008 | 2024-10-16T12:10:11.390Z | 2024-10-23T12:24:49.491Z |
5312209 | 5312209 | 20241015030134_zVpxw | IT0008 | 2024-10-16T12:10:10.897Z | 2024-10-23T12:24:49.486Z |
5312176 | 5312176 | 20241015025544_eF2f2 | IT0008 | 2024-10-16T12:10:04.945Z | 2024-10-23T12:24:49.102Z |
5312120 | 5312120 | 20241015024716_9Oi5J | IT0008 | 2024-10-16T12:10:01.601Z | 2024-10-23T12:24:47.839Z |
5311960 | 5311960 | 20241015022702_xERxa | IT0008 | 2024-10-16T12:09:49.768Z | 2024-10-23T12:24:47.089Z |
5294459 | 5294459 | 20241012041347_VGPaX | IT0008 | 2024-10-13T12:18:38.134Z | 2024-10-20T12:25:13.310Z |
5294371 | 5294371 | 20241012035523_htGaH | IT0008 | 2024-10-13T12:18:33.316Z | 2024-10-20T12:25:10.819Z |
5294269 | 5294269 | 20241012033525_DKy5p | IT0008 | 2024-10-13T12:18:27.524Z | 2024-10-20T12:25:09.719Z |
5294187 | 5294187 | 20241012031957_oJG3x | IT0008 | 2024-10-13T12:18:22.836Z | 2024-10-20T12:25:08.970Z |
5294124 | 5294124 | 20241012030629_mgek4 | IT0008 | 2024-10-13T12:18:17.846Z | 2024-10-20T12:25:07.645Z |
5294024 | 5294024 | 20241012025038_4HnzC | IT0008 | 2024-10-13T12:18:09.587Z | 2024-10-20T12:25:06.241Z |
5294010 | 5294010 | 20241012024833_L7NSs | IT0008 | 2024-10-13T12:18:08.131Z | 2024-10-20T12:25:06.141Z |
5293879 | 5293879 | 20241012023232_bdb6d | IT0008 | 2024-10-13T12:17:57.623Z | 2024-10-20T12:25:04.910Z |
5292943 | 5292943 | 20241012003659_hGTRi | IT0008 | 2024-10-13T12:16:47.660Z | 2024-10-20T12:24:53.639Z |
5292520 | 5292520 | 20241011234351_r27IZ | IT0008 | 2024-10-13T12:16:05.802Z | 2024-10-20T12:24:46.996Z |
5285623 | 5285623 | 20241011040834_tDYIv | IT0008 | 2024-10-12T12:18:17.267Z | 2024-10-19T12:28:04.002Z |
5284642 | 5284642 | 20241011025931_FlW7d | IT0008 | 2024-10-12T12:17:31.501Z | 2024-10-19T12:27:56.958Z |
5268707 | 5268707 | 20241009025325_EBz2o | IT0008 | 2024-10-10T12:16:20.843Z | 2024-10-17T12:20:18.505Z |
5268700 | 5268700 | 20241009025221_bgmiY | IT0008 | 2024-10-10T12:16:20.275Z | 2024-10-17T12:20:18.437Z |
5268693 | 5268693 | 20241009025051_T762m | IT0008 | 2024-10-10T12:16:19.561Z | 2024-10-17T12:20:18.384Z |
5268597 | 5268597 | 20241009022935_ovWaY | IT0008 | 2024-10-10T12:16:10.706Z | 2024-10-17T12:20:17.960Z |
5268085 | 5268085 | 20241009000918_gRxBp | IT0008 | 2024-10-10T12:15:09.627Z | 2024-10-17T12:20:14.817Z |
5252538 | 5252538 | 20241006202128_7ADvq | IT0008 | 2024-10-08T12:11:54.693Z | 2024-10-15T12:29:01.137Z |
5246542 | 5246542 | 20241006015619_nXyU3 | IT0008 | 2024-10-07T12:16:30.475Z | 2024-10-14T12:24:38.226Z |
5246457 | 5246457 | 20241006014736_rCBlm | IT0008 | 2024-10-07T12:16:26.854Z | 2024-10-14T12:24:37.970Z |
5246200 | 5246200 | 20241006011445_fRyKo | IT0008 | 2024-10-07T12:16:17.166Z | 2024-10-14T12:24:37.454Z |
5246179 | 5246179 | 20241006011022_kiZhK | IT0008 | 2024-10-07T12:16:16.033Z | 2024-10-14T12:24:37.390Z |
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);