TapewireFind a company

person · Reporting owner

Coles Joanna

Disclosed activity across 6 companies

Tapewire entity
24503
SEC CIK
0001699323

Export transaction history ↓

Reported relationships

Latest disclosed role at each company.

CompanyLast reported asReport datePublished
Snap IncSNAP · Entity 3584DirectorAugust 07, 2026August 11, 2026
Sonos IncSONO · Entity 1773DirectorMarch 05, 2026March 06, 2026

Disclosed balances

About these balances

Latest available filing per company, not a reconstructed current portfolio. Matching sequences show the last reported balance with all source rows expandable; grouping alone does not establish account ownership. Do not add unresolved positions together. Filings may omit unchanged positions, and amendments may correct only part of an older disclosure. Jointly reported shares are not necessarily this owner's personal holdings.

Snap Inc

Report date August 07, 2026 · Filed August 11, 2026

Security / awardOwnership accountDisclosed shares / unitsDisclosure context
Class A Common StockSEC Table I · non-derivativeDirect132,854 Reported balance After 2026-08-07 transaction · row 1
1 source row

Row 1 · 2026-08-07 · Grant · Acquired 46,905 · Balance 132,854

F1: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from August 1, 2026. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately. The settlement of such RSUs will be deferred until the earlier of a) the 90th day following the reporting person's separation from service from the Issuer (as defined under Treasury Regulations Section 1.409A-1(h)) or b) a change in control.

Filing footnotes · ownership attribution and instrument terms

F1: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from August 1, 2026. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately. The settlement of such RSUs will be deferred until the earlier of a) the 90th day following the reporting person's separation from service from the Issuer (as defined under Treasury Regulations Section 1.409A-1(h)) or b) a change in control.

Sonos Inc

Report date March 05, 2026 · Filed March 06, 2026

Security / awardOwnership accountDisclosed shares / unitsDisclosure context
Common StockSEC Table I · non-derivativeDirect48,196 Reported balance After 2026-03-05 transaction · row 1
1 source row

Row 1 · 2026-03-05 · Grant · Acquired 12,725 · Balance 48,196

F1: Represents the number of shares subject to restricted stock units ("RSUs") that were granted on March 5, 2026.

F2: The RSUs will vest in full upon the earlier of March 5, 2027 or the next annual meeting of stockholders, subject to the continuing service of the Reporting Person on the vesting date.

F3: Each RSU represents a contingent right to receive 1 share of the Issuer's Common Stock upon vesting and settlement for no consideration.

Filing footnotes · ownership attribution and instrument terms

F1: Represents the number of shares subject to restricted stock units ("RSUs") that were granted on March 5, 2026.

F2: The RSUs will vest in full upon the earlier of March 5, 2027 or the next annual meeting of stockholders, subject to the continuing service of the Reporting Person on the vesting date.

F3: Each RSU represents a contingent right to receive 1 share of the Issuer's Common Stock upon vesting and settlement for no consideration.

Past disclosures · reporting ended (4)

No longer tracked through insider filings. These historical balances do not imply present ownership or a zero position.

Bark, Inc.

Report date August 16, 2023 · Filed August 18, 2023

Section 16 reporting ended · disclosed 2023-08-18. Current position is not established by this disclosure.

Security / awardOwnership accountDisclosed shares / unitsDisclosure context
Common StockSEC Table I · non-derivativeDirect372,726 Ending reported balance After 2023-08-16 transaction · row 2
2 source rows · reconciled sequence

Row 1 · 2023-08-16 · Disposition to issuer · Disposed 36,363 · Balance 336,363

F1: On August 16, 2023, the Reporting Person was granted 36,363 restricted stock units ("RSUs"), which immediately vested in full, as a replacement for the 36,363 restricted stock units ("RSUs") that were forfeited, pursuant to the terms of the RSU award agreement, upon the Reporting Person's resignation from the Issuer's board of directors. Each RSU represents a contingent right to receive one share of Common Stock for each RSU.

Row 2 · 2023-08-16 · Grant · Acquired 36,363 · Balance 372,726

