participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,738 rows where station_code = "RO0002" 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 |
---|---|---|---|---|---|
5505169 | 5505169 | 20241108040310_qeQS7 | RO0002 | 2024-11-09T14:15:52.949Z | 2024-11-09T14:16:28.717Z |
5504926 | 5504926 | 20241108032033_qcxCh | RO0002 | 2024-11-09T14:15:24.018Z | 2024-11-09T14:16:28.659Z |
5504715 | 5504715 | 20241108024302_TAD13 | RO0002 | 2024-11-09T14:15:05.540Z | 2024-11-09T14:16:28.607Z |
5504524 | 5504524 | 20241108021148_GmdFx | RO0002 | 2024-11-09T14:14:48.137Z | 2024-11-09T14:16:28.560Z |
5504415 | 5504415 | 20241108015534_dcmB8 | RO0002 | 2024-11-09T14:14:35.485Z | 2024-11-09T14:16:28.531Z |
5504312 | 5504312 | 20241108013215_lD4hX | RO0002 | 2024-11-09T14:14:24.483Z | 2024-11-09T14:16:28.503Z |
5504254 | 5504254 | 20241108012024_Mt7Ci | RO0002 | 2024-11-09T14:14:17.364Z | 2024-11-09T14:16:28.487Z |
5504047 | 5504047 | 20241108004414_lkVbh | RO0002 | 2024-11-09T14:14:00.392Z | 2024-11-09T14:16:28.435Z |
5504045 | 5504045 | 20241108004353_2QT9t | RO0002 | 2024-11-09T14:14:00.350Z | 2024-11-09T14:16:28.434Z |
5504015 | 5504015 | 20241108003915_2ia2v | RO0002 | 2024-11-09T14:13:58.464Z | 2024-11-09T14:16:28.426Z |
5504007 | 5504007 | 20241108003904_5ogvI | RO0002 | 2024-11-09T14:13:58.153Z | 2024-11-09T14:16:28.425Z |
5504000 | 5504000 | 20241108003837_bBkX3 | RO0002 | 2024-11-09T14:13:57.763Z | 2024-11-09T14:16:28.423Z |
5503922 | 5503922 | 20241108001421_F4Noc | RO0002 | 2024-11-09T14:13:51.643Z | 2024-11-09T14:16:28.396Z |
5503900 | 5503900 | 20241108000930_noMnG | RO0002 | 2024-11-09T14:13:50.380Z | 2024-11-09T14:16:28.386Z |
5503889 | 5503889 | 20241108000544_7ygAZ | RO0002 | 2024-11-09T14:13:49.717Z | 2024-11-09T14:16:28.381Z |
5503864 | 5503864 | 20241108000322_k07n9 | RO0002 | 2024-11-09T14:13:48.586Z | 2024-11-09T14:16:28.371Z |
5503825 | 5503825 | 20241107235527_B66c0 | RO0002 | 2024-11-09T14:13:46.464Z | 2024-11-09T14:16:28.358Z |
5503801 | 5503801 | 20241107235117_BTrTf | RO0002 | 2024-11-09T14:13:45.171Z | 2024-11-09T14:16:28.350Z |
5503724 | 5503724 | 20241107233744_d0qQ7 | RO0002 | 2024-11-09T14:13:40.956Z | 2024-11-09T14:16:28.331Z |
5503707 | 5503707 | 20241107233408_4dfIp | RO0002 | 2024-11-09T14:13:39.047Z | 2024-11-09T14:16:28.327Z |
5503698 | 5503698 | 20241107233113_hxnxu | RO0002 | 2024-11-09T14:13:37.611Z | 2024-11-09T14:16:28.323Z |
5503679 | 5503679 | 20241107232626_7CAgH | RO0002 | 2024-11-09T14:13:33.755Z | 2024-11-09T14:16:28.319Z |
5503483 | 5503483 | 20241107222935_z6cTP | RO0002 | 2024-11-09T14:13:09.548Z | 2024-11-09T14:16:28.272Z |
5503435 | 5503435 | 20241107221949_ZAXLM | RO0002 | 2024-11-09T14:13:04.170Z | 2024-11-09T14:16:28.256Z |
5503421 | 5503421 | 20241107221747_A7jMU | RO0002 | 2024-11-09T14:13:02.301Z | 2024-11-09T14:16:28.251Z |
5503357 | 5503357 | 20241107215257_iitjg | RO0002 | 2024-11-09T14:12:53.574Z | 2024-11-09T14:16:28.226Z |
5503091 | 5503091 | 20241107203905_bXppQ | RO0002 | 2024-11-09T14:12:24.327Z | 2024-11-09T14:16:28.164Z |
5502546 | 5502546 | 20241107190202_07PqK | RO0002 | 2024-11-09T14:11:42.935Z | 2024-11-09T14:16:28.052Z |
5502348 | 5502348 | 20241107180926_R1CJZ | RO0002 | 2024-11-09T14:11:12.388Z | 2024-11-09T14:16:28.009Z |
5502336 | 5502336 | 20241107180901_yMmkA | RO0002 | 2024-11-09T14:11:11.779Z | 2024-11-09T14:16:28.006Z |
5502064 | 5502064 | 20241107170757_sMyTG | RO0002 | 2024-11-09T14:10:53.856Z | 2024-11-09T14:16:27.933Z |
5501939 | 5501939 | 20241107164311_yYUXJ | RO0002 | 2024-11-09T14:10:46.871Z | 2024-11-09T14:16:27.909Z |
5497539 | 5497539 | 20241107035740_KjlOf | RO0002 | 2024-11-08T14:13:57.019Z | 2024-11-09T14:18:45.792Z |
5497510 | 5497510 | 20241107035243_axyJR | RO0002 | 2024-11-08T14:13:55.072Z | 2024-11-09T14:18:45.040Z |
5497495 | 5497495 | 20241107035016_YppUK | RO0002 | 2024-11-08T14:13:53.970Z | 2024-11-09T14:18:44.753Z |
5497379 | 5497379 | 20241107033036_9J3Xj | RO0002 | 2024-11-08T14:13:39.671Z | 2024-11-09T14:18:41.825Z |
5497363 | 5497363 | 20241107032816_dMxhh | RO0002 | 2024-11-08T14:13:37.918Z | 2024-11-09T14:18:41.623Z |
5497281 | 5497281 | 20241107031347_bu68Q | RO0002 | 2024-11-08T14:13:29.301Z | 2024-11-09T14:18:39.840Z |
5497243 | 5497243 | 20241107030326_ijGig | RO0002 | 2024-11-08T14:13:26.061Z | 2024-11-09T14:18:38.852Z |
5497107 | 5497107 | 20241107024337_7Ffum | RO0002 | 2024-11-08T14:13:10.889Z | 2024-11-09T14:18:35.608Z |
5497022 | 5497022 | 20241107022926_CNHAJ | RO0002 | 2024-11-08T14:13:06.024Z | 2024-11-09T14:18:34.406Z |
5496945 | 5496945 | 20241107021248_mafcL | RO0002 | 2024-11-08T14:13:00.155Z | 2024-11-09T14:18:33.393Z |
5496939 | 5496939 | 20241107021219_4TjVF | RO0002 | 2024-11-08T14:12:59.860Z | 2024-11-09T14:18:33.320Z |
5496930 | 5496930 | 20241107021149_4I2bG | RO0002 | 2024-11-08T14:12:59.339Z | 2024-11-09T14:18:33.241Z |
5496871 | 5496871 | 20241107020208_72Gzz | RO0002 | 2024-11-08T14:12:56.034Z | 2024-11-09T14:18:31.845Z |
5496757 | 5496757 | 20241107013041_Y25WE | RO0002 | 2024-11-08T14:12:49.718Z | 2024-11-09T14:18:29.586Z |
5496516 | 5496516 | 20241107004228_9Fxj0 | RO0002 | 2024-11-08T14:12:18.264Z | 2024-11-09T14:18:23.832Z |
5496488 | 5496488 | 20241107003504_FT9pK | RO0002 | 2024-11-08T14:12:15.285Z | 2024-11-09T14:18:23.206Z |
5496425 | 5496425 | 20241107002140_JhY0U | RO0002 | 2024-11-08T14:12:08.569Z | 2024-11-09T14:18:22.002Z |
5496402 | 5496402 | 20241107001539_7RFsj | RO0002 | 2024-11-08T14:12:06.727Z | 2024-11-09T14:18:21.713Z |
5496365 | 5496365 | 20241107000347_inI5h | RO0002 | 2024-11-08T14:12:02.337Z | 2024-11-09T14:18:21.024Z |
5496178 | 5496178 | 20241106231610_TL6S7 | RO0002 | 2024-11-08T14:11:43.392Z | 2024-11-09T14:18:17.636Z |
5496167 | 5496167 | 20241106231337_JINQP | RO0002 | 2024-11-08T14:11:41.262Z | 2024-11-09T14:18:17.284Z |
5495985 | 5495985 | 20241106223036_szyBe | RO0002 | 2024-11-08T14:11:18.430Z | 2024-11-09T14:18:13.962Z |
5495887 | 5495887 | 20241106215649_C73hL | RO0002 | 2024-11-08T14:11:03.971Z | 2024-11-09T14:18:10.717Z |
5495811 | 5495811 | 20241106213857_OBDUL | RO0002 | 2024-11-08T14:10:55.436Z | 2024-11-09T14:18:09.492Z |
5495802 | 5495802 | 20241106213726_GUatq | RO0002 | 2024-11-08T14:10:54.870Z | 2024-11-09T14:18:09.411Z |
5495764 | 5495764 | 20241106212646_h722s | RO0002 | 2024-11-08T14:10:48.611Z | 2024-11-09T14:18:07.571Z |
5495726 | 5495726 | 20241106211627_3Yxzx | RO0002 | 2024-11-08T14:10:42.014Z | 2024-11-09T14:18:06.105Z |
5495724 | 5495724 | 20241106211527_SdxFN | RO0002 | 2024-11-08T14:10:41.906Z | 2024-11-09T14:18:06.044Z |
5495586 | 5495586 | 20241106202629_5zBGY | RO0002 | 2024-11-08T14:10:26.198Z | 2024-11-09T14:17:59.884Z |
5495576 | 5495576 | 20241106202429_FS5zS | RO0002 | 2024-11-08T14:10:25.158Z | 2024-11-09T14:17:58.919Z |
5495569 | 5495569 | 20241106201953_DHxhZ | RO0002 | 2024-11-08T14:10:24.275Z | 2024-11-09T14:17:57.917Z |
5495523 | 5495523 | 20241106200913_X2tCD | RO0002 | 2024-11-08T14:10:20.527Z | 2024-11-09T14:17:56.590Z |
5495425 | 5495425 | 20241106194348_Cm2CL | RO0002 | 2024-11-08T14:10:12.806Z | 2024-11-09T14:17:53.152Z |
5495230 | 5495230 | 20241106190226_K3bd9 | RO0002 | 2024-11-08T14:09:41.639Z | 2024-11-09T14:17:46.184Z |
5495089 | 5495089 | 20241106183630_wxEKr | RO0002 | 2024-11-08T14:09:16.632Z | 2024-11-09T14:17:42.154Z |
5494835 | 5494835 | 20241106173147_k6p3H | RO0002 | 2024-11-08T14:08:40.686Z | 2024-11-09T14:17:31.960Z |
5494727 | 5494727 | 20241106170513_wNlfa | RO0002 | 2024-11-08T14:08:29.562Z | 2024-11-09T14:17:26.602Z |
5491384 | 5491384 | 20241106030939_UVayt | RO0002 | 2024-11-07T14:16:01.658Z | 2024-11-09T14:20:07.285Z |
5491246 | 5491246 | 20241106023646_3qIXC | RO0002 | 2024-11-07T14:15:39.761Z | 2024-11-09T14:20:06.063Z |
5491229 | 5491229 | 20241106023054_hCt3W | RO0002 | 2024-11-07T14:15:34.947Z | 2024-11-09T14:20:05.762Z |
5491174 | 5491174 | 20241106021624_ICBiL | RO0002 | 2024-11-07T14:15:24.512Z | 2024-11-09T14:20:04.797Z |
5491150 | 5491150 | 20241106021143_OdSSH | RO0002 | 2024-11-07T14:15:22.989Z | 2024-11-09T14:20:04.560Z |
5491084 | 5491084 | 20241106015112_m5J8F | RO0002 | 2024-11-07T14:15:17.725Z | 2024-11-09T14:20:03.832Z |
5490969 | 5490969 | 20241106012530_tZBVT | RO0002 | 2024-11-07T14:15:08.905Z | 2024-11-09T14:20:02.493Z |
5490890 | 5490890 | 20241106010612_PnHms | RO0002 | 2024-11-07T14:15:03.076Z | 2024-11-09T14:20:01.022Z |
5490855 | 5490855 | 20241106005602_ulKTB | RO0002 | 2024-11-07T14:15:00.059Z | 2024-11-09T14:20:00.400Z |
5490786 | 5490786 | 20241106003600_dED3P | RO0002 | 2024-11-07T14:14:55.627Z | 2024-11-09T14:19:59.570Z |
5490739 | 5490739 | 20241106002557_foLNj | RO0002 | 2024-11-07T14:14:46.043Z | 2024-11-09T14:19:59.031Z |
5490735 | 5490735 | 20241106002525_UaNOh | RO0002 | 2024-11-07T14:14:44.713Z | 2024-11-09T14:19:59.029Z |
5490701 | 5490701 | 20241106001247_yRAEB | RO0002 | 2024-11-07T14:14:34.548Z | 2024-11-09T14:19:58.656Z |
5490694 | 5490694 | 20241106001056_vT0pp | RO0002 | 2024-11-07T14:14:33.383Z | 2024-11-09T14:19:58.580Z |
5490610 | 5490610 | 20241105233719_1UI7k | RO0002 | 2024-11-07T14:14:17.712Z | 2024-11-09T14:19:57.297Z |
5490569 | 5490569 | 20241105232845_V1x6V | RO0002 | 2024-11-07T14:14:13.595Z | 2024-11-09T14:19:56.984Z |
5490456 | 5490456 | 20241105225445_j7Zc3 | RO0002 | 2024-11-07T14:14:03.242Z | 2024-11-09T14:19:55.799Z |
5490439 | 5490439 | 20241105224720_MeONe | RO0002 | 2024-11-07T14:14:01.521Z | 2024-11-09T14:19:55.501Z |
5490354 | 5490354 | 20241105222014_Tp2GG | RO0002 | 2024-11-07T14:13:54.820Z | 2024-11-09T14:19:54.065Z |
5490333 | 5490333 | 20241105221505_2qtHa | RO0002 | 2024-11-07T14:13:53.272Z | 2024-11-09T14:19:53.912Z |
5490255 | 5490255 | 20241105214835_NATrX | RO0002 | 2024-11-07T14:13:45.698Z | 2024-11-09T14:19:53.203Z |
5490177 | 5490177 | 20241105213212_MH0s2 | RO0002 | 2024-11-07T14:13:30.284Z | 2024-11-09T14:19:51.754Z |
5490129 | 5490129 | 20241105211433_LsgMg | RO0002 | 2024-11-07T14:13:16.407Z | 2024-11-09T14:19:51.139Z |
5489976 | 5489976 | 20241105203707_jS764 | RO0002 | 2024-11-07T14:12:58.870Z | 2024-11-09T14:19:49.620Z |
5489924 | 5489924 | 20241105202826_jWMIa | RO0002 | 2024-11-07T14:12:55.344Z | 2024-11-09T14:19:49.094Z |
5489859 | 5489859 | 20241105202016_Fkcj0 | RO0002 | 2024-11-07T14:12:50.441Z | 2024-11-09T14:19:47.211Z |
5489847 | 5489847 | 20241105201708_lGczk | RO0002 | 2024-11-07T14:12:49.812Z | 2024-11-09T14:19:47.139Z |
5489304 | 5489304 | 20241105183339_3Lhzc | RO0002 | 2024-11-07T14:11:52.098Z | 2024-11-09T14:19:41.123Z |
5489225 | 5489225 | 20241105181108_13QAG | RO0002 | 2024-11-07T14:11:33.065Z | 2024-11-09T14:19:39.381Z |
5489167 | 5489167 | 20241105175942_5WT41 | RO0002 | 2024-11-07T14:11:24.196Z | 2024-11-09T14:19:37.774Z |
5488948 | 5488948 | 20241105172416_7He8F | RO0002 | 2024-11-07T14:11:04.854Z | 2024-11-09T14:19:34.499Z |
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);