participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,337 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 |
---|---|---|---|---|---|
5485115 | 5485115 | 20241105040626_mOYus | IT0008 | 2024-11-06T14:17:46.722Z | 2024-11-09T14:21:19.484Z |
5483248 | 5483248 | 20241105001820_o4L3o | IT0008 | 2024-11-06T14:14:49.507Z | 2024-11-09T14:21:04.317Z |
5482925 | 5482925 | 20241104233416_3cU3V | IT0008 | 2024-11-06T14:14:20.627Z | 2024-11-09T14:21:02.402Z |
5482430 | 5482430 | 20241104221141_YwK7Q | IT0008 | 2024-11-06T14:13:10.556Z | 2024-11-09T14:20:59.246Z |
5481445 | 5481445 | 20241104174622_sGBh4 | IT0008 | 2024-11-06T14:10:34.102Z | 2024-11-09T14:20:46.004Z |
5478067 | 5478067 | 20241104031651_MuqD6 | IT0008 | 2024-11-05T14:17:51.086Z | 2024-11-09T14:22:24.801Z |
5478001 | 5478001 | 20241104030549_khyP9 | IT0008 | 2024-11-05T14:17:43.753Z | 2024-11-09T14:22:23.506Z |
5477808 | 5477808 | 20241104023901_OhobB | IT0008 | 2024-11-05T14:17:26.392Z | 2024-11-09T14:22:22.101Z |
5477796 | 5477796 | 20241104023653_ostrH | IT0008 | 2024-11-05T14:17:25.787Z | 2024-11-09T14:22:22.016Z |
5468303 | 5468303 | 20241103000812_yHpL9 | IT0008 | 2024-11-04T14:13:55.434Z | 2024-11-09T14:22:57.956Z |
5467974 | 5467974 | 20241102230516_zM2W3 | IT0008 | 2024-11-04T14:13:03.495Z | 2024-11-09T14:22:56.198Z |
5466663 | 5466663 | 20241102182634_CLXWv | IT0008 | 2024-11-04T14:09:31.011Z | 2024-11-09T14:22:51.904Z |
5463500 | 5463500 | 20241102034731_UIulo | IT0008 | 2024-11-03T14:18:51.051Z | 2024-11-09T14:23:41.346Z |
5463378 | 5463378 | 20241102033009_lc5GH | IT0008 | 2024-11-03T14:18:40.661Z | 2024-11-09T14:23:40.299Z |
5463111 | 5463111 | 20241102023609_0arhK | IT0008 | 2024-11-03T14:18:19.489Z | 2024-11-09T14:23:37.995Z |
5463096 | 5463096 | 20241102023325_DpUzy | IT0008 | 2024-11-03T14:18:17.967Z | 2024-11-09T14:23:37.682Z |
5463074 | 5463074 | 20241102022952_bNz5o | IT0008 | 2024-11-03T14:18:16.966Z | 2024-11-09T14:23:37.626Z |
5462471 | 5462471 | 20241102002452_amsV5 | IT0008 | 2024-11-03T14:17:28.428Z | 2024-11-09T14:23:34.399Z |
5461482 | 5461482 | 20241101191323_MQmUh | IT0008 | 2024-11-03T14:15:49.015Z | 2024-11-09T14:23:29.518Z |
5461326 | 5461326 | 20241101175857_yWWP4 | IT0008 | 2024-11-03T14:15:10.340Z | 2024-11-09T14:23:27.879Z |
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 |
5245960 | 5245960 | 20241006003558_u28Gf | IT0008 | 2024-10-07T12:16:06.250Z | 2024-10-14T12:24:36.967Z |
5245535 | 5245535 | 20241005232103_na3U6 | IT0008 | 2024-10-07T12:15:43.842Z | 2024-10-14T12:24:35.777Z |
5245370 | 5245370 | 20241005224743_6LAju | IT0008 | 2024-10-07T12:15:37.986Z | 2024-10-14T12:24:35.328Z |
5245262 | 5245262 | 20241005222726_zHiCx | IT0008 | 2024-10-07T12:15:34.846Z | 2024-10-14T12:24:34.868Z |
5237390 | 5237390 | 20241006040340_YYF3m | IT0008 | 2024-10-07T12:01:29.562Z | 2024-10-15T12:28:41.680Z |
5237221 | 5237221 | 20241006032730_ebFTi | IT0008 | 2024-10-07T12:00:56.010Z | 2024-10-15T12:28:40.659Z |
5205552 | 5205552 | 20241001000643_lV1Xj | IT0008 | 2024-10-02T12:12:49.158Z | 2024-10-09T12:29:16.479Z |
5205376 | 5205376 | 20240930233244_3KHmJ | IT0008 | 2024-10-02T12:12:40.069Z | 2024-10-09T12:29:16.221Z |
5204991 | 5204991 | 20240930214153_7LZOj | IT0008 | 2024-10-02T12:12:14.684Z | 2024-10-09T12:29:15.313Z |
5204426 | 5204426 | 20240930194953_3XHhx | IT0008 | 2024-10-02T12:11:35.236Z | 2024-10-09T12:29:13.997Z |
5199299 | 5199299 | 20240929233254_BkbWf | IT0008 | 2024-10-01T12:16:04.139Z | 2024-10-07T12:21:39.403Z |
5194633 | 5194633 | 20240930020722_vr23O | IT0008 | 2024-10-01T12:01:34.128Z | 2024-10-09T12:29:00.472Z |
5194614 | 5194614 | 20240930020256_3ONTL | IT0008 | 2024-10-01T12:01:30.628Z | 2024-10-09T12:29:00.379Z |
5186230 | 5186230 | 20240929033855_Zwr7w | IT0008 | 2024-09-30T12:06:27.333Z | 2024-10-07T12:21:20.032Z |
5185344 | 5185344 | 20240929021806_3uXDJ | IT0008 | 2024-09-30T12:04:05.048Z | 2024-10-07T12:21:17.608Z |
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);