names

50 rows where place_id = 590554

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601603 1868157 1868157 defendant Squyer Humphrey   590554 590554 Squyer, Humphrey, of London, sergeant 0
3601606 1868158 1868158 defendant Squyer Humphrey   590554 590554 Squyer, Humphrey, of London, sergeant 0
3738282 1938189 1938189 defendant Nicholson William   590554 590554 Nicholson, William, of London, sergeant 0
3848685 1973176 1973176 defendant Gillett Richard   590554 590554 Gillett, Richard, of London, sergeant 0
3858001 1976149 1976149 defendant Morys William   590554 590554 Morys, William, of London, sergeant 1
4430632 2174336 2174336 plaintiff Abyndon Nicholas de   590554 590554 Abyndon, Nicholas de, of London, sergeant 0
4569659 2222095 2222095 plaintiff Wetyng John   590554 590554 Wetyng, John, of London, sergeant 0
4588921 2227908 2227908 defendant Crydy John   590554 590554 Crydy, John, of London, sergeant 0
4717657 2270858 2270858 plaintiff Andrewe John   590554 590554 Andrewe, John, of London, sergeant 0
4717659 2270859 2270859 plaintiff Andrewe John   590554 590554 Andrewe, John, of London, sergeant 0
4743375 2278591 2278591 defendant Langford Thomas   590554 590554 Langford, Thomas, of London, sergeant 1
4761687 2284000 2284000 plaintiff Elys Robert   590554 590554 Elys, Robert, of London, sergeant 0
4761688 2284000 2284000 plaintiff Norton William   590554 590554 Norton, William, of London, sergeant 1
4795995 2294895 2294895 defendant Roo John   590554 590554 Roo, John, of London, sergeant 2
4795998 2294896 2294896 defendant Roo John   590554 590554 Roo, John, of London, sergeant 0
4816834 2301369 2301369 defendant Jurdan Thomas   590554 590554 Jurdan, Thomas, of London, sergeant 0
4818594 2301896 2301896 defendant Guntere John   590554 590554 Guntere, John, of London, sergeant 3
4818723 2301943 2301943 defendant Guntere John   590554 590554 Guntere, John, of London, sergeant 3
4883482 2321751 2321751 defendant Jordan Thomas   590554 590554 Jordan, Thomas, of London, sergeant 0
4901866 2327192 2327192 defendant Jordan Thomas   590554 590554 Jordan, Thomas, of London, sergeant 0
4914164 2330941 2330941 defendant Elis Robert   590554 590554 Elis, Robert, of London, sergeant 0
4916147 2331551 2331551 plaintiff Elys Robert   590554 590554 Elys, Robert, of London, sergeant 0
4918247 2332227 2332227 defendant Ybotte Thomas   590554 590554 Ybotte, Thomas, of London, sergeant 2
4918248 2332227 2332227 defendant Bray William   590554 590554 Bray, William, of London, sergeant 3
5027391 2364889 2364889 defendant Broker Robert   590554 590554 together with Broker, Robert, of London, sergeant 1
5029621 2365532 2365532 defendant Broker Robert   590554 590554 Broker, Robert, of London, sergeant 1
5084350 2381830 2381830 defendant Eustas William   590554 590554 Eustas, William, of London, sergeant 3
5084364 2381832 2381832 defendant Eustas William   590554 590554 Eustas, William, of London, sergeant 3
5091670 2383952 2383952 plaintiff Norburgh William   590554 590554 Norburgh, William, of London, sergeant 0
5105036 2387906 2387906 defendant Norborgh William   590554 590554 Norborgh, William, of London, sergeant 0
5109726 2389271 2389271 defendant Eustas William   590554 590554 Eustas, William, of London, sergeant 0
5146254 2400034 2400034 defendant Budge Roger   590554 590554 Budge, Roger, of London, sergeant 0
5194531 2414133 2414133 defendant Maydyng Richard   590554 590554 Maydyng, Richard, of London, sergeant 1
5214337 2419927 2419927 defendant Breuster Alexander   590554 590554 Breuster, Alexander, of London, sergeant 1
5216626 2420592 2420592 defendant Andrewe William   590554 590554 Andrewe, William, of London, sergeant 0
5216628 2420593 2420593 defendant Andrewe William   590554 590554 Andrewe, William, of London, sergeant 0
5216630 2420594 2420594 defendant Andrewe William   590554 590554 Andrewe, William, of London, sergeant 0
5224001 2422703 2422703 defendant Norburgh William   590554 590554 Norburgh, William, of London, sergeant 2
5241937 2427839 2427839 defendant Humfrey John   590554 590554 Humfrey, John, of London, sergeant 1
5246964 2429278 2429278 defendant Brewester Alexander   590554 590554 Brewester, Alexander, of London, sergeant 0
5251830 2430681 2430681 defendant Statham William   590554 590554 Statham, William, of London, sergeant 0
5266512 2435276 2435276 defendant Egleston Thomas   590554 590554 Egleston, Thomas, of London, sergeant 0
5285155 2440682 2440682 defendant Chamber Thomas   590554 590554 Chamber, Thomas, of London, sergeant 0
5317015 2450165 2450165 defendant Gylmyn John   590554 590554 Gylmyn, John, of London, sergeant 0
5352200 2460789 2460789 defendant Mountteney John   590554 590554 Mountteney, John, of London, sergeant 2
5352205 2460790 2460790 defendant Mountteney John   590554 590554 Mountteney, John, of London, sergeant 2
5352210 2460791 2460791 defendant Mountteney John   590554 590554 Mountteney, John, of London, sergeant 2
5483899 2500124 2500124 defendant Hall John   590554 590554 Hall, John, of London, sergeant 4
5489004 2501581 2501581 defendant Hall John   590554 590554 Hall, John, of London, sergeant 4
5516223 2509909 2509909 defendant Grymer Richard   590554 590554 Grymer, Richard, of London, sergeant 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);