names

76 rows where place_id = 586934

✎ 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
3590024 1864518 1864518 defendant Millar John miller 586934 586934 Millar, John, of Stotfold, miller 3
3677493 1919010 1919010 plaintiff Lorymer Richard yeoman 586934 586934 Lorymer, Richard, of Stotfold, yeoman 0
3721538 1933042 1933042 defendant Hall John husbandman 586934 586934 Hall, John, of Stotfold, husbandman 2
3726260 1934480 1934480 plaintiff Tayllour Henry   586934 586934 Tayllour, Henry, of Stotfold 0
3726261 1934480 1934480 defendant Bygrave John yeoman 586934 586934 Bygrave, John, of Stotfold, yeoman 0
3741150 1939093 1939093 defendant Stanbank Robert miller 586934 586934 Stanbank, Robert, of Stotfold, miller 4
3811030 1961343 1961343 defendant Bygrave John husbandman 586934 586934 Bygrave, John, of Stotfold, husbandman 1
3811031 1961343 1961343 defendant Alyston Thomas husbandman 586934 586934 Alyston, Thomas, of Stotfold, husbandman 2
3815440 1962745 1962745 defendant Browne Nicholas husbandman 586934 586934 Browne, Nicholas, of Stotfold, husbandman 0
3842051 1971068 1971068 defendant Haryson Christopher smith 586934 586934 Haryson, Christopher, of Stotfold, smith 0
3842052 1971068 1971068 defendant Bygrave John husbandman 586934 586934 Bygrave, John, of Stotfold, husbandman 1
3842053 1971068 1971068 defendant Coppes William miller 586934 586934 Coppes, William, of Stotfold, miller 2
3842054 1971068 1971068 defendant Curteys William   586934 586934 Curteys, William, of Stotfold, plough wright 3
3855332 1975306 1975306 defendant Bygrave John husbandman 586934 586934 Bygrave, John, of Stotfold, husbandman 0
3884357 1985036 1985036 plaintiff Wystowe John   586934 586934 Wystowe, John, of Stotfold 0
3946297 2005780 2005780 plaintiff Butler Edward (legal representative) 586934 586934 Butler, Edward, of Stotfold, executrix of 0
3946594 2005874 2005874 defendant Butler Elizabeth widow 586934 586934 Butler, Elizabeth, of Stotfold, widow 1
3955302 2008922 2008922 defendant Butler Elizabeth widow 586934 586934 Butler, Elizabeth, of Stotfold, widow 1
4059382 2045747 2045747 defendant Wolverston Humphrey gent 586934 586934 Wolverston, Humphrey, of Stotfold, gent 0
4060207 2046052 2046052 defendant Wolverston Humphrey gent 586934 586934 Wolverston, Humphrey, of Stotfold, gent 0
4074998 2051360 2051360 defendant Wolverston Humphrey gent 586934 586934 Wolverston, Humphrey, of Stotfold, gent 0
4190171 2092069 2092069 defendant Grene John husbandman 586934 586934 Grene, John, of Stotfold, husbandman 0
4190174 2092070 2092070 defendant Grene John husbandman 586934 586934 Grene, John, of Stotfold, husbandman 1
4295211 2128371 2128371 defendant Grene John husbandman 586934 586934 Grene, John, of Stotfold, husbandman 0
4316856 2136014 2136014 defendant Harryson Oswald laborer 586934 586934 Harryson, Oswald, of Stotfold, laborer 0
4321323 2137549 2137549 defendant Wolverston Stanley gent 586934 586934 Wolverston, Stanley, of Stotfold, gent 0
4414942 2169566 2169566 defendant atte Water John   586934 586934 atte Water, John, of Stotfold, son of Richard 0
4577250 2224404 2224404 plaintiff Canon Richard   586934 586934 Canon, Richard, of Stotfold 0
4616047 2236020 2236020 defendant West John   586934 586934 West, John, of Stotfold 0
4630759 2240513 2240513 defendant Clerk John   586934 586934 Clerk, John, of Stotfold 0
4641851 2243719 2243719 defendant Mundessone Peter   586934 586934 Mundessone, Peter, of Stotfold 1
4650345 2246122 2246122 plaintiff Widowessone Simon   586934 586934 Widowessone, Simon, of Stotfold 0
4675396 2257914 2257914 defendant Clerk John, senior husbandman 586934 586934 Clerk, John, senior, of Stotfold, husbandman 0
4689407 2262245 2262245 defendant Brounyng Thomas yeoman 586934 586934 Brounyng, Thomas, of Stotfold, yeoman 0
4700759 2265637 2265637 defendant Clerk John, sen husbandman 586934 586934 Clerk, John, sen, of Stotfold, husbandman 0
4873206 2318571 2318571 defendant Maye Thomas gent 586934 586934 Maye, Thomas, of Stotfold, gent 0
4879506 2320517 2320517 defendant Maye Thomas gent 586934 586934 Maye, Thomas, of Stotfold, gent 0
4879508 2320518 2320518 defendant Maye Thomas gent 586934 586934 Maye, Thomas, of Stotfold, gent 0
4948701 2341576 2341576 defendant Smyth Edmund husbandman 586934 586934 Smyth, Edmund, of Stotfold, husbandman 0
4969271 2347769 2347769 defendant Laurence William laborer 586934 586934 Laurence, William, of Stotfold, laborer 1
4993593 2354958 2354958 defendant Archer Richard esq & formerly sheriff 586934 586934 Archer, Richard, of Stotfold, esq & formerly sheriff 0
4993595 2354959 2354959 defendant Archer Richard   586934 586934 Archer, Richard, of Stotfold, esq, formerly sheriff 0
5012966 2360626 2360626 defendant Munde John   586934 586934 Munde, John, of Stotfold 0
5022616 2363521 2363521 defendant Langhan Simon   586934 586934 Langhan, Simon, of Stotfold, servant 1
5051733 2372130 2372130 defendant Munne John, junior husbandman 586934 586934 Munne, John, junior, of Stotfold, husbandman 1
5052493 2372339 2372339 defendant Munde John   586934 586934 Munde, John, of Stotfold 0
5062107 2375222 2375222 defendant Grene John gent 586934 586934 Grene, John, of Stotfold, gent 0
5181676 2410381 2410381 defendant Marchall Alfred yeoman 586934 586934 Marchall, Alfred, of Stotfold, yeoman 3
5193515 2413827 2413827 defendant Mekys Thomas husbandman 586934 586934 Mekys, Thomas, of Stotfold, husbandman 2
5208224 2418132 2418132 defendant Mekys Thomas husbandman 586934 586934 Mekys, Thomas, of Stotfold, husbandman 2
5212016 2419254 2419254 plaintiff Archear Richard esq 586934 586934 Archear, Richard, of Stotfold, esq 0
5212019 2419255 2419255 plaintiff Archear Richard esq 586934 586934 Archear, Richard, of Stotfold, esq 0
5223906 2422676 2422676 defendant Mekys Thomas husbandman 586934 586934 Mekys, Thomas, of Stotfold, husbandman 0
5238054 2426722 2426722 defendant Bradway Thomas husbandman 586934 586934 Bradway, Thomas, of Stotfold, husbandman 0
5238057 2426722 2426722 defendant Bradway John laborer 586934 586934 Bradway, John, of Stotfold, laborer 3
5285173 2440686 2440686 plaintiff Grene John   586934 586934 Grene, John, of Stotfold 0
5285178 2440687 2440687 plaintiff Grene John   586934 586934 Grene, John, of Stotfold 0
5303398 2446012 2446012 plaintiff Grene John, sen (legal representative) 586934 586934 Grene, John, sen, of Stotfold, gent, executors of 0
5369003 2465897 2465897 defendant Fadlot John husbandman 586934 586934 Fadlot, John, of Stotfold, husbandman 2
5387014 2471351 2471351 defendant Phelip John husbandman 586934 586934 Phelip, John, of Stotfold, husbandman 3
5399459 2474922 2474922 defendant Philip John husbandman 586934 586934 Philip, John, of Stotfold, husbandman 3
5399460 2474922 2474922 defendant Fadlot John husbandman 586934 586934 Fadlot, John, of Stotfold, husbandman 4
5412442 2478667 2478667 defendant Philip John husbandman 586934 586934 Philip, John, of Stotfold, husbandman 3
5412443 2478667 2478667 defendant Fadlot John husbandman 586934 586934 Fadlot, John, of Stotfold, husbandman 4
5484757 2500364 2500364 defendant Philip John clerk 586934 586934 Philip, John, of Stotfold, clerk 0
5484758 2500364 2500364 defendant Philip William husbandman 586934 586934 Philip, William, of Stotfold, husbandman 1
5484759 2500364 2500364 defendant Philip John husbandman 586934 586934 Philip, John, of Stotfold, husbandman 2
5492003 2502515 2502515 defendant Miller John miller 586934 586934 Miller, John, of Stotfold, miller 2
5556300 2521837 2521837 plaintiff Lorimer Richard yeoman 586934 586934 Lorimer, Richard, of Stotfold, yeoman 0
5556325 2521847 2521847 plaintiff Lorymer Richard yeoman 586934 586934 Lorymer, Richard, of Stotfold, yeoman 0
5596572 2533845 2533845 defendant Lorymer Richard yeoman 586934 586934 Lorymer, Richard, of Stotfold, yeoman 0
5603306 2535920 2535920 defendant Loryner Richard yeoman 586934 586934 Loryner, Richard, of Stotfold, yeoman 0
5616809 2549061 2549061 plaintiff Irissh Henry thresher 586934 586934 Irissh, Henry, of Stotfold, thresher 0
5616810 2549061 2549061 defendant Irissh William   586934 586934 Irissh, William, of Stotfold 0
5629585 2553242 2553242 plaintiff Widowesson Simon   586934 586934 Widowesson, Simon, of Stotfold 0
5634433 2554766 2554766 defendant Brounyng Thomas yeoman 586934 586934 Brounyng, Thomas, of Stotfold, yeoman 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);