names

35 rows where place_id = 598406

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632332 1904933 1904933 defendant Gyrton Richard husbandman 598406 598406 Gyrton, Richard, of Meldeburne, husbandman 3
4437423 2176451 2176451 defendant atte Grene Thomas chaplain 598406 598406 atte Grene, Thomas, of Meldeburne, chaplain 1
4454723 2186484 2186484 plaintiff Marchal John   598406 598406 Marchal, John, of Meldeburne, son of Wiliam 0
4456959 2187185 2187185 defendant Wesenham John de   598406 598406 Wesenham, John de, of Meldeburne, vicar 0
4605014 2232727 2232727 plaintiff Aleyn William   598406 598406 Aleyn, William, of Meldeburne 0
4605256 2232811 2232811 defendant Ferour John   598406 598406 Ferour, John, of Meldeburne 0
4610287 2234302 2234302 defendant Geppesson John   598406 598406 Geppesson, John, of Meldeburne 1
4610288 2234302 2234302 defendant Lynterne John   598406 598406 Lynterne, John, of Meldeburne 2
4635689 2242008 2242008 plaintiff Aleyn William   598406 598406 Aleyn, William, of Meldeburne 0
4692254 2263092 2263092 defendant Russheden William husbandman 598406 598406 Russheden, William, of Meldeburne, husbandman 0
4700688 2265617 2265617 defendant Cusyn Walter yeoman 598406 598406 Cusyn, Walter, of Meldeburne, yeoman 0
4700692 2265618 2265618 defendant Stokes Thomas husbandman 598406 598406 Stokes, Thomas, of Meldeburne, husbandman 0
4700693 2265618 2265618 defendant Turvey John husbandman 598406 598406 Turvey, John, of Meldeburne, husbandman 1
4700694 2265618 2265618 defendant Newelyn John yeoman 598406 598406 Newelyn, John, of Meldeburne, yeoman 2
4734277 2275895 2275895 defendant Gentyng Thomas husbandman 598406 598406 Gentyng, Thomas, of Meldeburne, husbandman 0
4791759 2293521 2293521 defendant Stokys Thomas husbandman 598406 598406 Stokys, Thomas, of Meldeburne, husbandman 0
4791760 2293521 2293521 defendant Sturmyn Walter husbandman 598406 598406 Sturmyn, Walter, of Meldeburne, husbandman 1
4861585 2314994 2314994 defendant Cotill Geoffrey husbandman 598406 598406 Cotill, Geoffrey, of Meldeburne, husbandman 1
4929287 2335578 2335578 defendant Gentyng Thomas husbandman 598406 598406 Gentyng, Thomas, of Meldeburne, husbandman 0
4929291 2335578 2335578 defendant Jepson John husbandman 598406 598406 Jepson, John, of Meldeburne, husbandman 4
4950908 2342250 2342250 defendant Cotell Geoffrey husbandman 598406 598406 Cotell, Geoffrey, of Meldeburne, husbandman 4
4954222 2343235 2343235 defendant Payne John butcher 598406 598406 Payne, John, of Meldeburne, butcher 1
4958546 2344524 2344524 defendant Cotell William woolman 598406 598406 Cotell, William, of Meldeburne, woolman 0
4958547 2344524 2344524 defendant Trygge alias Clement John woolman 598406 598406 Trygge alias Clement, John, of Meldeburne, woolman 1
4977536 2350246 2350246 defendant Cotele John laborer 598406 598406 Cotele, John, of Meldeburne, laborer 0
4989337 2353745 2353745 plaintiff Chamburleyn John   598406 598406 Chamburleyn, John, of Meldeburne 1
4989338 2353745 2353745 defendant Cosyne Walter husbandman 598406 598406 Cosyne, Walter, of Meldeburne, husbandman 0
4989339 2353745 2353745 defendant Cosyn John husbandman 598406 598406 Cosyn, John, of Meldeburne, husbandman 1
5008246 2359302 2359302 defendant Lucas John baker 598406 598406 Lucas, John, of Meldeburne, baker 0
5023050 2363648 2363648 defendant Lucas John baker 598406 598406 Lucas, John, of Meldeburne, baker 3
5052326 2372298 2372298 defendant Ware Thomas husbandman 598406 598406 Ware, Thomas, of Meldeburne, husbandman 0
5052327 2372298 2372298 defendant Ware John husbandman 598406 598406 Ware, John, of Meldeburne, husbandman 1
5052329 2372298 2372298 defendant Lorde John pulter 598406 598406 Lorde, John, of Meldeburne, pulter 3
5632906 2554299 2554299 defendant Gepsone William husbandman 598406 598406 Gepsone, William, of Meldeburne, husbandman 0
5632907 2554299 2554299 defendant Ferour or Smith William, senior pulter 598406 598406 Ferour or Smith, William, senior, of Meldeburne, pulter 1

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