names

67 rows where place_id = 613795

✎ 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
3700314 1926338 1926338 defendant Criche Christopher tanner 613795 613795 Criche, Christopher, of Loughburgh, tanner 2
3701102 1926592 1926592 plaintiff Blowar John   613795 613795 Blowar, John, of Loughburgh 0
3701103 1926592 1926592 defendant Wolland Christopher draper 613795 613795 Wolland, Christopher, of Loughburgh, draper 0
3701107 1926594 1926594 plaintiff Blower John   613795 613795 Blower, John, of Loughburgh 0
3701108 1926594 1926594 defendant Lemyngton Ralph (legal representative) 613795 613795 Lemyngton, Ralph, of Loughburgh, merchant of the staple, executor of 0
3711961 1930056 1930056 defendant Purdon Edward gent 613795 613795 Purdon, Edward, of Loughburgh, gent 0
3722379 1933260 1933260 defendant Cryche Christopher tanner 613795 613795 Cryche, Christopher, of Loughburgh, tanner 0
3727838 1934978 1934978 plaintiff Willayn Christopher draper 613795 613795 Willayn, Christopher, of Loughburgh, draper 0
3728432 1935141 1935141 plaintiff Wyllayn Christopher draper 613795 613795 Wyllayn, Christopher, of Loughburgh, draper 0
3728436 1935142 1935142 plaintiff Wyllayn Christopher draper 613795 613795 Wyllayn, Christopher, of Loughburgh, draper 0
3745601 1940531 1940531 defendant Blower Humphrey painter 613795 613795 Blower, Humphrey, of Loughburgh, painter 0
3756665 1944064 1944064 defendant Chase Edmund butcher 613795 613795 Chase, Edmund, of Loughburgh, butcher 0
3756666 1944064 1944064 defendant Hurt Robert mercer 613795 613795 Hurt, Robert, of Loughburgh, mercer 1
3763633 1946266 1946266 plaintiff Hawden Robert mercer 613795 613795 Hawden, Robert, of Loughburgh, mercer 0
3765735 1946948 1946948 defendant Page Ralph yeoman 613795 613795 Page, Ralph, of Loughburgh, yeoman 0
3767514 1947476 1947476 defendant Whetley Thomas butcher 613795 613795 Whetley, Thomas, of Loughburgh, butcher 0
3781744 1952037 1952037 defendant Heth John draper 613795 613795 Heth, John, of Loughburgh, draper 0
3781746 1952037 1952037 defendant Cappe William walker 613795 613795 Cappe, William, of Loughburgh, walker 2
4658882 2248650 2248650 defendant Breton Robert gent 613795 613795 Breton, Robert, of Loughburgh, gent 0
4658884 2248650 2248650 defendant Langtoft John ostler 613795 613795 Langtoft, John, of Loughburgh, ostler 2
4658885 2248651 2248651 plaintiff Curryour John   613795 613795 Curryour, John, of Loughburgh 0
4658886 2248651 2248651 defendant Breton Robert   613795 613795 Breton, Robert, of Loughburgh 0
4677214 2258493 2258493 plaintiff Halle William   613795 613795 Halle, William, of Loughburgh, on his own account 0
4677216 2258494 2258494 plaintiff Halle William   613795 613795 Halle, William, of Loughburgh, on his own account 0
4778823 2289350 2289350 defendant Man William husbandman 613795 613795 Man, William, of Loughburgh, husbandman 0
4797486 2295384 2295384 defendant Pollard John yeoman 613795 613795 Pollard, John, of Loughburgh, yeoman 0
4862157 2315177 2315177 defendant Irnemonger William spicer 613795 613795 Irnemonger, William, of Loughburgh, spicer 1
4875189 2319194 2319194 plaintiff Rotheley John   613795 613795 Rotheley, John, of Loughburgh 0
4920437 2332908 2332908 defendant Yoman Thomas butcher 613795 613795 Yoman, Thomas, of Loughburgh, butcher 2
4926560 2334726 2334726 defendant Irenmonger William spicer 613795 613795 Irenmonger, William, of Loughburgh, spicer 1
4954646 2343347 2343347 defendant Rydyng John glover 613795 613795 Rydyng, John, of Loughburgh, glover 0
4961717 2345466 2345466 defendant Henton Richard yeoman 613795 613795 Henton, Richard, of Loughburgh, yeoman 1
5024331 2364035 2364035 defendant Dyotson John yeoman 613795 613795 Dyotson, John, of Loughburgh, yeoman 1
5059807 2374497 2374497 defendant Mylner Robert miller 613795 613795 Mylner, Robert, of Loughburgh, miller 0
5073223 2378478 2378478 defendant Annesley Robert husbandman 613795 613795 Annesley, Robert, of Loughburgh, husbandman 2
5093319 2384442 2384442 defendant Bocher Richard butcher 613795 613795 Bocher, Richard, of Loughburgh, butcher 1
5093322 2384443 2384443 defendant Bocher Richard butcher 613795 613795 Bocher, Richard, of Loughburgh, butcher 1
5142784 2399019 2399019 defendant Dyeston John mylner 613795 613795 Dyeston, John, of Loughburgh, mylner 0
5142785 2399019 2399019 defendant Chamberleyn Robert yeoman 613795 613795 Chamberleyn, Robert, of Loughburgh, yeoman 1
5164155 2405256 2405256 defendant Byeston John miller 613795 613795 Byeston, John, of Loughburgh, miller 0
5164156 2405256 2405256 defendant Chamberleyn Robert yeoman 613795 613795 Chamberleyn, Robert, of Loughburgh, yeoman 1
5164158 2405256 2405256 defendant Hygdon William husbandman 613795 613795 Hygdon, William, of Loughburgh, husbandman 3
5257625 2432505 2432505 defendant Hande William yeoman 613795 613795 Hande, William, of Loughburgh, yeoman 0
5268718 2435968 2435968 defendant Rydyng John yeoman 613795 613795 Rydyng, John, of Loughburgh, yeoman 0
5279314 2439043 2439043 defendant Marsshall Thomas yeoman 613795 613795 (Marsshall, Thomas, of Loughburgh, yeoman 1
5290255 2442152 2442152 defendant Hande William yeoman 613795 613795 Hande, William, of Loughburgh, yeoman 0
5314385 2449327 2449327 plaintiff Burton Thomas merchant 613795 613795 Burton, Thomas, of Loughburgh, merchant 0
5319280 2450859 2450859 defendant Rydynges John yeoman 613795 613795 Rydynges, John, of Loughburgh, yeoman 1
5326320 2452959 2452959 defendant Marshall Thomas yeoman 613795 613795 Marshall, Thomas, of Loughburgh, yeoman 0
5335087 2455562 2455562 plaintiff Bolles William   613795 613795 (Bolles, William, of Loughburgh 1
5339909 2457051 2457051 defendant Wymond John   613795 613795 Wymond, John, of Loughburgh, wright 0
5339910 2457051 2457051 defendant Skarresdale Richard barker 613795 613795 Skarresdale, Richard, of Loughburgh, barker 1
5339911 2457051 2457051 defendant Parker Thomas husbandman 613795 613795 Parker, Thomas, of Loughburgh, husbandman 2
5385055 2470802 2470802 defendant Annesley Thomas yeoman 613795 613795 Annesley, Thomas, of Loughburgh, yeoman 1
5397142 2474266 2474266 defendant Aunesley Thomas yeoman 613795 613795 Aunesley, Thomas, of Loughburgh, yeoman 1
5405601 2476678 2476678 defendant Byllyngton John butcher 613795 613795 Byllyngton, John, of Loughburgh, butcher 3
5405602 2476678 2476678 defendant Ferme-- John butcher 613795 613795 Ferme--, John, of Loughburgh, butcher 4
5410263 2478022 2478022 defendant Annesley Thomas yeoman 613795 613795 Annesley, Thomas, of Loughburgh, yeoman 1
5423606 2482025 2482025 defendant Marshall Thomas (legal representative) 613795 613795 Marshall, Thomas, of Loughburgh, merchant, executors of 0
5436662 2485892 2485892 defendant Fermour John butcher 613795 613795 Fermour, John, of Loughburgh, butcher 4
5455824 2491645 2491645 defendant Lemyngton John merchant of the Staple 613795 613795 Lemyngton, John, of Loughburgh, merchant of the Staple 0
5471153 2496307 2496307 defendant Barker Robert yeoman 613795 613795 Barker, Robert, of Loughburgh, yeoman 1
5472912 2496853 2496853 defendant Rydyngys John yeoman 613795 613795 Rydyngys, John, of Loughburgh, yeoman 0
5472914 2496854 2496854 defendant Rydyngys John yeoman 613795 613795 Rydyngys, John, of Loughburgh, yeoman 0
5527511 2513185 2513185 defendant Canell or Cavell Richard merchant of the staple 613795 613795 Canell or Cavell, Richard, of Loughburgh, merchant of the staple 0
5531244 2514287 2514287 defendant Orme Robert husbandman 613795 613795 Orme, Robert, of Loughburgh, husbandman 2
5634785 2554877 2554877 defendant Dexter John   613795 613795 Dexter, John, of Loughburgh, "dexter" or weaver 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);