participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,629 rows where station_code = "HR000J" 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 |
|---|---|---|---|---|---|
| 9613418 | 9613418 | 20260405201218_5CP8O | HR000J | 2026-04-07T12:06:41.074Z | 2026-04-07T12:13:19.380Z |
| 9613394 | 9613394 | 20260405195849_zGEBf | HR000J | 2026-04-07T12:06:37.561Z | 2026-04-07T12:13:19.373Z |
| 9613363 | 9613363 | 20260405194613_jpimL | HR000J | 2026-04-07T12:06:30.792Z | 2026-04-07T12:13:19.365Z |
| 9610841 | 9610841 | 20260404222313_Y5C9M | HR000J | 2026-04-06T12:11:36.029Z | 2026-04-07T12:15:36.160Z |
| 9610499 | 9610499 | 20260404195647_y2G9L | HR000J | 2026-04-06T12:09:46.130Z | 2026-04-07T12:15:12.668Z |
| 9608167 | 9608167 | 20260403202742_lCWR7 | HR000J | 2026-04-05T12:09:10.769Z | 2026-04-07T12:18:01.262Z |
| 9592876 | 9592876 | 20260329034433_uoyAI | HR000J | 2026-03-30T12:02:12.214Z | 2026-04-07T12:26:48.268Z |
| 9579862 | 9579862 | 20260324231102_q9Iye | HR000J | 2026-03-26T12:14:35.791Z | 2026-04-02T12:37:32.978Z |
| 9579764 | 9579764 | 20260324224818_d58K8 | HR000J | 2026-03-26T12:14:22.486Z | 2026-04-02T12:37:29.459Z |
| 9577095 | 9577095 | 20260325035419_0acFH | HR000J | 2026-03-26T12:04:07.032Z | 2026-04-03T12:36:34.288Z |
| 9577091 | 9577091 | 20260325035418_kd2zY | HR000J | 2026-03-26T12:04:06.743Z | 2026-04-03T12:36:34.211Z |
| 9576991 | 9576991 | 20260325033621_vA3yU | HR000J | 2026-03-26T12:03:50.881Z | 2026-04-03T12:36:28.414Z |
| 9576832 | 9576832 | 20260325031457_7WtNF | HR000J | 2026-03-26T12:03:26.307Z | 2026-04-03T12:36:22.877Z |
| 9576817 | 9576817 | 20260325031339_wq6hS | HR000J | 2026-03-26T12:03:23.493Z | 2026-04-03T12:36:22.196Z |
| 9576793 | 9576793 | 20260325030831_wtO9Z | HR000J | 2026-03-26T12:03:18.572Z | 2026-04-03T12:36:21.213Z |
| 9576583 | 9576583 | 20260325023623_82la1 | HR000J | 2026-03-26T12:02:41.045Z | 2026-04-03T12:36:13.350Z |
| 9576358 | 9576358 | 20260325015635_fQZtM | HR000J | 2026-03-26T12:02:01.199Z | 2026-04-03T12:35:54.423Z |
| 9576121 | 9576121 | 20260325011917_9mPeF | HR000J | 2026-03-26T12:01:22.630Z | 2026-04-03T12:35:45.267Z |
| 9575573 | 9575573 | 20260323232441_mJrU3 | HR000J | 2026-03-25T12:21:25.946Z | 2026-03-31T12:29:02.157Z |
| 9575486 | 9575486 | 20260323224919_cbHB8 | HR000J | 2026-03-25T12:21:15.334Z | 2026-03-31T12:29:00.091Z |
| 9575444 | 9575444 | 20260323221017_R54fj | HR000J | 2026-03-25T12:21:09.680Z | 2026-03-31T12:28:57.777Z |
| 9575349 | 9575349 | 20260323211705_W2aJK | HR000J | 2026-03-25T12:20:53.789Z | 2026-03-31T12:28:55.393Z |
| 9575302 | 9575302 | 20260323202807_TZ2Zt | HR000J | 2026-03-25T12:20:47.477Z | 2026-03-31T12:28:54.182Z |
| 9571484 | 9571484 | 20260324023033_7fS9J | HR000J | 2026-03-25T12:01:40.671Z | 2026-04-02T12:34:28.896Z |
| 9571438 | 9571438 | 20260324020702_fYXFg | HR000J | 2026-03-25T12:01:28.918Z | 2026-04-02T12:34:26.590Z |
| 9571323 | 9571323 | 20260324011351_9OaBy | HR000J | 2026-03-25T12:01:01.962Z | 2026-04-02T12:34:20.060Z |
| 9551917 | 9551917 | 20260320221346_R5EaR | HR000J | 2026-03-22T12:27:17.527Z | 2026-03-28T12:37:04.261Z |
| 9551858 | 9551858 | 20260320215925_u5PY3 | HR000J | 2026-03-22T12:27:07.369Z | 2026-03-28T12:37:03.193Z |
| 9542368 | 9542368 | 20260319231819_qEMqE | HR000J | 2026-03-21T12:29:59.980Z | 2026-03-27T12:43:00.357Z |
| 9541606 | 9541606 | 20260319210849_6SVEI | HR000J | 2026-03-21T12:29:12.765Z | 2026-03-27T12:42:39.215Z |
| 9541553 | 9541553 | 20260319210259_3iJgD | HR000J | 2026-03-21T12:29:10.154Z | 2026-03-27T12:42:38.691Z |
| 9532372 | 9532372 | 20260320004944_sIpG3 | HR000J | 2026-03-21T12:02:31.044Z | 2026-03-28T12:33:28.763Z |
| 9532368 | 9532368 | 20260320004943_QeAUM | HR000J | 2026-03-21T12:02:30.666Z | 2026-03-28T12:33:28.659Z |
| 9532258 | 9532258 | 20260320004134_NImmu | HR000J | 2026-03-21T12:02:12.652Z | 2026-03-28T12:33:26.514Z |
| 9518999 | 9518999 | 20260319014044_6yDNa | HR000J | 2026-03-20T12:03:43.999Z | 2026-03-27T12:40:17.069Z |
| 9501617 | 9501617 | 20260315225323_OzGT5 | HR000J | 2026-03-17T12:25:19.446Z | 2026-03-23T12:22:45.199Z |
| 9501139 | 9501139 | 20260315211436_ndm5r | HR000J | 2026-03-17T12:24:31.469Z | 2026-03-23T12:22:43.344Z |
| 9501012 | 9501012 | 20260315203709_2mF02 | HR000J | 2026-03-17T12:24:17.735Z | 2026-03-23T12:22:42.743Z |
| 9494876 | 9494876 | 20260316031741_T2e9U | HR000J | 2026-03-17T12:05:20.562Z | 2026-03-24T12:40:50.828Z |
| 9494738 | 9494738 | 20260316025124_KeCGm | HR000J | 2026-03-17T12:04:46.983Z | 2026-03-24T12:40:49.578Z |
| 9494736 | 9494736 | 20260316025122_uFQVk | HR000J | 2026-03-17T12:04:46.393Z | 2026-03-24T12:40:49.577Z |
| 9494630 | 9494630 | 20260316023755_fbHOk | HR000J | 2026-03-17T12:04:26.650Z | 2026-03-24T12:40:48.880Z |
| 9494603 | 9494603 | 20260316023447_4FCo4 | HR000J | 2026-03-17T12:04:20.699Z | 2026-03-24T12:40:48.646Z |
| 9494579 | 9494579 | 20260316022925_05SEw | HR000J | 2026-03-17T12:04:16.870Z | 2026-03-24T12:40:48.420Z |
| 9494471 | 9494471 | 20260316022130_H4Sfx | HR000J | 2026-03-17T12:04:02.661Z | 2026-03-24T12:40:47.749Z |
| 9493855 | 9493855 | 20260316004818_1jXPy | HR000J | 2026-03-17T12:02:15.811Z | 2026-03-24T12:40:42.562Z |
| 9483997 | 9483997 | 20260314233424_12jo2 | HR000J | 2026-03-16T12:01:11.056Z | 2026-03-23T12:21:44.758Z |
| 9483467 | 9483467 | 20260313221813_tfjpD | HR000J | 2026-03-15T12:26:33.857Z | 2026-03-21T12:50:27.894Z |
| 9483365 | 9483365 | 20260313215010_vAKq5 | HR000J | 2026-03-15T12:26:19.297Z | 2026-03-21T12:50:27.067Z |
| 9483347 | 9483347 | 20260313214739_9H2jg | HR000J | 2026-03-15T12:26:17.836Z | 2026-03-21T12:50:27.004Z |
| 9483239 | 9483239 | 20260313212029_UCFcO | HR000J | 2026-03-15T12:26:08.754Z | 2026-03-21T12:50:25.299Z |
| 9482807 | 9482807 | 20260313185214_GC7QY | HR000J | 2026-03-15T12:25:11.567Z | 2026-03-21T12:50:01.076Z |
| 9476898 | 9476898 | 20260314035410_U07sL | HR000J | 2026-03-15T12:07:10.726Z | 2026-03-22T12:42:00.041Z |
| 9476848 | 9476848 | 20260314034649_bSJeS | HR000J | 2026-03-15T12:07:02.465Z | 2026-03-22T12:41:59.699Z |
| 9476508 | 9476508 | 20260314031330_sUikQ | HR000J | 2026-03-15T12:06:13.102Z | 2026-03-22T12:41:57.333Z |
| 9475235 | 9475235 | 20260314010146_diH33 | HR000J | 2026-03-15T12:02:35.585Z | 2026-03-22T12:41:28.858Z |
| 9475142 | 9475142 | 20260314004556_RwhHS | HR000J | 2026-03-15T12:02:21.194Z | 2026-03-22T12:41:27.265Z |
| 9475046 | 9475046 | 20260314003055_D2lw2 | HR000J | 2026-03-15T12:02:05.201Z | 2026-03-22T12:41:26.512Z |
| 9474746 | 9474746 | 20260313234929_T3HdF | HR000J | 2026-03-15T12:01:13.614Z | 2026-03-22T12:41:23.852Z |
| 9469980 | 9469980 | 20260313041412_2XWj6 | HR000J | 2026-03-14T12:06:10.209Z | 2026-03-21T12:49:04.898Z |
| 9469893 | 9469893 | 20260313035814_Pc18A | HR000J | 2026-03-14T12:05:52.335Z | 2026-03-21T12:49:03.843Z |
| 9469744 | 9469744 | 20260313033751_3w3tw | HR000J | 2026-03-14T12:05:22.818Z | 2026-03-21T12:49:01.789Z |
| 9469391 | 9469391 | 20260313024153_HWfzB | HR000J | 2026-03-14T12:04:06.056Z | 2026-03-21T12:48:38.456Z |
| 9469311 | 9469311 | 20260313022842_23G7w | HR000J | 2026-03-14T12:03:48.555Z | 2026-03-21T12:48:37.326Z |
| 9468928 | 9468928 | 20260313011550_RZT4F | HR000J | 2026-03-14T12:02:19.681Z | 2026-03-21T12:48:31.566Z |
| 9468841 | 9468841 | 20260313005312_PK8Ny | HR000J | 2026-03-14T12:01:58.874Z | 2026-03-21T12:48:30.033Z |
| 9468729 | 9468729 | 20260313002831_3CxUr | HR000J | 2026-03-14T12:01:33.066Z | 2026-03-21T12:48:28.484Z |
| 9460816 | 9460816 | 20260310223325_YpaZg | HR000J | 2026-03-12T12:15:10.668Z | 2026-03-18T12:40:19.896Z |
| 9460745 | 9460745 | 20260310221016_khSsL | HR000J | 2026-03-12T12:15:01.896Z | 2026-03-18T12:40:18.876Z |
| 9460454 | 9460454 | 20260310193456_yuRzN | HR000J | 2026-03-12T12:14:10.455Z | 2026-03-18T12:39:57.856Z |
| 9457019 | 9457019 | 20260311021204_Bcns6 | HR000J | 2026-03-12T12:02:35.667Z | 2026-03-19T12:44:24.792Z |
| 9456741 | 9456741 | 20260311004327_zzBW6 | HR000J | 2026-03-12T12:01:39.008Z | 2026-03-19T12:44:21.402Z |
| 9456574 | 9456574 | 20260310235928_vAsww | HR000J | 2026-03-12T12:01:08.217Z | 2026-03-19T12:44:18.610Z |
| 9451011 | 9451011 | 20260310002047_cLo2u | HR000J | 2026-03-11T12:01:26.670Z | 2026-03-18T12:38:39.204Z |
| 9450818 | 9450818 | 20260309232142_oTD4N | HR000J | 2026-03-11T12:00:47.886Z | 2026-03-18T12:38:36.341Z |
| 9450266 | 9450266 | 20260308194323_GfizI | HR000J | 2026-03-10T12:19:05.420Z | 2026-03-16T12:44:38.944Z |
| 9445756 | 9445756 | 20260307213625_suU33 | HR000J | 2026-03-09T12:20:40.127Z | 2026-03-15T12:42:13.958Z |
| 9445746 | 9445746 | 20260307213358_953Lc | HR000J | 2026-03-09T12:20:36.360Z | 2026-03-15T12:42:13.857Z |
| 9445738 | 9445738 | 20260307212849_popT7 | HR000J | 2026-03-09T12:20:33.600Z | 2026-03-15T12:42:13.782Z |
| 9445436 | 9445436 | 20260307193154_242z2 | HR000J | 2026-03-09T12:19:08.239Z | 2026-03-15T12:42:08.705Z |
| 9441246 | 9441246 | 20260306203925_YZWkb | HR000J | 2026-03-08T12:21:04.343Z | 2026-03-14T12:40:48.647Z |
| 9402653 | 9402653 | 20260227041453_ezjOP | HR000J | 2026-02-28T14:05:30.392Z | 2026-03-07T14:46:56.003Z |
| 9402345 | 9402345 | 20260227033817_uAoX3 | HR000J | 2026-02-28T14:04:33.865Z | 2026-03-07T14:46:43.696Z |
| 9401849 | 9401849 | 20260227015302_ir2On | HR000J | 2026-02-28T14:02:28.187Z | 2026-03-07T14:46:11.047Z |
| 9401846 | 9401846 | 20260227015301_i2fRJ | HR000J | 2026-02-28T14:02:27.809Z | 2026-03-07T14:46:10.973Z |
| 9401636 | 9401636 | 20260227010309_IN1S1 | HR000J | 2026-02-28T14:01:36.231Z | 2026-03-07T14:45:55.340Z |
| 9401598 | 9401598 | 20260227005003_25wpn | HR000J | 2026-02-28T14:01:26.032Z | 2026-03-07T14:45:53.592Z |
| 9401593 | 9401593 | 20260227004958_ZK9QJ | HR000J | 2026-02-28T14:01:25.605Z | 2026-03-07T14:45:53.468Z |
| 9401214 | 9401214 | 20260225224105_pK2f7 | HR000J | 2026-02-27T14:16:39.622Z | 2026-03-05T14:39:10.036Z |
| 9401129 | 9401129 | 20260225221954_Jz2Ko | HR000J | 2026-02-27T14:16:27.975Z | 2026-03-05T14:39:07.167Z |
| 9400995 | 9400995 | 20260225214549_sZl53 | HR000J | 2026-02-27T14:16:11.008Z | 2026-03-05T14:39:03.449Z |
| 9400483 | 9400483 | 20260225175757_KnUOW | HR000J | 2026-02-27T14:14:34.404Z | 2026-03-05T14:38:24.687Z |
| 9396849 | 9396849 | 20260225233130_0kP2j | HR000J | 2026-02-27T14:00:31.554Z | 2026-03-06T14:42:46.592Z |
| 9396761 | 9396761 | 20260225231702_RXcDG | HR000J | 2026-02-27T14:00:10.056Z | 2026-03-06T14:42:43.623Z |
| 9391704 | 9391704 | 20260225030916_OEucO | HR000J | 2026-02-26T14:05:07.534Z | 2026-03-05T14:36:28.311Z |
| 9391475 | 9391475 | 20260225024314_Fzb2F | HR000J | 2026-02-26T14:04:24.683Z | 2026-03-05T14:36:21.498Z |
| 9390849 | 9390849 | 20260225012754_WHabB | HR000J | 2026-02-26T14:02:39.261Z | 2026-03-05T14:35:57.539Z |
| 9390435 | 9390435 | 20260225002916_DS1uL | HR000J | 2026-02-26T14:01:24.530Z | 2026-03-05T14:35:41.544Z |
| 9372183 | 9372183 | 20260221231830_2pooy | HR000J | 2026-02-23T14:26:17.708Z | 2026-03-02T14:22:31.055Z |
| 9372140 | 9372140 | 20260221225306_eIy8s | HR000J | 2026-02-23T14:26:08.531Z | 2026-03-02T14:22:28.127Z |
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);