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

3,927 rows where station_code = "BE000J" 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
8039429 8039429 20251001232557_FuXXP BE000J 2025-10-03T12:32:55.361Z 2025-10-10T12:40:03.834Z
8038715 8038715 20251001215017_Z8bjA BE000J 2025-10-03T12:31:17.401Z 2025-10-10T12:39:52.318Z
8038624 8038624 20251001213249_YraW1 BE000J 2025-10-03T12:31:09.104Z 2025-10-10T12:39:50.894Z
8038579 8038579 20251001212607_iQsXo BE000J 2025-10-03T12:31:06.361Z 2025-10-10T12:39:50.291Z
8038190 8038190 20251001201140_Mq2CI BE000J 2025-10-03T12:29:15.415Z 2025-10-10T12:39:43.452Z
8026995 8026995 20250930214109_Py3n2 BE000J 2025-10-02T12:22:27.483Z 2025-10-09T12:38:08.802Z
8026970 8026970 20250930213801_Lv07i BE000J 2025-10-02T12:22:23.537Z 2025-10-09T12:38:08.217Z
8026456 8026456 20250930203857_pgYQ0 BE000J 2025-10-02T12:20:43.982Z 2025-10-09T12:37:48.712Z
8026402 8026402 20250930203100_5iR1C BE000J 2025-10-02T12:20:29.527Z 2025-10-09T12:37:47.852Z
8026007 8026007 20250930193911_GwUsj BE000J 2025-10-02T12:19:12.089Z 2025-10-09T12:37:17.324Z
8025984 8025984 20250930193716_pjrHx BE000J 2025-10-02T12:19:09.420Z 2025-10-09T12:37:16.735Z
8025628 8025628 20250930183101_OhVXD BE000J 2025-10-02T12:17:48.080Z 2025-10-09T12:36:55.271Z
8018261 8018261 20250929035431_qBbLX BE000J 2025-10-01T12:38:32.950Z 2025-10-07T13:01:24.755Z
8010327 8010327 20250929034929_Uk782 BE000J 2025-09-30T12:32:36.636Z 2025-10-07T13:01:24.388Z
8010279 8010279 20250929034736_WFdUW BE000J 2025-09-30T12:32:34.592Z 2025-10-07T13:01:24.096Z
8008971 8008971 20250929030154_v2Xbk BE000J 2025-09-30T12:30:43.595Z 2025-10-07T13:01:16.134Z
8006897 8006897 20250929014339_k0p3G BE000J 2025-09-30T12:27:41.913Z 2025-10-07T13:01:01.499Z
8004288 8004288 20250928234053_dgBf9 BE000J 2025-09-30T12:22:23.318Z 2025-10-07T13:00:46.197Z
8004242 8004242 20250928233830_4io9J BE000J 2025-09-30T12:22:08.621Z 2025-10-07T13:00:45.885Z
8004005 8004005 20250928232718_NdrAl BE000J 2025-09-30T12:21:46.394Z 2025-10-07T13:00:44.750Z
8003798 8003798 20250928231422_yW0su BE000J 2025-09-30T12:21:10.243Z 2025-10-07T13:00:42.799Z
8003592 8003592 20250928230138_Mhxn2 BE000J 2025-09-30T12:20:44.071Z 2025-10-07T13:00:41.082Z
8002216 8002216 20250928213035_vuh2r BE000J 2025-09-30T12:17:24.103Z 2025-10-07T13:00:30.401Z
8002133 8002133 20250928212503_M1EOS BE000J 2025-09-30T12:17:13.074Z 2025-10-07T13:00:29.416Z
8001829 8001829 20250928210400_wyBDJ BE000J 2025-09-30T12:16:30.073Z 2025-10-07T13:00:26.057Z
8000563 8000563 20250928190310_Oe64y BE000J 2025-09-30T12:12:56.763Z 2025-10-07T13:00:03.008Z
8000451 8000451 20250928184719_ynWEo BE000J 2025-09-30T12:12:28.883Z 2025-10-07T12:59:58.573Z
7997612 7997612 20250928043753_xOBdB BE000J 2025-09-29T12:28:44.693Z 2025-10-05T13:07:55.847Z
7997469 7997469 20250928040952_sixMh BE000J 2025-09-29T12:28:20.846Z 2025-10-05T13:07:53.951Z
7997416 7997416 20250928040217_pmiQQ BE000J 2025-09-29T12:28:06.376Z 2025-10-05T13:07:52.831Z
7996551 7996551 20250928023813_taBqu BE000J 2025-09-29T12:26:27.844Z 2025-10-05T13:07:39.043Z
7995927 7995927 20250928014559_lm3DE BE000J 2025-09-29T12:25:10.448Z 2025-10-05T13:07:26.076Z
7995920 7995920 20250928014517_tGxnb BE000J 2025-09-29T12:25:10.215Z 2025-10-05T13:07:26.075Z
7995651 7995651 20250928011555_Gp3Y0 BE000J 2025-09-29T12:24:26.427Z 2025-10-05T13:07:19.702Z
7995475 7995475 20250928010015_9CkuN BE000J 2025-09-29T12:23:51.271Z 2025-10-05T13:07:16.352Z
7995304 7995304 20250928004225_QgxVT BE000J 2025-09-29T12:23:34.697Z 2025-10-05T13:07:13.133Z
7994549 7994549 20250927230616_r31ts BE000J 2025-09-29T12:21:37.551Z 2025-10-05T13:06:57.683Z
7993927 7993927 20250927213528_jRtf6 BE000J 2025-09-29T12:19:50.733Z 2025-10-05T13:06:46.116Z
7993822 7993822 20250927211953_dIQpc BE000J 2025-09-29T12:19:27.158Z 2025-10-05T13:06:43.548Z
7993755 7993755 20250927210724_3W3xp BE000J 2025-09-29T12:19:17.077Z 2025-10-05T13:06:41.828Z
7993650 7993650 20250927205521_3ICfb BE000J 2025-09-29T12:19:04.024Z 2025-10-05T13:06:33.859Z
7993543 7993543 20250927203647_T9PzF BE000J 2025-09-29T12:18:37.194Z 2025-10-05T13:06:28.941Z
7993245 7993245 20250927193615_kPDEb BE000J 2025-09-29T12:17:50.046Z 2025-10-05T13:06:20.622Z
7985571 7985571 20250927033629_36JNb BE000J 2025-09-28T12:26:37.651Z 2025-10-05T13:11:17.198Z
7985456 7985456 20250927032324_EHlUw BE000J 2025-09-28T12:26:14.135Z 2025-10-05T13:11:16.341Z
7984799 7984799 20250927022410_j984i BE000J 2025-09-28T12:25:07.048Z 2025-10-05T13:10:59.479Z
7984769 7984769 20250927022013_jUoYJ BE000J 2025-09-28T12:25:04.853Z 2025-10-05T13:10:59.147Z
7984716 7984716 20250927021337_K3NPl BE000J 2025-09-28T12:24:54.433Z 2025-10-05T13:10:57.126Z
7984139 7984139 20250927005030_ErreZ BE000J 2025-09-28T12:23:39.204Z 2025-10-05T13:10:46.779Z
7983955 7983955 20250927002027_L5kzi BE000J 2025-09-28T12:23:08.416Z 2025-10-05T13:10:44.112Z
7962362 7962362 20250925021858_zU2lB BE000J 2025-09-26T12:27:15.029Z 2025-10-03T13:04:19.454Z
7961946 7961946 20250925015445_UTUX0 BE000J 2025-09-26T12:26:41.177Z 2025-10-03T13:04:18.050Z
7950560 7950560 20250924025343_fkNP3 BE000J 2025-09-25T12:35:20.049Z 2025-10-02T13:27:57.797Z
7948233 7948233 20250924004940_rw4uV BE000J 2025-09-25T12:31:41.950Z 2025-10-02T13:27:00.182Z
7947476 7947476 20250924001007_KP8HP BE000J 2025-09-25T12:30:42.662Z 2025-10-02T13:26:51.211Z
7947352 7947352 20250924000609_1wf7e BE000J 2025-09-25T12:30:36.736Z 2025-10-02T13:26:50.434Z
7946637 7946637 20250923231900_eBzKU BE000J 2025-09-25T12:29:13.244Z 2025-10-02T13:26:41.767Z
7946118 7946118 20250923225201_rpY9G BE000J 2025-09-25T12:28:22.627Z 2025-10-02T13:26:36.950Z
7944509 7944509 20250923205943_9K2i3 BE000J 2025-09-25T12:25:24.251Z 2025-10-02T13:26:26.543Z
7943795 7943795 20250923201409_doaA2 BE000J 2025-09-25T12:23:44.489Z 2025-10-02T13:26:20.676Z
7943480 7943480 20250923194840_LYSiY BE000J 2025-09-25T12:22:57.355Z 2025-10-02T13:26:15.570Z
7938116 7938116 20250924042409_Gm1JY BE000J 2025-09-25T12:02:34.975Z 2025-10-03T13:02:33.612Z
7928940 7928940 20250921202555_aD9q9 BE000J 2025-09-24T12:46:47.124Z 2025-09-30T13:02:17.078Z
7927955 7927955 20250921191414_JYheR BE000J 2025-09-24T12:45:23.042Z 2025-09-30T13:02:09.137Z
7909106 7909106 20250919225654_2fO2x BE000J 2025-09-23T12:05:30.189Z 2025-09-28T12:54:36.685Z
7895526 7895526 20250919235316_7VZbc BE000J 2025-09-21T12:38:48.711Z 2025-09-28T12:54:41.623Z
7894903 7894903 20250919231007_a5Y1b BE000J 2025-09-21T12:37:50.504Z 2025-09-28T12:54:37.941Z
7894440 7894440 20250919223537_LmTp0 BE000J 2025-09-21T12:37:12.086Z 2025-09-28T12:54:35.089Z
7894265 7894265 20250919222555_IVql2 BE000J 2025-09-21T12:36:54.477Z 2025-09-28T12:54:34.532Z
7894065 7894065 20250919221411_wAP3y BE000J 2025-09-21T12:36:26.383Z 2025-09-28T12:54:32.959Z
7893967 7893967 20250919220442_iQKy2 BE000J 2025-09-21T12:36:17.965Z 2025-09-28T12:54:32.482Z
7893508 7893508 20250919212940_8GqDk BE000J 2025-09-21T12:35:25.384Z 2025-09-28T12:54:27.856Z
7893316 7893316 20250919211800_FnmYl BE000J 2025-09-21T12:35:13.546Z 2025-09-28T12:54:27.154Z
7893144 7893144 20250919210111_dFCEV BE000J 2025-09-21T12:35:05.133Z 2025-09-28T12:54:22.440Z
7892968 7892968 20250919204444_jjtNw BE000J 2025-09-21T12:34:47.649Z 2025-09-28T12:54:21.425Z
7892886 7892886 20250919203900_PybT9 BE000J 2025-09-21T12:34:30.677Z 2025-09-28T12:54:20.776Z
7892785 7892785 20250919203119_rwMWW BE000J 2025-09-21T12:34:25.374Z 2025-09-28T12:54:19.998Z
7892674 7892674 20250919202059_gZJ2l BE000J 2025-09-21T12:34:17.438Z 2025-09-28T12:54:19.344Z
7892636 7892636 20250919201621_Yytxh BE000J 2025-09-21T12:34:15.129Z 2025-09-28T12:54:19.287Z
7892619 7892619 20250919201446_iG2Ju BE000J 2025-09-21T12:34:13.784Z 2025-09-28T12:54:18.899Z
7892295 7892295 20250919194732_u3oMp BE000J 2025-09-21T12:33:36.516Z 2025-09-28T12:54:17.832Z
7881735 7881735 20250918231053_hw3Eh BE000J 2025-09-20T12:35:17.993Z 2025-09-27T12:47:45.126Z
7881060 7881060 20250918221825_U9Jrz BE000J 2025-09-20T12:34:09.185Z 2025-09-27T12:47:40.540Z
7881014 7881014 20250918221502_1viYT BE000J 2025-09-20T12:34:04.870Z 2025-09-21T12:48:34.995Z
7864055 7864055 20250916232758_lXvP2 BE000J 2025-09-18T12:35:58.203Z 2025-09-24T13:17:45.736Z
7863707 7863707 20250916223105_53d1I BE000J 2025-09-18T12:35:15.317Z 2025-09-24T13:17:40.290Z
7863662 7863662 20250916222504_k7UDL BE000J 2025-09-18T12:35:11.979Z 2025-09-24T13:17:39.555Z
7863210 7863210 20250916211553_Fj7pG BE000J 2025-09-18T12:34:25.154Z 2025-09-24T13:17:36.612Z
7855212 7855212 20250915211444_ThJod BE000J 2025-09-17T12:36:12.633Z 2025-09-22T13:05:48.643Z
7845000 7845000 20250916011414_gqptY BE000J 2025-09-17T12:05:27.584Z 2025-09-24T13:15:33.899Z
7844993 7844993 20250916011348_7EXCd BE000J 2025-09-17T12:05:27.052Z 2025-09-24T13:15:33.894Z
7844908 7844908 20250916010546_wNY9F BE000J 2025-09-17T12:05:08.730Z 2025-09-24T13:15:32.885Z
7844836 7844836 20250916005510_L8plg BE000J 2025-09-17T12:04:52.813Z 2025-09-24T13:15:32.405Z
7844711 7844711 20250916004052_dHBMb BE000J 2025-09-17T12:04:17.779Z 2025-09-24T13:15:23.729Z
7818270 7818270 20250911195118_tHVW2 BE000J 2025-09-13T12:32:29.250Z 2025-09-19T12:58:16.332Z
7813223 7813223 20250912033721_s3CEo BE000J 2025-09-13T12:15:17.513Z 2025-09-20T13:02:06.808Z
7812019 7812019 20250912021043_4U3Fc BE000J 2025-09-13T12:11:39.690Z 2025-09-20T13:01:51.209Z
7811498 7811498 20250912012538_gvEIz BE000J 2025-09-13T12:09:52.501Z 2025-09-20T13:01:40.949Z
7811404 7811404 20250912011811_YSdMW BE000J 2025-09-13T12:09:34.994Z 2025-09-20T13:01:38.940Z
7811328 7811328 20250912011338_DULm1 BE000J 2025-09-13T12:09:20.552Z 2025-09-20T13:01:38.252Z

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