participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
97 rows where station_code = "BR001Q" 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 |
---|---|---|---|---|---|
6270885 | 6270885 | 20250304081016_Ncjd5 | BR001Q | 2025-03-07T15:11:50.554Z | 2025-03-11T13:24:46.377Z |
6270745 | 6270745 | 20250304070801_nuRjQ | BR001Q | 2025-03-07T15:11:34.182Z | 2025-03-11T13:24:41.906Z |
6270706 | 6270706 | 20250304063637_tN38l | BR001Q | 2025-03-07T15:11:29.350Z | 2025-03-11T13:24:34.369Z |
6270352 | 6270352 | 20250304050458_Rmryd | BR001Q | 2025-03-07T15:11:04.707Z | 2025-03-11T13:24:09.338Z |
6267063 | 6267063 | 20250304005846_K54ho | BR001Q | 2025-03-07T15:05:47.033Z | 2025-03-11T13:21:44.819Z |
6266842 | 6266842 | 20250304003310_0ymyI | BR001Q | 2025-03-07T15:05:31.044Z | 2025-03-11T13:21:13.899Z |
6257054 | 6257054 | 20250305013926_StMc2 | BR001Q | 2025-03-07T14:46:48.148Z | 2025-03-13T12:41:57.208Z |
6247356 | 6247356 | 20250306070559_vzVdT | BR001Q | 2025-03-07T14:25:05.093Z | 2025-03-14T12:36:21.886Z |
6246827 | 6246827 | 20250306043114_CJvdS | BR001Q | 2025-03-07T14:24:10.596Z | 2025-03-14T12:36:17.838Z |
6246813 | 6246813 | 20250306043027_gGeEt | BR001Q | 2025-03-07T14:24:09.235Z | 2025-03-14T12:36:17.741Z |
6246670 | 6246670 | 20250306041941_Bnuwo | BR001Q | 2025-03-07T14:23:59.662Z | 2025-03-14T12:36:16.515Z |
6245796 | 6245796 | 20250306032529_yH0gP | BR001Q | 2025-03-07T14:22:33.069Z | 2025-03-14T12:35:57.056Z |
6245568 | 6245568 | 20250306031040_N02In | BR001Q | 2025-03-07T14:21:53.273Z | 2025-03-14T12:35:51.532Z |
6245493 | 6245493 | 20250306030339_eL2Qg | BR001Q | 2025-03-07T14:21:46.080Z | 2025-03-14T12:35:47.502Z |
6242681 | 6242681 | 20250306000559_DXYrd | BR001Q | 2025-03-07T14:16:16.378Z | 2025-03-14T12:34:38.046Z |
6216955 | 6216955 | 20250302075851_iEcPs | BR001Q | 2025-03-03T14:18:24.052Z | 2025-03-10T13:47:47.754Z |
6216909 | 6216909 | 20250302073814_ud4D5 | BR001Q | 2025-03-03T14:18:15.721Z | 2025-03-10T13:47:43.743Z |
6216907 | 6216907 | 20250302073411_zQ3KE | BR001Q | 2025-03-03T14:18:15.348Z | 2025-03-10T13:47:43.680Z |
6216731 | 6216731 | 20250302061103_8WyPn | BR001Q | 2025-03-03T14:17:38.487Z | 2025-03-10T13:47:18.809Z |
6216502 | 6216502 | 20250302051627_ch7zo | BR001Q | 2025-03-03T14:17:04.530Z | 2025-03-10T13:47:08.467Z |
6216289 | 6216289 | 20250302045104_ygJOn | BR001Q | 2025-03-03T14:16:28.848Z | 2025-03-10T13:47:01.669Z |
6216221 | 6216221 | 20250302044159_tcjhQ | BR001Q | 2025-03-03T14:16:19.367Z | 2025-03-10T13:46:55.340Z |
6215994 | 6215994 | 20250302041930_3E21z | BR001Q | 2025-03-03T14:15:48.844Z | 2025-03-10T13:46:44.331Z |
6215033 | 6215033 | 20250302025544_NS5jQ | BR001Q | 2025-03-03T14:13:29.617Z | 2025-03-10T13:45:51.862Z |
6206193 | 6206193 | 20250301072546_xYxyY | BR001Q | 2025-03-02T14:17:52.691Z | 2025-03-09T13:31:37.415Z |
6206153 | 6206153 | 20250301071146_XU2HY | BR001Q | 2025-03-02T14:17:43.758Z | 2025-03-09T13:31:36.513Z |
6204525 | 6204525 | 20250301031517_Vwufk | BR001Q | 2025-03-02T14:13:32.828Z | 2025-03-09T13:30:49.571Z |
6202380 | 6202380 | 20250228231244_OZMRL | BR001Q | 2025-03-02T14:07:53.532Z | 2025-03-06T14:25:41.530Z |
6165054 | 6165054 | 20250224232952_I2jdg | BR001Q | 2025-02-26T14:06:10.877Z | 2025-03-05T15:16:50.647Z |
6158058 | 6158058 | 20250224074043_UzL3J | BR001Q | 2025-02-25T14:10:02.152Z | 2025-03-04T15:24:04.330Z |
6158019 | 6158019 | 20250224072715_YeiJ3 | BR001Q | 2025-02-25T14:09:55.977Z | 2025-03-04T15:24:02.119Z |
6157996 | 6157996 | 20250224072130_8Ht99 | BR001Q | 2025-02-25T14:09:53.660Z | 2025-03-04T15:24:00.857Z |
6157756 | 6157756 | 20250224054404_uPX5J | BR001Q | 2025-02-25T14:08:55.047Z | 2025-03-04T15:23:47.098Z |
6157753 | 6157753 | 20250224054357_K7bsm | BR001Q | 2025-02-25T14:08:54.600Z | 2025-03-04T15:23:46.864Z |
6157417 | 6157417 | 20250224034325_8Qi23 | BR001Q | 2025-02-25T14:07:37.641Z | 2025-03-04T15:23:30.308Z |
6157242 | 6157242 | 20250224022701_3xFUq | BR001Q | 2025-02-25T14:06:49.992Z | 2025-03-04T15:23:22.634Z |
6150216 | 6150216 | 20250223074239_WopAz | BR001Q | 2025-02-24T14:18:56.242Z | 2025-03-03T15:22:29.874Z |
6150076 | 6150076 | 20250223065427_xHDOV | BR001Q | 2025-02-24T14:18:23.837Z | 2025-03-03T15:22:22.618Z |
6149624 | 6149624 | 20250223050226_qW6oH | BR001Q | 2025-02-24T14:16:54.463Z | 2025-03-03T15:22:02.041Z |
6149548 | 6149548 | 20250223044915_GD3u4 | BR001Q | 2025-02-24T14:16:42.131Z | 2025-03-03T15:21:58.565Z |
6148527 | 6148527 | 20250223021029_rVNbt | BR001Q | 2025-02-24T14:13:29.107Z | 2025-03-03T15:21:01.209Z |
6128182 | 6128182 | 20250221045222_FTIVL | BR001Q | 2025-02-22T14:11:24.336Z | 2025-03-01T15:27:44.801Z |
6117300 | 6117300 | 20250219070508_BBSg3 | BR001Q | 2025-02-20T14:12:07.243Z | 2025-02-27T15:28:40.277Z |
6112207 | 6112207 | 20250218074653_NOhw8 | BR001Q | 2025-02-19T14:09:33.308Z | 2025-02-26T15:15:43.156Z |
6112178 | 6112178 | 20250218064455_B0bt2 | BR001Q | 2025-02-19T14:09:27.062Z | 2025-02-26T15:15:41.667Z |
6112134 | 6112134 | 20250218061233_yXRxP | BR001Q | 2025-02-19T14:09:20.574Z | 2025-02-26T15:15:39.729Z |
6112044 | 6112044 | 20250218052757_Cr2mW | BR001Q | 2025-02-19T14:08:59.193Z | 2025-02-26T15:15:37.154Z |
6112029 | 6112029 | 20250218051903_Zxn8F | BR001Q | 2025-02-19T14:08:53.430Z | 2025-02-26T15:15:36.612Z |
6111852 | 6111852 | 20250218043332_xgL4R | BR001Q | 2025-02-19T14:08:13.942Z | 2025-02-26T15:15:30.224Z |
6111827 | 6111827 | 20250218042348_aqBhM | BR001Q | 2025-02-19T14:08:06.979Z | 2025-02-26T15:15:29.409Z |
6111789 | 6111789 | 20250218040907_dLhBm | BR001Q | 2025-02-19T14:08:00.783Z | 2025-02-26T15:15:28.401Z |
6111334 | 6111334 | 20250218020628_EjP9Z | BR001Q | 2025-02-19T14:06:17.602Z | 2025-02-26T15:14:50.185Z |
6111248 | 6111248 | 20250218014143_iFicV | BR001Q | 2025-02-19T14:05:53.590Z | 2025-02-26T15:14:42.976Z |
6111055 | 6111055 | 20250218004952_QSJd7 | BR001Q | 2025-02-19T14:05:02.035Z | 2025-02-26T15:14:36.338Z |
6110692 | 6110692 | 20250217222642_AUr7z | BR001Q | 2025-02-19T14:03:35.270Z | 2025-02-26T15:14:04.998Z |
6105223 | 6105223 | 20250216061530_g25gg | BR001Q | 2025-02-17T14:04:14.107Z | 2025-02-24T15:22:35.313Z |
6105074 | 6105074 | 20250216030036_vJN32 | BR001Q | 2025-02-17T14:03:37.274Z | 2025-02-24T15:22:29.761Z |
6104986 | 6104986 | 20250216020233_QlOjv | BR001Q | 2025-02-17T14:03:11.452Z | 2025-02-24T15:22:26.006Z |
6103300 | 6103300 | 20250215075821_Ib6CH | BR001Q | 2025-02-16T14:03:01.149Z | 2025-02-23T15:07:54.768Z |
6103286 | 6103286 | 20250215065158_FA83X | BR001Q | 2025-02-16T14:02:57.996Z | 2025-02-23T15:07:52.549Z |
6103284 | 6103284 | 20250215062336_0NG3e | BR001Q | 2025-02-16T14:02:57.492Z | 2025-02-23T15:07:52.430Z |
6100156 | 6100156 | 20250207073647_ztTNa | BR001Q | 2025-02-13T14:19:37.887Z | 2025-02-15T14:27:16.765Z |
6100153 | 6100153 | 20250207063610_swEuk | BR001Q | 2025-02-13T14:19:31.961Z | 2025-02-15T14:27:09.797Z |
6100152 | 6100152 | 20250207054754_gVeyw | BR001Q | 2025-02-13T14:19:24.682Z | 2025-02-15T14:27:00.424Z |
6100150 | 6100150 | 20250207053418_WJYaz | BR001Q | 2025-02-13T14:19:22.598Z | 2025-02-15T14:26:58.651Z |
6100148 | 6100148 | 20250207044303_y6AJV | BR001Q | 2025-02-13T14:19:05.848Z | 2025-02-15T14:26:39.992Z |
6100146 | 6100146 | 20250207040315_BbNCT | BR001Q | 2025-02-13T14:18:57.301Z | 2025-02-15T14:26:29.298Z |
6100143 | 6100143 | 20250207033712_ZCjQa | BR001Q | 2025-02-13T14:18:48.486Z | 2025-02-15T14:26:23.592Z |
6100142 | 6100142 | 20250207032517_wetoQ | BR001Q | 2025-02-13T14:18:44.756Z | 2025-02-15T14:26:21.675Z |
6100140 | 6100140 | 20250207024658_by2NB | BR001Q | 2025-02-13T14:18:34.882Z | 2025-02-15T14:26:09.360Z |
6100138 | 6100138 | 20250208074102_G3di9 | BR001Q | 2025-02-13T14:14:19.529Z | 2025-02-16T14:20:27.734Z |
6100135 | 6100135 | 20250208061111_DLxjY | BR001Q | 2025-02-13T14:14:14.308Z | 2025-02-16T14:20:17.201Z |
6100134 | 6100134 | 20250209054822_7hrt6 | BR001Q | 2025-02-13T14:11:41.207Z | 2025-02-17T14:24:33.140Z |
6100132 | 6100132 | 20250209053656_gZepo | BR001Q | 2025-02-13T14:11:39.494Z | 2025-02-17T14:24:32.409Z |
6100130 | 6100130 | 20250209031954_yTdy7 | BR001Q | 2025-02-13T14:11:16.717Z | 2025-02-17T14:24:11.503Z |
6100126 | 6100126 | 20250210074301_QfxSU | BR001Q | 2025-02-13T14:09:32.502Z | 2025-02-18T14:27:38.525Z |
6100123 | 6100123 | 20250210055026_9C6xt | BR001Q | 2025-02-13T14:09:29.847Z | 2025-02-18T14:27:37.481Z |
6100122 | 6100122 | 20250210043431_Ks9Nt | BR001Q | 2025-02-13T14:09:27.840Z | 2025-02-18T14:27:34.127Z |
5979952 | 5979952 | 20250122024445_XL4Bq | BR001Q | 2025-01-23T14:21:10.024Z | 2025-01-30T14:33:50.701Z |
5972300 | 5972300 | 20250122063448_UMwea | BR001Q | 2025-01-23T14:02:34.376Z | 2025-01-31T14:34:30.138Z |
5972022 | 5972022 | 20250122045135_phYRi | BR001Q | 2025-01-23T14:01:20.179Z | 2025-01-31T14:34:22.097Z |
5971895 | 5971895 | 20250122040849_mu3bU | BR001Q | 2025-01-23T14:00:51.976Z | 2025-01-31T14:34:20.145Z |
5971881 | 5971881 | 20250122040405_oUuyf | BR001Q | 2025-01-23T14:00:48.976Z | 2025-01-31T14:34:19.730Z |
5971817 | 5971817 | 20250122033459_nI3xk | BR001Q | 2025-01-23T14:00:33.890Z | 2025-01-31T14:34:18.865Z |
5971780 | 5971780 | 20250122032539_SwPZP | BR001Q | 2025-01-23T14:00:22.255Z | 2025-01-31T14:34:17.161Z |
5966810 | 5966810 | 20250119034545_f2ASG | BR001Q | 2025-01-22T14:24:58.161Z | 2025-01-27T14:47:29.419Z |
5966701 | 5966701 | 20250119031739_jED4N | BR001Q | 2025-01-22T14:24:49.981Z | 2025-01-27T14:47:17.284Z |
5964000 | 5964000 | 20250121005619_kGyEJ | BR001Q | 2025-01-22T14:13:16.575Z | 2025-01-29T14:36:15.026Z |
5963964 | 5963964 | 20250121003832_eir8C | BR001Q | 2025-01-22T14:13:05.233Z | 2025-01-29T14:36:14.678Z |
5963844 | 5963844 | 20250120234009_8tr5M | BR001Q | 2025-01-22T14:12:35.179Z | 2025-01-29T14:36:13.548Z |
5960841 | 5960841 | 20250121072544_yLJit | BR001Q | 2025-01-22T14:01:39.504Z | 2025-01-30T14:33:06.696Z |
5960819 | 5960819 | 20250121064234_NF9HW | BR001Q | 2025-01-22T14:01:33.268Z | 2025-01-30T14:33:04.369Z |
5960776 | 5960776 | 20250121055927_Dh77n | BR001Q | 2025-01-22T14:01:24.842Z | 2025-01-30T14:33:01.766Z |
5960604 | 5960604 | 20250121043228_wB5gX | BR001Q | 2025-01-22T14:00:39.747Z | 2025-01-30T14:32:57.595Z |
5960584 | 5960584 | 20250121042503_YJwXh | BR001Q | 2025-01-22T14:00:32.785Z | 2025-01-30T14:32:57.015Z |
5955027 | 5955027 | 20250113070451_ObIte | BR001Q | 2025-01-18T14:16:29.326Z | 2025-01-21T14:20:27.051Z |
5955024 | 5955024 | 20250113064226_v2jYv | BR001Q | 2025-01-18T14:16:28.505Z | 2025-01-21T14:20:26.412Z |
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);