names

166 rows where place_id = 608894

✎ 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
3630730 1904435 1904435 defendant Cooke William   608894 608894 Cooke, William, of Allerton, wheelwright 3
3675964 1918521 1918521 defendant Blakburne John husbandman 608894 608894 Blakburne, John, of Allerton, husbandman 0
3675965 1918521 1918521 defendant Gerves John husbandman 608894 608894 Gerves, John, of Allerton, husbandman 1
3693562 1924186 1924186 defendant Watter William husbandman 608894 608894 Watter, William, of Allerton, husbandman 1
3693563 1924186 1924186 defendant Ashton Robert yeoman 608894 608894 Ashton, Robert, of Allerton, yeoman 2
3693943 1924309 1924309 defendant Applyerd John yeoman 608894 608894 Applyerd, John, of Allerton, yeoman 1
3702718 1927123 1927123 defendant Blakborne John husbandman 608894 608894 Blakborne, John, of Allerton, husbandman 0
3702719 1927123 1927123 defendant Gerves John husbandman 608894 608894 Gerves, John, of Allerton, husbandman 1
3736856 1937782 1937782 defendant Banke Peter gent 608894 608894 Banke, Peter, of Allerton, gent 1
3736857 1937782 1937782 defendant Bewatter William husbandman 608894 608894 Bewatter, William, of Allerton, husbandman 2
3736864 1937784 1937784 defendant Banke Peter gent 608894 608894 Banke, Peter, of Allerton, gent 1
3775572 1950104 1950104 defendant Thorton Thomas gent 608894 608894 Thorton, Thomas, of Allerton, gent 0
3776770 1950480 1950480 defendant Wolley Richard fishmonger 608894 608894 Wolley, Richard, of Allerton, fishmonger 0
3783928 1952748 1952748 defendant Gyllowe John miller 608894 608894 Gyllowe, John, of Allerton, miller 0
3783929 1952748 1952748 defendant Shemeld William yeoman 608894 608894 Shemeld, William, of Allerton, yeoman 1
3784916 1953073 1953073 defendant Bewater William husbandman 608894 608894 Bewater, William, of Allerton Bywater, husbandman 1
3784945 1953078 1953078 defendant Bewater William husbandman 608894 608894 Bewater, William,of Allerton, husbandman 1
3784946 1953078 1953078 defendant Byrkby Thomas husbandman 608894 608894 Byrkby, Thomas, of Allerton, husbandman 2
3793734 1955906 1955906 defendant Brown Richard yeoman 608894 608894 Brown, Richard, of Allerton, yeoman 0
3796625 1956820 1956820 defendant Birkynsha John husbandman 608894 608894 Birkynsha, John, of Allerton, husbandman 1
3796628 1956821 1956821 defendant Byrkynsha John husbandman 608894 608894 Byrkynsha, John, of Allerton, husbandman 1
3801465 1958376 1958376 defendant Belder William husbandman 608894 608894 Belder, William, of Allerton, husbandman 1
3801466 1958376 1958376 defendant Langefeld William husbandman 608894 608894 Langefeld, William, of Allerton, husbandman 2
3845608 1972169 1972169 defendant Adams John husbandman 608894 608894 Adams, John, of Allerton, husbandman 1
3910157 1993711 1993711 plaintiff Swale Thomas gent 608894 608894 Swale, Thomas, of Allerton Malleverer, gent 0
3916527 1995903 1995903 defendant Walled John yeoman 608894 608894 Walled, John, of Allerton, yeoman 0
3935310 2002123 2002123 defendant Wilkynson John husbandman 608894 608894 Wilkynson, John, of Allerton, husbandman 0
3954563 2008668 2008668 defendant Hodge Thomas husbandman 608894 608894 Hodge, Thomas, of Allerton, husbandman 0
3958491 2010037 2010037 defendant Awsten John husbandman 608894 608894 Awsten, John, of Allerton, husbandman 0
3958493 2010038 2010038 defendant Awston John husbandman 608894 608894 Awston, John, of Allerton, husbandman 0
3960541 2010788 2010788 defendant Cade Thomas yeoman 608894 608894 Cade, Thomas, of Allerton, yeoman 0
3999709 2024658 2024658 plaintiff Garnett Roger yeoman 608894 608894 Garnett, Roger, of Allerton, yeoman 0
4007305 2027394 2027394 plaintiff Malyverer Thomas (legal representative) 608894 608894 Malyverer, Thomas, of Allerton Maliverer, knight, executors of 0
4049452 2042249 2042249 plaintiff Tyndall Peter gent 608894 608894 Tyndall, Peter, of Allerton Bewater, gent 1
4049455 2042250 2042250 plaintiff Tyndall Peter gent 608894 608894 Tyndall, Peter, of Allerton Bewater, gent 1
4070084 2049590 2049590 plaintiff Maleverer Richard esq 608894 608894 Maleverer, Richard, of Allerton, esq 0
4071291 2050036 2050036 defendant Aldersley John yeoman 608894 608894 Aldersley, John, of Allerton, yeoman 0
4130095 2071069 2071069 defendant Wayde Robert clothier 608894 608894 Wayde, Robert, of Allerton, clothier 0
4131224 2071489 2071489 defendant Roche Thomas yeoman 608894 608894 Roche, Thomas, of Allerton, or of Alverton, Wedmore, Soms, yeoman 0
4150100 2078172 2078172 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, or of Alrington, husbandman 0
4150413 2078274 2078274 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, husbandman 0
4151798 2078744 2078744 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, husbandman 0
4175202 2086787 2086787 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, husbandman 2
4184201 2089969 2089969 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, husbandman 1
4184204 2089970 2089970 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, husbandman 1
4184207 2089971 2089971 defendant Roche Thomas husbandman 608894 608894 Roche, Thomas, of Allerton, husbandman 1
4184277 2090001 2090001 defendant Roche Thomas yeoman 608894 608894 Roche, Thomas, of Allerton, yeoman 0
4260399 2116445 2116445 defendant Freman Thomas yeoman 608894 608894 Freman, Thomas, of Allerton, yeoman 0
4284627 2124552 2124552 defendant Freman Thomas yeoman 608894 608894 Freman, Thomas, of Allerton Bywater, yeoman 0
4302037 2130834 2130834 defendant Freman Thomas yeoman 608894 608894 Freman, Thomas, of Allerton by Water, yeoman 0
4309637 2133529 2133529 defendant Allerton William yeoman 608894 608894 Allerton, William, of Allerton, yeoman 2
4310327 2133766 2133766 defendant Allerton William yeoman 608894 608894 Allerton, William, of Allerton, yeoman 0
4319864 2137054 2137054 defendant Freman Thomas yeoman 608894 608894 Freman, Thomas, of Allerton Bywater, yeoman 0
4345723 2145772 2145772 defendant Freeman Thomas yeoman 608894 608894 Freeman, Thomas, of Allerton Bywater, yeoman 0
4350440 2147417 2147417 defendant Stevenson Robert yeoman 608894 608894 Stevenson, Robert, of Allerton, yeoman 1
4364324 2152302 2152302 defendant Cosin Edward yeoman 608894 608894 Cosin, Edward, of Allerton, yeoman 2
4374906 2156084 2156084 defendant Freman Thomas yeoman 608894 608894 Freman, Thomas, of Allerton Bywater, yeoman 0
4383270 2159124 2159124 defendant Allerton William, senior yeoman 608894 608894 Allerton, William, senior, of Allerton, yeoman 1
4401420 2165069 2165069 defendant Freeman Thomas yeoman 608894 608894 Freeman, Thomas, of Allerton Bywater, yeoman 0
4404481 2166065 2166065 defendant Freman Thomas yeoman 608894 608894 Freman, Thomas, of Allerton, yeoman 0
4421845 2171709 2171709 defendant Furneux John de   608894 608894 Furneux, John de, of Allerton 0
4425534 2172812 2172812 plaintiff Mauleverer John de   608894 608894 Mauleverer, John de, of Allerton Mauleverer 0
4425537 2172813 2172813 plaintiff Mauleverer John de   608894 608894 Mauleverer, John de, of Allerton Mauleverer 0
4449426 2184765 2184765 defendant Gabbe William   608894 608894 Gabbe, William, of Allerton 3
4449427 2184765 2184765 defendant Lowe John   608894 608894 Lowe, John, of Allerton 4
4466731 2190264 2190264 defendant Drye Robert   608894 608894 Drye, Robert, of Allerton 2
4466741 2190267 2190267 defendant Drye Robert   608894 608894 Drye, Robert, of Allerton 1
4486469 2196478 2196478 defendant Chapman Richard   608894 608894 Chapman, Richard, of Allerton 1
4511250 2203966 2203966 defendant Menyll Richard   608894 608894 Menyll, Richard, of Allerton 0
4515700 2205333 2205333 plaintiff Clerk John   608894 608894 Clerk, John, of Allerton 0
4535585 2211406 2211406 defendant Farnesfeld John   608894 608894 Farnesfeld, John, of Allerton 1
4544204 2214104 2214104 plaintiff Barker William   608894 608894 Barker, William, of Allerton 0
4549975 2215925 2215925 defendant Milner John   608894 608894 Milner, John, of Allerton 0
4555702 2217716 2217716 plaintiff Heyden Roger   608894 608894 Heyden, Roger, of Allerton 0
4555704 2217717 2217717 plaintiff Heydon Roger   608894 608894 Heydon, Roger, of Allerton 0
4555706 2217717 2217717 defendant Forster Robert   608894 608894 together with Forster, Robert, of Allerton 1
4560274 2219162 2219162 defendant Mitton John de   608894 608894 Mitton, John de, of Allerton 0
4560275 2219162 2219162 defendant Plastere Thomas   608894 608894 Plastere, Thomas, of Allerton 1
4561407 2219515 2219515 defendant del Bower Thomas   608894 608894 del Bower, Thomas, of Allerton 5
4561410 2219515 2219515 defendant Forster Robert   608894 608894 Forster, Robert, of Allerton 8
4561411 2219515 2219515 defendant Sadeler Thomas   608894 608894 Sadeler, Thomas, of Allerton 9
4561412 2219515 2219515 defendant Swaynby John de   608894 608894 Swaynby, John de, of Allerton 10
4561416 2219515 2219515 defendant Mitton John de   608894 608894 together with Mitton, John de, of Allerton 14
4561417 2219515 2219515 defendant Plastere Thomas   608894 608894 Plastere, Thomas, of Allerton 15
4569290 2221985 2221985 defendant Walsh John   608894 608894 Walsh, John, of Allerton 0
4569292 2221986 2221986 defendant Walsh John   608894 608894 Walsh, John, of Allerton 0
4569294 2221987 2221987 defendant Walsh John   608894 608894 Walsh, John, of Allerton 0
4569296 2221988 2221988 defendant Walssh John   608894 608894 Walssh, John, of Allerton 0
4575577 2223872 2223872 plaintiff Bower Thomas   608894 608894 Bower, Thomas, of Allerton 0
4575579 2223873 2223873 plaintiff Bower Thomas   608894 608894 Bower, Thomas, of Allerton 0
4594642 2229580 2229580 defendant Mitton John plasterer 608894 608894 Mitton, John, of Allerton, plasterer 5
4599847 2231181 2231181 plaintiff Taillour Roger   608894 608894 Taillour, Roger, of Allerton 0
4601543 2231706 2231706 defendant Cok John   608894 608894 Cok, John, of Allerton 1
4633576 2241357 2241357 defendant Walssh John   608894 608894 Walssh, John, of Allerton 0
4633577 2241357 2241357 defendant del Allers William   608894 608894 del Allers, William, of Allerton 1
4633617 2241369 2241369 defendant Farnesfeld William de   608894 608894 Farnesfeld, William de, of Allerton 0
4633619 2241370 2241370 defendant Walssh John   608894 608894 Walssh, John, of Allerton 0
4691549 2262882 2262882 defendant Yorke John sawer 608894 608894 Yorke, John, of Allerton, sawer 4
4707664 2267760 2267760 defendant Farnelay John husbandman 608894 608894 Farnelay, John, of Allerton, husbandman 1
4728772 2274235 2274235 defendant Holme John clerk 608894 608894 Holme, John, of Allerton, clerk 2

Next page

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