names

86 rows where place_id = 605085

✎ 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
3660323 1913489 1913489 defendant Carter Thomas laborer 605085 605085 Carter, Thomas, of Rodyngton, laborer 0
3766736 1947257 1947257 defendant Chamberleyn Richard yeoman 605085 605085 Chamberleyn, Richard, of Rodyngton, yeoman 2
3766740 1947258 1947258 defendant Chamberleyn Richard yeoman 605085 605085 Chamberleyn, Richard, of Rodyngton, yeoman 2
3805441 1959640 1959640 defendant Otteley Thomas gent 605085 605085 Otteley, Thomas, of Rodyngton, gent 1
4439213 2181543 2181543 plaintiff Auneslee Hugh de   605085 605085 Auneslee, Hugh de, of Rodyngton 0
4439219 2181544 2181544 plaintiff Auneslee Hugh de   605085 605085 Auneslee, Hugh de, of Rodyngton 0
4439223 2181545 2181545 plaintiff Auneslee Hugh de   605085 605085 Auneslee, Hugh de, of Rodyngton 0
4439227 2181546 2181546 plaintiff Auneslee Hugh de   605085 605085 Auneslee, Hugh de, of Rodyngton 0
4455344 2186680 2186680 plaintiff Middelton Thomas de   605085 605085 Middelton, Thomas de, of Rodyngton, parson, on his own account 0
4455347 2186680 2186680 defendant Jannoy or Janncy William   605085 605085 Jannoy or Janncy, William, of Rodyngton 2
4455348 2186680 2186680 defendant Smyth Robert   605085 605085 Smyth, Robert, of Rodyngton, son of Richard 3
4455349 2186681 2186681 plaintiff Middelton Thomas de   605085 605085 Middelton, Thomas de, of Rodyngton, parson, on his own account 0
4455350 2186681 2186681 defendant Smyth Richard (legal representative) 605085 605085 Smyth, Richard, of Rodyngton, executors of 0
4455352 2186681 2186681 defendant Janny William   605085 605085 Janny, William, of Rodyngton 2
4455353 2186681 2186681 defendant Smyth Robert   605085 605085 Smyth, Robert, of Rodyngton, son of Richard 3
4455354 2186682 2186682 plaintiff Middelton Thomas de   605085 605085 Middelton, Thomas de, of Rodyngton, parson, on his own account 0
4455355 2186682 2186682 defendant Tetheby Robert de   605085 605085 Tetheby, Robert de, of Rodyngton, vicar 0
4455400 2186692 2186692 plaintiff Midelton Thomas de   605085 605085 Midelton, Thomas de, of Rodyngton, parson, on his own account 0
4455401 2186692 2186692 defendant Teckeby Robert   605085 605085 Teckeby, Robert, of Rodyngton, vicar 0
4455410 2186695 2186695 plaintiff Midelton Thomas   605085 605085 Midelton, Thomas, of Rodyngton, parson, on his own account 0
4455411 2186695 2186695 defendant Smyth Richard (legal representative) 605085 605085 Smyth, Richard, of Rodyngton, executors of 0
4455413 2186695 2186695 defendant Jauncy William   605085 605085 Jauncy, William, of Rodyngton 2
4455414 2186695 2186695 defendant Smyth Robert   605085 605085 Smyth, Robert, of Rodyngton, son of Richard 3
4488398 2197090 2197090 defendant Kynalton Robert de merchant 605085 605085 Kynalton, Robert de, of Rodyngton, merchant 0
4498230 2200103 2200103 defendant North Hugh de   605085 605085 North, Hugh de, of Rodyngton 0
4533631 2210787 2210787 defendant Carter William   605085 605085 Carter, William, of Rodyngton 0
4564268 2220395 2220395 defendant Valey Robert   605085 605085 Valey, Robert, of Rodyngton 2
4564269 2220395 2220395 defendant Taillour Robert   605085 605085 Taillour, Robert, of Rodyngton 3
4564270 2220395 2220395 defendant Goteham Robert   605085 605085 Goteham, Robert, of Rodyngton 4
4602761 2232079 2232079 defendant Kenalton Robert   605085 605085 Kenalton, Robert, of Rodyngton 2
4612044 2234832 2234832 defendant Dalby Ralph de   605085 605085 Dalby, Ralph de, of Rodyngton, vicar 2
4645532 2244761 2244761 defendant Valey Robert   605085 605085 Valey, Robert, of Rodyngton 0
4654600 2247321 2247321 defendant Taillour Robert tailor 605085 605085 Taillour, Robert, of Rodyngton, tailor 0
4658021 2248387 2248387 defendant Valey Robert husbandman 605085 605085 Valey, Robert, of Rodyngton, husbandman 0
4658023 2248387 2248387 defendant Betson John husbandman 605085 605085 Betson, John, of Rodyngton, husbandman 2
4658028 2248388 2248388 defendant Valey Robert husbandman 605085 605085 Valey, Robert, of Rodyngton, husbandman 0
4658030 2248388 2248388 defendant Betson John husbandman 605085 605085 Betson, John, of Rodyngton, husbandman 2
4658035 2248389 2248389 defendant Valey Robert husbandman 605085 605085 Valey, Robert, of Rodyngton, husbandman 0
4658037 2248389 2248389 defendant Betson John husbandman 605085 605085 Betson, John, of Rodyngton, husbandman 2
4688349 2261921 2261921 defendant Bocher John husbandman 605085 605085 Bocher, John, of Rodyngton, husbandman 1
4689446 2262255 2262255 defendant Betson John   605085 605085 Betson, John, of Rodyngton, husbandma 2
4706745 2267494 2267494 defendant Bocher John butcher 605085 605085 Bocher, John, of Rodyngton, butcher 0
4730268 2274671 2274671 defendant Bailly Walter yeoman 605085 605085 Bailly, Walter, of Rodyngton, yeoman 2
4737145 2276735 2276735 defendant Gervesse John butcher 605085 605085 Gervesse, John, of Rodyngton, butcher 0
4756482 2282396 2282396 defendant Rodyngton Robert gent 605085 605085 Rodyngton, Robert, of Rodyngton, gent 0
4756552 2282411 2282411 defendant Betston John husbandman 605085 605085 Betston, John, of Rodyngton, husbandman 3
4761484 2283935 2283935 defendant Beyly John yeoman 605085 605085 Beyly, John, of Rodyngton, yeoman 0
4761485 2283935 2283935 defendant Gamyl John husbandman 605085 605085 Gamyl, John, of Rodyngton, husbandman 1
4761486 2283935 2283935 defendant Smythymon Robert husbandman 605085 605085 Smythymon, Robert, of Rodyngton, husbandman 2
4783344 2290814 2290814 plaintiff de Annesley High   605085 605085 de Annesley, High, of Rodyngton, knight 0
4783350 2290817 2290817 plaintiff de Annesley Hugh   605085 605085 de Annesley, Hugh, of Rodyngton, knight 0
4784188 2291053 2291053 defendant Taillour Robert tailor 605085 605085 Taillour, Robert, of Rodyngton, tailor 1
4784191 2291053 2291053 defendant Betson John husbandman 605085 605085 Betson, John, of Rodyngton, husbandman 4
4791573 2293458 2293458 defendant Annesley Hugh   605085 605085 Annesley, Hugh, of Rodyngton, knight 0
4791575 2293459 2293459 defendant Annesley Hugh   605085 605085 Annesley, Hugh, of Rodyngton, knight 0
4799898 2296152 2296152 defendant Hurleston William   605085 605085 Hurleston, William, of Rodyngton, bailiff 0
4848451 2310991 2310991 defendant Body Thomas chapman 605085 605085 Body, Thomas, of Rodyngton, chapman 0
4853275 2312440 2312440 defendant Webster William husbandman 605085 605085 Webster, William, of Rodyngton, husbandman 1
4872143 2318246 2318246 defendant Bocher John butcher 605085 605085 Bocher, John, of Rodyngton, butcher 0
4894174 2324870 2324870 defendant Bocher John butcher 605085 605085 Bocher, John, of Rodyngton, butcher 6
4898720 2326250 2326250 defendant Belfyn Richard husbandman 605085 605085 Belfyn, Richard, of Rodyngton, husbandman 0
4898721 2326250 2326250 defendant Shank John husbandman 605085 605085 Shank, John, of Rodyngton, husbandman 1
4898722 2326250 2326250 defendant Robertson Richard husbandman 605085 605085 Robertson, Richard, of Rodyngton, husbandman 2
4899466 2326474 2326474 defendant Lovet William husbandman 605085 605085 Lovet, William, of Rodyngton, husbandman 0
4899467 2326474 2326474 defendant Huberd William husbandman 605085 605085 Huberd, William, of Rodyngton, husbandman 1
4899468 2326474 2326474 defendant Gamull John husbandman 605085 605085 Gamull, John, of Rodyngton, husbandman 2
4905607 2328355 2328355 defendant Pedley John yeoman 605085 605085 Pedley, John, of Rodyngton, yeoman 0
4921120 2333122 2333122 plaintiff Koo John (legal representative) 605085 605085 Koo, John, of Rodyngton, vicar, executors of 0
4931150 2336129 2336129 defendant Bocher John butcher 605085 605085 Bocher, John, of Rodyngton, butcher 1
4931151 2336129 2336129 defendant Smythyman Robert husbandman 605085 605085 Smythyman, Robert, of Rodyngton, husbandman 2
4957834 2344314 2344314 defendant Annesley Hugh (legal representative) 605085 605085 Annesley, Hugh, of Rodyngton, knight, executors of 0
4996548 2355822 2355822 defendant Swyper William butcher 605085 605085 Swyper, William, of Rodyngton, butcher 0
5026481 2364627 2364627 defendant Rodyngton William yeoman 605085 605085 Rodyngton, William, of Rodyngton, yeoman 2
5093652 2384539 2384539 defendant Hill William tailor 605085 605085 Hill, William, of Rodyngton, tailor 0
5099712 2386352 2386352 defendant Hert William painter 605085 605085 Hert, William, of Rodyngton, painter 5
5129581 2395139 2395139 defendant Sambrook William   605085 605085 Sambrook, William, of Rodyngton 1
5226020 2423279 2423279 defendant Smyth John smith 605085 605085 Smyth, John, of Rodyngton, smith 0
5226021 2423279 2423279 defendant Lawe William husbandman 605085 605085 Lawe, William, of Rodyngton, husbandman 1
5251577 2430600 2430600 defendant Ondeslowe William gent 605085 605085 Ondeslowe, William, of Rodyngton, gent 1
5251609 2430606 2430606 defendant Ondeslowe William gent 605085 605085 Ondeslowe, William, of Rodyngton, gent 1
5385672 2470973 2470973 plaintiff Chamberleyn John   605085 605085 Chamberleyn, John, of Rodyngton 0
5397853 2474458 2474458 plaintiff Chamberley John   605085 605085 Chamberley, John, of Rodyngton 0
5411012 2478249 2478249 plaintiff Chamberleyn John   605085 605085 Chamberleyn, John, of Rodyngton 0
5456440 2491848 2491848 plaintiff Chamberleyn John   605085 605085 Chamberleyn, John, of Rodyngton 0
5605090 2536461 2536461 defendant Broun John yeoman 605085 605085 Broun, John, of Rodyngton, yeoman 4
5634503 2554790 2554790 defendant Bocher John butcher 605085 605085 Bocher, John, of Rodyngton, butcher 3

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);