home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

131 rows where station_code = "RO000J" sorted by created_at descending

✎ View and edit SQL

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
9611270 9611270 20260405010754_8pLL6 RO000J 2026-04-06T12:13:42.520Z 2026-04-06T12:16:14.766Z
9610411 9610411 20260404182422_yhehC RO000J 2026-04-06T12:09:18.193Z 2026-04-06T12:16:14.545Z
9610407 9610407 20260404181319_ax5fT RO000J 2026-04-06T12:09:15.356Z 2026-04-06T12:16:14.542Z
9585318 9585318 20260326001317_ZniQB RO000J 2026-03-27T12:17:06.539Z 2026-04-03T12:39:54.685Z
9585261 9585261 20260326000357_Z7KHM RO000J 2026-03-27T12:17:01.823Z 2026-04-03T12:39:53.273Z
9584738 9584738 20260325215059_lJTn4 RO000J 2026-03-27T12:16:01.676Z 2026-04-03T12:39:31.914Z
9576230 9576230 20260325014305_yfHAi RO000J 2026-03-26T12:01:38.627Z 2026-04-03T12:35:49.355Z
9576134 9576134 20260325011951_IFZYr RO000J 2026-03-26T12:01:24.497Z 2026-04-03T12:35:45.812Z
9531536 9531536 20260314212441_V37rf RO000J 2026-03-20T12:34:40.460Z 2026-03-22T12:42:53.363Z
9531531 9531531 20260314204823_KnkSO RO000J 2026-03-20T12:34:35.334Z 2026-03-22T12:42:52.352Z
9531517 9531517 20260315013421_clpbc RO000J 2026-03-20T12:30:50.970Z 2026-03-23T12:21:48.150Z
9531507 9531507 20260314234840_10Hnv RO000J 2026-03-20T12:30:41.972Z 2026-03-23T12:21:45.325Z
9531504 9531504 20260314233608_l8fcd RO000J 2026-03-20T12:30:40.856Z 2026-03-23T12:21:44.821Z
9517268 9517268 20260317230054_qPZ7H RO000J 2026-03-19T12:27:23.992Z 2026-03-25T12:43:09.687Z
9517060 9517060 20260317223355_YJmXZ RO000J 2026-03-19T12:27:08.866Z 2026-03-25T12:43:08.378Z
9516725 9516725 20260317214421_FLUmf RO000J 2026-03-19T12:26:41.759Z 2026-03-25T12:43:06.329Z
9516529 9516529 20260317210554_aG2oT RO000J 2026-03-19T12:26:22.269Z 2026-03-25T12:43:01.333Z
9516494 9516494 20260317210014_ZSA9t RO000J 2026-03-19T12:26:17.275Z 2026-03-25T12:42:59.968Z
9516275 9516275 20260317202315_k5wjJ RO000J 2026-03-19T12:25:52.689Z 2026-03-25T12:42:52.954Z
9515668 9515668 20260317173534_5lqOs RO000J 2026-03-19T12:24:27.599Z 2026-03-25T12:42:34.404Z
9507389 9507389 20260316214857_hKM10 RO000J 2026-03-18T12:20:22.936Z 2026-03-24T12:41:46.980Z
9502161 9502161 20260317022052_7nO3M RO000J 2026-03-18T12:01:43.576Z 2026-03-25T12:41:47.017Z
9501588 9501588 20260315224610_Cnfuf RO000J 2026-03-17T12:25:15.947Z 2026-03-23T12:22:44.967Z
9501347 9501347 20260315220252_23pnp RO000J 2026-03-17T12:24:51.484Z 2026-03-23T12:22:44.028Z
9501159 9501159 20260315212141_1kzI5 RO000J 2026-03-17T12:24:33.123Z 2026-03-23T12:22:43.423Z
9500952 9500952 20260315201711_9HXQ2 RO000J 2026-03-17T12:24:12.837Z 2026-03-23T12:22:42.488Z
9500946 9500946 20260315200630_E1H6N RO000J 2026-03-17T12:24:12.092Z 2026-03-23T12:22:42.373Z
9500834 9500834 20260315194108_w8BXv RO000J 2026-03-17T12:23:57.929Z 2026-03-23T12:22:41.830Z
9494793 9494793 20260316030436_3oyNi RO000J 2026-03-17T12:04:59.130Z 2026-03-24T12:40:50.142Z
9494239 9494239 20260316014431_7ZdPa RO000J 2026-03-17T12:03:25.006Z 2026-03-24T12:40:46.119Z
9494015 9494015 20260316011151_nWhXx RO000J 2026-03-17T12:02:46.440Z 2026-03-24T12:40:43.960Z
9493947 9493947 20260316005940_j2p0o RO000J 2026-03-17T12:02:30.237Z 2026-03-24T12:40:43.366Z
9493721 9493721 20260316002611_8HTSt RO000J 2026-03-17T12:01:50.038Z 2026-03-24T12:40:41.519Z
9493313 9493313 20260315230630_k3Xur RO000J 2026-03-17T12:00:21.996Z 2026-03-24T12:40:38.578Z
9485539 9485539 20260315031819_No3H5 RO000J 2026-03-16T12:06:47.089Z 2026-03-23T12:21:52.770Z
9484940 9484940 20260315020217_3V2rt RO000J 2026-03-16T12:04:41.374Z 2026-03-23T12:21:49.081Z
9484453 9484453 20260315004222_nOdsv RO000J 2026-03-16T12:02:56.623Z 2026-03-23T12:21:46.888Z
9484433 9484433 20260315003909_Be3yn RO000J 2026-03-16T12:02:52.143Z 2026-03-23T12:21:46.767Z
9484424 9484424 20260315003827_J7G3b RO000J 2026-03-16T12:02:50.610Z 2026-03-23T12:21:46.697Z
9483935 9483935 20260314233053_AFij3 RO000J 2026-03-16T12:01:02.159Z 2026-03-23T12:21:44.504Z
9483250 9483250 20260313212315_z3fF9 RO000J 2026-03-15T12:26:09.838Z 2026-03-21T12:50:25.919Z
9482811 9482811 20260313185401_a3Myr RO000J 2026-03-15T12:25:12.109Z 2026-03-21T12:50:01.133Z
9475959 9475959 20260314022522_6Koo1 RO000J 2026-03-15T12:04:42.985Z 2026-03-22T12:41:53.331Z
9474308 9474308 20260312222834_jEwBq RO000J 2026-03-14T12:22:35.564Z 2026-03-20T12:37:17.722Z
9474288 9474288 20260312222150_RmQen RO000J 2026-03-14T12:22:29.336Z 2026-03-20T12:37:17.313Z
9474265 9474265 20260312220651_8BIMq RO000J 2026-03-14T12:22:25.646Z 2026-03-20T12:37:17.068Z
9474157 9474157 20260312211640_aS2Nl RO000J 2026-03-14T12:22:12.963Z 2026-03-20T12:37:16.418Z
9469482 9469482 20260313025610_BDwUQ RO000J 2026-03-14T12:04:25.684Z 2026-03-21T12:48:40.269Z
9469386 9469386 20260313024101_PGXH2 RO000J 2026-03-14T12:04:04.584Z 2026-03-21T12:48:38.333Z
9469204 9469204 20260313021325_zV393 RO000J 2026-03-14T12:03:25.455Z 2026-03-21T12:48:35.027Z
9468965 9468965 20260313012538_8Je1n RO000J 2026-03-14T12:02:29.611Z 2026-03-21T12:48:31.945Z
9468934 9468934 20260313011728_1ZFpY RO000J 2026-03-14T12:02:20.609Z 2026-03-21T12:48:31.613Z
9468772 9468772 20260313003544_TxGiI RO000J 2026-03-14T12:01:41.758Z 2026-03-21T12:48:28.916Z
9468740 9468740 20260313002926_P34bm RO000J 2026-03-14T12:01:34.810Z 2026-03-21T12:48:28.539Z
9468708 9468708 20260313002205_8RKBc RO000J 2026-03-14T12:01:28.213Z 2026-03-21T12:48:28.104Z
9468664 9468664 20260313000954_EA4xK RO000J 2026-03-14T12:01:15.620Z 2026-03-21T12:48:27.601Z
9467437 9467437 20260311214457_T7xjd RO000J 2026-03-13T12:19:14.637Z 2026-03-19T12:45:52.346Z
9467357 9467357 20260311212852_1rvkW RO000J 2026-03-13T12:19:07.301Z 2026-03-19T12:45:51.769Z
9467233 9467233 20260311205456_ISTeU RO000J 2026-03-13T12:18:47.388Z 2026-03-19T12:45:50.604Z
9467123 9467123 20260311201427_jKSNf RO000J 2026-03-13T12:18:26.733Z 2026-03-19T12:45:48.509Z
9466957 9466957 20260311190557_0xM8Y RO000J 2026-03-13T12:17:47.229Z 2026-03-19T12:45:45.137Z
9463737 9463737 20260312023624_aBuAp RO000J 2026-03-13T12:05:01.984Z 2026-03-20T12:36:24.455Z
9463696 9463696 20260312022814_3DivP RO000J 2026-03-13T12:04:53.813Z 2026-03-20T12:36:24.085Z
9462624 9462624 20260311234550_xY7s8 RO000J 2026-03-13T12:01:38.308Z 2026-03-20T12:36:17.141Z
9460689 9460689 20260310214038_P7dsM RO000J 2026-03-12T12:14:54.880Z 2026-03-18T12:40:17.944Z
9460685 9460685 20260310213854_Q7iiu RO000J 2026-03-12T12:14:54.223Z 2026-03-18T12:40:17.879Z
9460483 9460483 20260310195141_XoDeI RO000J 2026-03-12T12:14:15.959Z 2026-03-18T12:39:58.701Z
9460372 9460372 20260310184016_OaNH6 RO000J 2026-03-12T12:13:51.432Z 2026-03-18T12:39:54.807Z
9460357 9460357 20260310182724_d9PQz RO000J 2026-03-12T12:13:47.376Z 2026-03-18T12:39:53.668Z
9460329 9460329 20260310180132_4qjiT RO000J 2026-03-12T12:13:40.726Z 2026-03-18T12:39:51.534Z
9457266 9457266 20260311031910_3yzfE RO000J 2026-03-12T12:03:24.007Z 2026-03-19T12:44:35.869Z
9457218 9457218 20260311030541_9m2Ab RO000J 2026-03-12T12:03:12.696Z 2026-03-19T12:44:32.450Z
9457049 9457049 20260311022049_Vl8aO RO000J 2026-03-12T12:02:40.883Z 2026-03-19T12:44:25.105Z
9456960 9456960 20260311015346_42lN1 RO000J 2026-03-12T12:02:22.014Z 2026-03-19T12:44:24.110Z
9456915 9456915 20260311013912_2Krzw RO000J 2026-03-12T12:02:10.893Z 2026-03-19T12:44:23.583Z
9456876 9456876 20260311012946_nPkVr RO000J 2026-03-12T12:02:03.983Z 2026-03-19T12:44:23.050Z
9456706 9456706 20260311003041_POMiu RO000J 2026-03-12T12:01:31.151Z 2026-03-19T12:44:20.980Z
9456636 9456636 20260311001714_VyFAW RO000J 2026-03-12T12:01:18.931Z 2026-03-19T12:44:19.416Z
9456633 9456633 20260311001709_8mNmt RO000J 2026-03-12T12:01:18.521Z 2026-03-19T12:44:19.381Z
9456527 9456527 20260310234844_TGKHZ RO000J 2026-03-12T12:00:58.614Z 2026-03-19T12:44:18.024Z
9456445 9456445 20260310232309_mjFoR RO000J 2026-03-12T12:00:43.418Z 2026-03-19T12:44:17.176Z
9456406 9456406 20260310231621_3nrZ6 RO000J 2026-03-12T12:00:33.774Z 2026-03-19T12:44:16.710Z
9456298 9456298 20260310224348_fo8rt RO000J 2026-03-12T12:00:10.275Z 2026-03-19T12:44:15.384Z
9456277 9456277 20260309223649_QRFIp RO000J 2026-03-11T12:15:58.572Z 2026-03-17T12:43:02.520Z
9456187 9456187 20260309221049_ZSzKe RO000J 2026-03-11T12:15:47.956Z 2026-03-17T12:42:57.673Z
9456012 9456012 20260309212504_hsYvz RO000J 2026-03-11T12:15:25.605Z 2026-03-17T12:42:46.468Z
9455766 9455766 20260309200900_ByKNu RO000J 2026-03-11T12:14:59.505Z 2026-03-17T12:42:38.806Z
9455675 9455675 20260309193821_pG8VF RO000J 2026-03-11T12:14:45.865Z 2026-03-17T12:42:37.460Z
9455602 9455602 20260309191312_narbi RO000J 2026-03-11T12:14:39.564Z 2026-03-17T12:42:36.546Z
9455561 9455561 20260309184931_Ao8X2 RO000J 2026-03-11T12:14:34.024Z 2026-03-17T12:42:34.634Z
9451741 9451741 20260310033511_x2ujX RO000J 2026-03-11T12:03:42.579Z 2026-03-18T12:39:03.721Z
9451641 9451641 20260310031052_KMDa2 RO000J 2026-03-11T12:03:24.536Z 2026-03-18T12:39:01.950Z
9451638 9451638 20260310031052_FOJdC RO000J 2026-03-11T12:03:24.179Z 2026-03-18T12:39:01.936Z
9451544 9451544 20260310024312_DQ9VC RO000J 2026-03-11T12:03:07.848Z 2026-03-18T12:38:48.271Z
9451222 9451222 20260310011904_rhTcE RO000J 2026-03-11T12:02:09.195Z 2026-03-18T12:38:43.338Z
9451156 9451156 20260310005216_Cgi4x RO000J 2026-03-11T12:01:53.872Z 2026-03-18T12:38:41.281Z
9451076 9451076 20260310003731_K5G2w RO000J 2026-03-11T12:01:39.748Z 2026-03-18T12:38:40.158Z
9450886 9450886 20260309234201_0GY42 RO000J 2026-03-11T12:01:02.671Z 2026-03-18T12:38:37.403Z
9450873 9450873 20260309234055_YlDv6 RO000J 2026-03-11T12:01:00.403Z 2026-03-18T12:38:37.240Z
9450866 9450866 20260309233901_wl9aq RO000J 2026-03-11T12:00:58.761Z 2026-03-18T12:38:37.110Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network