participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,917 rows where station_code = "IT0004" 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 |
---|---|---|---|---|---|
5132004 | 5132004 | 20240915223842_axkdc | IT0004 | 2024-09-19T12:15:42.751Z | 2024-09-19T12:15:42.751Z |
5131969 | 5131969 | 20240915222612_HCBKD | IT0004 | 2024-09-19T12:15:38.358Z | 2024-09-19T12:15:38.358Z |
5116709 | 5116709 | 20240915033723_YRR6e | IT0004 | 2024-09-18T12:07:17.415Z | 2024-09-19T12:19:12.103Z |
5116298 | 5116298 | 20240915032022_VrtMC | IT0004 | 2024-09-18T12:06:55.622Z | 2024-09-19T12:19:10.265Z |
5079286 | 5079286 | 20240911024634_zX7ch | IT0004 | 2024-09-15T12:16:14.251Z | 2024-09-19T12:21:41.403Z |
5079148 | 5079148 | 20240911023451_PGGQq | IT0004 | 2024-09-15T12:16:08.356Z | 2024-09-19T12:21:41.168Z |
5078911 | 5078911 | 20240911022040_gbCyG | IT0004 | 2024-09-15T12:15:55.657Z | 2024-09-19T12:21:40.814Z |
5078510 | 5078510 | 20240911020211_qQcJH | IT0004 | 2024-09-15T12:15:41.237Z | 2024-09-19T12:21:40.456Z |
5077973 | 5077973 | 20240911013331_vYn46 | IT0004 | 2024-09-15T12:15:13.540Z | 2024-09-19T12:21:39.864Z |
5077909 | 5077909 | 20240911012839_w62iU | IT0004 | 2024-09-15T12:15:10.544Z | 2024-09-19T12:21:39.775Z |
5077676 | 5077676 | 20240911011006_eQNq5 | IT0004 | 2024-09-15T12:14:58.585Z | 2024-09-19T12:21:39.500Z |
5077474 | 5077474 | 20240911005743_r0JMC | IT0004 | 2024-09-15T12:14:47.401Z | 2024-09-19T12:21:39.049Z |
5077358 | 5077358 | 20240911004605_FQyCP | IT0004 | 2024-09-15T12:14:39.778Z | 2024-09-19T12:21:38.692Z |
5077153 | 5077153 | 20240911002609_ijuAn | IT0004 | 2024-09-15T12:14:25.600Z | 2024-09-19T12:21:38.297Z |
5076925 | 5076925 | 20240911001412_FMVlT | IT0004 | 2024-09-15T12:14:10.666Z | 2024-09-19T12:21:37.780Z |
5076490 | 5076490 | 20240910234056_VE2vj | IT0004 | 2024-09-15T12:13:38.255Z | 2024-09-19T12:21:37.300Z |
5069608 | 5069608 | 20240910215410_PRrx2 | IT0004 | 2024-09-14T12:20:00.681Z | 2024-09-19T12:21:35.107Z |
5069320 | 5069320 | 20240910213024_95D93 | IT0004 | 2024-09-14T12:19:54.317Z | 2024-09-19T12:21:34.579Z |
5065224 | 5065224 | 20240910032314_UB4G6 | IT0004 | 2024-09-14T12:16:43.609Z | 2024-09-18T12:15:18.770Z |
5065174 | 5065174 | 20240910031651_UGnt0 | IT0004 | 2024-09-14T12:16:32.383Z | 2024-09-18T12:15:18.593Z |
5065121 | 5065121 | 20240910031000_fXmU2 | IT0004 | 2024-09-14T12:16:26.995Z | 2024-09-18T12:15:18.436Z |
5065050 | 5065050 | 20240910025901_wsfLf | IT0004 | 2024-09-14T12:16:19.915Z | 2024-09-18T12:15:18.249Z |
5064995 | 5064995 | 20240910024945_Bsm07 | IT0004 | 2024-09-14T12:16:16.363Z | 2024-09-18T12:15:18.065Z |
5064921 | 5064921 | 20240910023154_JLI3O | IT0004 | 2024-09-14T12:16:10.111Z | 2024-09-18T12:15:17.781Z |
5064883 | 5064883 | 20240910022247_CUWty | IT0004 | 2024-09-14T12:16:08.211Z | 2024-09-18T12:15:17.609Z |
5064809 | 5064809 | 20240910020759_B3Tbg | IT0004 | 2024-09-14T12:16:03.966Z | 2024-09-18T12:15:17.421Z |
5064464 | 5064464 | 20240910011258_VQk2L | IT0004 | 2024-09-14T12:15:29.125Z | 2024-09-18T12:15:16.674Z |
5064100 | 5064100 | 20240909235600_novNm | IT0004 | 2024-09-14T12:14:52.376Z | 2024-09-18T12:15:15.508Z |
5063762 | 5063762 | 20240909223635_4je1e | IT0004 | 2024-09-14T12:14:20.571Z | 2024-09-18T12:15:14.651Z |
5060758 | 5060758 | 20240910210308_XYtUR | IT0004 | 2024-09-14T12:09:30.679Z | 2024-09-19T12:21:33.569Z |
5060561 | 5060561 | 20240910203803_NfBVw | IT0004 | 2024-09-14T12:09:08.742Z | 2024-09-19T12:21:32.823Z |
5060301 | 5060301 | 20240910201542_CtbzF | IT0004 | 2024-09-14T12:08:36.450Z | 2024-09-19T12:21:32.112Z |
5059685 | 5059685 | 20240910183138_AE253 | IT0004 | 2024-09-14T12:06:45.581Z | 2024-09-19T12:21:31.107Z |
5053926 | 5053926 | 20240908014945_oeN3b | IT0004 | 2024-09-13T12:16:23.148Z | 2024-09-16T12:21:13.322Z |
5053913 | 5053913 | 20240908014820_j3kZS | IT0004 | 2024-09-13T12:16:22.700Z | 2024-09-16T12:21:13.158Z |
5053553 | 5053553 | 20240908005519_yVKs8 | IT0004 | 2024-09-13T12:16:08.436Z | 2024-09-16T12:21:11.894Z |
5053382 | 5053382 | 20240908002550_v9WxU | IT0004 | 2024-09-13T12:16:02.317Z | 2024-09-16T12:21:10.502Z |
5053250 | 5053250 | 20240907235707_nK7Vq | IT0004 | 2024-09-13T12:15:55.084Z | 2024-09-16T12:21:10.075Z |
5052982 | 5052982 | 20240907225358_IR3Pp | IT0004 | 2024-09-13T12:15:40.140Z | 2024-09-16T12:21:08.861Z |
5052974 | 5052974 | 20240907225047_LNPXH | IT0004 | 2024-09-13T12:15:39.625Z | 2024-09-16T12:21:08.814Z |
5052705 | 5052705 | 20240907214014_lcgUt | IT0004 | 2024-09-13T12:15:21.738Z | 2024-09-16T12:21:07.236Z |
5051978 | 5051978 | 20240907191746_B2W4c | IT0004 | 2024-09-13T12:14:51.331Z | 2024-09-16T12:21:02.682Z |
5040179 | 5040179 | 20240906031214_O7iEX | IT0004 | 2024-09-12T12:16:01.317Z | 2024-09-14T12:23:08.113Z |
5040050 | 5040050 | 20240906024749_3FCBM | IT0004 | 2024-09-12T12:15:56.994Z | 2024-09-14T12:23:07.201Z |
5039697 | 5039697 | 20240906015334_3eRD9 | IT0004 | 2024-09-12T12:15:42.202Z | 2024-09-14T12:23:04.119Z |
5039470 | 5039470 | 20240906010710_zV8R4 | IT0004 | 2024-09-12T12:15:34.111Z | 2024-09-14T12:23:02.372Z |
5039283 | 5039283 | 20240906000944_B23I2 | IT0004 | 2024-09-12T12:15:24.278Z | 2024-09-14T12:23:01.215Z |
5033763 | 5033763 | 20240907034328_DBkqz | IT0004 | 2024-09-12T12:09:56.044Z | 2024-09-15T12:21:31.704Z |
5033706 | 5033706 | 20240907033217_gfhhI | IT0004 | 2024-09-12T12:09:51.085Z | 2024-09-15T12:21:31.526Z |
5033688 | 5033688 | 20240907032853_qwDMQ | IT0004 | 2024-09-12T12:09:49.883Z | 2024-09-15T12:21:31.513Z |
5033676 | 5033676 | 20240907032800_9wc3i | IT0004 | 2024-09-12T12:09:49.330Z | 2024-09-15T12:21:31.495Z |
5033549 | 5033549 | 20240907030913_eufBs | IT0004 | 2024-09-12T12:09:39.078Z | 2024-09-15T12:21:30.464Z |
5033338 | 5033338 | 20240907025038_762vT | IT0004 | 2024-09-12T12:09:11.312Z | 2024-09-15T12:21:29.672Z |
5033291 | 5033291 | 20240907024450_ckVHr | IT0004 | 2024-09-12T12:09:05.303Z | 2024-09-15T12:21:29.512Z |
5033057 | 5033057 | 20240907022024_5xmRA | IT0004 | 2024-09-12T12:08:46.561Z | 2024-09-15T12:21:28.951Z |
5033029 | 5033029 | 20240907021517_XaFwC | IT0004 | 2024-09-12T12:08:44.366Z | 2024-09-15T12:21:28.868Z |
5033019 | 5033019 | 20240907021353_MytDK | IT0004 | 2024-09-12T12:08:43.642Z | 2024-09-15T12:21:28.848Z |
5032997 | 5032997 | 20240907021224_Kr26H | IT0004 | 2024-09-12T12:08:42.190Z | 2024-09-15T12:21:28.770Z |
5032680 | 5032680 | 20240907012916_f2TQ3 | IT0004 | 2024-09-12T12:07:50.942Z | 2024-09-15T12:21:27.418Z |
5032625 | 5032625 | 20240907012248_krAiR | IT0004 | 2024-09-12T12:07:46.009Z | 2024-09-15T12:21:27.164Z |
5032597 | 5032597 | 20240907011908_0zGgR | IT0004 | 2024-09-12T12:07:43.640Z | 2024-09-15T12:21:27.008Z |
5032284 | 5032284 | 20240907004007_jzs9M | IT0004 | 2024-09-12T12:07:03.368Z | 2024-09-15T12:21:25.800Z |
5032224 | 5032224 | 20240907003225_Emq3f | IT0004 | 2024-09-12T12:06:46.373Z | 2024-09-15T12:21:25.607Z |
5032164 | 5032164 | 20240907002149_8Hp2i | IT0004 | 2024-09-12T12:06:39.405Z | 2024-09-15T12:21:25.368Z |
5031956 | 5031956 | 20240906234615_dK826 | IT0004 | 2024-09-12T12:06:10.930Z | 2024-09-15T12:21:24.877Z |
5031866 | 5031866 | 20240906233351_jHvGy | IT0004 | 2024-09-12T12:05:57.818Z | 2024-09-15T12:21:24.595Z |
5031634 | 5031634 | 20240906224619_BQ6R2 | IT0004 | 2024-09-12T12:05:18.568Z | 2024-09-15T12:21:23.477Z |
5031623 | 5031623 | 20240906224357_KesnM | IT0004 | 2024-09-12T12:05:17.453Z | 2024-09-15T12:21:23.463Z |
5031416 | 5031416 | 20240906214837_GMldj | IT0004 | 2024-09-12T12:04:44.439Z | 2024-09-15T12:21:22.271Z |
5031361 | 5031361 | 20240906213327_3f3P4 | IT0004 | 2024-09-12T12:04:36.233Z | 2024-09-15T12:21:22.090Z |
5031112 | 5031112 | 20240906203006_z7sae | IT0004 | 2024-09-12T12:03:56.237Z | 2024-09-15T12:21:21.454Z |
5025652 | 5025652 | 20240905004907_11xUH | IT0004 | 2024-09-11T12:10:42.800Z | 2024-09-13T12:19:54.948Z |
5025362 | 5025362 | 20240906015334_7UUZk | IT0004 | 2024-09-11T12:06:20.979Z | 2024-09-11T12:16:32.597Z |
5025120 | 5025120 | 20240906010710_tUr3R | IT0004 | 2024-09-11T12:05:39.268Z | 2024-09-11T12:16:32.482Z |
5024905 | 5024905 | 20240906000944_XZkkz | IT0004 | 2024-09-11T12:05:05.776Z | 2024-09-11T12:16:32.374Z |
5020069 | 5020069 | 20240905004907_zCbTJ | IT0004 | 2024-09-10T12:13:53.264Z | 2024-09-10T12:16:55.061Z |
5008386 | 5008386 | 20240903233839_RWMqn | IT0004 | 2024-09-09T12:06:41.375Z | 2024-09-12T12:19:17.366Z |
5007988 | 5007988 | 20240903224950_OpJgU | IT0004 | 2024-09-09T12:06:18.437Z | 2024-09-12T12:19:15.754Z |
5007356 | 5007356 | 20240903205754_9jsr8 | IT0004 | 2024-09-09T12:05:43.189Z | 2024-09-12T12:19:12.712Z |
5007248 | 5007248 | 20240903203125_ontzb | IT0004 | 2024-09-09T12:05:38.586Z | 2024-09-12T12:19:12.246Z |
5000991 | 5000991 | 20240902031230_blGLP | IT0004 | 2024-09-08T12:16:05.020Z | 2024-09-10T12:19:31.069Z |
5000065 | 5000065 | 20240902012921_eIIB9 | IT0004 | 2024-09-08T12:15:05.495Z | 2024-09-10T12:19:24.466Z |
4999632 | 4999632 | 20240902004230_9ONjr | IT0004 | 2024-09-08T12:14:38.350Z | 2024-09-10T12:19:21.360Z |
4999462 | 4999462 | 20240902002403_6FeZM | IT0004 | 2024-09-08T12:14:21.478Z | 2024-09-10T12:19:19.421Z |
4998110 | 4998110 | 20240903021445_kWibm | IT0004 | 2024-09-08T12:07:12.497Z | 2024-09-11T12:21:10.983Z |
4991532 | 4991532 | 20240901024351_YNw9Z | IT0004 | 2024-09-07T12:12:08.436Z | 2024-09-09T12:27:11.943Z |
4991428 | 4991428 | 20240901023200_wDLco | IT0004 | 2024-09-07T12:12:02.233Z | 2024-09-09T12:27:07.754Z |
4991251 | 4991251 | 20240901021247_NcCZ7 | IT0004 | 2024-09-07T12:11:48.084Z | 2024-09-09T12:27:03.482Z |
4990960 | 4990960 | 20240901013859_azuIV | IT0004 | 2024-09-07T12:11:23.699Z | 2024-09-09T12:26:56.360Z |
4990548 | 4990548 | 20240901003120_1OyK7 | IT0004 | 2024-09-07T12:10:45.716Z | 2024-09-09T12:26:23.129Z |
4990497 | 4990497 | 20240901002320_OkQcU | IT0004 | 2024-09-07T12:10:41.889Z | 2024-09-09T12:26:22.009Z |
4990172 | 4990172 | 20240831233754_56kmF | IT0004 | 2024-09-07T12:10:08.608Z | 2024-09-09T12:26:12.504Z |
4990154 | 4990154 | 20240831233622_cCeHa | IT0004 | 2024-09-07T12:10:07.812Z | 2024-09-09T12:26:12.125Z |
4990007 | 4990007 | 20240831231507_k8rNR | IT0004 | 2024-09-07T12:09:54.982Z | 2024-09-09T12:26:08.670Z |
4989562 | 4989562 | 20240901235002_MfYaQ | IT0004 | 2024-09-07T12:09:08.012Z | 2024-09-10T12:19:17.900Z |
4988949 | 4988949 | 20240901220606_Q3rhU | IT0004 | 2024-09-07T12:08:15.091Z | 2024-09-10T12:19:15.956Z |
4983223 | 4983223 | 20240812004223_kxoxu | IT0004 | 2024-09-06T12:15:21.377Z | 2024-09-06T12:15:21.377Z |
4982795 | 4982795 | 20240812003752_dtTdf | IT0004 | 2024-09-06T12:15:03.050Z | 2024-09-06T12:15:03.050Z |
4982714 | 4982714 | 20240812003608_yWiOr | IT0004 | 2024-09-06T12:14:58.905Z | 2024-09-06T12:14:58.905Z |
4982677 | 4982677 | 20240812003536_DeJ5j | IT0004 | 2024-09-06T12:14:58.555Z | 2024-09-06T12:14:58.555Z |
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);