participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,398 rows where station_code = "SI0005" 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 |
|---|---|---|---|---|---|
| 9251628 | 9251628 | 20260122213428_HyG8w | SI0005 | 2026-01-24T14:12:38.792Z | 2026-01-29T14:51:55.888Z |
| 9228245 | 9228245 | 20260118205646_1pOSi | SI0005 | 2026-01-20T14:16:51.918Z | 2026-01-27T15:01:36.072Z |
| 9228185 | 9228185 | 20260118202840_tDInS | SI0005 | 2026-01-20T14:16:33.235Z | 2026-01-27T15:01:32.485Z |
| 9227970 | 9227970 | 20260118185803_BD33u | SI0005 | 2026-01-20T14:15:13.011Z | 2026-01-27T15:01:08.571Z |
| 9227893 | 9227893 | 20260118182915_Gs2Ew | SI0005 | 2026-01-20T14:14:43.584Z | 2026-01-27T15:01:01.245Z |
| 9189429 | 9189429 | 20260112042412_44LtK | SI0005 | 2026-01-13T14:17:33.188Z | 2026-01-20T15:23:09.760Z |
| 9189329 | 9189329 | 20260112035950_kGcl5 | SI0005 | 2026-01-13T14:17:02.539Z | 2026-01-20T15:23:04.364Z |
| 9189202 | 9189202 | 20260112032652_hUkwu | SI0005 | 2026-01-13T14:16:17.478Z | 2026-01-20T15:22:47.233Z |
| 9189035 | 9189035 | 20260112024011_7BI49 | SI0005 | 2026-01-13T14:15:24.879Z | 2026-01-20T15:22:35.547Z |
| 9189012 | 9189012 | 20260112023515_a9GId | SI0005 | 2026-01-13T14:15:19.557Z | 2026-01-20T15:22:34.283Z |
| 9188937 | 9188937 | 20260112022511_redeu | SI0005 | 2026-01-13T14:14:58.823Z | 2026-01-20T15:22:30.666Z |
| 9188931 | 9188931 | 20260112022408_lnMIi | SI0005 | 2026-01-13T14:14:56.603Z | 2026-01-20T15:22:30.327Z |
| 9188910 | 9188910 | 20260112022016_Ffqr7 | SI0005 | 2026-01-13T14:14:51.870Z | 2026-01-20T15:22:29.189Z |
| 9188906 | 9188906 | 20260112021938_lukwL | SI0005 | 2026-01-13T14:14:51.301Z | 2026-01-20T15:22:29.041Z |
| 9188900 | 9188900 | 20260112021851_DaWmz | SI0005 | 2026-01-13T14:14:49.498Z | 2026-01-20T15:22:28.591Z |
| 9188801 | 9188801 | 20260112015235_qQJba | SI0005 | 2026-01-13T14:14:21.099Z | 2026-01-20T15:22:15.681Z |
| 9188756 | 9188756 | 20260112014053_WVsSv | SI0005 | 2026-01-13T14:14:04.659Z | 2026-01-20T15:22:12.392Z |
| 9188705 | 9188705 | 20260112012035_cSwW8 | SI0005 | 2026-01-13T14:13:51.045Z | 2026-01-20T15:22:07.180Z |
| 9188643 | 9188643 | 20260112010156_GaiiU | SI0005 | 2026-01-13T14:13:26.409Z | 2026-01-20T15:22:03.334Z |
| 9188623 | 9188623 | 20260112005922_PKqaF | SI0005 | 2026-01-13T14:13:21.103Z | 2026-01-20T15:22:02.374Z |
| 9188468 | 9188468 | 20260111235115_bShra | SI0005 | 2026-01-13T14:12:27.886Z | 2026-01-20T15:21:44.046Z |
| 9188410 | 9188410 | 20260111232305_Zlxk6 | SI0005 | 2026-01-13T14:12:08.516Z | 2026-01-20T15:21:40.528Z |
| 9188332 | 9188332 | 20260111224233_7yxVg | SI0005 | 2026-01-13T14:11:46.644Z | 2026-01-20T15:21:34.789Z |
| 9188269 | 9188269 | 20260111215350_2X9q8 | SI0005 | 2026-01-13T14:11:21.574Z | 2026-01-20T15:21:31.052Z |
| 9188168 | 9188168 | 20260111210752_W8nSN | SI0005 | 2026-01-13T14:10:47.464Z | 2026-01-20T15:21:25.057Z |
| 9188018 | 9188018 | 20260111200018_XcapS | SI0005 | 2026-01-13T14:10:03.581Z | 2026-01-20T15:21:06.946Z |
| 9180703 | 9180703 | 20260110214652_HQpdB | SI0005 | 2026-01-12T14:08:04.351Z | 2026-01-19T15:16:28.572Z |
| 9171556 | 9171556 | 20260108230213_P99s1 | SI0005 | 2026-01-10T14:08:05.823Z | 2026-01-17T15:24:06.881Z |
| 9171503 | 9171503 | 20260108222236_gnHtv | SI0005 | 2026-01-10T14:07:45.844Z | 2026-01-17T15:24:03.838Z |
| 9171401 | 9171401 | 20260108213039_votFj | SI0005 | 2026-01-10T14:07:12.543Z | 2026-01-17T15:23:47.519Z |
| 9171392 | 9171392 | 20260108212814_A73o3 | SI0005 | 2026-01-10T14:07:09.392Z | 2026-01-17T15:23:47.210Z |
| 9171359 | 9171359 | 20260108211459_6blIO | SI0005 | 2026-01-10T14:06:55.132Z | 2026-01-17T15:23:45.366Z |
| 9171342 | 9171342 | 20260108211244_6P1AM | SI0005 | 2026-01-10T14:06:50.120Z | 2026-01-17T15:23:44.783Z |
| 9171340 | 9171340 | 20260108210756_wAFYJ | SI0005 | 2026-01-10T14:06:48.543Z | 2026-01-17T15:23:44.666Z |
| 9171305 | 9171305 | 20260108205128_PGdZi | SI0005 | 2026-01-10T14:06:38.489Z | 2026-01-17T15:23:43.218Z |
| 9171027 | 9171027 | 20260108184104_svlOb | SI0005 | 2026-01-10T14:04:46.811Z | 2026-01-17T15:23:16.617Z |
| 9170974 | 9170974 | 20260108181019_mehrH | SI0005 | 2026-01-10T14:04:26.655Z | 2026-01-17T15:23:13.927Z |
| 9170928 | 9170928 | 20260108174839_5CpP6 | SI0005 | 2026-01-10T14:04:11.006Z | 2026-01-17T15:23:11.802Z |
| 9170924 | 9170924 | 20260108174045_8D2o3 | SI0005 | 2026-01-10T14:04:08.539Z | 2026-01-17T15:23:11.543Z |
| 9125352 | 9125352 | 20251231174000_Kb1TW | SI0005 | 2026-01-02T14:54:57.485Z | 2026-01-08T15:15:26.964Z |
| 9125202 | 9125202 | 20251231170356_Xb2s0 | SI0005 | 2026-01-02T14:54:27.215Z | 2026-01-08T15:15:17.513Z |
| 9125121 | 9125121 | 20251231164058_2sthp | SI0005 | 2026-01-02T14:54:16.946Z | 2026-01-08T15:15:12.923Z |
| 9123971 | 9123971 | 20251231041556_LfAaY | SI0005 | 2026-01-02T14:38:59.799Z | 2026-01-08T15:09:46.906Z |
| 9122317 | 9122317 | 20260101053104_MPi8c | SI0005 | 2026-01-02T14:12:25.095Z | 2026-01-09T14:53:14.325Z |
| 9122309 | 9122309 | 20260101053021_HoA8V | SI0005 | 2026-01-02T14:12:19.596Z | 2026-01-09T14:53:13.875Z |
| 9122227 | 9122227 | 20260101050101_hvAN4 | SI0005 | 2026-01-02T14:11:53.944Z | 2026-01-09T14:53:08.479Z |
| 9122221 | 9122221 | 20260101045914_dUv8a | SI0005 | 2026-01-02T14:11:51.945Z | 2026-01-09T14:53:08.068Z |
| 9122173 | 9122173 | 20260101044457_4pMTv | SI0005 | 2026-01-02T14:11:36.780Z | 2026-01-09T14:53:05.177Z |
| 9122158 | 9122158 | 20260101044219_bDhoh | SI0005 | 2026-01-02T14:11:33.403Z | 2026-01-09T14:53:04.439Z |
| 9122145 | 9122145 | 20260101043840_R8e8N | SI0005 | 2026-01-02T14:11:29.613Z | 2026-01-09T14:53:03.463Z |
| 9122143 | 9122143 | 20260101043653_zy71P | SI0005 | 2026-01-02T14:11:28.699Z | 2026-01-09T14:53:03.304Z |
| 9122132 | 9122132 | 20260101043422_nyCke | SI0005 | 2026-01-02T14:11:22.966Z | 2026-01-09T14:53:02.843Z |
| 9122117 | 9122117 | 20260101043210_82LQU | SI0005 | 2026-01-02T14:11:18.712Z | 2026-01-09T14:53:01.994Z |
| 9122107 | 9122107 | 20260101042928_E4cCq | SI0005 | 2026-01-02T14:11:14.821Z | 2026-01-09T14:53:01.413Z |
| 9122092 | 9122092 | 20260101042718_321mz | SI0005 | 2026-01-02T14:11:07.205Z | 2026-01-09T14:53:00.479Z |
| 9122063 | 9122063 | 20260101041838_rJY4x | SI0005 | 2026-01-02T14:10:57.052Z | 2026-01-09T14:52:58.739Z |
| 9122039 | 9122039 | 20260101041326_iek7M | SI0005 | 2026-01-02T14:10:50.684Z | 2026-01-09T14:52:57.496Z |
| 9122037 | 9122037 | 20260101041143_M0U9R | SI0005 | 2026-01-02T14:10:49.974Z | 2026-01-09T14:52:57.351Z |
| 9121982 | 9121982 | 20260101040237_XOlCN | SI0005 | 2026-01-02T14:10:32.253Z | 2026-01-09T14:52:54.687Z |
| 9121956 | 9121956 | 20260101035321_aZ2gc | SI0005 | 2026-01-02T14:10:25.077Z | 2026-01-09T14:52:50.106Z |
| 9121871 | 9121871 | 20260101032002_2prP8 | SI0005 | 2026-01-02T14:09:57.624Z | 2026-01-09T14:52:43.554Z |
| 9121695 | 9121695 | 20260101014430_9nxrv | SI0005 | 2026-01-02T14:08:45.757Z | 2026-01-09T14:52:29.129Z |
| 9121693 | 9121693 | 20260101014337_iBbZg | SI0005 | 2026-01-02T14:08:44.954Z | 2026-01-09T14:52:28.947Z |
| 9121687 | 9121687 | 20260101014113_7pxao | SI0005 | 2026-01-02T14:08:43.425Z | 2026-01-09T14:52:28.652Z |
| 9120907 | 9120907 | 20251231200151_uCeYd | SI0005 | 2026-01-02T14:04:53.849Z | 2026-01-09T14:51:30.179Z |
| 9120544 | 9120544 | 20251231190524_RVHfr | SI0005 | 2026-01-02T14:03:00.692Z | 2026-01-09T14:51:13.458Z |
| 9119627 | 9119627 | 20251230182833_rFpWa | SI0005 | 2026-01-01T14:56:41.721Z | 2026-01-07T15:12:57.959Z |
| 9119499 | 9119499 | 20251230180926_Fcc2a | SI0005 | 2026-01-01T14:56:17.664Z | 2026-01-07T15:12:48.586Z |
| 9119400 | 9119400 | 20251230174658_fBr7F | SI0005 | 2026-01-01T14:56:03.030Z | 2026-01-01T14:58:01.732Z |
| 9115960 | 9115960 | 20251231053545_cRgOs | SI0005 | 2026-01-01T14:26:50.614Z | 2026-01-08T15:11:18.355Z |
| 9115958 | 9115958 | 20251231053544_j0zib | SI0005 | 2026-01-01T14:26:50.133Z | 2026-01-08T15:11:18.173Z |
| 9115650 | 9115650 | 20251231052149_mQgDH | SI0005 | 2026-01-01T14:26:05.853Z | 2026-01-08T15:11:06.219Z |
| 9115617 | 9115617 | 20251231051838_jD00a | SI0005 | 2026-01-01T14:25:55.628Z | 2026-01-08T15:10:57.274Z |
| 9115565 | 9115565 | 20251231051537_EFhs0 | SI0005 | 2026-01-01T14:25:46.717Z | 2026-01-08T15:10:55.334Z |
| 9115542 | 9115542 | 20251231051428_ivj2Q | SI0005 | 2026-01-01T14:25:41.937Z | 2026-01-08T15:10:53.785Z |
| 9115296 | 9115296 | 20251231045726_3qTu3 | SI0005 | 2026-01-01T14:24:58.527Z | 2026-01-08T15:10:40.775Z |
| 9114441 | 9114441 | 20251231041730_27I6f | SI0005 | 2026-01-01T14:22:32.119Z | 2026-01-08T15:09:48.302Z |
| 9114424 | 9114424 | 20251231041556_akgFI | SI0005 | 2026-01-01T14:22:27.416Z | 2026-01-08T15:09:46.748Z |
| 9113270 | 9113270 | 20251231032007_1OW99 | SI0005 | 2026-01-01T14:18:15.178Z | 2026-01-08T15:08:37.694Z |
| 9112825 | 9112825 | 20251231025423_WvysC | SI0005 | 2026-01-01T14:16:27.247Z | 2026-01-08T15:08:09.562Z |
| 9112505 | 9112505 | 20251231023250_05que | SI0005 | 2026-01-01T14:15:22.159Z | 2026-01-08T15:07:47.498Z |
| 9112172 | 9112172 | 20251231021025_CVAvf | SI0005 | 2026-01-01T14:14:16.999Z | 2026-01-08T15:07:24.330Z |
| 9112089 | 9112089 | 20251231020510_W20Hk | SI0005 | 2026-01-01T14:13:57.172Z | 2026-01-08T15:07:18.579Z |
| 9112009 | 9112009 | 20251231015522_2g5AJ | SI0005 | 2026-01-01T14:13:31.173Z | 2026-01-08T15:07:12.625Z |
| 9111925 | 9111925 | 20251231015220_U61bh | SI0005 | 2026-01-01T14:13:21.163Z | 2026-01-08T15:07:09.682Z |
| 9111747 | 9111747 | 20251231014031_YEKJn | SI0005 | 2026-01-01T14:12:39.457Z | 2026-01-08T15:06:55.686Z |
| 9111524 | 9111524 | 20251231011742_R0inb | SI0005 | 2026-01-01T14:11:50.499Z | 2026-01-08T15:06:44.132Z |
| 9111520 | 9111520 | 20251231011716_e9WPu | SI0005 | 2026-01-01T14:11:49.241Z | 2026-01-08T15:06:43.761Z |
| 9111327 | 9111327 | 20251231010232_83Evi | SI0005 | 2026-01-01T14:11:03.475Z | 2026-01-08T15:06:31.003Z |
| 9109670 | 9109670 | 20251230201541_Qbxyd | SI0005 | 2026-01-01T14:02:37.837Z | 2026-01-08T15:04:19.165Z |
| 9103690 | 9103690 | 20251230045255_i2f3C | SI0005 | 2025-12-31T14:18:53.254Z | 2026-01-07T15:09:04.894Z |
| 9103624 | 9103624 | 20251230044645_HT143 | SI0005 | 2025-12-31T14:18:31.448Z | 2026-01-07T15:09:00.507Z |
| 9102649 | 9102649 | 20251230032210_0lyyF | SI0005 | 2025-12-31T14:14:46.024Z | 2026-01-07T15:07:49.904Z |
| 9102538 | 9102538 | 20251230031146_VTun5 | SI0005 | 2025-12-31T14:14:21.912Z | 2026-01-07T15:07:43.595Z |
| 9102230 | 9102230 | 20251230023925_FkO7B | SI0005 | 2025-12-31T14:12:51.059Z | 2026-01-07T15:07:19.679Z |
| 9101688 | 9101688 | 20251230011643_xYArQ | SI0005 | 2025-12-31T14:09:58.764Z | 2026-01-07T15:06:41.432Z |
| 9101137 | 9101137 | 20251229225211_aeEWe | SI0005 | 2025-12-31T14:06:45.748Z | 2025-12-31T14:29:52.193Z |
| 9101098 | 9101098 | 20251229223532_Fa2J0 | SI0005 | 2025-12-31T14:06:33.357Z | 2026-01-07T15:05:53.336Z |
| 9100741 | 9100741 | 20251229210402_2C6Gm | SI0005 | 2025-12-31T14:04:29.422Z | 2025-12-31T14:29:50.366Z |
| 9099344 | 9099344 | 20251226205048_yODI2 | SI0005 | 2025-12-30T15:23:24.384Z | 2026-01-03T15:44:02.337Z |
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);