participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,541 rows where station_code = "NZ002V" 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 |
---|---|---|---|---|---|
5597625 | 5597625 | 20241124155322_Sg6Z2 | NZ002V | 2024-11-25T14:11:45.296Z | 2024-11-26T14:18:44.631Z |
5597280 | 5597280 | 20241124151522_3YXct | NZ002V | 2024-11-25T14:11:20.635Z | 2024-11-26T14:18:44.572Z |
5597140 | 5597140 | 20241124150654_3JkZR | NZ002V | 2024-11-25T14:11:11.259Z | 2024-11-26T14:18:44.551Z |
5597007 | 5597007 | 20241124145355_crpat | NZ002V | 2024-11-25T14:10:57.056Z | 2024-11-26T14:18:44.532Z |
5596995 | 5596995 | 20241124145312_xho0i | NZ002V | 2024-11-25T14:10:56.087Z | 2024-11-26T14:18:44.531Z |
5596929 | 5596929 | 20241124144557_qo1QN | NZ002V | 2024-11-25T14:10:48.435Z | 2024-11-26T14:18:44.511Z |
5596764 | 5596764 | 20241124142339_iqXtH | NZ002V | 2024-11-25T14:10:33.085Z | 2024-11-26T14:18:44.476Z |
5596562 | 5596562 | 20241124140427_qc7VQ | NZ002V | 2024-11-25T14:10:19.739Z | 2024-11-26T14:18:44.447Z |
5596045 | 5596045 | 20241124131021_l2kEm | NZ002V | 2024-11-25T14:09:24.989Z | 2024-11-26T14:18:44.366Z |
5595754 | 5595754 | 20241124124625_C96zJ | NZ002V | 2024-11-25T14:08:50.742Z | 2024-11-26T14:18:44.320Z |
5595712 | 5595712 | 20241124124421_qdva6 | NZ002V | 2024-11-25T14:08:47.187Z | 2024-11-26T14:18:44.314Z |
5595153 | 5595153 | 20241124114807_e2DRi | NZ002V | 2024-11-25T14:07:40.255Z | 2024-11-26T14:18:44.216Z |
5595067 | 5595067 | 20241124113803_l9t6v | NZ002V | 2024-11-25T14:07:18.421Z | 2024-11-26T14:18:44.200Z |
5595033 | 5595033 | 20241124113421_TQP6U | NZ002V | 2024-11-25T14:07:09.584Z | 2024-11-26T14:18:44.194Z |
5594829 | 5594829 | 20241124110843_krXXP | NZ002V | 2024-11-25T14:06:38.498Z | 2024-11-26T14:18:44.154Z |
5593713 | 5593713 | 20241124083359_O2X52 | NZ002V | 2024-11-25T14:03:30.425Z | 2024-11-26T14:18:43.928Z |
5583823 | 5583823 | 20241118154838_4ugrY | NZ002V | 2024-11-23T14:25:03.608Z | 2024-11-26T14:28:09.229Z |
5577246 | 5577246 | 20241121131445_EnBQn | NZ002V | 2024-11-23T14:14:24.498Z | 2024-11-26T14:24:30.283Z |
5569515 | 5569515 | 20241121154711_K38Ic | NZ002V | 2024-11-22T14:11:00.614Z | 2024-11-26T14:24:34.865Z |
5569488 | 5569488 | 20241121154158_sr2sT | NZ002V | 2024-11-22T14:10:58.370Z | 2024-11-26T14:24:34.781Z |
5569423 | 5569423 | 20241121152627_YPFUx | NZ002V | 2024-11-22T14:10:51.914Z | 2024-11-26T14:24:34.282Z |
5569271 | 5569271 | 20241121150353_T3ogZ | NZ002V | 2024-11-22T14:10:43.379Z | 2024-11-26T14:24:33.507Z |
5569147 | 5569147 | 20241121144130_KdzVi | NZ002V | 2024-11-22T14:10:24.193Z | 2024-11-26T14:24:32.941Z |
5569144 | 5569144 | 20241121144108_3nM2T | NZ002V | 2024-11-22T14:10:23.867Z | 2024-11-26T14:24:32.885Z |
5569118 | 5569118 | 20241121143808_FthPx | NZ002V | 2024-11-22T14:10:22.160Z | 2024-11-26T14:24:32.828Z |
5568918 | 5568918 | 20241121140408_rP7aL | NZ002V | 2024-11-22T14:10:04.338Z | 2024-11-26T14:24:31.548Z |
5568778 | 5568778 | 20241121133209_d87k5 | NZ002V | 2024-11-22T14:09:41.744Z | 2024-11-26T14:24:30.852Z |
5568758 | 5568758 | 20241121133044_KvoHH | NZ002V | 2024-11-22T14:09:40.370Z | 2024-11-26T14:24:30.839Z |
5568754 | 5568754 | 20241121132955_wLXjP | NZ002V | 2024-11-22T14:09:40.081Z | 2024-11-26T14:24:30.814Z |
5568716 | 5568716 | 20241121132644_aaRQg | NZ002V | 2024-11-22T14:09:36.261Z | 2024-11-26T14:24:30.763Z |
5568404 | 5568404 | 20241121124153_JHc2N | NZ002V | 2024-11-22T14:08:52.356Z | 2024-11-26T14:24:27.821Z |
5568006 | 5568006 | 20241121114127_DLA3O | NZ002V | 2024-11-22T14:07:56.663Z | 2024-11-26T14:24:24.000Z |
5567700 | 5567700 | 20241121105305_BLiJi | NZ002V | 2024-11-22T14:07:04.507Z | 2024-11-26T14:24:20.703Z |
5567290 | 5567290 | 20241121095823_QgWzV | NZ002V | 2024-11-22T14:05:46.703Z | 2024-11-26T14:24:14.779Z |
5567215 | 5567215 | 20241121094252_52OnX | NZ002V | 2024-11-22T14:05:35.634Z | 2024-11-26T14:24:14.068Z |
5567093 | 5567093 | 20241121092011_porC8 | NZ002V | 2024-11-22T14:05:10.476Z | 2024-11-26T14:24:12.490Z |
5560776 | 5560776 | 20241120142228_slr3e | NZ002V | 2024-11-21T14:09:44.316Z | 2024-11-26T14:26:07.744Z |
5560682 | 5560682 | 20241120135539_f7bgv | NZ002V | 2024-11-21T14:09:25.331Z | 2024-11-26T14:26:07.559Z |
5560635 | 5560635 | 20241120133535_CeYA0 | NZ002V | 2024-11-21T14:09:18.794Z | 2024-11-26T14:26:07.347Z |
5560598 | 5560598 | 20241120132030_29p92 | NZ002V | 2024-11-21T14:09:12.080Z | 2024-11-26T14:26:07.243Z |
5560593 | 5560593 | 20241120131926_cUx0B | NZ002V | 2024-11-21T14:09:10.996Z | 2024-11-26T14:26:07.221Z |
5560282 | 5560282 | 20241120123004_c2Lp2 | NZ002V | 2024-11-21T14:08:30.465Z | 2024-11-26T14:26:04.478Z |
5559150 | 5559150 | 20241120092959_BlUhT | NZ002V | 2024-11-21T14:05:29.170Z | 2024-11-26T14:25:53.165Z |
5551796 | 5551796 | 20241118151719_BSebL | NZ002V | 2024-11-19T14:05:32.406Z | 2024-11-26T14:28:08.557Z |
5551793 | 5551793 | 20241118151444_oSfdU | NZ002V | 2024-11-19T14:05:31.973Z | 2024-11-26T14:28:08.552Z |
5551766 | 5551766 | 20241118150759_YATvY | NZ002V | 2024-11-19T14:05:27.099Z | 2024-11-26T14:28:08.524Z |
5551675 | 5551675 | 20241118144128_85XvK | NZ002V | 2024-11-19T14:05:10.884Z | 2024-11-26T14:28:08.380Z |
5551483 | 5551483 | 20241118135524_hS1De | NZ002V | 2024-11-19T14:04:52.143Z | 2024-11-26T14:28:08.137Z |
5551385 | 5551385 | 20241118132009_JmGGm | NZ002V | 2024-11-19T14:04:42.904Z | 2024-11-26T14:28:07.885Z |
5551064 | 5551064 | 20241118121759_34X1p | NZ002V | 2024-11-19T14:03:51.807Z | 2024-11-26T14:28:05.538Z |
5551040 | 5551040 | 20241118121334_I8L3z | NZ002V | 2024-11-19T14:03:49.344Z | 2024-11-26T14:28:05.495Z |
5550775 | 5550775 | 20241118112412_zxlnY | NZ002V | 2024-11-19T14:03:04.790Z | 2024-11-26T14:28:04.040Z |
5550723 | 5550723 | 20241118111524_Uc36n | NZ002V | 2024-11-19T14:02:58.699Z | 2024-11-26T14:28:03.789Z |
5550383 | 5550383 | 20241118101124_sy9bb | NZ002V | 2024-11-19T14:02:16.209Z | 2024-11-26T14:28:01.482Z |
5550184 | 5550184 | 20241118094412_07H6l | NZ002V | 2024-11-19T14:01:43.131Z | 2024-11-26T14:28:01.038Z |
5549863 | 5549863 | 20241118082106_d3o5Z | NZ002V | 2024-11-19T14:01:01.198Z | 2024-11-26T14:27:59.012Z |
5547380 | 5547380 | 20241117155359_Fz7D0 | NZ002V | 2024-11-18T14:05:38.055Z | 2024-11-26T14:28:38.569Z |
5546986 | 5546986 | 20241117140022_KrGxb | NZ002V | 2024-11-18T14:04:39.675Z | 2024-11-26T14:28:34.918Z |
5546396 | 5546396 | 20241117104244_cZbB5 | NZ002V | 2024-11-18T14:03:00.554Z | 2024-11-26T14:28:28.461Z |
5544270 | 5544270 | 20241116092648_aUImH | NZ002V | 2024-11-17T14:00:42.878Z | 2024-11-25T14:22:37.855Z |
5520070 | 5520070 | 20241111143041_SsTzQ | NZ002V | 2024-11-12T14:05:32.933Z | 2024-11-20T14:25:03.042Z |
5519996 | 5519996 | 20241111141408_vWhDI | NZ002V | 2024-11-12T14:05:26.603Z | 2024-11-20T14:25:01.528Z |
5519990 | 5519990 | 20241111141201_YyC2t | NZ002V | 2024-11-12T14:05:25.899Z | 2024-11-20T14:25:01.484Z |
5519881 | 5519881 | 20241111134512_6wJkS | NZ002V | 2024-11-12T14:05:16.247Z | 2024-11-20T14:25:00.431Z |
5514462 | 5514462 | 20241110160743_6o25B | NZ002V | 2024-11-11T14:06:42.612Z | 2024-11-19T14:21:48.847Z |
5514203 | 5514203 | 20241110150639_u5WZU | NZ002V | 2024-11-11T14:06:20.361Z | 2024-11-19T14:21:44.857Z |
5514168 | 5514168 | 20241110145627_AoPiR | NZ002V | 2024-11-11T14:06:17.993Z | 2024-11-19T14:21:44.613Z |
5508082 | 5508082 | 20241109141636_JDSsw | NZ002V | 2024-11-10T14:06:53.159Z | 2024-11-18T14:26:18.707Z |
5500474 | 5500474 | 20241108154912_Yjx3g | NZ002V | 2024-11-09T14:06:20.145Z | 2024-11-17T14:23:22.863Z |
5500469 | 5500469 | 20241108154912_MDEMC | NZ002V | 2024-11-09T14:06:19.536Z | 2024-11-17T14:23:22.862Z |
5500316 | 5500316 | 20241108151843_bycYs | NZ002V | 2024-11-09T14:06:06.252Z | 2024-11-17T14:23:21.509Z |
5500279 | 5500279 | 20241108151056_QrFJv | NZ002V | 2024-11-09T14:06:03.359Z | 2024-11-17T14:23:21.044Z |
5500274 | 5500274 | 20241108150938_cO16p | NZ002V | 2024-11-09T14:06:02.824Z | 2024-11-17T14:23:21.025Z |
5500041 | 5500041 | 20241108143245_IyHQp | NZ002V | 2024-11-09T14:05:34.356Z | 2024-11-17T14:23:18.226Z |
5500013 | 5500013 | 20241108142336_xlP9S | NZ002V | 2024-11-09T14:05:30.005Z | 2024-11-17T14:23:17.971Z |
5499983 | 5499983 | 20241108141909_VdhTt | NZ002V | 2024-11-09T14:05:27.351Z | 2024-11-17T14:23:17.863Z |
5499960 | 5499960 | 20241108141445_e6ZFo | NZ002V | 2024-11-09T14:05:24.278Z | 2024-11-17T14:23:17.649Z |
5499957 | 5499957 | 20241108141359_Hhidz | NZ002V | 2024-11-09T14:05:24.025Z | 2024-11-17T14:23:17.602Z |
5499941 | 5499941 | 20241108141107_g0489 | NZ002V | 2024-11-09T14:05:22.156Z | 2024-11-17T14:23:17.439Z |
5499915 | 5499915 | 20241108140146_81qPd | NZ002V | 2024-11-09T14:05:19.421Z | 2024-11-17T14:23:17.138Z |
5499898 | 5499898 | 20241108135900_Dxrrk | NZ002V | 2024-11-09T14:05:14.424Z | 2024-11-17T14:23:16.923Z |
5499846 | 5499846 | 20241108134628_9HaLM | NZ002V | 2024-11-09T14:05:03.494Z | 2024-11-17T14:23:16.430Z |
5499835 | 5499835 | 20241108134410_kp0RQ | NZ002V | 2024-11-09T14:05:02.877Z | 2024-11-17T14:23:16.363Z |
5499772 | 5499772 | 20241108132136_Fvfbc | NZ002V | 2024-11-09T14:04:56.516Z | 2024-11-17T14:23:15.938Z |
5499654 | 5499654 | 20241108125219_rYIST | NZ002V | 2024-11-09T14:04:34.640Z | 2024-11-17T14:23:14.198Z |
5499412 | 5499412 | 20241108121657_4y38O | NZ002V | 2024-11-09T14:04:03.769Z | 2024-11-17T14:23:11.481Z |
5499376 | 5499376 | 20241108120625_bN3DU | NZ002V | 2024-11-09T14:03:53.764Z | 2024-11-17T14:23:10.570Z |
5499053 | 5499053 | 20241108105437_0waIM | NZ002V | 2024-11-09T14:03:03.402Z | 2024-11-17T14:23:04.402Z |
5498970 | 5498970 | 20241108103647_sdGPw | NZ002V | 2024-11-09T14:02:53.429Z | 2024-11-17T14:23:02.882Z |
5498788 | 5498788 | 20241108095952_N32bO | NZ002V | 2024-11-09T14:02:24.987Z | 2024-11-17T14:22:59.921Z |
5498585 | 5498585 | 20241108091412_wq2Ak | NZ002V | 2024-11-09T14:01:52.735Z | 2024-11-17T14:22:58.108Z |
5498312 | 5498312 | 20241108080130_i45l2 | NZ002V | 2024-11-09T14:01:07.209Z | 2024-11-17T14:22:52.792Z |
5494149 | 5494149 | 20241107160442_dPsDj | NZ002V | 2024-11-08T14:05:26.474Z | 2024-11-16T14:27:48.578Z |
5494144 | 5494144 | 20241107160222_Gzird | NZ002V | 2024-11-08T14:05:26.276Z | 2024-11-16T14:27:48.415Z |
5494140 | 5494140 | 20241107154723_HjuG7 | NZ002V | 2024-11-08T14:05:25.691Z | 2024-11-16T14:27:48.294Z |
5494095 | 5494095 | 20241107153437_MNWud | NZ002V | 2024-11-08T14:05:22.259Z | 2024-11-16T14:27:46.871Z |
5494083 | 5494083 | 20241107153205_2AS3k | NZ002V | 2024-11-08T14:05:21.297Z | 2024-11-16T14:27:46.673Z |
5487281 | 5487281 | 20241106153034_72HiM | NZ002V | 2024-11-07T14:05:27.577Z | 2024-11-15T14:24:38.856Z |
5487066 | 5487066 | 20241106143936_s8lN7 | NZ002V | 2024-11-07T14:04:54.486Z | 2024-11-15T14:24:36.987Z |
5480719 | 5480719 | 20241105150800_Ki1JQ | NZ002V | 2024-11-06T14:06:24.632Z | 2024-11-14T14:23:05.793Z |
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);