participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
428 rows where station_code = "AU0001" 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 |
---|---|---|---|---|---|
5310422 | 5310422 | 20241014164541_vbkzh | AU0001 | 2024-10-16T12:06:54.331Z | 2024-10-18T12:09:35.493Z |
5299312 | 5299312 | 20241012183152_R6dzw | AU0001 | 2024-10-14T12:12:09.303Z | 2024-10-18T12:15:38.140Z |
5298963 | 5298963 | 20241012174025_9T79r | AU0001 | 2024-10-14T12:11:22.288Z | 2024-10-18T12:15:26.049Z |
5298626 | 5298626 | 20241012164831_EgI0L | AU0001 | 2024-10-14T12:10:56.699Z | 2024-10-18T12:15:20.854Z |
5298590 | 5298590 | 20241012164249_Sb2iS | AU0001 | 2024-10-14T12:10:51.159Z | 2024-10-18T12:15:20.284Z |
5273671 | 5273671 | 20241009181056_xh69y | AU0001 | 2024-10-11T12:12:57.818Z | 2024-10-18T12:22:03.713Z |
5273418 | 5273418 | 20241009172349_d4a0o | AU0001 | 2024-10-11T12:12:24.686Z | 2024-10-18T12:22:01.593Z |
5273259 | 5273259 | 20241009164747_3opZM | AU0001 | 2024-10-11T12:12:10.682Z | 2024-10-18T12:22:00.665Z |
5272984 | 5272984 | 20241009160258_6hdcy | AU0001 | 2024-10-11T12:11:49.478Z | 2024-10-18T12:21:59.200Z |
5272816 | 5272816 | 20241009152841_Gwo11 | AU0001 | 2024-10-11T12:11:25.948Z | 2024-10-18T12:21:58.424Z |
5272133 | 5272133 | 20241009131405_QHcHx | AU0001 | 2024-10-11T12:10:11.089Z | 2024-10-18T12:21:54.801Z |
5272067 | 5272067 | 20241009125731_QgWWH | AU0001 | 2024-10-11T12:09:55.587Z | 2024-10-18T12:21:54.439Z |
5267012 | 5267012 | 20241008182429_i1d86 | AU0001 | 2024-10-10T12:13:13.843Z | 2024-10-17T12:20:07.853Z |
5266970 | 5266970 | 20241008180753_v8buB | AU0001 | 2024-10-10T12:13:08.693Z | 2024-10-17T12:20:07.731Z |
5266896 | 5266896 | 20241008174108_PZ8oE | AU0001 | 2024-10-10T12:12:58.882Z | 2024-10-17T12:20:07.487Z |
5266892 | 5266892 | 20241008174057_pxJgb | AU0001 | 2024-10-10T12:12:58.347Z | 2024-10-17T12:20:07.480Z |
5266862 | 5266862 | 20241008172933_jTSYe | AU0001 | 2024-10-10T12:12:54.221Z | 2024-10-17T12:20:07.307Z |
5266616 | 5266616 | 20241008160507_CVgvF | AU0001 | 2024-10-10T12:12:17.235Z | 2024-10-17T12:20:05.548Z |
5266477 | 5266477 | 20241008152010_Xwgqy | AU0001 | 2024-10-10T12:11:52.102Z | 2024-10-17T12:20:04.665Z |
5266212 | 5266212 | 20241008134223_Amuu3 | AU0001 | 2024-10-10T12:11:30.391Z | 2024-10-17T12:20:03.024Z |
5266154 | 5266154 | 20241008131712_36rTE | AU0001 | 2024-10-10T12:11:25.302Z | 2024-10-17T12:20:02.940Z |
5265996 | 5265996 | 20241008121701_FHuI2 | AU0001 | 2024-10-10T12:10:50.909Z | 2024-10-17T12:20:02.585Z |
5265987 | 5265987 | 20241008120604_4aAFd | AU0001 | 2024-10-10T12:10:47.177Z | 2024-10-17T12:20:02.379Z |
5260642 | 5260642 | 20241007170616_hXKSv | AU0001 | 2024-10-09T12:12:47.217Z | 2024-10-16T12:21:11.698Z |
5260357 | 5260357 | 20241007161334_AkPPN | AU0001 | 2024-10-09T12:12:24.665Z | 2024-10-16T12:21:11.163Z |
5232597 | 5232597 | 20241004172348_OvPfJ | AU0001 | 2024-10-06T12:12:06.637Z | 2024-10-13T12:26:19.440Z |
5232371 | 5232371 | 20241004164743_Md0GQ | AU0001 | 2024-10-06T12:11:51.992Z | 2024-10-13T12:26:19.074Z |
5232243 | 5232243 | 20241004163242_r9vwo | AU0001 | 2024-10-06T12:11:38.345Z | 2024-10-13T12:26:18.950Z |
5221720 | 5221720 | 20241003110057_WApZq | AU0001 | 2024-10-05T12:14:25.942Z | 2024-10-12T12:25:02.313Z |
5209690 | 5209690 | 20241001164038_p79ee | AU0001 | 2024-10-03T12:13:39.788Z | 2024-10-10T12:24:43.646Z |
5208981 | 5208981 | 20241002185023_3uCF4 | AU0001 | 2024-10-03T12:09:38.478Z | 2024-10-11T12:23:31.057Z |
5208912 | 5208912 | 20241002181152_22HVa | AU0001 | 2024-10-03T12:09:32.597Z | 2024-10-11T12:23:30.681Z |
5208793 | 5208793 | 20241002171400_LabjP | AU0001 | 2024-10-03T12:09:12.164Z | 2024-10-11T12:23:30.474Z |
5208583 | 5208583 | 20241002143221_us6K6 | AU0001 | 2024-10-03T12:08:42.972Z | 2024-10-11T12:23:30.059Z |
5197943 | 5197943 | 20240929163314_2JzER | AU0001 | 2024-10-01T12:14:02.685Z | 2024-10-07T12:21:30.194Z |
5197110 | 5197110 | 20240930183404_NO0E2 | AU0001 | 2024-10-01T12:09:18.833Z | 2024-10-09T12:29:12.135Z |
5197090 | 5197090 | 20240930162308_tN4BV | AU0001 | 2024-10-01T12:09:13.043Z | 2024-10-09T12:29:08.483Z |
5148961 | 5148961 | 20240922125240_35n1W | AU0001 | 2024-09-23T12:07:37.114Z | 2024-09-30T12:22:47.398Z |
5071838 | 5071838 | 20240911183407_4tQJS | AU0001 | 2024-09-15T12:03:48.962Z | 2024-09-20T12:21:23.426Z |
5059872 | 5059872 | 20240910191103_oNaa3 | AU0001 | 2024-09-14T12:07:29.357Z | 2024-09-19T12:21:31.339Z |
5051967 | 5051967 | 20240907191634_zg5LR | AU0001 | 2024-09-13T12:14:50.750Z | 2024-09-16T12:21:02.633Z |
5051952 | 5051952 | 20240907191412_NzSZW | AU0001 | 2024-09-13T12:14:49.775Z | 2024-09-16T12:21:02.604Z |
5051849 | 5051849 | 20240907185331_6HBil | AU0001 | 2024-09-13T12:14:37.911Z | 2024-09-16T12:21:02.148Z |
5051511 | 5051511 | 20240907173815_7mSGz | AU0001 | 2024-09-13T12:14:21.457Z | 2024-09-16T12:21:00.643Z |
5051411 | 5051411 | 20240907172526_qQxd8 | AU0001 | 2024-09-13T12:14:13.589Z | 2024-09-16T12:21:00.377Z |
5050848 | 5050848 | 20240907161555_kryJX | AU0001 | 2024-09-13T12:13:48.690Z | 2024-09-16T12:20:58.781Z |
5050827 | 5050827 | 20240907161334_wUqu3 | AU0001 | 2024-09-13T12:13:47.912Z | 2024-09-16T12:20:58.727Z |
5050634 | 5050634 | 20240907155051_Qg1BK | AU0001 | 2024-09-13T12:13:41.424Z | 2024-09-16T12:20:58.186Z |
5050569 | 5050569 | 20240907154134_K3xKL | AU0001 | 2024-09-13T12:13:37.228Z | 2024-09-16T12:20:58.014Z |
5050452 | 5050452 | 20240907152232_wk5Gk | AU0001 | 2024-09-13T12:13:32.420Z | 2024-09-16T12:20:57.724Z |
5050377 | 5050377 | 20240907151553_MDSQ3 | AU0001 | 2024-09-13T12:13:29.388Z | 2024-09-16T12:20:57.409Z |
5030768 | 5030768 | 20240906183125_AhJY3 | AU0001 | 2024-09-12T12:03:02.385Z | 2024-09-15T12:21:19.603Z |
5030752 | 5030752 | 20240906182215_R0wgX | AU0001 | 2024-09-12T12:02:56.154Z | 2024-09-15T12:21:19.549Z |
5006694 | 5006694 | 20240903182809_cBMP2 | AU0001 | 2024-09-09T12:04:55.627Z | 2024-09-12T12:19:09.248Z |
4987872 | 4987872 | 20240901190944_p3C2A | AU0001 | 2024-09-07T12:06:25.944Z | 2024-09-10T12:19:11.764Z |
4984987 | 4984987 | 20240901111555_mUQDW | AU0001 | 2024-09-07T12:02:41.976Z | 2024-09-10T12:19:06.735Z |
4963110 | 4963110 | 20240811194507_osueg | AU0001 | 2024-09-04T12:05:11.853Z | 2024-09-06T12:04:18.775Z |
4962052 | 4962052 | 20240811183238_sW86M | AU0001 | 2024-09-04T12:04:14.029Z | 2024-09-06T12:03:26.027Z |
4962032 | 4962032 | 20240811182938_3Vm3A | AU0001 | 2024-09-04T12:04:12.862Z | 2024-09-06T12:03:25.011Z |
4961206 | 4961206 | 20240811172406_y6BkD | AU0001 | 2024-09-04T12:03:22.876Z | 2024-09-06T12:02:47.585Z |
4961118 | 4961118 | 20240811171829_BQmvK | AU0001 | 2024-09-04T12:03:18.296Z | 2024-09-06T12:02:44.263Z |
4960339 | 4960339 | 20240811161715_KRbNv | AU0001 | 2024-09-04T12:02:26.864Z | 2024-09-06T12:02:04.273Z |
4951935 | 4951935 | 20240811144713_A8ZyL | AU0001 | 2024-09-03T12:01:37.953Z | 2024-09-06T12:01:07.511Z |
4951244 | 4951244 | 20240811132148_qurAz | AU0001 | 2024-09-03T12:00:43.892Z | 2024-09-06T12:00:33.220Z |
4950947 | 4950947 | 20240811124444_FR8xu | AU0001 | 2024-09-03T12:00:11.519Z | 2024-09-06T12:00:11.142Z |
4934714 | 4934714 | 20240810185153_M2CNM | AU0001 | 2024-09-01T12:05:42.011Z | 2024-09-06T12:20:18.896Z |
4934707 | 4934707 | 20240810185129_AZGOU | AU0001 | 2024-09-01T12:05:40.620Z | 2024-09-06T12:20:18.700Z |
4934610 | 4934610 | 20240810183846_yPWS8 | AU0001 | 2024-09-01T12:05:35.222Z | 2024-09-06T12:20:16.469Z |
4934590 | 4934590 | 20240810183629_hHTsO | AU0001 | 2024-09-01T12:05:33.372Z | 2024-09-06T12:20:15.894Z |
4934414 | 4934414 | 20240810181149_5i3X0 | AU0001 | 2024-09-01T12:05:18.279Z | 2024-09-06T12:20:11.382Z |
4934350 | 4934350 | 20240810180714_7SVLw | AU0001 | 2024-09-01T12:05:12.347Z | 2024-09-06T12:20:09.615Z |
4933943 | 4933943 | 20240810173453_OHG9u | AU0001 | 2024-09-01T12:04:47.401Z | 2024-09-06T12:19:43.725Z |
4933213 | 4933213 | 20240810164849_xP3MX | AU0001 | 2024-09-01T12:04:03.529Z | 2024-09-06T12:19:01.910Z |
4933194 | 4933194 | 20240810164822_GAtYC | AU0001 | 2024-09-01T12:04:02.245Z | 2024-09-06T12:19:01.345Z |
4932855 | 4932855 | 20240810162405_QSANJ | AU0001 | 2024-09-01T12:03:44.991Z | 2024-09-06T12:18:49.755Z |
4932818 | 4932818 | 20240810162146_pYuea | AU0001 | 2024-09-01T12:03:41.317Z | 2024-09-06T12:18:48.853Z |
4932502 | 4932502 | 20240810160308_eG0Wf | AU0001 | 2024-09-01T12:03:25.122Z | 2024-09-06T12:18:40.670Z |
4924868 | 4924868 | 20240810141852_5ngvf | AU0001 | 2024-08-31T12:02:37.884Z | 2024-09-06T12:17:14.595Z |
4861686 | 4861686 | 20240806114908_EtWMM | AU0001 | 2024-08-18T12:03:51.058Z | 2024-08-27T12:03:44.259Z |
4861669 | 4861669 | 20240806114745_ez7H4 | AU0001 | 2024-08-18T12:03:50.053Z | 2024-08-27T12:03:43.149Z |
4850920 | 4850920 | 20240805201307_h2Jr3 | AU0001 | 2024-08-17T12:13:57.804Z | 2024-08-19T12:23:33.765Z |
4850789 | 4850789 | 20240805195358_24QU3 | AU0001 | 2024-08-17T12:13:41.882Z | 2024-08-19T12:23:24.680Z |
4850761 | 4850761 | 20240805195157_vqwHj | AU0001 | 2024-08-17T12:13:39.818Z | 2024-08-19T12:23:23.663Z |
4850665 | 4850665 | 20240805193525_cz9WP | AU0001 | 2024-08-17T12:13:32.326Z | 2024-08-19T12:23:17.530Z |
4850413 | 4850413 | 20240805185311_4TZEJ | AU0001 | 2024-08-17T12:13:05.877Z | 2024-08-19T12:23:02.192Z |
4850274 | 4850274 | 20240805183633_wj9gx | AU0001 | 2024-08-17T12:12:51.064Z | 2024-08-19T12:22:54.386Z |
4850223 | 4850223 | 20240805183200_2lGYq | AU0001 | 2024-08-17T12:12:45.193Z | 2024-08-19T12:22:51.621Z |
4850153 | 4850153 | 20240805182814_TBwAt | AU0001 | 2024-08-17T12:12:40.621Z | 2024-08-19T12:22:46.815Z |
4849540 | 4849540 | 20240805175327_Sx3JM | AU0001 | 2024-08-17T12:11:55.364Z | 2024-08-19T12:22:20.498Z |
4848893 | 4848893 | 20240805172608_UQ44f | AU0001 | 2024-08-17T12:11:03.120Z | 2024-08-19T12:21:45.781Z |
4848741 | 4848741 | 20240805171959_sS3Kt | AU0001 | 2024-08-17T12:10:54.952Z | 2024-08-19T12:21:39.902Z |
4847014 | 4847014 | 20240805163709_RM9HA | AU0001 | 2024-08-16T12:10:44.127Z | 2024-08-19T12:21:04.146Z |
4846638 | 4846638 | 20240805162203_r73vw | AU0001 | 2024-08-16T12:10:27.346Z | 2024-08-19T12:20:57.699Z |
4846038 | 4846038 | 20240805155957_nf1Ws | AU0001 | 2024-08-16T12:09:46.279Z | 2024-08-19T12:20:45.952Z |
4845921 | 4845921 | 20240805155501_B5RaL | AU0001 | 2024-08-16T12:09:38.113Z | 2024-08-19T12:20:39.586Z |
4844797 | 4844797 | 20240805151358_jF2z3 | AU0001 | 2024-08-16T12:08:37.380Z | 2024-08-19T12:19:49.451Z |
4844726 | 4844726 | 20240805151038_3yQLx | AU0001 | 2024-08-16T12:08:34.289Z | 2024-08-19T12:19:46.466Z |
4844632 | 4844632 | 20240805150840_ovAnv | AU0001 | 2024-08-16T12:08:30.248Z | 2024-08-19T12:19:41.673Z |
4844195 | 4844195 | 20240805145509_x2SUZ | AU0001 | 2024-08-16T12:07:57.212Z | 2024-08-19T12:19:21.456Z |
4842674 | 4842674 | 20240805134721_UTtYW | AU0001 | 2024-08-16T12:06:38.375Z | 2024-08-19T12:18:36.845Z |
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);