participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
90 rows where station_code = "IT0005" 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 |
|---|---|---|---|---|---|
| 2888636 | 2888636 | 20230824020012_QknPP | IT0005 | 2024-01-06T00:01:11.974Z | 2024-01-06T00:01:11.974Z |
| 2888641 | 2888641 | 20230824020032_bhdYE | IT0005 | 2024-01-06T00:01:11.974Z | 2024-01-06T00:01:11.974Z |
| 2888012 | 2888012 | 20230824003628_G3NyO | IT0005 | 2024-01-06T00:01:11.900Z | 2024-01-06T00:01:11.900Z |
| 2887726 | 2887726 | 20230823235918_HTw16 | IT0005 | 2024-01-06T00:01:11.868Z | 2024-01-06T00:01:11.868Z |
| 2887540 | 2887540 | 20230823233717_juq3C | IT0005 | 2024-01-06T00:01:11.851Z | 2024-01-06T00:01:11.851Z |
| 2887040 | 2887040 | 20230823224717_2d3oQ | IT0005 | 2024-01-06T00:01:11.810Z | 2024-01-06T00:01:11.810Z |
| 2887008 | 2887008 | 20230823223809_dd3yA | IT0005 | 2024-01-06T00:01:11.806Z | 2024-01-06T00:01:11.806Z |
| 2886205 | 2886205 | 20230823195335_iJ01J | IT0005 | 2024-01-06T00:01:11.722Z | 2024-01-06T00:01:11.722Z |
| 2883803 | 2883803 | 20230823024356_P3gfW | IT0005 | 2024-01-06T00:01:10.149Z | 2024-01-06T00:01:10.149Z |
| 2883545 | 2883545 | 20230823023012_ZiabU | IT0005 | 2024-01-06T00:01:10.123Z | 2024-01-06T00:01:10.123Z |
| 2883246 | 2883246 | 20230823020818_KqDcH | IT0005 | 2024-01-06T00:01:10.088Z | 2024-01-06T00:01:10.088Z |
| 2883102 | 2883102 | 20230823015910_NLWep | IT0005 | 2024-01-06T00:01:10.075Z | 2024-01-06T00:01:10.075Z |
| 2882696 | 2882696 | 20230823013754_vq2wx | IT0005 | 2024-01-06T00:01:10.040Z | 2024-01-06T00:01:10.040Z |
| 2882099 | 2882099 | 20230823010429_Y63ED | IT0005 | 2024-01-06T00:01:09.987Z | 2024-01-06T00:01:09.987Z |
| 2882082 | 2882082 | 20230823010303_3WUVm | IT0005 | 2024-01-06T00:01:09.986Z | 2024-01-06T00:01:09.986Z |
| 2882063 | 2882063 | 20230823010217_hjjXv | IT0005 | 2024-01-06T00:01:09.984Z | 2024-01-06T00:01:09.984Z |
| 2881640 | 2881640 | 20230823003739_2Hp43 | IT0005 | 2024-01-06T00:01:09.944Z | 2024-01-06T00:01:09.944Z |
| 2881219 | 2881219 | 20230823000148_pIsfT | IT0005 | 2024-01-06T00:01:09.901Z | 2024-01-06T00:01:09.901Z |
| 2881101 | 2881101 | 20230822235238_qXKDA | IT0005 | 2024-01-06T00:01:09.891Z | 2024-01-06T00:01:09.891Z |
| 2880768 | 2880768 | 20230822231717_v2o32 | IT0005 | 2024-01-06T00:01:09.852Z | 2024-01-06T00:01:09.852Z |
| 2880469 | 2880469 | 20230822225012_i5Vt6 | IT0005 | 2024-01-06T00:01:09.823Z | 2024-01-06T00:01:09.823Z |
| 2880471 | 2880471 | 20230822225016_SJw47 | IT0005 | 2024-01-06T00:01:09.823Z | 2024-01-06T00:01:09.823Z |
| 2880457 | 2880457 | 20230822224829_ysqTj | IT0005 | 2024-01-06T00:01:09.822Z | 2024-01-06T00:01:09.822Z |
| 2880324 | 2880324 | 20230822223359_LOi8b | IT0005 | 2024-01-06T00:01:09.805Z | 2024-01-06T00:01:09.805Z |
| 2880068 | 2880068 | 20230822221644_5317F | IT0005 | 2024-01-06T00:01:09.786Z | 2024-01-06T00:01:09.786Z |
| 2879963 | 2879963 | 20230822220945_bUP16 | IT0005 | 2024-01-06T00:01:09.777Z | 2024-01-06T00:01:09.777Z |
| 2879618 | 2879618 | 20230822213355_iRk50 | IT0005 | 2024-01-06T00:01:09.747Z | 2024-01-06T00:01:09.747Z |
| 2879565 | 2879565 | 20230822213038_ZOFyM | IT0005 | 2024-01-06T00:01:09.743Z | 2024-01-06T00:01:09.743Z |
| 2879097 | 2879097 | 20230822201655_6f8ZD | IT0005 | 2024-01-06T00:01:09.696Z | 2024-01-06T00:01:09.696Z |
| 2879057 | 2879057 | 20230822195638_7p0Ui | IT0005 | 2024-01-06T00:01:09.691Z | 2024-01-06T00:01:09.691Z |
| 2876066 | 2876066 | 20230822020205_s7XRz | IT0005 | 2024-01-06T00:01:08.025Z | 2024-01-06T00:01:08.025Z |
| 2875823 | 2875823 | 20230822014120_iZLnY | IT0005 | 2024-01-06T00:01:08.000Z | 2024-01-06T00:01:08.000Z |
| 2875144 | 2875144 | 20230822004956_zPqHm | IT0005 | 2024-01-06T00:01:07.930Z | 2024-01-06T00:01:07.930Z |
| 2875039 | 2875039 | 20230822004258_f3OQM | IT0005 | 2024-01-06T00:01:07.920Z | 2024-01-06T00:01:07.920Z |
| 2874868 | 2874868 | 20230822003352_VpEQS | IT0005 | 2024-01-06T00:01:07.905Z | 2024-01-06T00:01:07.905Z |
| 2874626 | 2874626 | 20230822001642_UT949 | IT0005 | 2024-01-06T00:01:07.882Z | 2024-01-06T00:01:07.882Z |
| 2873839 | 2873839 | 20230821230202_lkpWZ | IT0005 | 2024-01-06T00:01:07.798Z | 2024-01-06T00:01:07.798Z |
| 2873798 | 2873798 | 20230821225942_UK2vw | IT0005 | 2024-01-06T00:01:07.794Z | 2024-01-06T00:01:07.794Z |
| 2873629 | 2873629 | 20230821224638_dzv1h | IT0005 | 2024-01-06T00:01:07.778Z | 2024-01-06T00:01:07.778Z |
| 2873610 | 2873610 | 20230821224440_rB7ra | IT0005 | 2024-01-06T00:01:07.776Z | 2024-01-06T00:01:07.776Z |
| 2873534 | 2873534 | 20230821223556_5qhM9 | IT0005 | 2024-01-06T00:01:07.768Z | 2024-01-06T00:01:07.768Z |
| 2873368 | 2873368 | 20230821222319_aBj3U | IT0005 | 2024-01-06T00:01:07.752Z | 2024-01-06T00:01:07.752Z |
| 2873147 | 2873147 | 20230821220305_Wo7iW | IT0005 | 2024-01-06T00:01:07.733Z | 2024-01-06T00:01:07.733Z |
| 2872638 | 2872638 | 20230821205640_1PDdc | IT0005 | 2024-01-06T00:01:07.674Z | 2024-01-06T00:01:07.674Z |
| 2872608 | 2872608 | 20230821205306_X4qpp | IT0005 | 2024-01-06T00:01:07.670Z | 2024-01-06T00:01:07.670Z |
| 2868602 | 2868602 | 20230821020646_P8xyq | IT0005 | 2024-01-06T00:01:05.932Z | 2024-01-06T00:01:05.932Z |
| 2868590 | 2868590 | 20230821020524_22dD2 | IT0005 | 2024-01-06T00:01:05.930Z | 2024-01-06T00:01:05.930Z |
| 2868347 | 2868347 | 20230821015040_5ORKm | IT0005 | 2024-01-06T00:01:05.908Z | 2024-01-06T00:01:05.908Z |
| 2867845 | 2867845 | 20230821011858_X6uMT | IT0005 | 2024-01-06T00:01:05.863Z | 2024-01-06T00:01:05.863Z |
| 2867000 | 2867000 | 20230821003819_7Y5kT | IT0005 | 2024-01-06T00:01:05.800Z | 2024-01-06T00:01:05.800Z |
| 2866179 | 2866179 | 20230820235457_TG2Q1 | IT0005 | 2024-01-06T00:01:05.735Z | 2024-01-06T00:01:05.735Z |
| 2860661 | 2860661 | 20230820025548_gUQ9g | IT0005 | 2024-01-06T00:01:03.863Z | 2024-01-06T00:01:03.863Z |
| 2860624 | 2860624 | 20230820025413_dz3VH | IT0005 | 2024-01-06T00:01:03.860Z | 2024-01-06T00:01:03.860Z |
| 2860619 | 2860619 | 20230820025406_ohHZK | IT0005 | 2024-01-06T00:01:03.859Z | 2024-01-06T00:01:03.859Z |
| 2860478 | 2860478 | 20230820024310_4FbpJ | IT0005 | 2024-01-06T00:01:03.846Z | 2024-01-06T00:01:03.846Z |
| 2860331 | 2860331 | 20230820023437_v5ABY | IT0005 | 2024-01-06T00:01:03.833Z | 2024-01-06T00:01:03.833Z |
| 2860289 | 2860289 | 20230820023306_NnvZ2 | IT0005 | 2024-01-06T00:01:03.830Z | 2024-01-06T00:01:03.830Z |
| 2859888 | 2859888 | 20230820021059_CzBHD | IT0005 | 2024-01-06T00:01:03.797Z | 2024-01-06T00:01:03.797Z |
| 2859865 | 2859865 | 20230820020956_T0O0h | IT0005 | 2024-01-06T00:01:03.795Z | 2024-01-06T00:01:03.795Z |
| 2859441 | 2859441 | 20230820014656_CvvON | IT0005 | 2024-01-06T00:01:03.759Z | 2024-01-06T00:01:03.759Z |
| 2859357 | 2859357 | 20230820014310_qJ5Ne | IT0005 | 2024-01-06T00:01:03.751Z | 2024-01-06T00:01:03.751Z |
| 2859254 | 2859254 | 20230820013947_FBEe7 | IT0005 | 2024-01-06T00:01:03.744Z | 2024-01-06T00:01:03.744Z |
| 2858847 | 2858847 | 20230820011605_CrFw8 | IT0005 | 2024-01-06T00:01:03.708Z | 2024-01-06T00:01:03.708Z |
| 2858141 | 2858141 | 20230820003711_P20HR | IT0005 | 2024-01-06T00:01:03.653Z | 2024-01-06T00:01:03.653Z |
| 2857841 | 2857841 | 20230820001739_XAFzt | IT0005 | 2024-01-06T00:01:03.625Z | 2024-01-06T00:01:03.625Z |
| 2857544 | 2857544 | 20230819235931_QTyOA | IT0005 | 2024-01-06T00:01:03.601Z | 2024-01-06T00:01:03.601Z |
| 2856987 | 2856987 | 20230819232449_i6sBJ | IT0005 | 2024-01-06T00:01:03.556Z | 2024-01-06T00:01:03.556Z |
| 2855456 | 2855456 | 20230819212713_p6wg5 | IT0005 | 2024-01-06T00:01:03.435Z | 2024-01-06T00:01:03.435Z |
| 2855345 | 2855345 | 20230819211105_sQrq2 | IT0005 | 2024-01-06T00:01:03.423Z | 2024-01-06T00:01:03.423Z |
| 2855215 | 2855215 | 20230819205335_aK5bP | IT0005 | 2024-01-06T00:01:03.411Z | 2024-01-06T00:01:03.411Z |
| 2855198 | 2855198 | 20230819204911_LTZFz | IT0005 | 2024-01-06T00:01:03.409Z | 2024-01-06T00:01:03.409Z |
| 781870 | 781870 | 20210914023518_9GOSE | IT0005 | 2024-01-05T23:36:55.591Z | 2024-01-05T23:36:55.591Z |
| 781864 | 781864 | 20210914023200_fX2Q5 | IT0005 | 2024-01-05T23:36:55.590Z | 2024-01-05T23:36:55.590Z |
| 781405 | 781405 | 20210913235535_c3I44 | IT0005 | 2024-01-05T23:36:55.525Z | 2024-01-05T23:36:55.525Z |
| 778452 | 778452 | 20210912223443_z1ZxC | IT0005 | 2024-01-05T23:36:53.927Z | 2024-01-05T23:36:53.927Z |
| 778394 | 778394 | 20210912221029_W2Vrl | IT0005 | 2024-01-05T23:36:53.919Z | 2024-01-05T23:36:53.919Z |
| 775987 | 775987 | 20210912005249_V5Let | IT0005 | 2024-01-05T23:36:52.369Z | 2024-01-05T23:36:52.369Z |
| 775541 | 775541 | 20210911224744_ZxRkS | IT0005 | 2024-01-05T23:36:52.312Z | 2024-01-05T23:36:52.312Z |
| 770702 | 770702 | 20210910000727_QWdKw | IT0005 | 2024-01-05T23:36:49.227Z | 2024-01-05T23:36:49.227Z |
| 770641 | 770641 | 20210909234010_1rhiF | IT0005 | 2024-01-05T23:36:49.219Z | 2024-01-05T23:36:49.219Z |
| 770441 | 770441 | 20210909224206_UbsMR | IT0005 | 2024-01-05T23:36:49.194Z | 2024-01-05T23:36:49.194Z |
| 770196 | 770196 | 20210909211327_7gaFd | IT0005 | 2024-01-05T23:36:49.164Z | 2024-01-05T23:36:49.164Z |
| 768445 | 768445 | 20210909022204_NVvRG | IT0005 | 2024-01-05T23:36:47.756Z | 2024-01-05T23:36:47.756Z |
| 768434 | 768434 | 20210909021726_SmvUr | IT0005 | 2024-01-05T23:36:47.755Z | 2024-01-05T23:36:47.755Z |
| 768370 | 768370 | 20210909015949_OqriE | IT0005 | 2024-01-05T23:36:47.746Z | 2024-01-05T23:36:47.746Z |
| 768256 | 768256 | 20210909011536_pewfL | IT0005 | 2024-01-05T23:36:47.729Z | 2024-01-05T23:36:47.729Z |
| 768165 | 768165 | 20210909004851_jeH1O | IT0005 | 2024-01-05T23:36:47.716Z | 2024-01-05T23:36:47.716Z |
| 767997 | 767997 | 20210909000420_wacT1 | IT0005 | 2024-01-05T23:36:47.692Z | 2024-01-05T23:36:47.692Z |
| 764578 | 764578 | 20210908005456_MtK72 | IT0005 | 2024-01-05T23:36:45.719Z | 2024-01-05T23:36:45.719Z |
| 764190 | 764190 | 20210907233323_EXFyW | IT0005 | 2024-01-05T23:36:45.672Z | 2024-01-05T23:36:45.672Z |
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);