participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,259 rows where station_code = "BR0003" 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 |
---|---|---|---|---|---|
5122321 | 5122321 | 20240914053914_I5Nkk | BR0003 | 2024-09-18T12:11:14.344Z | 2024-09-20T12:19:11.164Z |
4669144 | 4669144 | 20240719080901_JyFgs | BR0003 | 2024-07-20T12:05:36.039Z | 2024-07-27T12:17:23.204Z |
4668910 | 4668910 | 20240719054832_F3oLc | BR0003 | 2024-07-20T12:05:15.155Z | 2024-07-27T12:17:20.691Z |
4489938 | 4489938 | 20240621081524_Zn2Ud | BR0003 | 2024-06-22T12:00:29.662Z | 2024-06-30T12:09:33.984Z |
4486156 | 4486156 | 20240619083412_aR1S5 | BR0003 | 2024-06-21T12:02:03.387Z | 2024-06-28T12:09:27.372Z |
4486144 | 4486144 | 20240619082620_FuqXA | BR0003 | 2024-06-21T12:02:02.192Z | 2024-06-28T12:09:27.270Z |
4485720 | 4485720 | 20240619041320_dkmD6 | BR0003 | 2024-06-21T12:01:14.945Z | 2024-06-28T12:09:24.726Z |
4472574 | 4472574 | 20240616080645_OuAfG | BR0003 | 2024-06-18T12:02:28.395Z | 2024-06-24T12:11:09.771Z |
4467605 | 4467605 | 20240614223759_ySIad | BR0003 | 2024-06-17T12:00:20.428Z | 2024-06-23T12:11:29.004Z |
4465053 | 4465053 | 20240615081614_0AK4f | BR0003 | 2024-06-16T12:03:44.464Z | 2024-06-23T12:12:00.903Z |
4465026 | 4465026 | 20240615080852_dJitS | BR0003 | 2024-06-16T12:03:42.382Z | 2024-06-23T12:11:59.398Z |
4464289 | 4464289 | 20240615034240_AUicJ | BR0003 | 2024-06-16T12:01:51.232Z | 2024-06-23T12:11:43.055Z |
4461229 | 4461229 | 20240613042008_SBxQ3 | BR0003 | 2024-06-15T12:05:40.719Z | 2024-06-21T12:11:34.799Z |
4461222 | 4461222 | 20240613001459_E3XMr | BR0003 | 2024-06-15T12:05:06.920Z | 2024-06-21T12:11:31.372Z |
4460958 | 4460958 | 20240614082647_Ak2mX | BR0003 | 2024-06-15T12:03:35.953Z | 2024-06-22T12:16:27.341Z |
4460947 | 4460947 | 20240614082253_3q2qH | BR0003 | 2024-06-15T12:03:34.511Z | 2024-06-22T12:16:27.257Z |
4460913 | 4460913 | 20240614081015_PPu7c | BR0003 | 2024-06-15T12:03:30.345Z | 2024-06-22T12:16:26.421Z |
4460903 | 4460903 | 20240614080812_3Vp0C | BR0003 | 2024-06-15T12:03:28.935Z | 2024-06-22T12:16:26.232Z |
4460626 | 4460626 | 20240614040921_BevUw | BR0003 | 2024-06-15T12:02:28.680Z | 2024-06-22T12:16:23.914Z |
4460624 | 4460624 | 20240614040606_bs7YG | BR0003 | 2024-06-15T12:02:27.264Z | 2024-06-22T12:16:23.891Z |
4460608 | 4460608 | 20240614032409_XEkI2 | BR0003 | 2024-06-15T12:02:22.747Z | 2024-06-22T12:16:23.689Z |
4460410 | 4460410 | 20240614000838_4naYd | BR0003 | 2024-06-15T12:01:42.926Z | 2024-06-22T12:16:21.009Z |
4460350 | 4460350 | 20240613233620_q0HMt | BR0003 | 2024-06-15T12:01:28.568Z | 2024-06-22T12:16:20.178Z |
4456787 | 4456787 | 20240613032148_6AWOB | BR0003 | 2024-06-14T12:02:08.342Z | 2024-06-21T12:11:33.915Z |
4456746 | 4456746 | 20240613022657_C8Qqu | BR0003 | 2024-06-14T12:02:03.805Z | 2024-06-21T12:11:33.581Z |
4446756 | 4446756 | 20240611082840_sKb4N | BR0003 | 2024-06-12T12:03:18.051Z | 2024-06-19T12:13:37.202Z |
4446334 | 4446334 | 20240611034832_oR26T | BR0003 | 2024-06-12T12:02:39.415Z | 2024-06-19T12:13:33.190Z |
4446318 | 4446318 | 20240611032107_oGMQk | BR0003 | 2024-06-12T12:02:37.103Z | 2024-06-19T12:13:33.170Z |
4445449 | 4445449 | 20240611001208_VEYGV | BR0003 | 2024-06-12T12:01:42.903Z | 2024-06-19T12:13:29.181Z |
4442350 | 4442350 | 20240610034207_xb5X6 | BR0003 | 2024-06-11T12:01:42.147Z | 2024-06-18T12:11:05.331Z |
4442336 | 4442336 | 20240610021530_IN6OT | BR0003 | 2024-06-11T12:01:39.383Z | 2024-06-18T12:11:05.177Z |
4442132 | 4442132 | 20240609235610_Dj37K | BR0003 | 2024-06-11T12:01:18.166Z | 2024-06-18T12:11:03.151Z |
4437670 | 4437670 | 20240608235631_SSBWf | BR0003 | 2024-06-10T12:01:13.029Z | 2024-06-17T12:15:08.266Z |
4437062 | 4437062 | 20240608231434_zOo2E | BR0003 | 2024-06-10T12:00:55.253Z | 2024-06-17T12:15:04.691Z |
4434280 | 4434280 | 20240608044820_T3MWS | BR0003 | 2024-06-09T12:02:37.851Z | 2024-06-16T12:14:12.063Z |
4433822 | 4433822 | 20240608003656_BYAmK | BR0003 | 2024-06-09T12:02:15.879Z | 2024-06-16T12:14:08.106Z |
4433512 | 4433512 | 20240607234611_RV2DG | BR0003 | 2024-06-09T12:02:01.931Z | 2024-06-16T12:14:05.938Z |
4433292 | 4433292 | 20240607231616_3ne2T | BR0003 | 2024-06-09T12:01:53.691Z | 2024-06-16T12:14:03.462Z |
4428915 | 4428915 | 20240607042005_3H6j2 | BR0003 | 2024-06-08T12:06:39.204Z | 2024-06-15T12:17:01.181Z |
4428052 | 4428052 | 20240607003610_ZoC32 | BR0003 | 2024-06-08T12:05:38.294Z | 2024-06-15T12:16:57.079Z |
4422782 | 4422782 | 20240605045649_Z4YGa | BR0003 | 2024-06-07T12:10:24.469Z | 2024-06-13T12:08:34.833Z |
4422755 | 4422755 | 20240605043129_uCsd7 | BR0003 | 2024-06-07T12:10:20.164Z | 2024-06-13T12:08:34.685Z |
4422734 | 4422734 | 20240605041511_enSKd | BR0003 | 2024-06-07T12:10:17.476Z | 2024-06-13T12:08:34.626Z |
4422651 | 4422651 | 20240605025312_8r3uh | BR0003 | 2024-06-07T12:10:07.160Z | 2024-06-13T12:08:34.227Z |
4411428 | 4411428 | 20240603043947_Fb5XC | BR0003 | 2024-06-05T12:09:07.041Z | 2024-06-11T12:13:40.553Z |
4411414 | 4411414 | 20240603043257_ygZVE | BR0003 | 2024-06-05T12:09:05.357Z | 2024-06-11T12:13:40.394Z |
4411364 | 4411364 | 20240603022912_mq21D | BR0003 | 2024-06-05T12:09:00.117Z | 2024-06-11T12:13:39.693Z |
4411347 | 4411347 | 20240603011013_hZarc | BR0003 | 2024-06-05T12:08:53.098Z | 2024-06-11T12:13:37.730Z |
4407319 | 4407319 | 20240602045628_Utltg | BR0003 | 2024-06-04T12:09:27.422Z | 2024-06-10T12:06:48.208Z |
4407284 | 4407284 | 20240602044032_fmlbe | BR0003 | 2024-06-04T12:09:22.590Z | 2024-06-10T12:06:48.131Z |
4407279 | 4407279 | 20240602043635_NTf3W | BR0003 | 2024-06-04T12:09:22.047Z | 2024-06-10T12:06:48.129Z |
4407257 | 4407257 | 20240602042704_mgtNv | BR0003 | 2024-06-04T12:09:17.722Z | 2024-06-10T12:06:48.060Z |
4403076 | 4403076 | 20240601045246_i39Zr | BR0003 | 2024-06-03T12:10:54.239Z | 2024-06-09T12:06:02.619Z |
4403022 | 4403022 | 20240601040250_NEqXe | BR0003 | 2024-06-03T12:10:44.722Z | 2024-06-09T12:06:02.425Z |
4402347 | 4402347 | 20240531233149_pMX0r | BR0003 | 2024-06-03T12:10:15.568Z | 2024-06-09T12:06:01.063Z |
4402058 | 4402058 | 20240531212452_cv9oe | BR0003 | 2024-06-03T12:09:41.395Z | 2024-06-09T12:06:00.454Z |
4400765 | 4400765 | 20240602002630_v5pA3 | BR0003 | 2024-06-03T12:06:27.957Z | 2024-06-10T12:06:46.974Z |
4400617 | 4400617 | 20240602000522_pH2H1 | BR0003 | 2024-06-03T12:06:13.507Z | 2024-06-10T12:06:46.753Z |
4400265 | 4400265 | 20240601220337_gjc5V | BR0003 | 2024-06-03T12:05:30.792Z | 2024-06-10T12:06:45.956Z |
4398083 | 4398083 | 20240531031022_v2KPO | BR0003 | 2024-06-02T12:05:08.965Z | 2024-06-08T12:14:11.989Z |
4397304 | 4397304 | 20240531044755_d23Qo | BR0003 | 2024-06-01T12:08:59.138Z | 2024-06-08T12:14:12.805Z |
4397109 | 4397109 | 20240531013924_w2Yvn | BR0003 | 2024-06-01T12:08:29.839Z | 2024-06-08T12:14:11.231Z |
4396952 | 4396952 | 20240531003902_63Gi4 | BR0003 | 2024-06-01T12:08:13.332Z | 2024-06-08T12:14:09.621Z |
4396931 | 4396931 | 20240531002330_xRb23 | BR0003 | 2024-06-01T12:08:10.409Z | 2024-06-08T12:14:09.544Z |
4396917 | 4396917 | 20240531001843_7AvSs | BR0003 | 2024-06-01T12:08:09.003Z | 2024-06-08T12:14:09.491Z |
4394245 | 4394245 | 20240530012020_F6xsu | BR0003 | 2024-05-31T12:09:43.841Z | 2024-06-07T12:16:06.340Z |
4394177 | 4394177 | 20240530003833_APKmK | BR0003 | 2024-05-31T12:09:38.583Z | 2024-06-07T12:16:05.933Z |
4333882 | 4333882 | 20240509010128_7KM8D | BR0003 | 2024-05-18T12:10:47.462Z | 2024-05-19T12:15:06.015Z |
4297055 | 4297055 | 20240505065039_8MahC | BR0003 | 2024-05-08T12:12:28.666Z | 2024-05-13T12:12:37.158Z |
4297013 | 4297013 | 20240505063007_49IMk | BR0003 | 2024-05-08T12:12:21.387Z | 2024-05-13T12:12:34.976Z |
4275774 | 4275774 | 20240503015031_sC5SY | BR0003 | 2024-05-05T12:11:49.339Z | 2024-05-11T12:28:17.634Z |
4100879 | 4100879 | 20240321044613_pxTCF | BR0003 | 2024-03-22T12:09:50.267Z | 2024-03-29T12:14:56.360Z |
3895042 | 3895042 | 20240129073014_1xj2x | BR0003 | 2024-01-30T14:04:31.371Z | 2024-02-06T14:20:51.677Z |
3895027 | 3895027 | 20240129070938_UkPWL | BR0003 | 2024-01-30T14:04:27.388Z | 2024-02-06T14:20:51.544Z |
3895014 | 3895014 | 20240129064900_fJpi3 | BR0003 | 2024-01-30T14:04:24.706Z | 2024-02-06T14:20:50.993Z |
3895010 | 3895010 | 20240129064233_x9x0T | BR0003 | 2024-01-30T14:04:23.906Z | 2024-02-06T14:20:50.976Z |
3894995 | 3894995 | 20240129061139_O5K02 | BR0003 | 2024-01-30T14:04:21.652Z | 2024-02-06T14:20:50.776Z |
3894973 | 3894973 | 20240129053428_IkSrJ | BR0003 | 2024-01-30T14:04:17.722Z | 2024-02-06T14:20:50.586Z |
3884949 | 3884949 | 20240124074037_2Ys7z | BR0003 | 2024-01-26T14:04:58.037Z | 2024-02-01T14:18:02.651Z |
3884947 | 3884947 | 20240124072513_mcMqp | BR0003 | 2024-01-26T14:04:57.716Z | 2024-02-01T14:18:02.640Z |
3884945 | 3884945 | 20240124072504_jwM3B | BR0003 | 2024-01-26T14:04:57.272Z | 2024-02-01T14:18:02.599Z |
3757200 | 3757200 | 20240106071605_tYDyA | BR0003 | 2024-01-08T14:03:22.516Z | 2024-01-15T14:23:47.640Z |
3341681 | 3341681 | 20231108010134_eu8kQ | BR0003 | 2024-01-06T00:04:04.933Z | 2024-01-06T00:04:04.933Z |
3321558 | 3321558 | 20231106053940_dUngK | BR0003 | 2024-01-06T00:03:55.879Z | 2024-01-06T00:03:55.879Z |
3320832 | 3320832 | 20231106044740_HxJ0E | BR0003 | 2024-01-06T00:03:55.817Z | 2024-01-06T00:03:55.817Z |
3318872 | 3318872 | 20231106020629_fyIXB | BR0003 | 2024-01-06T00:03:55.608Z | 2024-01-06T00:03:55.608Z |
3314678 | 3314678 | 20231105070725_YND1v | BR0003 | 2024-01-06T00:03:52.717Z | 2024-01-06T00:03:52.717Z |
3313792 | 3313792 | 20231105042750_Qvm69 | BR0003 | 2024-01-06T00:03:52.414Z | 2024-01-06T00:03:52.414Z |
2721728 | 2721728 | 20230808052131_SWEb1 | BR0003 | 2024-01-06T00:00:21.667Z | 2024-01-06T00:00:21.667Z |
2692891 | 2692891 | 20230804070230_fSlo1 | BR0003 | 2024-01-06T00:00:13.476Z | 2024-01-06T00:00:13.476Z |
2689761 | 2689761 | 20230803061406_trmTu | BR0003 | 2024-01-06T00:00:11.847Z | 2024-01-06T00:00:11.847Z |
2667396 | 2667396 | 20230728053259_9FjY1 | BR0003 | 2024-01-06T00:00:01.304Z | 2024-01-06T00:00:01.304Z |
2659069 | 2659069 | 20230726033643_8uj3T | BR0003 | 2024-01-05T23:59:55.148Z | 2024-01-05T23:59:55.148Z |
2653418 | 2653418 | 20230725043633_1Dvk4 | BR0003 | 2024-01-05T23:59:51.280Z | 2024-01-05T23:59:51.280Z |
2653360 | 2653360 | 20230725035419_CUDVo | BR0003 | 2024-01-05T23:59:51.260Z | 2024-01-05T23:59:51.260Z |
2653289 | 2653289 | 20230725033432_5CuMA | BR0003 | 2024-01-05T23:59:51.239Z | 2024-01-05T23:59:51.239Z |
2650356 | 2650356 | 20230724084932_VauZY | BR0003 | 2024-01-05T23:59:48.774Z | 2024-01-05T23:59:48.774Z |
2649250 | 2649250 | 20230724014216_2sIh9 | BR0003 | 2024-01-05T23:59:48.366Z | 2024-01-05T23:59:48.366Z |
2646001 | 2646001 | 20230723070252_GgtL9 | BR0003 | 2024-01-05T23:59:45.173Z | 2024-01-05T23:59:45.173Z |
2645629 | 2645629 | 20230723035543_ULLpn | BR0003 | 2024-01-05T23:59:45.121Z | 2024-01-05T23:59:45.121Z |
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);