names

34 rows where place_id = 587582

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591830 1865065 1865065 defendant Haryngton Robert esq 587582 587582 Haryngton, Robert, of Exton, Rutland, esq 0
3607330 1869954 1869954 defendant Loge Nicholas yeoman 587582 587582 Loge, Nicholas, of Exton, Rutland, yeoman 1
3716575 1931481 1931481 defendant Haryngton John esq 587582 587582 Haryngton, John, of Exton, Rutland, esq 2
3776153 1950285 1950285 defendant Haryngton John esq 587582 587582 Haryngton, John, of Exton, Rutland, esq 0
3810736 1961257 1961257 defendant Haryngton John esq 587582 587582 Haryngton, John, of Exton, Rutland, esq 2
3904250 1991667 1991667 plaintiff Haryngton John   587582 587582 Haryngton, John, of Exton, Rutland, knight 0
4065123 2047811 2047811 plaintiff Harryngton James   587582 587582 Harryngton, James, of Exton, Rutland, knight 0
4071778 2050203 2050203 defendant Bygg William yeoman 587582 587582 Bygg, William, of Exton, Rutland, yeoman 2
4105297 2062174 2062174 defendant Bigg William yeoman 587582 587582 Bigg, William, of Exton, Rutland, yeoman 2
4222806 2103468 2103468 defendant Harryngton James (legal representative) 587582 587582 Harryngton, James, of Exton, Rutland, knight, executor of 0
4348724 2146814 2146814 defendant Harington John   587582 587582 Harington, John, of Exton, Rutland, knight 0
4801909 2296781 2296781 defendant Assheby John husbandman 587582 587582 Assheby, John, of Exton, Rutland, husbandman 0
4880202 2320721 2320721 defendant Colepeper John   587582 587582 Colepeper, John, of Exton, Rutland, knight 0
4880204 2320722 2320722 defendant Colepeper John   587582 587582 Colepeper, John, of Exton, Rutland, knight 0
4880206 2320723 2320723 defendant Colepeper John   587582 587582 Colepeper, John, of Exton, Rutland, knight 0
4880210 2320724 2320724 defendant Colepeper John   587582 587582 Colepeper, John, of Exton, Rutland, knight 0
4961885 2345507 2345507 defendant Stanley Ralph husbandman 587582 587582 Stanley, Ralph, of Exton, Rutland, husbandman 2
4961889 2345508 2345508 defendant Stanley Ralph husbandman 587582 587582 Stanley, Ralph, of Exton, Rutland, husbandman 2
4983083 2351842 2351842 defendant Stanley Robert courser 587582 587582 Stanley, Robert, of Exton, Rutland, courser 0
4993660 2354977 2354977 defendant Taillour John husbandman 587582 587582 Taillour, John, of Exton, Rutland, husbandman 0
5103200 2387365 2387365 defendant Fenne Robert esq 587582 587582 Fenne, Robert, of Exton, Rutland, esq 0
5103203 2387366 2387366 defendant Fenne Robert esq 587582 587582 Fenne, Robert, of Exton, Rutland, esq 0
5191071 2413128 2413128 defendant Hert William yeoman 587582 587582 Hert, William, of Exton, Rutland, yeoman 1
5238626 2426890 2426890 defendant Norme Richard clerk 587582 587582 Norme, Richard, of Exton, Rutland, clerk 0
5292466 2442794 2442794 defendant Marshall Barnard yeoman 587582 587582 Marshall, Barnard, of Exton, Rutland, yeoman 0
5326733 2453063 2453063 defendant Talbot Brian esq 587582 587582 Talbot, Brian, of Exton, Rutland, esq 0
5361683 2463679 2463679 defendant Talbot Brian esq 587582 587582 Talbot, Brian, of Exton, Rutland, esq 0
5435531 2485565 2485565 defendant Leek John yeoman 587582 587582 Leek, John, of Exton, Rutland, yeoman 3
5482573 2499730 2499730 defendant Haryngton Robert esq 587582 587582 Haryngton, Robert, of Exton, Rutland, esq 0
5482575 2499731 2499731 defendant Haryngton Robert esq 587582 587582 Haryngton, Robert, of Exton, Rutland, esq 0
5482907 2499831 2499831 defendant Hert John husbandman 587582 587582 Hert, John, of Exton, Rutland, husbandman 0
5490694 2502110 2502110 defendant Aparke John husbandman 587582 587582 Aparke, John, of Exton, Rutland, husbandman 0
5513566 2509093 2509093 defendant Haryngton Robert gent 587582 587582 Haryngton, Robert, of Exton, Rutland, gent 0
5530470 2514047 2514047 defendant Loge Nicholas yeoman 587582 587582 Loge, Nicholas, of Exton, Rutland, yeoman 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);