names

77 rows where place_id = 591160

✎ 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
3603532 1868773 1868773 plaintiff Drane Stephen   591160 591160 Drane, Stephen, of Tatyngton 0
3606545 1869719 1869719 defendant Nicoll George yeoman 591160 591160 Nicoll, George, of Tatyngton, yeoman 0
3616525 1872805 1872805 plaintiff Drane Stephen   591160 591160 Drane, Stephen, of Tatyngton 0
3632013 1904829 1904829 defendant Carleys John husbandman 591160 591160 Carleys, John, of Tatyngton, husbandman 0
3642308 1908043 1908043 plaintiff Carene Philip (legal representative) 591160 591160 Carene, Philip, of Tatyngton, executors of 0
3898899 1989835 1989835 defendant Shottyswall Henry husbandman 591160 591160 Shottyswall, Henry, of Tatyngton, husbandman 1
3898900 1989835 1989835 defendant Shottyswall Richard husbandman 591160 591160 Shottyswall, Richard, of Tatyngton, husbandman 2
3934268 2001756 2001756 defendant Drane Nicholas husbandman 591160 591160 Drane, Nicholas, of Tatyngton, husbandman 0
3934270 2001757 2001757 defendant Drane Nicholas husbandman 591160 591160 Drane, Nicholas, of Tatyngton, husbandman 0
3945351 2005458 2005458 plaintiff Borrett John yeoman 591160 591160 Borrett, John, of Tatyngton, yeoman 0
4437802 2181147 2181147 defendant Frost Thomas   591160 591160 Frost, Thomas, of Tatyngton 0
4437805 2181148 2181148 defendant Frost Thomas   591160 591160 Frost, Thomas, of Tatyngton 0
4445371 2183502 2183502 plaintiff Crandale Thomas de   591160 591160 Crandale, Thomas de, of Tatyngton, vicar 0
4445372 2183502 2183502 defendant Parker Robert le   591160 591160 Parker, Robert le, of Tatyngton 0
4445502 2183547 2183547 plaintiff Crondale Thomas   591160 591160 Crondale, Thomas, of Tatyngton, vicar 0
4445503 2183547 2183547 defendant Parker Robert le   591160 591160 Parker, Robert le, of Tatyngton 0
4486901 2196618 2196618 defendant Godyng Thomas   591160 591160 Godyng, Thomas, of Tatyngton 0
4581293 2225614 2225614 defendant Dust Benedict   591160 591160 Dust, Benedict, of Tatyngton 1
4581297 2225615 2225615 defendant Dust Benedict   591160 591160 Dust, Benedict, of Tatyngton 1
4593048 2229134 2229134 defendant Coterell Henry le   591160 591160 Coterell, Henry le, of Tatyngton 0
4593049 2229134 2229134 defendant Gladewyn Richard le   591160 591160 Gladewyn, Richard le, of Tatyngton 1
4594488 2229536 2229536 defendant Skynnere Robert   591160 591160 Skynnere, Robert, of Tatyngton 0
4594490 2229537 2229537 defendant Skynnere Robert   591160 591160 Skynnere, Robert, of Tatyngton 0
4610509 2234358 2234358 defendant Godyng Thomas   591160 591160 Godyng, Thomas, of Tatyngton 3
4610525 2234359 2234359 defendant Godyng Thomas   591160 591160 Godyng, Thomas, of Tatyngton 11
4617264 2236412 2236412 plaintiff Godyng Thomas   591160 591160 Godyng, Thomas, of Tatyngton 0
4629378 2240117 2240117 defendant Godyng Thomas   591160 591160 Godyng, Thomas, of Tatyngton 0
4687840 2261763 2261763 defendant Brak Thomas yeoman 591160 591160 Brak, Thomas, of Tatyngton, yeoman 1
4739338 2277391 2277391 defendant Parker William yeoman 591160 591160 Parker, William, of Tatyngton, yeoman 0
4827571 2304672 2304672 defendant Aylmere John yeoman 591160 591160 Aylmere, John, of Tatyngton, yeoman 0
4861831 2315076 2315076 defendant Aylmere John   591160 591160 Aylmere, John, of Tatyngton, franklin 0
4963331 2345941 2345941 defendant Aylmere William gent 591160 591160 Aylmere, William, of Tatyngton, gent 0
4966346 2346869 2346869 defendant Drane or Drave John husbandman 591160 591160 Drane or Drave, John, of Tatyngton, husbandman 0
4966347 2346869 2346869 defendant Drane or Drave Thomas husbandman 591160 591160 Drane or Drave, Thomas, of Tatyngton, husbandman 1
4966348 2346869 2346869 defendant Drane or Drave William laborer 591160 591160 Drane or Drave, William, of Tatyngton, laborer 2
5023943 2363915 2363915 defendant Denys John gent 591160 591160 Denys, John, of Tatyngton, gent 1
5025160 2364255 2364255 defendant Aylmere John yeoman 591160 591160 Aylmere, John, of Tatyngton, yeoman 0
5110202 2389390 2389390 defendant Jenour John smith 591160 591160 Jenour, John, of Tatyngton, smith 0
5142051 2398797 2398797 defendant Aylmer William gent 591160 591160 Aylmer, William, of Tatyngton, gent 0
5163218 2404972 2404972 defendant Aylmer William gent 591160 591160 Aylmer, William, of Tatyngton, gent 0
5176961 2408953 2408953 defendant Aylmer William gent 591160 591160 Aylmer, William, of Tatyngton, gent 0
5184689 2411271 2411271 defendant Alred Rogerf yeoman 591160 591160 Alred, Rogerf, of Tatyngton, yeoman 0
5199632 2415636 2415636 defendant Aylmer William gent 591160 591160 Aylmer, William, of Tatyngton, gent 0
5204458 2417055 2417055 defendant Alred Roger yeoman 591160 591160 Alred, Roger, of Tatyngton, yeoman 0
5211171 2418994 2418994 defendant Aylmer William gent 591160 591160 Aylmer, William, of Tatyngton, gent 0
5239489 2427133 2427133 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 2
5256377 2432118 2432118 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 0
5295441 2443659 2443659 defendant Aylmere Roger esq 591160 591160 Aylmere, Roger, of Tatyngton, esq 1
5310218 2448090 2448090 defendant Aylmere Roger esq 591160 591160 Aylmere, Roger, of Tatyngton, esq 0
5324018 2452272 2452272 plaintiff Pod Robert, junior   591160 591160 Pod, Robert, junior, of Tatyngton 0
5327499 2453293 2453293 defendant Aylmere Roger esq 591160 591160 Aylmere, Roger, of Tatyngton, esq 0
5350908 2460393 2460393 defendant Broun Robert carpenter 591160 591160 Broun, Robert, of Tatyngton, carpenter 4
5364026 2464407 2464407 defendant Necholl John yeoman 591160 591160 Necholl, John, of Tatyngton, yeoman 0
5395303 2473732 2473732 defendant Boreth Alan husbandman 591160 591160 Boreth, Alan, of Tatyngton, husbandman 1
5408574 2477529 2477529 defendant Boreth Alan husbandman 591160 591160 Boreth, Alan, of Tatyngton, husbandman 0
5410729 2478154 2478154 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 1
5421035 2481222 2481222 defendant Alreed Roger yeoman 591160 591160 Alreed, Roger, of Tatyngton, yeoman 0
5421794 2481454 2481454 defendant Boreth Alan husbandman 591160 591160 Boreth, Alan, of Tatyngton, husbandman 0
5421797 2481455 2481455 defendant Boreth Alan husbandman 591160 591160 Boreth, Alan, of Tatyngton, husbandman 0
5424799 2482375 2482375 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 1
5424806 2482376 2482376 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 1
5424812 2482377 2482377 defendant Nicholl John yeoman 591160 591160 Nicholl, John, of Tatyngton, yeoman 0
5440217 2486973 2486973 defendant Alreed Roger yeoman 591160 591160 Alreed, Roger, of Tatyngton, yeoman 0
5457234 2492061 2492061 defendant Bedon Stephen carpenter 591160 591160 Bedon, Stephen, of Tatyngton, carpenter 4
5468014 2495376 2495376 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 0
5469085 2495680 2495680 defendant Beden Stephen carpenter 591160 591160 Beden, Stephen, of Tatyngton, carpenter 4
5480255 2499074 2499074 defendant Bedon Stephen carpenter 591160 591160 Bedon, Stephen, of Tatyngton, carpenter 3
5481269 2499344 2499344 defendant Warner William yeoman 591160 591160 Warner, William, of Tatyngton, yeoman 0
5482739 2499783 2499783 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 0
5491417 2502319 2502319 defendant Nycoll John, senior yeoman 591160 591160 Nycoll, John, senior, of Tatyngton, yeoman 6
5491420 2502319 2502319 defendant Godyng Richard husbandman 591160 591160 Godyng, Richard, of Tatyngton, husbandman 9
5491421 2502319 2502319 defendant Deynes John husbandman 591160 591160 Deynes, John, of Tatyngton, husbandman 10
5495056 2503421 2503421 defendant Reydon Roger laborer 591160 591160 Reydon, Roger, of Tatyngton, laborer 1
5528890 2513557 2513557 defendant Alred Roger yeoman 591160 591160 Alred, Roger, of Tatyngton, yeoman 0
5528892 2513558 2513558 defendant Nicoll John yeoman 591160 591160 Nicoll, John, of Tatyngton, yeoman 0
5554446 2521335 2521335 defendant Crane Philip cooper 591160 591160 Crane, Philip, of Tatyngton, cooper 0
5613408 2547983 2547983 plaintiff Crondale Thomas de   591160 591160 Crondale, Thomas de, of Tatyngton, vicar 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);