names

87 rows where place_id = 586921

✎ 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
3589991 1864511 1864511 defendant Lodynden Robert roper 586921 586921 Lodynden, Robert, of Saleherst, roper 0
3595417 1866200 1866200 defendant Lodynden Robert roper 586921 586921 Lodynden, Robert, of Saleherst, roper 2
3595422 1866201 1866201 defendant Lodynden Robert roper 586921 586921 Lodynden, Robert, of Saleherst, roper 2
3623602 1874914 1874914 defendant Cradok John husbandman 586921 586921 Cradok, John, of Saleherst, husbandman 1
3623605 1874915 1874915 defendant Cradok John husbandman 586921 586921 Cradok, John, of Saleherst, husbandman 1
3625305 1875450 1875450 defendant Jerard Richard laborer 586921 586921 Jerard, Richard, of Saleherst, laborer 5
3658560 1912930 1912930 defendant Snep Robert smith 586921 586921 Snep, Robert, of Saleherst, smith 0
3725325 1934215 1934215 defendant Cooke William yeoman 586921 586921 Cooke, William, of Saleherst, yeoman 2
3742814 1939606 1939606 defendant Saunder John laborer 586921 586921 Saunder, John, of Saleherst, laborer 1
3742815 1939606 1939606 defendant Nasshe Thomas laborer 586921 586921 Nasshe, Thomas, of Saleherst, laborer 2
3771232 1948691 1948691 defendant Son Edward husbandman 586921 586921 Son, Edward, of Saleherst, husbandman 0
3794669 1956209 1956209 defendant Norman John husbandman 586921 586921 Norman, John, of Saleherst, husbandman 0
3909285 1993398 1993398 defendant Bowyer Reginald husbandman 586921 586921 Bowyer, Reginald, of Saleherst, husbandman 0
3963798 2011940 2011940 defendant Brownyng Thomas tailor 586921 586921 Brownyng, Thomas, of Saleherst, tailor 0
3963799 2011940 2011940 defendant Colgatt Stephen yeoman 586921 586921 Colgatt, Stephen, of Saleherst, yeoman 1
4012926 2029354 2029354 plaintiff Relfe or Relse Richard ironmonger 586921 586921 Relfe or Relse, Richard, of Saleherst, ironmonger 0
4044559 2040505 2040505 plaintiff Relse or Relfe Richard ironmonger 586921 586921 Relse or Relfe, Richard, of Saleherst, ironmonger 0
4073230 2050717 2050717 defendant Bysshopenden Robert yeoman 586921 586921 Bysshopenden, Robert, of Saleherst, yeoman 1
4095223 2058614 2058614 defendant Woodgate Edmund yeoman 586921 586921 Woodgate, Edmund, of Saleherst, yeoman 1
4119390 2067228 2067228 defendant Russell Goddard husbandman 586921 586921 Russell, Goddard, of Saleherst, husbandman 0
4139627 2074536 2074536 defendant Stonestrete Edward butcher 586921 586921 Stonestrete, Edward, of Saleherst, butcher 0
4139628 2074536 2074536 defendant Frenche Thomas butcher 586921 586921 Frenche, Thomas, of Saleherst, butcher 1
4164416 2083074 2083074 defendant Stonestrete Edward butcher 586921 586921 Stonestrete, Edward, of Saleherst, butcher 0
4164417 2083074 2083074 defendant Frenche Thomas butcher 586921 586921 Frenche, Thomas, of Saleherst, butcher 1
4171006 2085342 2085342 defendant Foster John blacksmith 586921 586921 Foster, John, of Saleherst, or of Robarthesbrydge, blacksmith 0
4175547 2086918 2086918 defendant Goodegrome Thomas yeoman 586921 586921 Goodegrome, Thomas, of Saleherst, yeoman 0
4184085 2089930 2089930 defendant Kempe Christopher shoemaker 586921 586921 Kempe, Christopher, of Saleherst, shoemaker 0
4188082 2091334 2091334 defendant Marlowe Richard blacksmith 586921 586921 Marlowe, Richard, of Saleherst, blacksmith 1
4190737 2092322 2092322 defendant Russell Edward husbandman 586921 586921 Russell, Edward, of Saleherst, husbandman 0
4225293 2104313 2104313 defendant Bemys Thomas yeoman 586921 586921 Bemys, Thomas, of Saleherst, yeoman 0
4249966 2112970 2112970 defendant Wennell Anthony yeoman 586921 586921 Wennell, Anthony, of Saleherst, yeoman 0
4249967 2112970 2112970 defendant Ellys John glover 586921 586921 Ellys, John, of Saleherst, glover 1
4249968 2112970 2112970 defendant Padyam Thomas shoemaker 586921 586921 Padyam, Thomas, of Saleherst, shoemaker 2
4249970 2112970 2112970 defendant Padyam John yeoman 586921 586921 Padyam, John, of Saleherst, yeoman 4
4289696 2126379 2126379 defendant Norman Anthony yeoman 586921 586921 Norman, Anthony, of Saleherst, or of Robertsbridge, yeoman 0
4289746 2126395 2126395 defendant Norman Anthony yeoman 586921 586921 Norman, Anthony, of Saleherst, or of Robertsbridge, yeoman 0
4310238 2133736 2133736 defendant Saunder John husbandman 586921 586921 Saunder, John, of Saleherst, husbandman 1
4369992 2154323 2154323 defendant Shober Stephen yeoman 586921 586921 Shober, Stephen, of Saleherst, yeoman 0
4369993 2154323 2154323 defendant Leiche Thomas yeoman 586921 586921 Leiche, Thomas, of Saleherst, yeoman 1
4376271 2156582 2156582 defendant Sone George chapman 586921 586921 Sone, George, of Saleherst, chapman 0
4376273 2156583 2156583 defendant Sone George chapman 586921 586921 Sone, George, of Saleherst, chapman 0
4379587 2157790 2157790 defendant Hodgkyns John husbandman 586921 586921 Hodgkyns, John, of Saleherst, husbandman 0
4379589 2157791 2157791 defendant Hodgkyns John husbandman 586921 586921 Hodgkyns, John, of Saleherst, husbandman 0
4381919 2158638 2158638 defendant Barden Richard yeoman 586921 586921 Barden, Richard, of Saleherst, or of Robynsbrydge, yeoman 2
4381923 2158639 2158639 defendant Barden Richard yeoman 586921 586921 Barden, Richard, of Saleherst, yeoman 2
4397732 2163820 2163820 defendant Jarrett Anthony butcher 586921 586921 Jarrett, Anthony, of Saleherst, butcher 0
4407776 2167166 2167166 defendant Robynson Richard tanner 586921 586921 Robynson, Richard, of Saleherst, tanner 0
4580176 2225288 2225288 defendant Catte Robert   586921 586921 Catte, Robert, of Saleherst 2
4720886 2271866 2271866 plaintiff Burton John   586921 586921 Burton, John, of Saleherst 0
4720889 2271867 2271867 plaintiff Burton John   586921 586921 Burton, John, of Saleherst 0
4743680 2278680 2278680 defendant Bate William yeoman 586921 586921 Bate, William, of Saleherst, yeoman 0
4909294 2329449 2329449 defendant Wodelond John husbandman 586921 586921 Wodelond, John, of Saleherst, husbandman 0
4941148 2339254 2339254 defendant Westbourn Henry husbandman 586921 586921 Westbourn, Henry, of Saleherst, husbandman 0
4941150 2339255 2339255 defendant Westbourne Henry husbandman 586921 586921 Westbourne, Henry, of Saleherst, husbandman 0
4946109 2340772 2340772 defendant Burgham John husbandman 586921 586921 Burgham, John, of Saleherst, husbandman 1
4946116 2340773 2340773 defendant Burgham John husbandman 586921 586921 Burgham, John, of Saleherst, husbandman 1
4983222 2351884 2351884 defendant Hekwode Stephen husbandman 586921 586921 Hekwode, Stephen, of Saleherst, husbandman 0
5217605 2420890 2420890 defendant Pyppesden Robert husbandman 586921 586921 Pyppesden, Robert, of Saleherst, husbandman 2
5217606 2420890 2420890 defendant Rede William husbandman 586921 586921 Rede, William, of Saleherst, husbandman 3
5217612 2420890 2420890 defendant Brabon Robert husbandman 586921 586921 Brabon, Robert, of Saleherst, husbandman 9
5217614 2420890 2420890 defendant Tomset Robert husbandman 586921 586921 Tomset, Robert, of Saleherst, husbandman 11
5217616 2420890 2420890 defendant Tomset William husbandman 586921 586921 Tomset, William, of Saleherst, husbandman 13
5217627 2420890 2420890 defendant Burhham Richard husbandman 586921 586921 Burhham, Richard, of Saleherst, husbandman 24
5334161 2455285 2455285 defendant Pepysden John yeoman 586921 586921 Pepysden, John, of Saleherst, yeoman 0
5334167 2455287 2455287 defendant Pepysden John yeoman 586921 586921 Pepysden, John, of Saleherst, yeoman 0
5340537 2457238 2457238 defendant Wodman Simon husbandman 586921 586921 Wodman, Simon, of Saleherst, husbandman 1
5364358 2464513 2464513 defendant More Richard dyer 586921 586921 More, Richard, of Saleherst, dyer 0
5376395 2468214 2468214 defendant Mascall Thomas tanner 586921 586921 Mascall, Thomas, of Saleherst, tanner 0
5376398 2468214 2468214 defendant More Richard dyer 586921 586921 More, Richard, of Saleherst, dyer 3
5393842 2473298 2473298 defendant Tylly John husbandman 586921 586921 Tylly, John, of Saleherst, husbandman 2
5404771 2476445 2476445 defendant Clement John clerk 586921 586921 Clement, John, of Saleherst, clerk 0
5407074 2477084 2477084 defendant Tylly John husbandman 586921 586921 Tylly, John, of Saleherst, husbandman 2
5422059 2481538 2481538 defendant Bocher John butcher 586921 586921 Bocher, John, of Saleherst, butcher 2
5452923 2490754 2490754 defendant Tylly John husbandman 586921 586921 Tylly, John, of Saleherst, husbandman 0
5454580 2491284 2491284 defendant Pensherst Edmund tailor 586921 586921 Pensherst, Edmund, of Saleherst, tailor 1
5454594 2491289 2491289 defendant Bocher John butcher 586921 586921 Bocher, John, of Saleherst, butcher 1
5454597 2491290 2491290 defendant Bocher John butcher 586921 586921 Bocher, John, of Saleherst, butcher 1
5454600 2491291 2491291 defendant Bocher John butcher 586921 586921 Bocher, John, of Saleherst, butcher 1
5489259 2501671 2501671 defendant Ingelton John miller 586921 586921 Ingelton, John, of Saleherst, miller 0
5502737 2505771 2505771 defendant Tely John butcher 586921 586921 Tely, John, of Saleherst, butcher 2
5583911 2530046 2530046 defendant Wenell or Wevell Thomas draper 586921 586921 Wenell or Wevell, Thomas, of Saleherst, draper 0
5583912 2530046 2530046 defendant Burcam ichard husbandman 586921 586921 Burcam, ichard, of Saleherst, husbandman 1
5583913 2530046 2530046 defendant Upton Henry smith 586921 586921 Upton, Henry, of Saleherst, smith 2
5583914 2530046 2530046 defendant Swane Henry husbandman 586921 586921 Swane, Henry, of Saleherst, husbandman 3
5586645 2530859 2530859 defendant Burkeham Richard husbandman 586921 586921 Burkeham, Richard, of Saleherst, husbandman 2
5586646 2530859 2530859 defendant Swane Henry   586921 586921 Swane, Henry, of Saleherst, point maker 3
5607207 2537142 2537142 defendant Burkham Thomas husbandman 586921 586921 Burkham, Thomas, of Saleherst, husbandman 0

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