names

48 rows where place_id = 757631

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4447454 2184118 2184118 defendant Langham William   757631 757631 Langham, William, of Elmesete 0
4496069 2199446 2199446 defendant Smyth John (legal representative) 757631 757631 Smyth, John, of Elmesete, executors of 1
4619201 2237002 2237002 defendant Ram John, sen   757631 757631 Ram, John, sen, of Elmesete 4
4624945 2238770 2238770 defendant Bacon Bartholomew   757631 757631 Bacon, Bartholomew, of Elmesete 1
4657633 2248280 2248280 defendant Mascall Roger esq 757631 757631 Mascall, Roger, of Elmesete, esq 0
4657641 2248281 2248281 defendant Mascall Roger esq 757631 757631 Mascall, Roger, of Elmesete, esq 0
4697479 2264699 2264699 defendant Mascall Roger esq 757631 757631 Mascall, Roger, of Elmesete, esq 0
4723278 2272591 2272591 plaintiff Mascal Roger   757631 757631 Mascal, Roger, of Elmesete 2
4770656 2286804 2286804 defendant Binne William yeoman 757631 757631 Binne, William, of Elmesete, yeoman 1
4806108 2298118 2298118 defendant Brook John, senior laborer 757631 757631 Brook, John, senior, of Elmesete, laborer 0
4806109 2298118 2298118 defendant Brook John, junior laborer 757631 757631 Brook, John, junior, of Elmesete, laborer 1
4806110 2298118 2298118 defendant Brook Nicholas laborer 757631 757631 Brook, Nicholas, of Elmesete, laborer 2
4806111 2298118 2298118 defendant Bunne John laborer 757631 757631 Bunne, John, of Elmesete, laborer 3
4806112 2298118 2298118 defendant Dunne Geoffrey laborer 757631 757631 Dunne, Geoffrey, of Elmesete, laborer 4
4835084 2306975 2306975 defendant Brook John yeoman 757631 757631 Brook, John, of Elmesete, yeoman 0
4835088 2306975 2306975 defendant Weyvyene William yeoman 757631 757631 Weyvyene, William, of Elmesete, yeoman 4
4835089 2306975 2306975 defendant Weyvyene John yeoman 757631 757631 Weyvyene, John, of Elmesete, yeoman 5
4838392 2307922 2307922 defendant Brock John yeman 757631 757631 Brock, John, of Elmesete, yeman 0
4861982 2315127 2315127 defendant Brook John yeoman 757631 757631 Brook, John, of Elmesete, yeoman 0
4861985 2315127 2315127 defendant Weynyeve William yeoman 757631 757631 Weynyeve, William, of Elmesete, yeoman 3
4861986 2315127 2315127 defendant Waynyeve John yeoman 757631 757631 Waynyeve, John, of Elmesete, yeoman 4
4861992 2315128 2315128 defendant Weynyeve William yeoman 757631 757631 Weynyeve, William, of Elmesete, yeoman 2
4861993 2315128 2315128 defendant Waynyeve John yeoman 757631 757631 Waynyeve, John, of Elmesete, yeoman 3
4861994 2315128 2315128 defendant Brook John yeoman 757631 757631 Brook, John, of Elmesete, yeoman 4
4865578 2316199 2316199 defendant Brook John yeoman 757631 757631 Brook, John, of Elmesete, yeoman 0
4884070 2321929 2321929 defendant Deye Richard husbandman 757631 757631 Deye, Richard, of Elmesete, husbandman 1
4884071 2321929 2321929 defendant Blakesale John husbandman 757631 757631 Blakesale, John, of Elmesete, husbandman 2
4952552 2342721 2342721 defendant Aleyn Richard clerk 757631 757631 Aleyn, Richard, of Elmesete, clerk 0
4993384 2354893 2354893 defendant Aleyn Richard clerk 757631 757631 Aleyn, Richard, of Elmesete, clerk 0
5007048 2358957 2358957 defendant Warde Thomas husbandman 757631 757631 Warde, Thomas, of Elmesete, husbandman 0
5020413 2362856 2362856 defendant Aleyn Richard clerk 757631 757631 Aleyn, Richard, of Elmesete, clerk 0
5025059 2364228 2364228 defendant Warde Thomas husbandman 757631 757631 Warde, Thomas, of Elmesete, husbandman 4
5042756 2369439 2369439 defendant Warde Thomas husbandman 757631 757631 Warde, Thomas, of Elmesete, husbandman 5
5069847 2377475 2377475 defendant Warde Thomas butcher 757631 757631 Warde, Thomas, of Elmesete, butcher 2
5081238 2380894 2380894 defendant Warde Thomas yeoman 757631 757631 Warde, Thomas, of Elmesete, yeoman 0
5086023 2382303 2382303 defendant Warde Thomas husbandman 757631 757631 Warde, Thomas, of Elmesete, husbandman 4
5086028 2382304 2382304 defendant Warde Thomas husbandman 757631 757631 Warde, Thomas, of Elmesete, husbandman 3
5086034 2382305 2382305 defendant Warde John yeoman 757631 757631 Warde, John, of Elmesete, yeoman 4
5138578 2397780 2397780 defendant Aleyn Richard   757631 757631 Aleyn, Richard, of Elmesete 2
5292172 2442705 2442705 defendant Lodbrook William yeoman 757631 757631 Lodbrook, William, of Elmesete, yeoman 2
5293716 2443124 2443124 defendant Warde Thomas yeoman 757631 757631 Warde, Thomas, of Elmesete, yeoman 0
5311730 2448529 2448529 defendant Lodbrook William yeoman 757631 757631 Lodbrook, William, of Elmesete, yeoman 1
5321737 2451574 2451574 defendant Snellyng Alexander husbandman 757631 757631 Snellyng, Alexander, of Elmesete, husbandman 1
5325690 2452764 2452764 defendant Lodbrook William yeoman 757631 757631 together with Lodbrook, William, of Elmesete, yeoman 1
5325692 2452765 2452765 defendant Lodbrook William yeoman 757631 757631 Lodbrook, William, of Elmesete, yeoman 0
5613797 2548090 2548090 defendant Haukyn Adam   757631 757631 Haukyn, Adam, of Elmesete 1
5629966 2553373 2553373 defendant Porter Nicholas husbandman 757631 757631 Porter, Nicholas, of Elmesete, husbandman 0
5636701 2555424 2555424 defendant Mascall Roger esq 757631 757631 Mascall, Roger, of Elmesete, esq 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);