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

7,340 rows where station_code = "BE000E" 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
8687246 8687246 20251204061222_CemXn BE000E 2025-12-05T14:14:29.935Z 2025-12-05T14:14:35.665Z
8687116 8687116 20251204044101_1MG5t BE000E 2025-12-05T14:13:55.506Z 2025-12-05T14:14:35.624Z
8687114 8687114 20251204044100_60g9B BE000E 2025-12-05T14:13:55.161Z 2025-12-05T14:14:35.623Z
8687108 8687108 20251204043613_J78XV BE000E 2025-12-05T14:13:54.665Z 2025-12-05T14:14:35.621Z
8687096 8687096 20251204035011_vUmVP BE000E 2025-12-05T14:13:52.766Z 2025-12-05T14:14:35.618Z
8681598 8681598 20251203032804_S74Nq BE000E 2025-12-04T14:15:06.201Z 2025-12-05T14:21:42.562Z
8681420 8681420 20251203030821_3C3eB BE000E 2025-12-04T14:14:41.821Z 2025-12-05T14:21:36.615Z
8681401 8681401 20251203030505_9W4qr BE000E 2025-12-04T14:14:38.928Z 2025-12-05T14:21:35.506Z
8666507 8666507 20251201060011_rKJ3F BE000E 2025-12-02T14:26:21.271Z 2025-12-05T14:37:00.586Z
8665427 8665427 20251201032014_F5Wzo BE000E 2025-12-02T14:23:40.842Z 2025-12-05T14:36:03.880Z
8665188 8665188 20251201024521_Nlosc BE000E 2025-12-02T14:23:06.119Z 2025-12-05T14:35:45.293Z
8665079 8665079 20251201022649_HcYaz BE000E 2025-12-02T14:22:54.143Z 2025-12-05T14:35:42.036Z
8665016 8665016 20251201021732_TfMqP BE000E 2025-12-02T14:22:37.274Z 2025-12-05T14:35:39.430Z
8664992 8664992 20251201021404_2YjTE BE000E 2025-12-02T14:22:34.425Z 2025-12-05T14:35:38.444Z
8664916 8664916 20251201020440_tsACM BE000E 2025-12-02T14:22:26.938Z 2025-12-05T14:35:36.336Z
8664878 8664878 20251201015559_ckGUE BE000E 2025-12-02T14:22:15.944Z 2025-12-05T14:35:34.548Z
8664852 8664852 20251201015116_P2AVF BE000E 2025-12-02T14:22:12.163Z 2025-12-05T14:35:33.759Z
8664663 8664663 20251201012006_OKx89 BE000E 2025-12-02T14:21:45.633Z 2025-12-05T14:35:12.073Z
8664615 8664615 20251201011223_VvIA2 BE000E 2025-12-02T14:21:38.262Z 2025-12-05T14:35:10.531Z
8664545 8664545 20251201005511_DNm0S BE000E 2025-12-02T14:21:19.502Z 2025-12-05T14:35:08.112Z
8664305 8664305 20251201000059_8BptF BE000E 2025-12-02T14:20:40.898Z 2025-12-05T14:35:00.138Z
8664293 8664293 20251130235913_xSmNt BE000E 2025-12-02T14:20:39.874Z 2025-12-05T14:34:59.868Z
8664091 8664091 20251130231621_j3xwo BE000E 2025-12-02T14:20:04.438Z 2025-12-05T14:34:51.930Z
8663882 8663882 20251130222524_gv4zA BE000E 2025-12-02T14:19:30.657Z 2025-12-05T14:34:35.456Z
8663788 8663788 20251130220420_VMJxz BE000E 2025-12-02T14:19:09.440Z 2025-12-05T14:34:32.229Z
8662128 8662128 20251130180255_qcHqX BE000E 2025-12-02T14:14:27.302Z 2025-12-05T14:33:08.427Z
8654958 8654958 20251130033953_l5rOB BE000E 2025-12-01T14:26:13.018Z 2025-12-05T14:44:26.427Z
8654541 8654541 20251130031952_9P8FM BE000E 2025-12-01T14:25:34.181Z 2025-12-05T14:44:10.637Z
8653481 8653481 20251130021818_26sLn BE000E 2025-12-01T14:23:34.024Z 2025-12-05T14:43:32.502Z
8651189 8651189 20251129230314_ViI2q BE000E 2025-12-01T14:18:20.209Z 2025-12-05T14:41:51.469Z
8651038 8651038 20251129222831_VEotI BE000E 2025-12-01T14:17:53.122Z 2025-12-05T14:41:35.150Z
8646239 8646239 20251129013009_w4w3J BE000E 2025-11-30T14:25:42.527Z 2025-12-05T14:51:36.986Z
8646214 8646214 20251129012551_0Ut4r BE000E 2025-11-30T14:25:25.813Z 2025-12-05T14:51:36.126Z
8646160 8646160 20251129011605_S322e BE000E 2025-11-30T14:25:17.771Z 2025-12-05T14:51:34.501Z
8646066 8646066 20251129005740_dzhge BE000E 2025-11-30T14:25:08.098Z 2025-12-05T14:51:32.232Z
8645997 8645997 20251129004624_t0GRy BE000E 2025-11-30T14:25:03.000Z 2025-12-05T14:51:30.762Z
8645740 8645740 20251128234347_KkA89 BE000E 2025-11-30T14:24:28.373Z 2025-12-05T14:51:11.042Z
8645713 8645713 20251128233518_He5As BE000E 2025-11-30T14:24:26.045Z 2025-12-05T14:51:07.948Z
8645682 8645682 20251128232702_oVcjp BE000E 2025-11-30T14:24:23.646Z 2025-12-05T14:51:06.690Z
8645608 8645608 20251128230446_8l5Af BE000E 2025-11-30T14:24:16.459Z 2025-12-05T14:50:57.285Z
8645363 8645363 20251128212925_iDkLg BE000E 2025-11-30T14:23:36.849Z 2025-12-05T14:50:37.531Z
8645194 8645194 20251128204911_5Y3hL BE000E 2025-11-30T14:23:11.918Z 2025-12-05T14:50:32.846Z
8623232 8623232 20251126232638_tZl92 BE000E 2025-11-28T14:21:08.611Z 2025-12-05T15:03:39.315Z
8623141 8623141 20251126230114_F3Dlx BE000E 2025-11-28T14:20:57.182Z 2025-12-05T15:03:32.505Z
8623072 8623072 20251126224429_pMM2G BE000E 2025-11-28T14:20:48.582Z 2025-12-05T15:03:27.347Z
8615364 8615364 20251126045846_NYw4T BE000E 2025-11-27T14:29:28.945Z 2025-12-04T15:11:28.069Z
8615088 8615088 20251126044508_12eWG BE000E 2025-11-27T14:29:06.718Z 2025-11-27T14:32:46.590Z
8614949 8614949 20251126043829_qAowh BE000E 2025-11-27T14:28:45.162Z 2025-12-04T15:11:23.077Z
8614912 8614912 20251126043634_ilYDB BE000E 2025-11-27T14:28:42.513Z 2025-12-04T15:11:21.152Z
8614585 8614585 20251126041910_fAnsq BE000E 2025-11-27T14:28:03.841Z 2025-12-04T15:10:53.044Z
8614047 8614047 20251126034913_FHGYv BE000E 2025-11-27T14:27:08.245Z 2025-12-04T15:10:12.273Z
8613951 8613951 20251126034233_1buhH BE000E 2025-11-27T14:26:59.804Z 2025-12-04T15:09:56.886Z
8613858 8613858 20251126033742_genaA BE000E 2025-11-27T14:26:52.557Z 2025-12-04T15:09:52.845Z
8613552 8613552 20251126032326_D44Y0 BE000E 2025-11-27T14:26:12.866Z 2025-12-04T15:09:47.708Z
8613500 8613500 20251126031953_aGyrV BE000E 2025-11-27T14:26:09.289Z 2025-12-04T15:09:41.324Z
8611754 8611754 20251126015804_UsLSs BE000E 2025-11-27T14:22:35.904Z 2025-12-04T15:09:23.875Z
8611559 8611559 20251126015118_HgLuk BE000E 2025-11-27T14:22:19.328Z 2025-12-04T15:09:22.547Z
8609456 8609456 20251125234215_IEaLw BE000E 2025-11-27T14:18:13.143Z 2025-12-04T15:07:54.405Z
8607810 8607810 20251125212456_lRCCV BE000E 2025-11-27T14:14:33.463Z 2025-12-04T15:07:32.198Z
8607498 8607498 20251125205750_37683 BE000E 2025-11-27T14:13:52.084Z 2025-12-04T15:07:03.051Z
8607355 8607355 20251125204344_QS1hV BE000E 2025-11-27T14:13:27.611Z 2025-12-04T15:07:01.130Z
8607179 8607179 20251125202430_Be7Oa BE000E 2025-11-27T14:12:40.605Z 2025-12-04T15:06:56.125Z
8606381 8606381 20251125184042_r6DHw BE000E 2025-11-27T14:09:59.261Z 2025-12-04T15:06:44.447Z
8606177 8606177 20251125181026_A0HU3 BE000E 2025-11-27T14:09:17.046Z 2025-12-04T15:06:29.941Z
8600149 8600149 20251125024551_AR1Jv BE000E 2025-11-26T14:22:04.948Z 2025-12-02T15:08:34.938Z
8598988 8598988 20251125014011_itjPK BE000E 2025-11-26T14:20:09.675Z 2025-12-02T15:08:15.412Z
8598635 8598635 20251125011214_HyzRp BE000E 2025-11-26T14:19:22.940Z 2025-12-02T15:08:01.497Z
8597551 8597551 20251124234512_HMIIS BE000E 2025-11-26T14:17:07.436Z 2025-12-02T15:07:37.546Z
8597543 8597543 20251124234410_Z1YxN BE000E 2025-11-26T14:17:06.249Z 2025-12-02T15:07:37.407Z
8597206 8597206 20251124231405_v6eyY BE000E 2025-11-26T14:16:21.814Z 2025-12-02T15:07:24.308Z
8597081 8597081 20251124225244_SGlqR BE000E 2025-11-26T14:15:58.120Z 2025-12-02T15:07:22.837Z
8591641 8591641 20251124043949_8JWuz BE000E 2025-11-25T14:24:41.926Z 2025-12-02T15:12:59.778Z
8591634 8591634 20251124043815_Deave BE000E 2025-11-25T14:24:40.925Z 2025-12-02T15:12:59.744Z
8591082 8591082 20251124034548_dTaey BE000E 2025-11-25T14:23:35.129Z 2025-12-02T15:12:57.036Z
8590806 8590806 20251124031259_sbbbD BE000E 2025-11-25T14:22:50.481Z 2025-12-02T15:12:55.551Z
8590683 8590683 20251124030321_bpPzk BE000E 2025-11-25T14:22:22.701Z 2025-12-02T15:12:54.201Z
8590479 8590479 20251124024509_Z33TS BE000E 2025-11-25T14:22:06.369Z 2025-12-02T15:12:48.650Z
8590332 8590332 20251124023527_3N2BI BE000E 2025-11-25T14:21:43.830Z 2025-12-02T15:12:46.929Z
8590153 8590153 20251124022651_NK2sa BE000E 2025-11-25T14:21:29.767Z 2025-12-02T15:12:43.015Z
8589828 8589828 20251124015818_PBpZK BE000E 2025-11-25T14:20:47.134Z 2025-12-02T15:12:37.091Z
8589466 8589466 20251124013704_NloJD BE000E 2025-11-25T14:20:06.717Z 2025-12-02T15:12:31.299Z
8589432 8589432 20251124013403_NNPN3 BE000E 2025-11-25T14:20:04.483Z 2025-12-02T15:12:30.732Z
8589219 8589219 20251124011543_5FwOF BE000E 2025-11-25T14:19:28.982Z 2025-12-02T15:12:11.672Z
8589197 8589197 20251124011321_QpK0o BE000E 2025-11-25T14:19:26.018Z 2025-12-02T15:12:10.976Z
8589121 8589121 20251124010354_2R3LZ BE000E 2025-11-25T14:19:06.310Z 2025-12-02T15:12:09.075Z
8589039 8589039 20251124005553_ZUkRX BE000E 2025-11-25T14:18:54.842Z 2025-12-02T15:12:03.862Z
8588822 8588822 20251124003412_G03CU BE000E 2025-11-25T14:18:21.402Z 2025-12-02T15:11:56.538Z
8588691 8588691 20251124002120_RH9qL BE000E 2025-11-25T14:18:08.415Z 2025-12-02T15:11:50.025Z
8588502 8588502 20251124000258_VeMXs BE000E 2025-11-25T14:17:40.090Z 2025-12-02T15:11:47.751Z
8587502 8587502 20251123221033_UeGME BE000E 2025-11-25T14:15:24.521Z 2025-12-02T15:11:16.461Z
8587144 8587144 20251123212734_zqgle BE000E 2025-11-25T14:14:42.924Z 2025-12-02T15:11:08.006Z
8586680 8586680 20251123203026_YPEKX BE000E 2025-11-25T14:13:35.890Z 2025-12-02T15:10:58.768Z
8586650 8586650 20251123202632_t03BZ BE000E 2025-11-25T14:13:33.394Z 2025-12-02T15:10:56.747Z
8585783 8585783 20251123174321_DZPTk BE000E 2025-11-25T14:10:50.342Z 2025-12-02T15:10:20.402Z
8581227 8581227 20251122165555_hH8sj BE000E 2025-11-24T14:29:44.230Z 2025-12-01T15:18:42.101Z
8580707 8580707 20251121230736_0hFPm BE000E 2025-11-24T14:22:36.997Z 2025-11-30T15:05:29.949Z
8573879 8573879 20251122043204_rC2d3 BE000E 2025-11-23T14:42:05.021Z 2025-11-30T15:06:48.007Z
8573827 8573827 20251122041849_bHIc3 BE000E 2025-11-23T14:42:02.305Z 2025-11-30T15:06:41.459Z
8573803 8573803 20251122041325_nUojS BE000E 2025-11-23T14:42:00.783Z 2025-11-30T15:06:40.397Z
8573760 8573760 20251122040644_SzL7m BE000E 2025-11-23T14:41:58.233Z 2025-11-30T15:06:37.046Z

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