names

62 rows where place_id = 612018

✎ 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
3691149 1923394 1923394 defendant Lee John yeoman 612018 612018 Lee, John, of Altoftes, yeoman 0
3744160 1940074 1940074 defendant Fryston George   612018 612018 Fryston, George, of Altoftes, gent, son of William Fryston 0
3780175 1951524 1951524 defendant Lee Richard husbandman 612018 612018 Lee, Richard, of Altoftes, husbandman 0
3795106 1956332 1956332 defendant Fryston George gent 612018 612018 Fryston, George, of Altoftes, gent 0
3795108 1956332 1956332 defendant Thornton Thomas sherman 612018 612018 Thornton, Thomas, of Altoftes, sherman 2
4085131 2054965 2054965 defendant Frobysher Gregory gent 612018 612018 Frobysher, Gregory, of Altoftes, gent 0
4126866 2069902 2069902 defendant Lee William husbandman 612018 612018 Lee, William, of Altoftes, husbandman 0
4139005 2074321 2074321 defendant Smytheson Robert yeoman 612018 612018 Smytheson, Robert, of Altoftes, yeoman 0
4139006 2074321 2074321 defendant Nalson Richard yeoman 612018 612018 Nalson, Richard, of Altoftes, yeoman 1
4157774 2080792 2080792 defendant Smythson Robert husbandman 612018 612018 Smythson, Robert, of Altoftes, husbandman 0
4163879 2082893 2082893 defendant Smythson Robert yeoman 612018 612018 Smythson, Robert, of Altoftes, yeoman 0
4163880 2082893 2082893 defendant Nalson Richard yeoman 612018 612018 Nalson, Richard, of Altoftes, yeoman 1
4178043 2087791 2087791 defendant Abbotte Richard laborer 612018 612018 Abbotte, Richard, of Altoftes, laborer 0
4178044 2087791 2087791 defendant Cowplande Richard laborer 612018 612018 Cowplande, Richard, of Altoftes, laborer 1
4180188 2088553 2088553 defendant Thorneton Richard yeoman 612018 612018 Thorneton, Richard, of Altoftes, yeoman 0
4183872 2089853 2089853 plaintiff Ricard Thomas gent 612018 612018 Ricard, Thomas, of Altoftes, gent 0
4203543 2096790 2096790 defendant Thornton Richard yeoman 612018 612018 Thornton, Richard, of Altoftes, yeoman 0
4355079 2148993 2148993 defendant Freiston Margery widow 612018 612018 Freiston, Margery, of Altoftes, widow 1
4397536 2163755 2163755 defendant Frobisher Richard gent 612018 612018 Frobisher, Richard, of Altoftes, gent 2
4397537 2163755 2163755 defendant Nalson Richard yeoman 612018 612018 Nalson, Richard, of Altoftes, yeoman 3
4479707 2194314 2194314 defendant Knottyng John   612018 612018 Knottyng, John, of Altoftes 0
4526168 2208473 2208473 defendant Shireson Robert   612018 612018 Shireson, Robert, of Altoftes 1
4567698 2221462 2221462 plaintiff Tilly John   612018 612018 Tilly, John, of Altoftes 0
4575693 2223910 2223910 defendant Dodworth Adam de   612018 612018 Dodworth, Adam de, of Altoftes 6
4655487 2247611 2247611 defendant Bate William yeoman 612018 612018 Bate, William, of Altoftes, yeoman 1
4655488 2247611 2247611 defendant Tylly John yeoman 612018 612018 Tylly, John, of Altoftes, yeoman 2
4664600 2250407 2250407 defendant Bate William yeoman 612018 612018 Bate, William, of Altoftes, yeoman 0
4724271 2272886 2272886 defendant Smyth John yeoman 612018 612018 Smyth, John, of Altoftes, yeoman 3
4725191 2273175 2273175 defendant Smythson Robert husbandman 612018 612018 Smythson, Robert, of Altoftes, husbandman 0
4725192 2273175 2273175 defendant Taillour Thomas husbandman 612018 612018 Taillour, Thomas, of Altoftes, husbandman 1
4725193 2273175 2273175 defendant Smythson John husbandman 612018 612018 Smythson, John, of Altoftes, husbandman 2
4738031 2276996 2276996 defendant Souter William husbandman 612018 612018 Souter, William, of Altoftes, husbandman 1
4738032 2276996 2276996 defendant Wryght Thomas husbandman 612018 612018 Wryght, Thomas, of Altoftes, husbandman 2
4738033 2276996 2276996 defendant Nallon John husbandman 612018 612018 Nallon, John, of Altoftes, husbandman 3
4742031 2278167 2278167 defendant Smythson Robert husbandman 612018 612018 Smythson, Robert, of Altoftes, husbandman 2
4750196 2280532 2280532 defendant Smyth John yeoman 612018 612018 Smyth, John, of Altoftes, yeoman 0
4750198 2280533 2280533 defendant Smythson John yeoman 612018 612018 Smythson, John, of Altoftes, yeoman 0
4750200 2280534 2280534 defendant Smythson Robert yeoman 612018 612018 Smythson, Robert, of Altoftes, yeoman 0
4826232 2304239 2304239 defendant Taillour Thomas husbandman 612018 612018 Taillour, Thomas, of Altoftes, husbandman 0
4829088 2305139 2305139 defendant Bate William yeoman 612018 612018 Bate, William, of Altoftes, yeoman 2
4829092 2305140 2305140 defendant Bate William yeoman 612018 612018 Bate, William, of Altoftes, yeoman 2
4842907 2309322 2309322 defendant Tailour Thomas husbandman 612018 612018 Tailour, Thomas, of Altoftes, husbandman 0
4842908 2309322 2309322 defendant Tailour Edmund husbandman 612018 612018 Tailour, Edmund, of Altoftes, husbandman 1
4855845 2313199 2313199 defendant Bate William yeoman 612018 612018 Bate, William, of Altoftes, yeoman 0
4855847 2313200 2313200 defendant Bate William yeoman 612018 612018 Bate, William, of Altoftes, yeoman 0
4864774 2315957 2315957 defendant Smythson Robert husbandman 612018 612018 Smythson, Robert, of Altoftes, husbandman 0
4870360 2317707 2317707 defendant Taylour Thomas husbandman 612018 612018 Taylour, Thomas, of Altoftes, husbandman 0
4870361 2317707 2317707 defendant Taylour Edmund husbandman 612018 612018 Taylour, Edmund, of Altoftes, husbandman 1
5082133 2381149 2381149 defendant Hommes Henry husbandman 612018 612018 Hommes, Henry, of Altoftes, husbandman 0
5082134 2381149 2381149 defendant Hourom or Honrom John, senior husbandman 612018 612018 Hourom or Honrom, John, senior, of Altoftes, husbandman 1
5082135 2381149 2381149 defendant Mason Thomas husbandman 612018 612018 Mason, Thomas, of Altoftes, husbandman 2
5082136 2381149 2381149 defendant Pete Joan widow 612018 612018 Pete, Joan, of Altoftes, widow 3
5082138 2381149 2381149 defendant Ellys Anes widow 612018 612018 Ellys, Anes, of Altoftes, widow 5
5214377 2419937 2419937 defendant Thorp Robert husbandman 612018 612018 Thorp, Robert, of Altoftes, husbandman 1
5369658 2466096 2466096 defendant Thorp Robert yeoman 612018 612018 Thorp, Robert, of Altoftes, yeoman 0
5369660 2466097 2466097 defendant Thorp Robert yeoman 612018 612018 Thorp, Robert, of Altoftes, yeoman 0
5428654 2483488 2483488 plaintiff Fryston John gent 612018 612018 Fryston, John, of Altoftes, gent 0
5445926 2488670 2488670 plaintiff Fryston John gent 612018 612018 Fryston, John, of Altoftes, gent 0
5596399 2533785 2533785 defendant Scargyll Thomas gent 612018 612018 Scargyll, Thomas, of Altoftes, gent 0
5596401 2533786 2533786 defendant Scargyll Thomas gent 612018 612018 Scargyll, Thomas, of Altoftes, gent 0
5604895 2536400 2536400 defendant Chaloner John gent 612018 612018 Chaloner, John, of Altoftes, gent 0
5604897 2536401 2536401 defendant Wright Robert husbandman 612018 612018 Wright, Robert, of Altoftes, husbandman 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);