names

67 rows where place_id = 760887

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4474223 2192590 2192590 defendant Milner William   760887 760887 Milner, William, of Gillesland 4
4474224 2192590 2192590 defendant Milner John   760887 760887 Milner, John, of Gillesland 5
4506471 2202524 2202524 defendant Aleynson John   760887 760887 Aleynson, John, of Gillesland 3
4598920 2230883 2230883 defendant Jonson Andrew   760887 760887 Jonson, Andrew, of Gillesland 1
4608666 2233815 2233815 defendant Vaux John   760887 760887 Vaux, John, of Gillesland 0
4613149 2235171 2235171 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613163 2235172 2235172 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613175 2235173 2235173 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613187 2235174 2235174 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613200 2235175 2235175 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613211 2235176 2235176 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613222 2235177 2235177 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4613227 2235178 2235178 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4665597 2250713 2250713 defendant Bell William yeoman 760887 760887 Bell, William, of Gillesland, yeoman 1
4681980 2259980 2259980 defendant Bell Gilbert yeoman 760887 760887 Bell, Gilbert, of Gillesland, yeoman 2
4688710 2262028 2262028 defendant del Hall Michael yeoman 760887 760887 del Hall, Michael, of Gillesland, yeoman 4
4688712 2262028 2262028 defendant Snowedon John, junior yeoman 760887 760887 Snowedon, John, junior, of Gillesland, yeoman 6
4688713 2262028 2262028 defendant Neweton John yeoman 760887 760887 Neweton, John, of Gillesland, yeoman 7
4688714 2262028 2262028 defendant Stele William yeoman 760887 760887 Stele, William, of Gillesland, yeoman 8
4688715 2262028 2262028 defendant Bell Rolland yeoman 760887 760887 Bell, Rolland, of Gillesland, yeoman 9
4698508 2265009 2265009 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland 0
4698510 2265010 2265010 plaintiff Dacre Thomas   760887 760887 Dacre, Thomas, of Gillesland 0
4705516 2267089 2267089 defendant Heryngton Patrick de gent 760887 760887 Heryngton, Patrick de, of Gillesland, gent 1
4723197 2272564 2272564 plaintiff Dacre Thomas de   760887 760887 Dacre, Thomas de, of Gillesland, knight 0
4729950 2274573 2274573 defendant Whelpdale William yeoman 760887 760887 Whelpdale, William, of Gillesland, yeoman 2
4754640 2281835 2281835 defendant Brakenthwayt John   760887 760887 Brakenthwayt, John, of Gillesland 0
4760562 2283653 2283653 defendant Wode John yeoman 760887 760887 Wode, John, of Gillesland, yeoman 9
4760574 2283656 2283656 defendant Blount Richard yeoman 760887 760887 Blount, Richard, of Gillesland, yeoman 0
4760576 2283656 2283656 defendant Jonesson Thomas yeoman 760887 760887 Jonesson, Thomas, of Gillesland, yeoman 2
4760578 2283656 2283656 defendant Chartere Thomas yeoman 760887 760887 together with Chartere, Thomas, of Gillesland, yeoman 4
4760579 2283656 2283656 defendant Walton John yeoman 760887 760887 Walton, John, of Gillesland, yeoman 5
4760584 2283656 2283656 defendant Heveryngton William yeoman 760887 760887 Heveryngton, William, of Gillesland, yeoman 10
4760587 2283657 2283657 defendant Bullok John yeoman 760887 760887 Bullok, John, of Gillesland, yeoman 0
4760595 2283657 2283657 defendant Tyndale Rowland yeoman 760887 760887 Tyndale, Rowland, of Gillesland, yeoman 8
4760596 2283657 2283657 defendant Tennmam Thoams yeoman 760887 760887 Tennmam, Thoams, of Gillesland, yeoman 9
4760598 2283657 2283657 defendant Whelpdale John yeoman 760887 760887 Whelpdale, John, of Gillesland, yeoman 11
4774286 2287939 2287939 defendant Beauchamp William esq 760887 760887 Beauchamp, William, of Gillesland, esq 1
4774289 2287940 2287940 defendant Belle Gilbert   760887 760887 Belle, Gilbert, of Gillesland 0
4774292 2287940 2287940 defendant Heryngton William yeoman 760887 760887 Heryngton, William, of Gillesland, yeoman 3
4774298 2287941 2287941 defendant Bell Rowland yeoman 760887 760887 Bell, Rowland, of Gillesland, yeoman 3
4774299 2287941 2287941 defendant S_ Richard yeoman 760887 760887 S_, Richard, of Gillesland, yeoman 4
4775486 2288329 2288329 defendant Bell John (legal representative) 760887 760887 Bell, John, of Gillesland, executors of 3
4799205 2295932 2295932 defendant Beauchamp William esq 760887 760887 Beauchamp, William, of Gillesland, esq 2
4799216 2295936 2295936 defendant Bell Gilbert yeoman 760887 760887 Bell, Gilbert, of Gillesland, yeoman 0
4799219 2295936 2295936 defendant de Heryngton William yeoman 760887 760887 de Heryngton, William, of Gillesland, yeoman 3
4799739 2296104 2296104 defendant Belle Roland yeoman 760887 760887 Belle, Roland, of Gillesland, yeoman 3
4799740 2296104 2296104 defendant Snawdon Richard yeoman 760887 760887 Snawdon, Richard, of Gillesland, yeoman 4
4824785 2303795 2303795 defendant Twedale Richard yeoman 760887 760887 Twedale, Richard, of Gillesland, yeoman 2
4824786 2303795 2303795 defendant Twedale Wiliam yeoman 760887 760887 Twedale, Wiliam, of Gillesland, yeoman 3
4824815 2303801 2303801 defendant Whelpdale Robert de yeoman 760887 760887 Whelpdale, Robert de, of Gillesland, yeoman 0
4857310 2313674 2313674 defendant Elwalde Alexander yeoman 760887 760887 Elwalde, Alexander, of Gillesland, yeoman 0
4857311 2313674 2313674 defendant Bulman Patrick yeoman 760887 760887 Bulman, Patrick, of Gillesland, yeoman 1
4857312 2313674 2313674 defendant Whelpedale Robert yeoman 760887 760887 Whelpedale, Robert, of Gillesland, yeoman 2
4857313 2313674 2313674 defendant Derman Robert yeoman 760887 760887 Derman, Robert, of Gillesland, yeoman 3
4857314 2313674 2313674 defendant Derman Richard yeoman 760887 760887 Derman, Richard, of Gillesland, yeoman 4
4857316 2313674 2313674 defendant Hetheryngton Thomas gent 760887 760887 Hetheryngton, Thomas, of Gillesland, gent 6
4857317 2313674 2313674 defendant Hetheryngton William gent 760887 760887 Hetheryngton, William, of Gillesland, gent 7
4857318 2313674 2313674 defendant Robenson John yeoman 760887 760887 Robenson, John, of Gillesland, yeoman 8
4857320 2313674 2313674 defendant Bulluke William yeoman 760887 760887 Bulluke, William, of Gillesland, yeoman 10
4857321 2313674 2313674 defendant Doweson Robert yeoman 760887 760887 Doweson, Robert, of Gillesland, yeoman 11
4860814 2314744 2314744 defendant Bell Nicholas yeoman 760887 760887 Bell, Nicholas, of Gillesland, yeoman 0
4883256 2321690 2321690 defendant Bell Mathew yeoman 760887 760887 Bell, Mathew, of Gillesland, yeoman 3
4970389 2348089 2348089 defendant Hetheryngton John esq 760887 760887 Hetheryngton, John, of Gillesland, esq 2
4979713 2350888 2350888 defendant Hetheryngton John gent 760887 760887 Hetheryngton, John, of Gillesland, gent 1
5332578 2454811 2454811 defendant Vaus or Vans Roland esq 760887 760887 Vaus or Vans, Roland, of Gillesland, esq 0
5628115 2552763 2552763 defendant Carrok Robert husbandman 760887 760887 Carrok, Robert, of Gillesland, husbandman 3
5633197 2554387 2554387 defendant Bell William yeoman 760887 760887 Bell, William, of Gillesland, yeoman 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);