participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,504 rows where station_code = "HR0004" 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 |
|---|---|---|---|---|---|
| 9611526 | 9611526 | 20260405023228_bicR5 | HR0004 | 2026-04-06T12:14:59.664Z | 2026-04-06T12:16:14.816Z |
| 9608601 | 9608601 | 20260403235519_2pxRt | HR0004 | 2026-04-05T12:10:54.094Z | 2026-04-06T12:20:24.900Z |
| 9608517 | 9608517 | 20260403233026_Krp2G | HR0004 | 2026-04-05T12:10:43.240Z | 2026-04-06T12:20:18.346Z |
| 9595240 | 9595240 | 20260330030813_E4vAs | HR0004 | 2026-03-31T12:00:52.159Z | 2026-04-06T12:29:49.599Z |
| 9576283 | 9576283 | 20260325014828_3odJJ | HR0004 | 2026-03-26T12:01:50.429Z | 2026-04-03T12:35:51.905Z |
| 9576052 | 9576052 | 20260325010752_ObnV1 | HR0004 | 2026-03-26T12:01:08.159Z | 2026-04-03T12:35:42.599Z |
| 9575373 | 9575373 | 20260323213213_fsytR | HR0004 | 2026-03-25T12:20:57.309Z | 2026-03-31T12:28:56.138Z |
| 9571707 | 9571707 | 20260324033913_HS3iD | HR0004 | 2026-03-25T12:02:26.498Z | 2026-04-02T12:34:40.420Z |
| 9571680 | 9571680 | 20260324033342_YypRP | HR0004 | 2026-03-25T12:02:19.611Z | 2026-04-02T12:34:38.940Z |
| 9571538 | 9571538 | 20260324024640_GK3T7 | HR0004 | 2026-03-25T12:01:51.496Z | 2026-04-02T12:34:31.105Z |
| 9571424 | 9571424 | 20260324015949_a7DLv | HR0004 | 2026-03-25T12:01:25.177Z | 2026-04-02T12:34:25.996Z |
| 9571373 | 9571373 | 20260324014103_4RYJD | HR0004 | 2026-03-25T12:01:13.747Z | 2026-04-02T12:34:23.442Z |
| 9570006 | 9570006 | 20260322185124_lnOSC | HR0004 | 2026-03-24T12:22:27.861Z | 2026-03-30T12:30:26.289Z |
| 9561830 | 9561830 | 20260323004923_XQFqu | HR0004 | 2026-03-24T12:01:25.552Z | 2026-03-31T12:25:54.642Z |
| 9552224 | 9552224 | 20260320232435_tlQQJ | HR0004 | 2026-03-22T12:27:33.796Z | 2026-03-28T12:37:08.045Z |
| 9551820 | 9551820 | 20260320214949_hB1Hj | HR0004 | 2026-03-22T12:27:05.052Z | 2026-03-28T12:37:02.589Z |
| 9551762 | 9551762 | 20260320212629_mLGbg | HR0004 | 2026-03-22T12:27:01.441Z | 2026-03-28T12:37:01.806Z |
| 9543098 | 9543098 | 20260321023706_NNDsw | HR0004 | 2026-03-22T12:02:40.109Z | 2026-03-29T12:19:02.954Z |
| 9542013 | 9542013 | 20260319222852_i4LOX | HR0004 | 2026-03-21T12:29:35.278Z | 2026-03-27T12:42:44.238Z |
| 9541424 | 9541424 | 20260319203333_cjiyz | HR0004 | 2026-03-21T12:28:55.543Z | 2026-03-27T12:42:37.489Z |
| 9532263 | 9532263 | 20260320004138_dFTX3 | HR0004 | 2026-03-21T12:02:14.127Z | 2026-03-28T12:33:26.743Z |
| 9531934 | 9531934 | 20260320000343_7Y2Em | HR0004 | 2026-03-21T12:01:14.501Z | 2026-03-28T12:33:22.951Z |
| 9531622 | 9531622 | 20260319232954_EQ2tm | HR0004 | 2026-03-21T12:00:22.299Z | 2026-03-28T12:33:19.287Z |
| 9531492 | 9531492 | 20260317213102_px3QK | HR0004 | 2026-03-20T12:28:03.634Z | 2026-03-25T12:43:05.531Z |
| 9531490 | 9531490 | 20260317212955_U6VDU | HR0004 | 2026-03-20T12:28:03.451Z | 2026-03-25T12:43:05.467Z |
| 9531485 | 9531485 | 20260317211242_fjtRj | HR0004 | 2026-03-20T12:28:01.304Z | 2026-03-25T12:43:02.012Z |
| 9501310 | 9501310 | 20260315215309_7tehG | HR0004 | 2026-03-17T12:24:48.967Z | 2026-03-23T12:22:43.895Z |
| 9501253 | 9501253 | 20260315214220_EJwaq | HR0004 | 2026-03-17T12:24:46.087Z | 2026-03-23T12:22:43.752Z |
| 9500859 | 9500859 | 20260315195004_esquR | HR0004 | 2026-03-17T12:24:01.141Z | 2026-03-23T12:22:42.108Z |
| 9494923 | 9494923 | 20260316033018_NhaOj | HR0004 | 2026-03-17T12:05:31.426Z | 2026-03-24T12:40:51.250Z |
| 9493914 | 9493914 | 20260316005624_ytvoV | HR0004 | 2026-03-17T12:02:25.251Z | 2026-03-24T12:40:43.118Z |
| 9493347 | 9493347 | 20260315231308_nIwXF | HR0004 | 2026-03-17T12:00:30.603Z | 2026-03-24T12:40:38.797Z |
| 9483208 | 9483208 | 20260313211102_jYpes | HR0004 | 2026-03-15T12:26:06.046Z | 2026-03-21T12:50:23.813Z |
| 9474986 | 9474986 | 20260314002354_qo1id | HR0004 | 2026-03-15T12:01:56.775Z | 2026-03-22T12:41:25.963Z |
| 9474981 | 9474981 | 20260314002354_Q9roM | HR0004 | 2026-03-15T12:01:56.348Z | 2026-03-22T12:41:25.955Z |
| 9474924 | 9474924 | 20260314001344_2Mrev | HR0004 | 2026-03-15T12:01:46.396Z | 2026-03-22T12:41:25.530Z |
| 9474405 | 9474405 | 20260313224936_O3AeK | HR0004 | 2026-03-15T12:00:09.777Z | 2026-03-22T12:41:20.222Z |
| 9462217 | 9462217 | 20260309023103_8dXGz | HR0004 | 2026-03-12T12:19:29.265Z | 2026-03-17T12:41:40.696Z |
| 9460317 | 9460317 | 20260310034628_2lH66 | HR0004 | 2026-03-12T12:11:25.102Z | 2026-03-18T12:39:04.248Z |
| 9445515 | 9445515 | 20260307201344_gcKZi | HR0004 | 2026-03-09T12:19:34.454Z | 2026-03-15T12:42:10.377Z |
| 9442285 | 9442285 | 20260308025512_bvpOD | HR0004 | 2026-03-09T12:03:24.270Z | 2026-03-16T12:43:49.091Z |
| 9442027 | 9442027 | 20260308010233_gnKX2 | HR0004 | 2026-03-09T12:02:19.250Z | 2026-03-16T12:43:35.776Z |
| 9442022 | 9442022 | 20260308010216_00SOC | HR0004 | 2026-03-09T12:02:17.974Z | 2026-03-16T12:43:35.541Z |
| 9441304 | 9441304 | 20260306210029_Iv0Gg | HR0004 | 2026-03-08T12:21:20.719Z | 2026-03-14T12:40:50.056Z |
| 9440902 | 9440902 | 20260306180649_WErEg | HR0004 | 2026-03-08T12:19:42.864Z | 2026-03-14T12:40:39.459Z |
| 9437083 | 9437083 | 20260307014716_BAgSj | HR0004 | 2026-03-08T12:02:32.581Z | 2026-03-15T12:41:01.866Z |
| 9437049 | 9437049 | 20260307013528_5NB5j | HR0004 | 2026-03-08T12:02:25.847Z | 2026-03-15T12:41:01.370Z |
| 9436710 | 9436710 | 20260306233218_7dsm7 | HR0004 | 2026-03-08T12:00:57.240Z | 2026-03-15T12:40:56.899Z |
| 9411946 | 9411946 | 20260227225844_sv33K | HR0004 | 2026-03-01T14:09:22.770Z | 2026-03-07T14:51:24.556Z |
| 9411874 | 9411874 | 20260227215625_2d2bc | HR0004 | 2026-03-01T14:09:13.904Z | 2026-03-07T14:51:20.539Z |
| 9407819 | 9407819 | 20260226210908_NvlP8 | HR0004 | 2026-02-28T14:22:33.629Z | 2026-03-06T14:45:20.291Z |
| 9402313 | 9402313 | 20260227033308_QCSG7 | HR0004 | 2026-02-28T14:04:26.438Z | 2026-03-07T14:46:39.319Z |
| 9402251 | 9402251 | 20260227032057_2II0d | HR0004 | 2026-02-28T14:04:11.507Z | 2026-03-07T14:46:36.523Z |
| 9402010 | 9402010 | 20260227022958_Cd7HM | HR0004 | 2026-02-28T14:03:11.517Z | 2026-03-07T14:46:19.433Z |
| 9401701 | 9401701 | 20260227011710_KCG32 | HR0004 | 2026-02-28T14:01:51.885Z | 2026-03-07T14:45:59.649Z |
| 9401075 | 9401075 | 20260225220840_ezHe3 | HR0004 | 2026-02-27T14:16:22.575Z | 2026-03-05T14:39:05.812Z |
| 9401021 | 9401021 | 20260225215059_agoYn | HR0004 | 2026-02-27T14:16:14.117Z | 2026-03-05T14:39:04.190Z |
| 9400652 | 9400652 | 20260225193416_kaG6m | HR0004 | 2026-02-27T14:15:18.422Z | 2026-03-05T14:38:41.259Z |
| 9398377 | 9398377 | 20260226033246_dB27E | HR0004 | 2026-02-27T14:05:10.608Z | 2026-03-06T14:43:41.915Z |
| 9396981 | 9396981 | 20260226000313_5plFU | HR0004 | 2026-02-27T14:00:57.571Z | 2026-03-06T14:42:51.695Z |
| 9396955 | 9396955 | 20260225235644_XAIl9 | HR0004 | 2026-02-27T14:00:52.068Z | 2026-03-06T14:42:50.700Z |
| 9392084 | 9392084 | 20260225034059_MIEFd | HR0004 | 2026-02-26T14:06:23.441Z | 2026-03-05T14:36:47.890Z |
| 9391757 | 9391757 | 20260225031228_d2V7F | HR0004 | 2026-02-26T14:05:16.452Z | 2026-03-05T14:36:30.114Z |
| 9391289 | 9391289 | 20260225022317_C3Xn2 | HR0004 | 2026-02-26T14:03:57.283Z | 2026-03-05T14:36:16.639Z |
| 9390789 | 9390789 | 20260225012046_1GeD3 | HR0004 | 2026-02-26T14:02:27.456Z | 2026-03-05T14:35:55.950Z |
| 9386305 | 9386305 | 20260223211015_1b08s | HR0004 | 2026-02-25T14:17:56.607Z | 2026-03-03T14:32:49.262Z |
| 9372180 | 9372180 | 20260221231724_fnaVt | HR0004 | 2026-02-23T14:26:17.367Z | 2026-03-02T14:22:29.875Z |
| 9371959 | 9371959 | 20260221203400_RytEt | HR0004 | 2026-02-23T14:25:44.116Z | 2026-03-02T14:22:18.925Z |
| 9371564 | 9371564 | 20260221184002_YJLGl | HR0004 | 2026-02-23T14:24:37.518Z | 2026-03-02T14:22:11.883Z |
| 9365263 | 9365263 | 20260222030109_hyuv7 | HR0004 | 2026-02-23T14:02:46.430Z | 2026-02-24T14:15:02.988Z |
| 9365079 | 9365079 | 20260222020433_BhrzM | HR0004 | 2026-02-23T14:01:58.087Z | 2026-02-24T14:14:49.429Z |
| 9364971 | 9364971 | 20260222013100_RGBgY | HR0004 | 2026-02-23T14:01:34.388Z | 2026-02-24T14:14:43.850Z |
| 9364767 | 9364767 | 20260222002659_HMb0r | HR0004 | 2026-02-23T14:00:36.215Z | 2026-02-24T14:14:33.307Z |
| 9364710 | 9364710 | 20260222000331_ybvhN | HR0004 | 2026-02-23T14:00:14.715Z | 2026-02-24T14:14:26.013Z |
| 9349384 | 9349384 | 20260218180359_grLpW | HR0004 | 2026-02-20T14:01:57.594Z | 2026-02-27T14:35:49.305Z |
| 8439450 | 8439450 | 20251112035028_6Fzxq | HR0004 | 2025-11-13T14:26:34.878Z | 2025-11-20T15:25:24.926Z |
| 8436977 | 8436977 | 20251111230031_NhQRB | HR0004 | 2025-11-13T14:19:45.943Z | 2025-11-20T15:23:06.262Z |
| 8436685 | 8436685 | 20251111222000_saGlB | HR0004 | 2025-11-13T14:18:54.559Z | 2025-11-20T15:22:59.168Z |
| 8436477 | 8436477 | 20251111214641_iN48c | HR0004 | 2025-11-13T14:18:17.578Z | 2025-11-20T15:22:51.580Z |
| 8436268 | 8436268 | 20251111210937_oyA2N | HR0004 | 2025-11-13T14:17:38.473Z | 2025-11-20T15:22:45.337Z |
| 8427474 | 8427474 | 20251111044447_Aztvl | HR0004 | 2025-11-12T14:28:12.012Z | 2025-11-19T15:17:54.183Z |
| 8426978 | 8426978 | 20251111035829_WN2F6 | HR0004 | 2025-11-12T14:26:46.115Z | 2025-11-12T14:39:51.350Z |
| 8426857 | 8426857 | 20251111034945_EFogs | HR0004 | 2025-11-12T14:26:30.535Z | 2025-11-19T15:17:28.659Z |
| 8426824 | 8426824 | 20251111034537_49wQU | HR0004 | 2025-11-12T14:26:26.839Z | 2025-11-19T15:17:27.742Z |
| 8426372 | 8426372 | 20251111025855_mfUQ3 | HR0004 | 2025-11-12T14:25:09.420Z | 2025-11-19T15:17:06.152Z |
| 8426087 | 8426087 | 20251111023356_2WvDZ | HR0004 | 2025-11-12T14:24:24.504Z | 2025-11-19T15:16:56.583Z |
| 8426048 | 8426048 | 20251111023119_4q2BU | HR0004 | 2025-11-12T14:24:21.580Z | 2025-11-19T15:16:56.075Z |
| 8424738 | 8424738 | 20251111004415_BkIcH | HR0004 | 2025-11-12T14:21:03.634Z | 2025-11-19T15:16:23.492Z |
| 8424329 | 8424329 | 20251111000835_lkAZL | HR0004 | 2025-11-12T14:19:54.300Z | 2025-11-19T15:16:10.905Z |
| 8423921 | 8423921 | 20251110233938_yEKkt | HR0004 | 2025-11-12T14:19:10.494Z | 2025-11-19T15:16:04.492Z |
| 8423665 | 8423665 | 20251110232627_PyG3C | HR0004 | 2025-11-12T14:18:55.295Z | 2025-11-19T15:15:58.742Z |
| 8423307 | 8423307 | 20251110230619_ar77Q | HR0004 | 2025-11-12T14:18:14.745Z | 2025-11-19T15:15:51.773Z |
| 8422604 | 8422604 | 20251110221423_dwzSK | HR0004 | 2025-11-12T14:16:48.254Z | 2025-11-19T15:15:29.799Z |
| 8422466 | 8422466 | 20251110220601_IT6gi | HR0004 | 2025-11-12T14:16:24.021Z | 2025-11-19T15:15:22.060Z |
| 8422408 | 8422408 | 20251110220022_RCGQx | HR0004 | 2025-11-12T14:16:16.300Z | 2025-11-19T15:15:20.971Z |
| 8421704 | 8421704 | 20251110210204_1THl4 | HR0004 | 2025-11-12T14:14:42.321Z | 2025-11-19T15:14:44.470Z |
| 8420950 | 8420950 | 20251110195134_x9T6n | HR0004 | 2025-11-12T14:12:31.236Z | 2025-11-19T15:14:18.038Z |
| 8420498 | 8420498 | 20251110191158_WCQRc | HR0004 | 2025-11-12T14:11:01.953Z | 2025-11-19T15:14:07.715Z |
| 8420426 | 8420426 | 20251110190617_o2I5h | HR0004 | 2025-11-12T14:10:48.382Z | 2025-11-19T15:14:00.302Z |
| 8419695 | 8419695 | 20251110172153_S3DWI | HR0004 | 2025-11-12T14:07:54.245Z | 2025-11-19T15:13:20.847Z |
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);