names

36 rows where place_id = 587030

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590291 1864609 1864609 plaintiff Conyers William esq 587030 587030 Conyers, William, of Hornby, esq 0
3738439 1938228 1938228 defendant Stanley Edward esq 587030 587030 Stanley, Edward, of Hornby, esq 2
3746868 1940937 1940937 defendant Banke Robert gent 587030 587030 Banke, Robert, of Hornby, gent 3
3818655 1963737 1963737 defendant Atkynson Richard clerk 587030 587030 Atkynson, Richard, of Hornby, clerk 1
4229864 2105928 2105928 defendant Smyth George yeoman 587030 587030 Smyth, George, of Hornby, yeoman 4
4456168 2186948 2186948 plaintiff Nevile Robert   587030 587030 Nevile, Robert, of Hornby, knight 0
4502770 2201445 2201445 plaintiff Nevyll Robert   587030 587030 Nevyll, Robert, of Hornby, knight 0
4529999 2209673 2209673 plaintiff Nevyll Robert   587030 587030 Nevyll, Robert, of Hornby, knight 0
4560422 2219200 2219200 plaintiff Nevyll (illegible)   587030 587030 Nevyll, _, of Hornby, knight 0
4618650 2236843 2236843 defendant Wawan John   587030 587030 Wawan, John, of Hornby 0
4722647 2272399 2272399 plaintiff Conyers Christopher   587030 587030 Conyers, Christopher, of Hornby 0
4739557 2277449 2277449 defendant Ferrour William   587030 587030 Ferrour, William, of Hornby 9
4739558 2277449 2277449 defendant Boteler John yeoman 587030 587030 Boteler, John, of Hornby, yeoman 10
4739559 2277449 2277449 defendant Williamson John husbandman 587030 587030 Williamson, John, of Hornby, husbandman 11
4739560 2277449 2277449 defendant Osmunderlawe Simon   587030 587030 Osmunderlawe, Simon, of Hornby 12
4739561 2277449 2277449 defendant Payneter Thomas   587030 587030 Payneter, Thomas, of Hornby 13
4739562 2277449 2277449 defendant Lonesdales John   587030 587030 Lonesdales, John, of Hornby 14
4739563 2277449 2277449 defendant Carter John   587030 587030 Carter, John, of Hornby 15
4739564 2277449 2277449 defendant Nethird Nicholas   587030 587030 Nethird, Nicholas, of Hornby 16
4776673 2288695 2288695 defendant Tumbell John husbandman 587030 587030 Tumbell, John, of Hornby, husbandman 1
4779312 2289510 2289510 defendant Williamson John husbandman 587030 587030 Williamson, John, of Hornby, husbandman 0
4782416 2290508 2290508 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 0
4834069 2306663 2306663 plaintiff Orre John   587030 587030 Orre, John, of Hornby, vicar 1
4834072 2306664 2306664 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 1
4834075 2306665 2306665 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 1
4853442 2312488 2312488 defendant Merchant John husbandman 587030 587030 Merchant, John, of Hornby, husbandman 0
4913881 2330849 2330849 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 0
4990346 2354019 2354019 defendant Thorp Henry yeoman 587030 587030 Thorp, Henry, of Hornby, yeoman 0
5018358 2362256 2362256 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 0
5018360 2362257 2362257 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 0
5018361 2362257 2362257 defendant Walker William husbandman 587030 587030 Walker, William, of Hornby, husbandman 0
5018395 2362265 2362265 defendant Walker William yeoman 587030 587030 Walker, William, of Hornby, yeoman 0
5080862 2380767 2380767 plaintiff Conyers Christopher esq 587030 587030 Conyers, Christopher, of Hornby, esq 0
5099512 2386296 2386296 defendant Conyers Christopher, junior   587030 587030 Conyers, Christopher, junior, of Hornby 5
5121034 2392581 2392581 defendant Conyers Thomas   587030 587030 Conyers, Thomas, of Hornby, gent, his brother 1
5277370 2438459 2438459 defendant Lofthous William yeoman 587030 587030 Lofthous, William, of Hornby, yeoman 1

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