F1: On August 16, 2023, the Reporting Person was granted 36,363 restricted stock units ("RSUs"), which immediately vested in full, as a replacement for the 36,363 restricted stock units ("RSUs") that were forfeited, pursuant to the terms of the RSU award agreement, upon the Reporting Person's resignation from the Issuer's board of directors. Each RSU represents a contingent right to receive one share of Common Stock for each RSU.

Filing footnotes · ownership attribution and instrument terms

F1: On August 16, 2023, the Reporting Person was granted 36,363 restricted stock units ("RSUs"), which immediately vested in full, as a replacement for the 36,363 restricted stock units ("RSUs") that were forfeited, pursuant to the terms of the RSU award agreement, upon the Reporting Person's resignation from the Issuer's board of directors. Each RSU represents a contingent right to receive one share of Common Stock for each RSU.

Northern Star Investment Corp. II

Report date May 12, 2023 · Filed June 14, 2023

Section 16 reporting ended · disclosed 2023-06-14. Current position is not established by this disclosure.

Security / awardOwnership accountDisclosed shares / unitsDisclosure context
Class A Common StockSEC Table I · non-derivativeIndirectby Northern Star II Sponsor LLC0 Reported balance After 2023-05-12 transaction · row 1 Account identity is unresolved; indirect or unspecified ownership is not merged.
1 source row

Row 1 · 2023-05-12 · Other · Disposed 9,708,334 · Balance 0

