names

70 rows where place_id = 613015

✎ 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
3696122 1925010 1925010 defendant Butler John yeoman 613015 613015 (Butler, John, of Edlyngton, yeoman 1
3770423 1948427 1948427 defendant Thymylby Mathew gent 613015 613015 Thymylby, Mathew, of Edlyngton, gent 0
3776968 1950541 1950541 defendant Jakson John husbandman 613015 613015 Jakson, John, of Edlyngton, husbandman 0
3800223 1957990 1957990 defendant Thornton Joan widow 613015 613015 Thornton, Joan, of Edlyngton, widow 2
3809396 1960821 1960821 defendant Robuck Richard husbandman 613015 613015 Robuck, Richard, of Edlyngton, husbandman 0
3827271 1966397 1966397 defendant Gylpyng Gilslet gent 613015 613015 Gylpyng, Gilslet, of Edlyngton, gent 0
3846353 1972413 1972413 defendant Palfreyman Robert yeoman 613015 613015 Palfreyman, Robert, of Edlyngton, yeoman 1
3881383 1984040 1984040 defendant Boswell Thomas gent 613015 613015 Boswell, Thomas, of Edlyngton, gent 0
3881384 1984040 1984040 defendant Cartwright John yeoman 613015 613015 Cartwright, John, of Edlyngton, yeoman 1
3881385 1984040 1984040 defendant Jakson Thomas yeoman 613015 613015 Jakson, Thomas, of Edlyngton, yeoman 2
3881386 1984040 1984040 defendant Ledbeter John yeoman 613015 613015 Ledbeter, John, of Edlyngton, yeoman 3
3881387 1984040 1984040 defendant Emere Thomas yeoman 613015 613015 Emere, Thomas, of Edlyngton, yeoman 4
3881388 1984040 1984040 defendant ferro Robert yeoman 613015 613015 ferro, Robert, of Edlyngton, yeoman 5
3881389 1984040 1984040 defendant Emere William yeoman 613015 613015 Emere, William, of Edlyngton, yeoman 6
3881391 1984041 1984041 defendant Smyth John yeoman 613015 613015 Smyth, John, of Edlyngton, yeoman 0
3881392 1984041 1984041 defendant Smyth Thomas yeoman 613015 613015 Smyth, Thomas, of Edlyngton, yeoman 1
3881393 1984041 1984041 defendant Vasse Martin laborer 613015 613015 Vasse, Martin, of Edlyngton, laborer 2
3881394 1984041 1984041 defendant Thornton Robert tailor 613015 613015 Thornton, Robert, of Edlyngton, tailor 3
3881395 1984041 1984041 defendant Drable William smith 613015 613015 Drable, William, of Edlyngton, smith 4
3881396 1984041 1984041 defendant Arnold William laborer 613015 613015 Arnold, William, of Edlyngton, laborer 5
3881397 1984041 1984041 defendant Horton Richard laborer 613015 613015 Horton, Richard, of Edlyngton, laborer 6
3921202 1997443 1997443 defendant Marshall Robert husbandman 613015 613015 Marshall, Robert, of Edlyngton, husbandman 0
3921203 1997443 1997443 defendant Whytehood Robert husbandman 613015 613015 Whytehood, Robert, of Edlyngton, husbandman 1
3921204 1997443 1997443 defendant Jakson Thomas husbandman 613015 613015 Jakson, Thomas, of Edlyngton, husbandman 2
3921205 1997443 1997443 defendant Johnson Thomas husbandman 613015 613015 Johnson, Thomas, of Edlyngton, husbandman 3
3975518 2016002 2016002 defendant Rede Thomas gent 613015 613015 Rede, Thomas, of Edlyngton, gent 1
4035028 2037210 2037210 defendant Reade Thomas gent 613015 613015 Reade, Thomas, of Edlyngton, gent 0
4035031 2037211 2037211 defendant Reade Thomas gent 613015 613015 Reade, Thomas, of Edlyngton, gent 0
4043513 2040140 2040140 defendant Fede Henry yeoman 613015 613015 Fede, Henry, of Edlyngton, yeoman 0
4286423 2125183 2125183 defendant Lee Clement yeoman 613015 613015 Lee, Clement, of Edlyngton, yeoman 0
4295052 2128312 2128312 defendant Lee Edmund yeoman 613015 613015 Lee, Edmund, of Edlyngton, yeoman 0
4505262 2202176 2202176 defendant Cartewryght John   613015 613015 Cartewryght, John, of Edlyngton 2
4510224 2203682 2203682 defendant Raynald John   613015 613015 Raynald, John, of Edlyngton 0
4510225 2203682 2203682 defendant atte Abbotes William   613015 613015 atte Abbotes, William, of Edlyngton 1
4548716 2215537 2215537 defendant Forster Ralph   613015 613015 Forster, Ralph, of Edlyngton 0
4606703 2233209 2233209 defendant Poye Simon   613015 613015 Poye, Simon, of Edlyngton 0
4636376 2242212 2242212 defendant Forman John   613015 613015 Forman, John, of Edlyngton 0
4664578 2250401 2250401 defendant Fester Richard husbandman 613015 613015 Fester, Richard, of Edlyngton, husbandman 2
4664655 2250422 2250422 defendant Forster Richard husbandman 613015 613015 Forster, Richard, of Edlyngton, husbandman 2
4674498 2257635 2257635 defendant Crobber Richard husbandman 613015 613015 Crobber, Richard, of Edlyngton, husbandman 4
4679816 2259297 2259297 defendant Boswell Richard yeoman 613015 613015 Boswell, Richard, of Edlyngton, yeoman 1
4725541 2273279 2273279 defendant Burges Alice   613015 613015 Burges, Alice, of Edlyngton, widow, formerly of Robert 0
4725542 2273279 2273279 defendant Burges John laborer 613015 613015 Burges, John, of Edlyngton, laborer 1
4725543 2273279 2273279 defendant Derlyng William laborer 613015 613015 Derlyng, William, of Edlyngton, laborer 2
4725544 2273279 2273279 defendant Cartwryght John yeoman 613015 613015 Cartwryght, John, of Edlyngton, yeoman 3
4730414 2274708 2274708 defendant Burges Robert (legal representative) 613015 613015 Burges, Robert, of Edlyngton, executrix of 0
4848173 2310900 2310900 defendant Webster John husbandman 613015 613015 Webster, John, of Edlyngton, husbandman 0
4857810 2313814 2313814 defendant Bradley Robert   613015 613015 Bradley, Robert, of Edlyngton, cartwright 0
4868991 2317276 2317276 defendant Halyday John carpenter 613015 613015 Halyday, John, of Edlyngton, carpenter 0
4868992 2317276 2317276 defendant Milner William husbandman 613015 613015 Milner, William, of Edlyngton, husbandman 1
4878056 2320090 2320090 defendant Cokke William husbandman 613015 613015 Cokke, William, of Edlyngton, husbandman 2
4914499 2331054 2331054 defendant Stanes John merchant 613015 613015 Stanes, John, of Edlyngton, merchant 6
4967958 2347358 2347358 defendant Milner William husbandman 613015 613015 Milner, William, of Edlyngton, husbandman 1
4973726 2349096 2349096 defendant Jolyff John yeoman 613015 613015 Jolyff, John, of Edlyngton, yeoman 1
5061335 2374973 2374973 defendant Nobys Thomas husbandman 613015 613015 Nobys, Thomas, of Edlyngton, husbandman 0
5091522 2383910 2383910 defendant Tailour William yeoman 613015 613015 Tailour, William, of Edlyngton, yeoman 3
5106566 2388346 2388346 defendant Mylner Christopher husbandman 613015 613015 Mylner, Christopher, of Edlyngton, husbandman 0
5113915 2390458 2390458 defendant Kirkby John clerk 613015 613015 Kirkby, John, of Edlyngton, clerk 0
5113916 2390458 2390458 defendant Thomson William husbandman 613015 613015 Thomson, William, of Edlyngton, husbandman 1
5113917 2390458 2390458 defendant Dryffeld William husbandman 613015 613015 Dryffeld, William,of Edlyngton, husbandman 2
5125455 2393929 2393929 defendant Hogeson Nicholas husbandman 613015 613015 Hogeson, Nicholas, of Edlyngton, husbandman 0
5133758 2396364 2396364 plaintiff Jolyff John   613015 613015 Jolyff, John, of Edlyngton 0
5133759 2396364 2396364 defendant Hoggeson Nicholas husbandman 613015 613015 Hoggeson, Nicholas, of Edlyngton, husbandman 0
5165044 2405517 2405517 defendant Hogeson Nicholas husbandman 613015 613015 Hogeson, Nicholas, of Edlyngton, husbandman 0
5184637 2411253 2411253 defendant Milner Christopher husbandman 613015 613015 Milner, Christopher, of Edlyngton, husbandman 0
5247797 2429502 2429502 defendant Clerk William   613015 613015 Clerk, William, of Edlyngton, parish clerk 0
5586557 2530832 2530832 defendant Thymbylby Robert gent 613015 613015 Thymbylby, Robert, of Edlyngton, gent 1
5586561 2530833 2530833 defendant Thymbylby Robert gent 613015 613015 Thymbylby, Robert, of Edlyngton, gent 1
5586565 2530834 2530834 defendant Thymbylby Robert gent 613015 613015 Thymbylby, Robert, of Edlyngton, gent 0
5601815 2535468 2535468 defendant Thymbylby Robert gent 613015 613015 Thymbylby, Robert, of Edlyngton, gent 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);