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

5,576 rows where station_code = "BE000A" 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
9260518 9260518 20260125050348_8vGX2 BE000A 2026-01-26T14:22:04.069Z 2026-01-29T14:44:19.780Z
9260361 9260361 20260125035900_72dow BE000A 2026-01-26T14:21:24.289Z 2026-01-29T14:44:08.095Z
9260303 9260303 20260125033051_MRYXq BE000A 2026-01-26T14:21:07.353Z 2026-01-29T14:44:04.740Z
9259995 9259995 20260125015045_2f976 BE000A 2026-01-26T14:19:43.514Z 2026-01-29T14:43:40.107Z
9259898 9259898 20260125010538_DxENJ BE000A 2026-01-26T14:19:13.706Z 2026-01-29T14:43:34.169Z
9259797 9259797 20260125002335_nlUv4 BE000A 2026-01-26T14:18:38.083Z 2026-01-29T14:43:22.103Z
9259767 9259767 20260125000202_0Omg0 BE000A 2026-01-26T14:18:31.579Z 2026-01-29T14:43:18.101Z
9259624 9259624 20260124222252_sD9tV BE000A 2026-01-26T14:17:44.590Z 2026-01-29T14:43:09.631Z
9259597 9259597 20260124215243_0lfd3 BE000A 2026-01-26T14:17:33.870Z 2026-01-29T14:43:08.105Z
9256027 9256027 20260124054541_s3nth BE000A 2026-01-25T14:15:36.405Z 2026-01-29T14:48:19.061Z
9255991 9255991 20260124053613_JvGhj BE000A 2026-01-25T14:15:29.813Z 2026-01-29T14:48:17.025Z
9255792 9255792 20260124045709_Apw8r BE000A 2026-01-25T14:14:45.122Z 2026-01-29T14:47:58.294Z
9255627 9255627 20260124042240_OAv2G BE000A 2026-01-25T14:14:08.478Z 2026-01-29T14:47:48.387Z
9255492 9255492 20260124035105_fDLtJ BE000A 2026-01-25T14:13:37.806Z 2026-01-29T14:47:34.146Z
9252782 9252782 20260123062140_q9tdJ BE000A 2026-01-24T14:17:07.834Z 2026-01-29T14:53:24.742Z
9252709 9252709 20260123053336_PCvC3 BE000A 2026-01-24T14:16:52.853Z 2026-01-29T14:53:17.849Z
9252585 9252585 20260123043026_m732v BE000A 2026-01-24T14:16:18.765Z 2026-01-29T14:53:10.070Z
9252289 9252289 20260123020411_QhAPF BE000A 2026-01-24T14:14:57.746Z 2026-01-29T14:52:43.754Z
9249254 9249254 20260122042534_L34Qj BE000A 2026-01-23T14:15:03.717Z 2026-01-29T14:58:19.954Z
9248343 9248343 20260121230345_jJqKh BE000A 2026-01-23T14:12:33.434Z 2026-01-29T14:57:14.829Z
9248327 9248327 20260121225618_fNAG8 BE000A 2026-01-23T14:12:31.290Z 2026-01-29T14:57:13.981Z
9248296 9248296 20260121224851_D9Jyi BE000A 2026-01-23T14:12:25.963Z 2026-01-29T14:57:12.817Z
9248275 9248275 20260121224613_fuXTY BE000A 2026-01-23T14:12:23.924Z 2026-01-29T14:57:11.610Z
9248245 9248245 20260121222955_qUeP2 BE000A 2026-01-23T14:12:19.228Z 2026-01-29T14:57:09.892Z
9237867 9237867 20260120061608_2QtAs BE000A 2026-01-21T14:27:48.707Z 2026-01-28T15:01:46.025Z
9237826 9237826 20260120060954_djfcV BE000A 2026-01-21T14:27:44.372Z 2026-01-28T15:01:43.897Z
9237688 9237688 20260120055002_43IA7 BE000A 2026-01-21T14:27:18.676Z 2026-01-28T15:01:36.242Z
9237204 9237204 20260120045034_VqYrW BE000A 2026-01-21T14:25:40.420Z 2026-01-28T15:01:02.776Z
9237073 9237073 20260120043415_YHKXS BE000A 2026-01-21T14:25:13.424Z 2026-01-28T15:00:56.981Z
9236654 9236654 20260120034451_YgkQV BE000A 2026-01-21T14:23:37.881Z 2026-01-28T15:00:27.904Z
9235451 9235451 20260120011454_0yYjd BE000A 2026-01-21T14:18:57.031Z 2026-01-28T14:58:56.056Z
9234612 9234612 20260119223709_kslt4 BE000A 2026-01-21T14:15:27.952Z 2026-01-28T14:57:56.687Z
9234481 9234481 20260119214928_u70gQ BE000A 2026-01-21T14:14:40.588Z 2026-01-28T14:57:49.606Z
9229653 9229653 20260119021223_NfoDI BE000A 2026-01-20T14:23:35.202Z 2026-01-27T15:03:47.151Z
9229441 9229441 20260119014701_L0JFG BE000A 2026-01-20T14:22:37.501Z 2026-01-27T15:03:26.328Z
9229310 9229310 20260119012950_QGKpU BE000A 2026-01-20T14:21:56.888Z 2026-01-27T15:03:16.989Z
9229286 9229286 20260119012231_rP1Hu BE000A 2026-01-20T14:21:50.078Z 2026-01-27T15:03:15.362Z
9229058 9229058 20260119004112_z7Svp BE000A 2026-01-20T14:20:46.514Z 2026-01-27T15:02:51.985Z
9228835 9228835 20260119000303_sb9Xi BE000A 2026-01-20T14:19:45.394Z 2026-01-27T15:02:38.443Z
9228442 9228442 20260118222346_x6Ydi BE000A 2026-01-20T14:17:51.220Z 2026-01-27T15:02:01.617Z
9228390 9228390 20260118220523_ramFw BE000A 2026-01-20T14:17:33.784Z 2026-01-27T15:01:58.368Z
9228346 9228346 20260118214702_6JGjq BE000A 2026-01-20T14:17:22.343Z 2026-01-27T15:01:55.219Z
9224387 9224387 20260118043213_UD5ge BE000A 2026-01-19T14:24:09.811Z 2026-01-26T15:03:16.694Z
9223259 9223259 20260117235956_s3pGB BE000A 2026-01-19T14:18:25.547Z 2026-01-26T15:02:00.082Z
9223156 9223156 20260117233005_QCW2V BE000A 2026-01-19T14:17:57.252Z 2026-01-26T15:01:55.940Z
9222742 9222742 20260117203633_Ym5WM BE000A 2026-01-19T14:16:05.200Z 2026-01-26T15:01:19.319Z
9222353 9222353 20260117191447_MsBut BE000A 2026-01-19T14:14:28.042Z 2026-01-26T15:00:51.033Z
9213369 9213369 20260116031839_33ctC BE000A 2026-01-17T14:16:38.960Z 2026-01-24T15:12:11.035Z
9207696 9207696 20260115024844_feE5n BE000A 2026-01-16T14:09:43.533Z 2026-01-22T15:03:30.300Z
9195397 9195397 20260113011849_6SBXJ BE000A 2026-01-14T14:13:10.461Z 2026-01-21T15:04:39.975Z
9195347 9195347 20260113011021_vdour BE000A 2026-01-14T14:13:01.308Z 2026-01-21T15:04:39.362Z
9171627 9171627 20260109000117_y1QyD BE000A 2026-01-10T14:08:32.281Z 2026-01-17T15:24:11.451Z
9167556 9167556 20260108025106_uOg2m BE000A 2026-01-09T14:08:12.172Z 2026-01-16T15:11:26.508Z
9167329 9167329 20260108002924_sxFKg BE000A 2026-01-09T14:07:14.201Z 2026-01-16T15:11:04.301Z
9150894 9150894 20260105035505_ZLDEe BE000A 2026-01-06T14:11:49.979Z 2026-01-13T15:14:06.499Z
9150707 9150707 20260105031631_AQAFb BE000A 2026-01-06T14:11:07.281Z 2026-01-13T15:13:50.177Z
9150675 9150675 20260105030609_y3EeR BE000A 2026-01-06T14:10:56.803Z 2026-01-13T15:13:48.387Z
9149391 9149391 20260104203807_1Cr2m BE000A 2026-01-06T14:05:15.889Z 2026-01-13T15:12:08.259Z
9149360 9149360 20260104202125_sB7Yq BE000A 2026-01-06T14:05:08.057Z 2026-01-13T15:12:06.462Z
9149300 9149300 20260104200145_lDJRb BE000A 2026-01-06T14:04:53.296Z 2026-01-13T15:11:56.083Z
9136477 9136477 20260103195659_hIVPj BE000A 2026-01-05T14:06:45.524Z 2026-01-12T15:01:20.612Z
9134892 9134892 20260103182904_iEMve BE000A 2026-01-05T14:03:11.292Z 2026-01-12T14:59:54.451Z
9129560 9129560 20260102231259_JLeZU BE000A 2026-01-04T14:04:48.157Z 2026-01-10T14:57:53.804Z
9129283 9129283 20260102205642_bDLt1 BE000A 2026-01-04T14:03:07.014Z 2026-01-10T14:57:27.824Z
9123425 9123425 20251231004806_EriBZ BE000A 2026-01-02T14:27:38.108Z 2026-01-08T15:06:20.613Z
9123362 9123362 20251230235219_rAJkX BE000A 2026-01-02T14:25:34.714Z 2026-01-08T15:05:46.374Z
9116132 9116132 20251231055138_vsUab BE000A 2026-01-01T14:27:20.408Z 2026-01-01T14:57:54.657Z
9114964 9114964 20251231043734_HYGCn BE000A 2026-01-01T14:23:54.835Z 2026-01-08T15:10:16.694Z
9114356 9114356 20251231041408_Xt4rm BE000A 2026-01-01T14:22:18.045Z 2026-01-08T15:09:43.881Z
9114115 9114115 20251231040240_rVVhE BE000A 2026-01-01T14:21:26.889Z 2026-01-08T15:09:25.337Z
9112037 9112037 20251231015859_Tug3Q BE000A 2026-01-01T14:13:42.031Z 2026-01-08T15:07:15.111Z
9111707 9111707 20251231013652_oB520 BE000A 2026-01-01T14:12:32.772Z 2026-01-08T15:06:53.419Z
9111193 9111193 20251231004806_BWXA8 BE000A 2026-01-01T14:10:27.210Z 2026-01-08T15:06:20.470Z
9110711 9110711 20251230235219_28aJK BE000A 2026-01-01T14:08:31.663Z 2026-01-08T15:05:46.671Z
9109420 9109420 20251230193439_Bgud0 BE000A 2026-01-01T14:00:23.356Z 2026-01-08T15:03:48.135Z
9104734 9104734 20251230062954_43eXL BE000A 2025-12-31T14:22:12.520Z 2026-01-07T15:10:04.021Z
9104386 9104386 20251230054954_5i2hU BE000A 2025-12-31T14:21:05.350Z 2026-01-07T15:09:40.994Z
9104379 9104379 20251230054952_9fcvu BE000A 2025-12-31T14:21:04.683Z 2026-01-07T15:09:40.730Z
9104186 9104186 20251230053551_FFrjx BE000A 2025-12-31T14:20:35.084Z 2026-01-07T15:09:34.114Z
9103825 9103825 20251230050641_RNeNY BE000A 2025-12-31T14:19:24.921Z 2026-01-07T15:09:10.904Z
9103204 9103204 20251230040653_FeFBx BE000A 2025-12-31T14:16:54.043Z 2026-01-07T15:08:31.973Z
9102902 9102902 20251230034217_Un9wW BE000A 2025-12-31T14:15:45.838Z 2026-01-07T15:08:10.777Z
9102237 9102237 20251230024020_jp32k BE000A 2025-12-31T14:12:53.658Z 2026-01-07T15:07:20.278Z
9099112 9099112 20251226172305_q6ctr BE000A 2025-12-30T15:22:25.484Z 2026-01-03T15:42:16.349Z
9075165 9075165 20251225211304_U8Ss8 BE000A 2025-12-29T15:01:31.355Z 2026-01-02T15:48:45.708Z
9074340 9074340 20251225194421_23lDy BE000A 2025-12-29T15:00:47.847Z 2026-01-02T15:48:29.706Z
9073895 9073895 20251225183955_TzI7x BE000A 2025-12-29T14:59:57.402Z 2026-01-02T15:48:00.245Z
9072078 9072078 20251226201709_OYDJ0 BE000A 2025-12-29T14:50:22.052Z 2026-01-03T15:43:41.019Z
9066437 9066437 20251226061702_mPqln BE000A 2025-12-29T14:40:00.031Z 2026-01-03T15:37:50.180Z
9066036 9066036 20251226054506_qqsxJ BE000A 2025-12-29T14:39:19.017Z 2026-01-03T15:37:29.476Z
9065937 9065937 20251226054054_2XyBH BE000A 2025-12-29T14:39:12.715Z 2026-01-03T15:37:25.377Z
9065833 9065833 20251226053431_iw825 BE000A 2025-12-29T14:39:06.520Z 2026-01-03T15:37:20.884Z
9065483 9065483 20251226051353_yHo5K BE000A 2025-12-29T14:38:35.703Z 2026-01-03T15:36:56.498Z
9064786 9064786 20251226043247_C4iyo BE000A 2025-12-29T14:37:26.979Z 2026-01-03T15:36:24.545Z
9064382 9064382 20251226040743_OL34P BE000A 2025-12-29T14:36:49.094Z 2026-01-03T15:36:11.875Z
9064329 9064329 20251226040351_5SV9U BE000A 2025-12-29T14:36:45.879Z 2026-01-03T15:35:58.814Z
9063874 9063874 20251226033624_loWTH BE000A 2025-12-29T14:36:00.650Z 2026-01-03T15:35:41.510Z
9063657 9063657 20251226032630_3DUIr BE000A 2025-12-29T14:35:37.642Z 2026-01-03T15:35:28.276Z
9063578 9063578 20251226032140_xn1He BE000A 2025-12-29T14:35:31.379Z 2026-01-03T15:35:23.312Z
9062857 9062857 20251226024239_0EnJ2 BE000A 2025-12-29T14:34:13.567Z 2026-01-03T15:34:44.884Z

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