F1: As previously reported, the reporting person had been a managing member of Northern Star II Sponsor LLC ("NS2 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS2 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS2 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

WarrantsSEC Table II · derivative / convertible security · Conversion / exercise price $11.50Indirectby Northern Star II Sponsor LLC0 Reported balance After 2023-05-12 transaction · row 2 Instrument identity requires review; Table II rows are not merged.
1 source row

Row 2 · 2023-05-12 · Other · Disposed 8,750,000 · Balance 0

F1: As previously reported, the reporting person had been a managing member of Northern Star II Sponsor LLC ("NS2 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS2 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS2 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

F2: Each warrant will become exercisable 30 days after the completion of an initial business combination, and will expire five years after the completion of an initial business combination.

Filing footnotes · ownership attribution and instrument terms

F1: As previously reported, the reporting person had been a managing member of Northern Star II Sponsor LLC ("NS2 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS2 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS2 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

F2: Each warrant will become exercisable 30 days after the completion of an initial business combination, and will expire five years after the completion of an initial business combination.

Northern Star Investment Corp. III

Report date May 12, 2023 · Filed June 14, 2023

Section 16 reporting ended · disclosed 2023-06-14. Current position is not established by this disclosure.

Security / awardOwnership accountDisclosed shares / unitsDisclosure context
Class A Common StockSEC Table I · non-derivativeIndirectby Northern Star III Sponsor LLC0 Reported balance After 2023-05-12 transaction · row 1 Account identity is unresolved; indirect or unspecified ownership is not merged.
1 source row

Row 1 · 2023-05-12 · Other · Disposed 9,708,334 · Balance 0

F1: As previously reported, the reporting person had been a managing member of Northern Star III Sponsor LLC ("NS3 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS3 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS3 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

WarrantsSEC Table II · derivative / convertible security · Conversion / exercise price $11.50Indirectby Northern Star III Sponsor LLC0 Reported balance After 2023-05-12 transaction · row 2 Instrument identity requires review; Table II rows are not merged.
1 source row

Row 2 · 2023-05-12 · Other · Disposed 8,750,000 · Balance 0

F1: As previously reported, the reporting person had been a managing member of Northern Star III Sponsor LLC ("NS3 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS3 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS3 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

F2: Each warrant will become exercisable 30 days after the completion of an initial business combination, and will expire five years after the completion of an initial business combination.

Filing footnotes · ownership attribution and instrument terms

F1: As previously reported, the reporting person had been a managing member of Northern Star III Sponsor LLC ("NS3 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS3 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS3 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

F2: Each warrant will become exercisable 30 days after the completion of an initial business combination, and will expire five years after the completion of an initial business combination.

Northern Star Investment Corp. IV

Report date May 12, 2023 · Filed June 14, 2023

Section 16 reporting ended · disclosed 2023-06-14. Current position is not established by this disclosure.

Security / awardOwnership accountDisclosed shares / unitsDisclosure context
Class A Common StockSEC Table I · non-derivativeIndirectby Northern Star IV Sponsor LLC0 Reported balance After 2023-05-12 transaction · row 1 Account identity is unresolved; indirect or unspecified ownership is not merged.
1 source row

Row 1 · 2023-05-12 · Other · Disposed 9,708,334 · Balance 0

F1: As previously reported, the reporting person had been a managing member of Northern Star IV Sponsor LLC ("NS4 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS4 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS4 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

WarrantsSEC Table II · derivative / convertible security · Conversion / exercise price $11.50Indirectby Northern Star IV Sponsor LLC0 Reported balance After 2023-05-12 transaction · row 2 Instrument identity requires review; Table II rows are not merged.
1 source row

Row 2 · 2023-05-12 · Other · Disposed 8,750,000 · Balance 0

F1: As previously reported, the reporting person had been a managing member of Northern Star IV Sponsor LLC ("NS4 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS4 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS4 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

F2: Each warrant will become exercisable 30 days after the completion of an initial business combination, and will expire five years after the completion of an initial business combination.

Filing footnotes · ownership attribution and instrument terms

F1: As previously reported, the reporting person had been a managing member of Northern Star IV Sponsor LLC ("NS4 Sponsor") together with Jonathan Ledecky. On May 12, 2023, the reporting person entered into an agreement with Northern Star Sponsor LLC ("NS1 Sponsor") and Mr. Ledecky pursuant to which the parties agreed, among other things, that the reporting person (i) first resigned from all officer and director positions with the Issuer, (ii) then resigned from all officer and managing member positions with NS4 Sponsor and (iii) following such resignations, forfeited all of her membership interests in NS4 Sponsor originally allocated to her and agreed to cause such interests to be transferred to Mr. Ledecky.

F2: Each warrant will become exercisable 30 days after the completion of an initial business combination, and will expire five years after the completion of an initial business combination.

Transaction history

JSON API
Reset

Purchases/sales include open-market and private transactions. Plan disclosure applies to the filing; individual rows may differ. “Not disclosed” is not “unplanned.”

The cutoff filters transaction history only. Company summaries and owner relationships show the latest available disclosures. Parser corrections can improve historical records.

Transaction dateCompanyActivity / securityShares / unitsReported priceReported valueDetails
July 25, 2022 Filed Jul 27, 2022 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 20,000 $10.00 $200,002.00
Disclosure

SEC source: 0001209191-22-043311 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 27,041

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

F2 · price: The reported price in Column 4 is a weighted average price. These shares were sold in multiple transactions at prices ranging from $10.00 to $10.005 per share, inclusive. The reporting person undertakes to provide to the Issuer, any security holder of the Issuer, or the staff of the Securities and Exchange Commission, upon request, full information regarding the number of shares sold at each separate price within the range set forth in this footnote.

Read SEC document
July 20, 2022 Filed Jul 22, 2022 23:00 UTC Snap Inc SNAP · Entity 3584 GrantOption (right to buy) · Derivative 14,864 $0.00 Strike: $15.03 $0.00
Disclosure

SEC source: 0001209191-22-043051 · doc4.xml · derivative · entry 2

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 65,553

Underlying: Class A Common Stock · 14,864 shares

Expires 2032-07-19

F2 · derivative.exercise_date: 100% of the shares subject to the option will vest upon the reporting person's completion of one year of continuous service from July 20, 2022. The shares subject to the option will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the shares subject to the option will be deemed fully vested immediately.

Read SEC document
July 20, 2022 Filed Jul 22, 2022 23:00 UTC Snap Inc SNAP · Entity 3584 GrantClass A Common Stock 9,114 $0.00 $0.00
Disclosure

SEC source: 0001209191-22-043051 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 47,041

F1 · shares: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from July 20, 2022. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately.

Read SEC document
July 08, 2022 Filed Jul 12, 2022 13:04 UTC Sonos Inc SONO · Entity 1773 SaleCommon Stock 905 $20.00 $18,100.00
Disclosure

SEC source: 0001562180-22-005640 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 22,002

F1 · kind: The reported transaction was effected pursuant to a Rule 10b5-1 trading plan previously adopted by the Reporting Person.

Read SEC document
June 03, 2022 Filed Jun 7, 2022 20:20 UTC Sonos Inc SONO · Entity 1773 SaleCommon Stock 905 $22.69 $20,534.45
Disclosure

SEC source: 0001562180-22-004877 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 22,907

F1 · kind: The reported transaction was effected pursuant to a Rule 10b5-1 trading plan previously adopted by the Reporting Person.

Read SEC document
May 03, 2022 Filed May 5, 2022 20:10 UTC Sonos Inc SONO · Entity 1773 SaleCommon Stock 905 $22.90 $20,724.50
Disclosure

SEC source: 0001562180-22-003814 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 23,812

F1 · kind: The reported transaction was effected pursuant to a Rule 10b5-1 trading plan previously adopted by the Reporting Person.

Read SEC document
April 04, 2022 Filed Apr 6, 2022 21:04 UTC Sonos Inc SONO · Entity 1773 SaleCommon Stock 905 $27.71 $25,077.55
Disclosure

SEC source: 0001562180-22-003300 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 24,717

F1 · kind: The reported transaction was effected pursuant to a Rule 10b5-1 trading plan previously adopted by the Reporting Person.

Read SEC document
March 10, 2022 Filed Mar 14, 2022 23:24 UTC Sonos Inc SONO · Entity 1773 GrantCommon Stock 7,493 Not disclosed Not disclosed
Disclosure

SEC source: 0001562180-22-002628 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 25,622

F1 · shares: Represents the number of shares subject to restricted stock units ("RSUs") that were granted on March 10, 2022.

F2 · shares: The RSUs will vest in full on the earlier of March 10, 2023 or the next annual meeting of stockholders, subject to the continuing service of the Reporting Person on the vesting date. Vested shares will be delivered to the Reporting Person upon vesting.

F3 · price: Each RSU represents a contingent right to receive 1 share of the Issuer's Common Stock upon vesting and settlement for no consideration.

Read SEC document
October 14, 2021 Filed Oct 18, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 1,893 $76.88 $145,533.84
Disclosure

SEC source: 0001209191-21-060762 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 37,927

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
September 14, 2021 Filed Sep 16, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 1,993 $71.75 $142,997.75
Disclosure

SEC source: 0001209191-21-056474 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 39,820

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
August 13, 2021 Filed Aug 17, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 1,792 $75.29 $134,919.68
Disclosure

SEC source: 0001209191-21-052041 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 41,813

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
August 11, 2021 Filed Aug 13, 2021 23:30 UTC Bark, Inc. BARK · Entity 6772 GrantRestricted Stock Unit · Derivative 36,363 $0.00 $0.00
Disclosure

SEC source: 0001819574-21-000019 · wf-form4_162889741166652.xml · derivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 36,363

Underlying: Common Stock · 36,363 shares

Expires not disclosed

F1 · derivative.exercise_price: The Reporting Person was granted restricted stock units ("RSUs"), which represent a contingent right to receive one share of Common Stock for each RSU. The RSUs are subject to a service-based vesting requirement, which shall vest on the first year anniversary of June 1, 2021, or, at the Reporting Person's sole discretion, such later date on which the Reporting Person ceases to serve as a director of The Original BARK Company.

F1 · derivative.exercise_date: The Reporting Person was granted restricted stock units ("RSUs"), which represent a contingent right to receive one share of Common Stock for each RSU. The RSUs are subject to a service-based vesting requirement, which shall vest on the first year anniversary of June 1, 2021, or, at the Reporting Person's sole discretion, such later date on which the Reporting Person ceases to serve as a director of The Original BARK Company.

F1 · derivative.expiration_date: The Reporting Person was granted restricted stock units ("RSUs"), which represent a contingent right to receive one share of Common Stock for each RSU. The RSUs are subject to a service-based vesting requirement, which shall vest on the first year anniversary of June 1, 2021, or, at the Reporting Person's sole discretion, such later date on which the Reporting Person ceases to serve as a director of The Original BARK Company.

Read SEC document
July 21, 2021 Filed Jul 22, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 GrantOption (right to buy) · Derivative 4,044 $0.00 Strike: $62.73 $0.00
Disclosure

SEC source: 0001209191-21-047852 · doc4.xml · derivative · entry 2

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 40,077

Underlying: Class A Common Stock · 4,044 shares

Expires 2031-07-20

F2 · derivative.exercise_date: 100% of the shares subject to the option will vest upon the reporting person's completion of one year of continuous service from July 20, 2021. The shares subject to the option will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the shares subject to the option will be deemed fully vested immediately.

Read SEC document
July 21, 2021 Filed Jul 22, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 GrantClass A Common Stock 1,965 $0.00 $0.00
Disclosure

SEC source: 0001209191-21-047852 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 43,605

F1 · shares: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from July 20, 2021. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately.

Read SEC document
July 14, 2021 Filed Jul 16, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 1,887 $64.53 $121,768.11
Disclosure

SEC source: 0001209191-21-047007 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 41,640

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
June 14, 2021 Filed Jun 16, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 1,986 $64.57 $128,236.02
Disclosure

SEC source: 0001209191-21-041090 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 43,527

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
June 01, 2021 Filed Jun 3, 2021 09:43 UTC Bark, Inc. STIC.U · Entity 6772 ConversionClass B Common Stock · Derivative 6,108,750 Not disclosed Not disclosed
Disclosure

SEC source: 0001094891-21-000237 · edgar.xml · derivative · entry 2

Northern Star Sponsor LLC · CIK 0001828910 · 10% owner

Coles Joanna · CIK 0001699323 · Director · 10% owner · Former Chief Executive Officer

LEDECKY JONATHAN J · CIK 0001008382 · Director · 10% owner · former Chief Operating Officer

Joint disclosure: these amounts are not allocated separately to each reporting owner.

10b5-1 filing: Not disclosed

Ownership: Indirect · By Northern Star Sponsor LLC

Disclosed balance after: 0

Underlying: Common Stock · 6,108,750 shares

Expires not disclosed

Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event.

F1 · derivative.exercise_price: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F1 · price: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F1 · derivative.exercise_date: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F1 · derivative.expiration_date: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F1 · derivative.underlying: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F2 · ownership.nature: These securities are owned directly by Northern Star Sponsor LLC, a ten percent owner of the Issuer, and indirectly by its managing members, Joanna Coles, a director of the Issuer and the Issuer's former Chief Executive Officer, and Jonathan J. Ledecky, a director of the Issuer and the Issuer's former Chief Operating Officer. Each of Ms. Coles and Mr. Ledecky disclaims beneficial ownership of the securities held by Northern Star Sponsor LLC, except to the extent of his or her pecuniary interest therein.

Read SEC document
June 01, 2021 Filed Jun 3, 2021 09:43 UTC Bark, Inc. STIC.U · Entity 6772 ConversionCommon Stock 6,108,750 Not disclosed Not disclosed
Disclosure

SEC source: 0001094891-21-000237 · edgar.xml · nonDerivative · entry 1

Northern Star Sponsor LLC · CIK 0001828910 · 10% owner

Coles Joanna · CIK 0001699323 · Director · 10% owner · Former Chief Executive Officer

LEDECKY JONATHAN J · CIK 0001008382 · Director · 10% owner · former Chief Operating Officer

Joint disclosure: these amounts are not allocated separately to each reporting owner.

10b5-1 filing: Not disclosed

Ownership: Indirect · By Northern Star Sponsor LLC

Disclosed balance after: 6,108,750

Exercise/conversion can include RSU settlement. Transaction price and option strike are different fields; a missing price is not zero. Derivative and underlying rows can describe the same event.

F1 · security: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F1 · price: The Class B common stock automatically converted into Class A common stock at the time of the Issuer's initial business combination on a one-for-one basis. The Class B common stock had no expiration date. Upon consummation of the business combination, the Class A common stock was redesignated as common stock (without class designation).

F2 · ownership.nature: These securities are owned directly by Northern Star Sponsor LLC, a ten percent owner of the Issuer, and indirectly by its managing members, Joanna Coles, a director of the Issuer and the Issuer's former Chief Executive Officer, and Jonathan J. Ledecky, a director of the Issuer and the Issuer's former Chief Operating Officer. Each of Ms. Coles and Mr. Ledecky disclaims beneficial ownership of the securities held by Northern Star Sponsor LLC, except to the extent of his or her pecuniary interest therein.

Read SEC document
May 14, 2021 Filed May 18, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 2,091 $51.36 $107,393.76
Disclosure

SEC source: 0001209191-21-033729 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 45,513

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
April 14, 2021 Filed Apr 16, 2021 23:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 2,201 $64.16 $141,216.16
Disclosure

SEC source: 0001209191-21-027040 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 47,604

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
March 15, 2021 Filed Mar 17, 2021 22:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 2,317 $62.50 $144,812.50
Disclosure

SEC source: 0001209191-21-021490 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 49,805

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
March 11, 2021 Filed Mar 15, 2021 21:36 UTC Sonos Inc SONO · Entity 1773 GrantCommon Stock 5,337 Not disclosed Not disclosed
Disclosure

SEC source: 0001562180-21-002246 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 18,129

F1 · shares: Represents the number of shares subject to restricted stock units ("RSUs") that were granted on March 11, 2021.

F2 · shares: The RSUs will vest in full on the earlier of March 11, 2022 or the next annual meeting of stockholders, subject to the continuing service of the Reporting Person on the vesting date. Vested shares will be delivered to the Reporting Person upon vesting.

F3 · price: Each RSU represents a contingent right to receive 1 share of the Issuer's Common Stock upon vesting and settlement for no consideration.

Read SEC document
February 08, 2021 Filed Feb 11, 2021 02:00 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 2,438 $63.39 $154,544.82
Disclosure

SEC source: 0001209191-21-009486 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 52,122

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
September 14, 2020 Filed Sep 16, 2020 23:01 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 5,418 $23.66 $128,189.88
Disclosure

SEC source: 0001209191-20-050766 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 54,560

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
August 13, 2020 Filed Aug 17, 2020 23:16 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 5,027 $22.00 $110,594.00
Disclosure

SEC source: 0001209191-20-047001 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 59,978

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
July 19, 2020 Filed Jul 22, 2020 22:40 UTC Snap Inc SNAP · Entity 3584 GrantOption (right to buy) · Derivative 10,612 $0.00 Strike: $24.24 $0.00
Disclosure

SEC source: 0001209191-20-043380 · doc4.xml · derivative · entry 2

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 36,033

Underlying: Class A Common Stock · 10,612 shares

Expires 2030-07-18

F2 · derivative.exercise_date: 100% of the shares subject to the option will vest upon the reporting person's completion of one year of continuous service from July 19, 2020. The shares subject to the option will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the shares subject to the option will be deemed fully vested immediately.

Read SEC document
July 19, 2020 Filed Jul 22, 2020 22:40 UTC Snap Inc SNAP · Entity 3584 GrantClass A Common Stock 5,800 $0.00 $0.00
Disclosure

SEC source: 0001209191-20-043380 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 65,005

F1 · shares: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from July 19, 2020. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately.

Read SEC document
July 13, 2020 Filed Jul 15, 2020 23:26 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 5,586 $25.77 $143,951.22
Disclosure

SEC source: 0001209191-20-042531 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 59,205

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
June 15, 2020 Filed Jun 17, 2020 23:35 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 6,206 $19.81 $122,940.86
Disclosure

SEC source: 0001209191-20-037432 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 64,791

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
May 13, 2020 Filed May 15, 2020 23:23 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 6,896 $17.40 $119,990.40
Disclosure

SEC source: 0001209191-20-029860 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 70,997

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
February 27, 2020 Filed Mar 3, 2020 02:21 UTC Sonos Inc SONO · Entity 1773 GrantCommon Stock 12,792 Not disclosed Not disclosed
Disclosure

SEC source: 0001562180-20-001940 · primarydocument.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 12,792

F1 · shares: Represents the number of shares subject to restricted stock units ("RSUs") that were granted on February 27, 2020.

F2 · shares: The RSUs will vest in full on the earlier of February 27, 2021 or the next annual meeting of stockholders, subject to the continuing service of the Reporting Person on the vesting date. Vested shares will be delivered to the Reporting Person upon vesting.

F3 · price: Each RSU represents a contingent right to receive 1 share of the Issuer's Common Stock upon vesting and settlement for no consideration.

Read SEC document
July 24, 2019 Filed Jul 26, 2019 23:24 UTC Snap Inc SNAP · Entity 3584 SaleClass A Common Stock 5,631 $17.00 $95,727.00
Disclosure

SEC source: 0001209191-19-043428 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 77,893

F1 · shares: The sales reported were effected pursuant to a Rule 10b5-1 trading plan adopted by the reporting person.

Read SEC document
July 18, 2019 Filed Jul 19, 2019 23:30 UTC Snap Inc SNAP · Entity 3584 GrantOption (right to buy) · Derivative 16,802 $0.00 Strike: $14.69 $0.00
Disclosure

SEC source: 0001209191-19-042826 · doc4.xml · derivative · entry 2

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 36,033

Underlying: Class A Common Stock · 16,802 shares

Expires 2029-07-17

F2 · derivative.exercise_date: 100% of the shares subject to the option will vest upon the reporting person's completion of one year of continuous service from July 18, 2019. The shares subject to the option will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the shares subject to the option will be deemed fully vested immediately.

Read SEC document
July 18, 2019 Filed Jul 19, 2019 23:30 UTC Snap Inc SNAP · Entity 3584 GrantClass A Common Stock 8,937 $0.00 $0.00
Disclosure

SEC source: 0001209191-19-042826 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 83,524

F1 · shares: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from July 18, 2019. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately.

Read SEC document
August 02, 2018 Filed Aug 3, 2018 22:29 UTC Snap Inc SNAP · Entity 3584 GrantOption (right to buy) · Derivative 19,231 $0.00 Strike: $12.47 $0.00
Disclosure

SEC source: 0001209191-18-045403 · doc4.xml · derivative · entry 2

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 19,231

Underlying: Class A Common Stock · 19,231 shares

Expires 2028-08-01

F2 · derivative.exercise_date: 100% of the shares subject to the option will vest upon the reporting person's completion of one year of continuous service from August 2, 2018. The shares subject to the option will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the shares subject to the option will be deemed fully vested immediately.

Read SEC document
August 02, 2018 Filed Aug 3, 2018 22:29 UTC Snap Inc SNAP · Entity 3584 GrantClass A Common Stock 9,481 $0.00 $0.00
Disclosure

SEC source: 0001209191-18-045403 · doc4.xml · nonDerivative · entry 1

Coles Joanna · CIK 0001699323 · Director

10b5-1 filing: Not disclosed

Ownership: Direct

Disclosed balance after: 74,587

F1 · shares: Represents shares issuable on settlement of restricted stock units ("RSUs") granted to the reporting person. Each RSU represents a contingent right to receive one share of Issuer's Class A Common Stock. 100% of the RSUs shall vest after the reporting person completes one year of continuous service from August 2, 2018. The RSUs will be subject to pro-rata acceleration upon the reporting person's discontinued service on the Issuer's board of directors and automatic full acceleration in the event of a change in control, as defined in the Issuer's 2017 Equity Incentive Plan. If the reporting person dies while in continuous service, 100% of the RSUs will be deemed fully vested immediately.

Read SEC document

Value uses the disclosed total when available, otherwise shares × reported transaction price. It is not an estimate of exercise cash cost or investment performance.