names

52 rows where place_id = 589582

✎ 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
3598053 1867014 1867014 defendant Gybbes John husbandman 589582 589582 Gybbes, John, of Mafeld, husbandman 5
3598056 1867015 1867015 defendant Gybbes John husbandman 589582 589582 Gybbes, John, of Mafeld, husbandman 1
3698604 1925779 1925779 defendant Wymbysherst William weaver 589582 589582 Wymbysherst, William, of Mafeld, weaver 0
3698605 1925779 1925779 defendant Mowseherst William husbandman 589582 589582 Mowseherst, William, of Mafeld, husbandman 1
3698606 1925779 1925779 defendant Wenbourn William carpenter 589582 589582 Wenbourn, William, of Mafeld, carpenter 2
3698608 1925779 1925779 defendant Lukke John laborer 589582 589582 Lukke, John, of Mafeld, laborer 4
3698609 1925779 1925779 defendant Fletcher Richard yeoman 589582 589582 Fletcher, Richard, of Mafeld, yeoman 5
3698614 1925779 1925779 defendant Wenborne Thomas yeoman 589582 589582 Wenborne, Thomas, of Mafeld, yeoman 10
3698615 1925779 1925779 defendant Rolf John laborer 589582 589582 Rolf, John, of Mafeld, laborer 11
3698616 1925779 1925779 defendant Wymbysherst John yeoman 589582 589582 Wymbysherst, John, of Mafeld, yeoman 12
3699962 1926221 1926221 defendant Vosshell Woden collier 589582 589582 Vosshell, Woden, of Mafeld, collier 0
3699963 1926221 1926221 defendant Vosshell Thomas collier 589582 589582 Vosshell, Thomas, of Mafeld, collier 1
3745155 1940390 1940390 defendant Bovynden John husbandman 589582 589582 Bovynden, John, of Mafeld, husbandman 0
3751035 1942257 1942257 plaintiff Mone William (legal representative) 589582 589582 Mone, William, of Mafeld, yeoman, executor of 0
3751037 1942257 1942257 defendant A Wodde William laborer 589582 589582 A Wodde, William, of Mafeld, laborer 0
3782110 1952157 1952157 defendant Weston Thomas mercer 589582 589582 Weston, Thomas, of Mafeld, mercer 0
3789899 1954665 1954665 defendant Brykden John husbandman 589582 589582 Brykden, John, of Mafeld, husbandman 0
4496538 2199593 2199593 plaintiff Cowedenn Richard   589582 589582 Cowedenn, Richard, of Mafeld, 0
4510177 2203668 2203668 defendant Glover Geoffrey   589582 589582 Glover, Geoffrey, of Mafeld 0
4770071 2286610 2286610 defendant Heryng Thomas butcher 589582 589582 Heryng, Thomas, of Mafeld, butcher 2
4778065 2289126 2289126 defendant Bost Thomas husbandman 589582 589582 Bost, Thomas, of Mafeld, husbandman 0
4805517 2297937 2297937 defendant Kynch Nicholas husbandman 589582 589582 Kynch, Nicholas, of Mafeld, husbandman 0
4810581 2299458 2299458 defendant Beynden Thomas, senior gent 589582 589582 Beynden, Thomas, senior, of Mafeld, gent 1
4862972 2315399 2315399 defendant Kenge Robert laborer 589582 589582 Kenge, Robert, of Mafeld, laborer 0
4862985 2315401 2315401 defendant Kynge Robert husbandman 589582 589582 Kynge, Robert, of Mafeld, husbandman 1
4864807 2315968 2315968 defendant Poweke John husbandman 589582 589582 Poweke, John, of Mafeld, husbandman 0
4864808 2315968 2315968 defendant Rukke John husbandman 589582 589582 Rukke, John, of Mafeld, husbandman 1
4876735 2319697 2319697 defendant Stonlegh William yeoman 589582 589582 Stonlegh, William, of Mafeld, yeoman 0
4882104 2321303 2321303 defendant Ky- Robert husbandman 589582 589582 Ky-, Robert, of Mafeld, husbandman 1
4895264 2325178 2325178 defendant atte Water William tailor 589582 589582 atte Water, William, of Mafeld, tailor 0
4938923 2338564 2338564 defendant Ponte Richard butcher 589582 589582 Ponte, Richard, of Mafeld, butcher 0
4946110 2340772 2340772 defendant Wodegate John husbandman 589582 589582 Wodegate, John, of Mafeld, husbandman 2
4946117 2340773 2340773 defendant Wodegate John husbandman 589582 589582 Wodegate, John, of Mafeld, husbandman 2
4951342 2342382 2342382 defendant atte Welle William husbandman 589582 589582 atte Welle, William, of Mafeld, husbandman 0
4957318 2344150 2344150 defendant Wylmesherst Lawrence weaver 589582 589582 Wylmesherst, Lawrence, of Mafeld, weaver 1
4963848 2346099 2346099 defendant Ponte Richard butcher 589582 589582 Ponte, Richard, of Mafeld, butcher 1
4974453 2349322 2349322 defendant Crust Thomas butcher 589582 589582 Crust, Thomas, of Mafeld, butcher 0
4974454 2349322 2349322 defendant Pynder Nicholas laborer 589582 589582 Pynder, Nicholas, of Mafeld, laborer 1
5120893 2392542 2392542 defendant Knyght John cordwainer 589582 589582 Knyght, John, of Mafeld, cordwainer 0
5193128 2413719 2413719 defendant Aynescombe John fuller 589582 589582 Aynescombe, John, of Mafeld, fuller 0
5208272 2418147 2418147 defendant Rede William husbandman 589582 589582 Rede, William, of Mafeld, husbandman 1
5216791 2420651 2420651 defendant Frye William laborer 589582 589582 Frye, William, of Mafeld, laborer 2
5223974 2422694 2422694 defendant Rede William husbandman 589582 589582 Rede, William, of Mafeld, husbandman 1
5248872 2429790 2429790 defendant Pont John weaver 589582 589582 Pont, John, of Mafeld, weaver 2
5248873 2429790 2429790 defendant Couper John cooper 589582 589582 Couper, John, of Mafeld, cooper 3
5262646 2434063 2434063 defendant Wynter William gent 589582 589582 Wynter, William, of Mafeld, gent 0
5262647 2434063 2434063 defendant Couper John, junior laborer 589582 589582 Couper, John, junior, of Mafeld, laborer 1
5280086 2439250 2439250 defendant Mone Lawrence husbandman 589582 589582 Mone, Lawrence, of Mafeld, husbandman 0
5414339 2479224 2479224 defendant Tomson Robert yeoman 589582 589582 Tomson, Robert, of Mafeld, yeoman 0
5459413 2492730 2492730 defendant Tomson Robert yeoman 589582 589582 Tomson, Robert, of Mafeld, yeoman 0
5589018 2531575 2531575 defendant Relffe William husbandman 589582 589582 Relffe, William, of Mafeld, husbandman 1
5589019 2531575 2531575 defendant Marten John husbandman 589582 589582 Marten, John, of Mafeld, husbandman 2

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