names

43 rows where place_id = 758818

✎ 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
4424601 2172534 2172534 plaintiff Kent Robert de   758818 758818 Kent, Robert de, of Leryngsete, parson 0
4456999 2187199 2187199 defendant Lytster John   758818 758818 Lytster, John, of Leryngsete 4
4526921 2208701 2208701 plaintiff Leche Richard   758818 758818 Leche, Richard, of Leryngsete 0
4607542 2233471 2233471 defendant Herryesson Thomas   758818 758818 Herryesson, Thomas, of Leryngsete 1
4650817 2246258 2246258 defendant Betes Stephen   758818 758818 Betes, Stephen, of Leryngsete 0
4666337 2250945 2250945 plaintiff Isabel sister of Thomas Meliers   758818 758818 Isabel, sister of Thomas Meliers, of Leryngsete 0
4690837 2262665 2262665 defendant Lyghtfote Robert thatcher 758818 758818 Lyghtfote, Robert, of Leryngsete, thatcher 0
4865352 2316132 2316132 defendant Cooke John butcher 758818 758818 Cooke, John, of Leryngsete, butcher 4
4943897 2340055 2340055 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 1
5053651 2372695 2372695 defendant Bocher Godfrey butcher 758818 758818 Bocher, Godfrey, of Leryngsete, butcher 1
5069997 2377521 2377521 defendant Bircham William barker 758818 758818 Bircham, William, of Leryngsete, barker 0
5073805 2378652 2378652 defendant Crese William laborer 758818 758818 Crese, William, of Leryngsete, laborer 2
5097302 2385642 2385642 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 2
5102427 2387112 2387112 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 0
5102429 2387113 2387113 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 0
5121276 2392656 2392656 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 0
5166754 2406002 2406002 defendant Hard William husbandman 758818 758818 Hard, William, of Leryngsete, husbandman 0
5179387 2409708 2409708 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 3
5179390 2409709 2409709 defendant Betys John   758818 758818 Betys, John, of Leryngsete, yeoman, administrators of 1
5179392 2409709 2409709 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 3
5201876 2416314 2416314 defendant Betys Agnes widow 758818 758818 (Betys, Agnes, of Leryngsete, widow 2
5201877 2416314 2416314 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 3
5212961 2419526 2419526 defendant Randes Henry clerk 758818 758818 Randes, Henry, of Leryngsete, clerk 0
5219307 2421369 2421369 defendant Herryis William husbandman 758818 758818 Herryis, William, of Leryngsete, husbandman 2
5223733 2422625 2422625 defendant Harryes William miller 758818 758818 Harryes, William, of Leryngsete, miller 1
5223739 2422626 2422626 defendant Herryes William miller 758818 758818 Herryes, William, of Leryngsete, miller 1
5227601 2423696 2423696 defendant Lavelye John gent 758818 758818 Lavelye, John, of Leryngsete, gent 0
5233036 2425242 2425242 defendant Herryes William husbandman 758818 758818 Herryes, William, of Leryngsete, husbandman 2
5280049 2439238 2439238 defendant Ixworth Robert husbandman 758818 758818 Ixworth, Robert, of Leryngsete, husbandman 2
5312985 2448915 2448915 plaintiff Bene Nicholas clerk 758818 758818 Bene, Nicholas, of Leryngsete, clerk 0
5319203 2450838 2450838 defendant Colyns Nicholas yeoman 758818 758818 Colyns, Nicholas, of Leryngsete, yeoman 2
5330338 2454150 2454150 plaintiff Benet Nicholas clerk 758818 758818 Benet, Nicholas, of Leryngsete, clerk 0
5342520 2457861 2457861 defendant Betys John yeoman 758818 758818 Betys, John, of Leryngsete, yeoman 0
5351205 2460472 2460472 defendant Benet Nicholas clerk 758818 758818 Benet, Nicholas, of Leryngsete, clerk 0
5428700 2483498 2483498 defendant Mylles John yeoman 758818 758818 (Mylles, John, of Leryngsete, yeoman 5
5428708 2483499 2483499 defendant Mylles John yeoman 758818 758818 (Mylles, John, of Leryngsete, yeoman 5
5445959 2488679 2488679 defendant Mylles John yeoman 758818 758818 (Mylles, John, of Leryngsete, yeoman 5
5492774 2502756 2502756 defendant Betys John (legal representative) 758818 758818 Betys, John, of Leryngsete, yeoman, administratrix of 1
5492775 2502756 2502756 defendant Myllys Margaret widow 758818 758818 Myllys, Margaret, of Leryngsete, widow 2
5500157 2504999 2504999 defendant Wylles Richard yeoman 758818 758818 Wylles, Richard, of Leryngsete, yeoman 0
5500158 2504999 2504999 defendant Helme Peter husbandman 758818 758818 Helme, Peter, of Leryngsete, husbandman 1
5504327 2506267 2506267 defendant Milles Margaret widow 758818 758818 Milles, Margaret, of Leryngsete, widow 2
5509397 2507788 2507788 defendant Milles Margaret widow 758818 758818 Milles, Margaret, of Leryngsete, widow 4

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