names

47 rows where place_id = 586936

✎ 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
3590030 1864521 1864521 plaintiff Clerk Vincent   586936 586936 Clerk, Vincent, of Thoresby 0
3590032 1864522 1864522 plaintiff Clerk Vincent   586936 586936 Clerk, Vincent, of Thoresby 0
3650144 1910415 1910415 defendant Clerk Hugh husbandman 586936 586936 Clerk, Hugh, of Thoresby, husbandman 0
3650145 1910415 1910415 defendant Lyson Richard husbandman 586936 586936 Lyson, Richard, of Thoresby, husbandman 1
3650146 1910415 1910415 defendant Coytt John husbandman 586936 586936 Coytt, John, of Thoresby, husbandman 2
3683979 1921122 1921122 defendant Holte Edmund gent 586936 586936 Holte, Edmund, of Thoresby, gent 2
3792891 1955630 1955630 defendant Richardson Martin gent 586936 586936 Richardson, Martin, of Thoresby, gent 0
3813072 1961994 1961994 defendant Holt Edmund gent 586936 586936 Holt, Edmund, of Thoresby, gent 0
3868711 1979777 1979777 defendant White Thomas husbandman 586936 586936 White, Thomas, of Thoresby, husbandman 0
3925377 1998801 1998801 defendant Clarke Hugh husbandman 586936 586936 Clarke, Hugh, of Thoresby, husbandman 0
3925378 1998801 1998801 defendant Wylson Robert husbandman 586936 586936 Wylson, Robert, of Thoresby, husbandman 1
4051967 2043124 2043124 defendant Johnson Anthony yeoman 586936 586936 Johnson, Anthony, of Thoresby, yeoman 2
4077728 2052328 2052328 defendant Wylson Peter butcher 586936 586936 Wylson, Peter, of Thoresby, butcher 0
4353778 2148541 2148541 defendant Taylor John yeoman 586936 586936 Taylor, John, of Thoresby, yeoman 1
4353779 2148541 2148541 defendant Taylor Michael yeoman 586936 586936 Taylor, Michael, of Thoresby, yeoman 2
4413407 2169073 2169073 defendant Dry Henry de   586936 586936 Dry, Henry de, of Thoresby 0
4419540 2170996 2170996 defendant Dry Henry   586936 586936 Dry, Henry, of Thoresby 0
4450517 2185125 2185125 defendant Willyson John   586936 586936 Willyson, John, of Thoresby 1
4458013 2187533 2187533 defendant Briggeslaye Richard tailor 586936 586936 Briggeslaye, Richard, of Thoresby, tailor 0
4465584 2189908 2189908 defendant Smyth John   586936 586936 Smyth, John, of Thoresby 1
4485857 2196284 2196284 plaintiff Robynson Hugh   586936 586936 Robynson, Hugh, of Thoresby 0
4485859 2196285 2196285 plaintiff Robynson Hugh   586936 586936 Robynson, Hugh, of Thoresby 0
4506468 2202524 2202524 defendant Artured John   586936 586936 Artured, John, of Thoresby, parson 0
4555814 2217759 2217759 defendant Thoresby Richard   586936 586936 Thoresby, Richard, of Thoresby 0
4555818 2217759 2217759 defendant Kelle Robert   586936 586936 Kelle, Robert, of Thoresby 4
4659633 2248866 2248866 defendant Clerk Richard yeoman 586936 586936 Clerk, Richard, of Thoresby, yeoman 1
4691114 2262741 2262741 plaintiff Wryght John   586936 586936 Wryght, John, of Thoresby 0
4799345 2295971 2295971 defendant Raulynson Philip husbandman 586936 586936 Raulynson, Philip, of Thoresby, husbandman 1
4806253 2298164 2298164 defendant Norcotes John husbandman 586936 586936 Norcotes, John, of Thoresby, husbandman 0
4821003 2302654 2302654 defendant Berwyse de Richard yeoman 586936 586936 Berwyse de, Richard, of Thoresby, yeoman 2
4821004 2302654 2302654 defendant Richardson William yeoman 586936 586936 Richardson, William, of Thoresby, yeoman 3
4821005 2302654 2302654 defendant Wilson Thomas yeoman 586936 586936 Wilson, Thomas, of Thoresby, yeoman 4
4821006 2302654 2302654 defendant Bullok Robert yeoman 586936 586936 Bullok, Robert, of Thoresby, yeoman 5
4821022 2302655 2302655 defendant Shyphird Adam yeoman 586936 586936 Shyphird, Adam, of Thoresby, yeoman 7
4904198 2327923 2327923 defendant Fraunceys Thomas husbandman 586936 586936 Fraunceys, Thomas, of Thoresby, husbandman 0
5130010 2395262 2395262 defendant Cok Robert milner 586936 586936 Cok, Robert, of Thoresby, milner 7
5386610 2471234 2471234 plaintiff Croxton William   586936 586936 Croxton, William, of Thoresby, rector 0
5387261 2471431 2471431 defendant Tharold Robert, senior husbandman 586936 586936 Tharold, Robert, senior, of Thoresby, husbandman 4
5387262 2471431 2471431 defendant Tharold John, junior yeoman 586936 586936 Tharold, John, junior, of Thoresby, yeoman 5
5398916 2474760 2474760 plaintiff Croxton William   586936 586936 Croxton, William, of Thoresby, Rector 0
5412012 2478548 2478548 plaintiff Croxton William   586936 586936 Croxton, William, of Thoresby, rector 0
5426543 2482884 2482884 plaintiff Croxton William   586936 586936 Croxton, William, of Thoresby, rector 0
5426546 2482885 2482885 plaintiff Croxton William   586936 586936 Croxton, William, of Thoresby, rector 0
5441341 2487328 2487328 plaintiff (illegible) William   586936 586936 _, William, of Thoresby, vicar 0
5506764 2507036 2507036 plaintiff Clerk Vincent   586936 586936 Clerk, Vincent, of Thoresby 0
5611077 2547185 2547185 plaintiff Bernak Philip   586936 586936 Bernak, Philip, of Thoresby 0
5617869 2549405 2549405 defendant Ferrour John   586936 586936 Ferrour, John, of Thoresby 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);