names

40 rows where place_id = 617235

✎ 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
3718495 1932062 1932062 plaintiff Frevyll Robert clerk 617235 617235 Frevyll, Robert, of Apuldre, clerk 0
3718496 1932062 1932062 defendant Topynden Simon husbandman 617235 617235 Topynden, Simon, of Apuldre, husbandman 0
3735981 1937492 1937492 defendant Blakburn John yeoman 617235 617235 Blakburn, John, of Apuldre, yeoman 0
3735982 1937492 1937492 defendant Belle John merchant 617235 617235 Belle, John, of Apuldre, merchant 1
3735983 1937492 1937492 defendant Brown Clement brewer 617235 617235 Brown, Clement, of Apuldre, brewer 2
3757288 1944260 1944260 plaintiff Bell John merchant 617235 617235 Bell, John, of Apuldre, merchant 0
3857196 1975883 1975883 defendant Standen Thomas laborer 617235 617235 Standen, Thomas, of Apuldre, laborer 0
3896061 1988885 1988885 defendant Welshe Morgan husbandman 617235 617235 Welshe, Morgan, of Apuldre, husbandman 0
4667458 2255544 2255544 plaintiff atte Grove Thomas   617235 617235 atte Grove, Thomas, of Apuldre 0
4671544 2256746 2256746 defendant Cheseman William butcher 617235 617235 Cheseman, William, of Apuldre, butcher 1
4780240 2289820 2289820 plaintiff Brykynden Thomas   617235 617235 Brykynden, Thomas, of Apuldre 0
4793769 2294170 2294170 defendant Hykke Augustine husbandman 617235 617235 Hykke, Augustine, of Apuldre, husbandman 0
4858104 2313907 2313907 defendant Cheseman William husbandman 617235 617235 Cheseman, William, of Apuldre, husbandman 0
4858667 2314085 2314085 defendant Lang Thomas yeoman 617235 617235 Lang, Thomas, of Apuldre, yeoman 0
4865763 2316257 2316257 defendant Gosebourne Thomas gent 617235 617235 Gosebourne, Thomas, of Apuldre, gent 0
4865765 2316258 2316258 defendant Goseburne William husbandman 617235 617235 Goseburne, William, of Apuldre, husbandman 0
4865767 2316259 2316259 defendant Goseburne William gent 617235 617235 Goseburne, William, of Apuldre, gent 0
4865769 2316260 2316260 defendant Goseburne William gent 617235 617235 Goseburne, William, of Apuldre, gent 0
4868942 2317259 2317259 defendant Ketyng John husbandman 617235 617235 Ketyng, John, of Apuldre, husbandman 1
4972798 2348801 2348801 defendant Erdle Bartholomew tailor 617235 617235 Erdle, Bartholomew, of Apuldre, tailor 0
4972799 2348801 2348801 defendant Erdle John tailor 617235 617235 Erdle, John, of Apuldre, tailor 1
5022857 2363596 2363596 defendant Blake Ralph husbandman 617235 617235 Blake, Ralph, of Apuldre, husbandman 0
5063994 2375762 2375762 defendant Taillour Simon tailor 617235 617235 Taillour, Simon, of Apuldre, tailor 0
5245841 2428950 2428950 defendant Clerk Richard husbandman 617235 617235 Clerk, Richard, of Apuldre, husbandman 1
5245842 2428950 2428950 defendant Sugyland Thomas miller 617235 617235 Sugyland, Thomas, of Apuldre, miller 2
5245845 2428950 2428950 defendant Coteler John glover 617235 617235 Coteler, John, of Apuldre, glover 5
5245884 2428958 2428958 defendant Snayland Thomas miller 617235 617235 Snayland, Thomas, of Apuldre, miller 2
5260246 2433332 2433332 defendant Lucas Nicholas chapman 617235 617235 Lucas, Nicholas, of Apuldre, chapman 1
5260247 2433332 2433332 defendant Drury Roger chapman 617235 617235 Drury, Roger, of Apuldre, chapman 2
5263794 2434431 2434431 plaintiff Robeleys William (legal representative) 617235 617235 Robeleys, William, of Apuldre, executors of 0
5266217 2435187 2435187 defendant Goosborne John yeoman 617235 617235 Goosborne, John, of Apuldre, yeoman 0
5360178 2463226 2463226 defendant Ovyngham Richard smith 617235 617235 Ovyngham, Richard, of Apuldre, smith 1
5360180 2463226 2463226 defendant Broun John husbandman 617235 617235 Broun, John, of Apuldre, husbandman 3
5360201 2463233 2463233 defendant Regge Richard butcher 617235 617235 Regge, Richard, of Apuldre, butcher 0
5360203 2463233 2463233 defendant Ketyng William husbandman 617235 617235 Ketyng, William, of Apuldre, husbandman 2
5542033 2517639 2517639 defendant Henxhill Robert merchant 617235 617235 Henxhill, Robert, of Apuldre, merchant 0
5574809 2527201 2527201 defendant Henxhill Robert yeoman 617235 617235 Henxhill, Robert, of Apuldre, yeoman 0
5584330 2530165 2530165 defendant Broune William carpenter 617235 617235 Broune, William, of Apuldre, carpenter 3
5599779 2534819 2534819 defendant Broun William carpenter 617235 617235 Broun, William, of Apuldre, carpenter 3
5628019 2552734 2552734 plaintiff Peek John   617235 617235 Peek, John, of Apuldre 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);